Answered step by step
Verified Expert Solution
Question
1 Approved Answer
COSTS otes: 1. Every Excel outputs should be properly edited. 2. Every Excel output should be shown on your homework answer sheet (Copy your Excel
COSTS otes: 1. Every Excel outputs should be properly edited. 2. Every Excel output should be shown on your homework answer sheet (Copy your Excel outputs from Excel spread sheet, and then paste these outputs on your Word homework answer sheet, here. Do not print Excel outputs. Do not attach them to your homework). Situation 0 You are the director in North Bend Day Care Center, which is a not-for-profit or Center provides the most affordable day care service to children in North Bend. The North Bend Day Care Center charges each child who the program $300 per month. The cost of supplies and snacks that the Center purchases for each child is $100. The Center pays a rent. $1,000, per month. (1) Calculate a contribution margin (CM). Show how you calculated a CM (2) How many children havet come to the Center each month for it to break even? Show how you calculated the number of children Situation 2 You got a notice from the building owner. The notice says that the Center should pay an increased rent, $1,200, from next year (3) How many children haveto come to the Center each month for it to break even next year? Show how you calculated anumer.t cmldren. (4) However, you expect that the number of children who come to the Center will not be changed next year. Therefore, how much should the Center charge each child for it to break even next year given ncreased rent? Showhow you calculated a day care tee. year, you want to visualize cost and To understand cost and revenue structure of the Center this revenue data of the Center (5) Develop cost and revenue data set by filling out the Excel work sheet. Show the data set. Does the data set completed confirm your answer for (2)? (6) As we did it in class, create "a single" Line Chart using the data set you have created (The single Line Chart should show five lines, such as fixed cost, variable cost, total cost, average cost, and total revenue lines, at the same time [See Appendix). Show the Chart. Does the Chart also confirm your answer for (2)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started