ACC 544 Decision Support Tools

Published : 17-Sep,2021 | Views : 10

Question:

Develop a most qualified child care centre, where parents can undoubtedly leave their children in our hands with complete satisfaction in long run.Our mission is to ensure the high quality child care that will support all aspects of child’s care along with fun educational opportunities that enhance growth and development while applying healthy, physical and social development for each child.Center will be a good prospect and we are looking forward for every possible supportfrom all the people involved in the industry Why.

Answer:

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Inflow (Source of Fund)	$20,000	$25,000	$30,000	$35,000	$40,000	$45,000	$50,000	$55,000	$60,000	$65,000	$70,000	$80,000
Cash Sales	$2,000	$3,000	$4,000	$5,000	$6,000	$7,000	$8,000	$9,000	$10,000	$11,000	$12,000	$13,000
Collection from Accounts Receivable	$1,500	$2,500	$3,000	$4,500	$5,500	$6,500	$7,000	$8,000	$9,500	$1,00,000	$1,15,000	$1,20,000
Other Cash Receipts	$2,000	$2,200	$2,300	$2,400	$2,500	$2,600	$2,700	$2,800	$2,900	$3,000	$3,100	$3,200
Total Cash Inflow	25500	32700	39300	46900	54000	61100	67700	74800	82400	179000	200100	216200
Fixed Cost	$50,000	$50,000	$50,000	$50,000	$50,000	$50,000	$50,000	$50,000	$50,000	$50,000	$50,000	$50,000
Administration	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000
Marketing	$5,000	$5,000	$5,000	$5,000	$5,000	$10,000	$30,000	$30,000	$30,000	$40,000	$40,000	$40,000
Operations	$5,000	$5,000	$5,000	$8,200	$8,200	$8,200	$9,500	$9,500	$9,500	$11,000	$11,000	$11,000
Administration	$20,000	$20,000	$20,000	$35,000	$35,000	$35,000	$50,000	$50,000	$50,000	$60,000	$60,000	$60,000
Marketing	$15,000	$15,000	$20,000	$20,000	$35,000	$35,000	$50,000	$50,000	$65,000	$65,000	$80,000	$80,000
Operations	$20,000	$25,000	$35,000	$45,000	$55,000	$65,000	$75,000	$85,000	$95,000	$10,500	$11,500	$12,000
Total Cash Outflow	117000	122000	137000	165200	190200	205200	266500	276500	301500	238500	254500	255000
Closing Cash Position	-91500	-89300	-97700	-118300	-136200	-144100	-198800	-201700	-219100	-59500	-54400	-38800