Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

identify current issues relating to equal pay in organisations

Answered: 1 week ago