Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need to calculate the forecast : Actual Quarter 1 Actual Quarter 2 Forecast Quarter 3 Forecast Quarter 4 Forecast Total Year FTEs 25 28 36

image text in transcribed

Need to calculate the forecast :

Actual Quarter 1 Actual Quarter 2 Forecast Quarter 3 Forecast Quarter 4 Forecast Total Year
FTEs 25 28 36 34 31
Revenue $64,042.00 $71,358.00 $317,663.00
Variable Cost $27,826.00 $26,911.00
Fixed Cost $39,906.00 $40,182.00
Total Cost $67,732.00 $67,093.00
Net Income $(3,690.00) $4,625.00
Budget Income $(676.00) $6,347.00 $24,097.00 $22,309.00 $52,077.00
Difference $(3,014.00) $(2,082.00)

*FTE means full-time-equivalent student here. I have added a screenshot of the introduction.

INTRODUCTION The Sunshine Daycare Center has been in business for a number of years and until recently has been profitable. A few months ago, regional management dismissed a director who had a confrontational style, potentially causing a decrease in attendance. During the former director's employ, many clients were lost and a complete staff turnover occurred. The new director, fresh out of college, is enthusiastic and energetic, and while experienced in daycare operations, has no business training other than the three-day course she was given upon taking the job. Your professor has volunteered your class to break into groups of four or five students and serve as consulting teams for the Sunshine Daycare Center, which will be referred to as SDC in the rest of the case. This will give you an opportunity to use some of the skills you are learning in your Management Accounting class. Your team's ultimate goal will be a presentation outlining a strategy for improved profitability for the SDC. To do that, you will need to understand how the business is operating now and decide what areas need improvement. You will need a new forecast of the next two quarters, assuming no change in the current operations. By comparing this to the current yearly plan, you will see how far off the plan the SDC is operating. Now the big challenge: you will choose some of the possible marketing improvements listed in Exhibit 3 to improve the operations of the center. Then incorporate your suggestions into a four-quarter budget for the subsequent fiscal year, 2013-2014. The SDC is open Monday through Friday and provides care for children in the following categories: Infants (ages 0-18 months), Toddlers (ages 18-36 months), Preschool (ages 3-5 years), Kindergarten (ages 6-7 years), and School-Age Children (ages 8-11 years). Children enroll for either full-day or half-day care. Full-time billing rates vary from infants at $262 per week to $127 for school-age children. Half-day rates vary from $183 for toddlers to $89 per week for school- age children. Note that two half-day students equal one full-time-equivalent student (FTE) for headcount purposes. The center is licensed by the state and meets all regulatory requirements for health and safety. The center is located in an affluent community and has four other competitors in a five-mile radius. All centers offer comparable programs, at comparable rates. The challenge to SDC is to increase enrollment. INTRODUCTION The Sunshine Daycare Center has been in business for a number of years and until recently has been profitable. A few months ago, regional management dismissed a director who had a confrontational style, potentially causing a decrease in attendance. During the former director's employ, many clients were lost and a complete staff turnover occurred. The new director, fresh out of college, is enthusiastic and energetic, and while experienced in daycare operations, has no business training other than the three-day course she was given upon taking the job. Your professor has volunteered your class to break into groups of four or five students and serve as consulting teams for the Sunshine Daycare Center, which will be referred to as SDC in the rest of the case. This will give you an opportunity to use some of the skills you are learning in your Management Accounting class. Your team's ultimate goal will be a presentation outlining a strategy for improved profitability for the SDC. To do that, you will need to understand how the business is operating now and decide what areas need improvement. You will need a new forecast of the next two quarters, assuming no change in the current operations. By comparing this to the current yearly plan, you will see how far off the plan the SDC is operating. Now the big challenge: you will choose some of the possible marketing improvements listed in Exhibit 3 to improve the operations of the center. Then incorporate your suggestions into a four-quarter budget for the subsequent fiscal year, 2013-2014. The SDC is open Monday through Friday and provides care for children in the following categories: Infants (ages 0-18 months), Toddlers (ages 18-36 months), Preschool (ages 3-5 years), Kindergarten (ages 6-7 years), and School-Age Children (ages 8-11 years). Children enroll for either full-day or half-day care. Full-time billing rates vary from infants at $262 per week to $127 for school-age children. Half-day rates vary from $183 for toddlers to $89 per week for school- age children. Note that two half-day students equal one full-time-equivalent student (FTE) for headcount purposes. The center is licensed by the state and meets all regulatory requirements for health and safety. The center is located in an affluent community and has four other competitors in a five-mile radius. All centers offer comparable programs, at comparable rates. The challenge to SDC is to increase enrollment

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Cpa Financial Services A Guide To Fitting The Pieces Together

Authors: Billy Hemby

1st Edition

1958331007, 978-1958331002

More Books

Students also viewed these Accounting questions