Concept explainers
Operating expenses budget and an income statement (Learning Objective 2)
Evansville Preschool operates a not-for-profit morning preschool that operates eight months of the year. The preschool has 190 kids enrolled in its various programs. The preschool’s primary expense is payroll. Teachers are paid a flat salary each of the eight months as follows:
Teachers of two-day program | $ 428 per month |
Teachers of three-day program | $ 657 per month |
Teachers of four-day program | $ 856 per month |
Teachers of five-day program | $1,075 per month |
Preschool director’s salary | $1,500 per month |
Evansville Preschool has 9 two-day program teachers, 4 three-day program teachers, 5 four-day program teachers, and 4 five-day program teachers. The preschool also has a director.
In addition to the salary expense, the preschool must pay federal payroll taxes (FICA taxes) in the amount of 7.65% of salary expense. The preschool leases its facilities from a local church, paying $4,050 every month it operates. Fixed operating expenses (telephone, Internet access, bookkeeping services, and so forth) amount to $890 per month over the nine-month school year. Variable monthly expenses (over the eight-month school year) for art supplies and other miscellaneous supplies are $13 per child. Revenue for the entire nine-month school year from tuition, registration fees, and the lunch program is projected to be $241,300.
Requirements
- 1. Prepare Evansville Preschool’s monthly operating expenses budget. Round all amounts to the nearest dollar.
- 2. Using your answer from Requirement 1, create Start Evansville Preschool’s
budgeted income statement for the entire eight-month school year. You may group all operating expenses together. - 3. Start Evansville is a not-for-profit preschool. What might the preschool do with its projected income for the year?
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Managerial Accounting Plus Mylab Accounting With Pearson Etext -- Access Card Package (5th Edition)
- (Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?arrow_forwardPlease prepare a consolidated budget pivot table in Excel by budget class and year. Please upload your excel document. Budget Class – Staff Costs • Salary of the Project Manager @ USD 5,000 per month. • Salary of the Admin Finance Officer @ USD 3,500 per month. • Salary of Admin. & Finance Assistant @USD 1,000 per month • Salary of Driver @USD 500 per month Budget Class – Equipment & Furniture Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project. Budget Class – Operating Costs (training) Two trainers are required for each training. Each training lasts for 5 days. The total number of participants for each training is 30. • DSA/ ticket cost of each participant @ USD1, 000 per training. • Total number of 5-day trainings planned for each year is 4. • Fee for Trainer @ USD 2,000 per training. • Cost of logistic arrangements for each training @ USD 10,000. In addition to the main direct…arrow_forwarda. Prepare a revenue budget for the upcoming academic year.b. Determine the number of staff needed to cover classes.c. Assume there is a shortage of full-time academic staff. List at least five actions thatSouth Hampton might take to accommodate the growing student numbers.arrow_forward
- (1) At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $9,800 Purchase season football tickets in September 170 Additional entertainment for each month 270 Pay fall semester tuition in September 5,100 Pay rent at the beginning of each month 650 Pay for food each month 600 Pay apartment deposit on September 2 (to be returned December 15) 650 Part-time job earnings each month (net of taxes) 1,300 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except cash decrease which should be indicated with a minus sign.arrow_forwardAt the beginning of the school year, Craig Kovar decided to prepare a cash budget for the monthsof September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The followinginformation relates to the budget: Cash balance, September 1 (from a summer job) . . . . . . . . . . . . . . . . . $9,250Purchase season football tickets in September . . . . . . . . . . . . . . . . . . . . . . 160Additional entertainment for each month . . . . . . . . . . . . . . . . . .. . . . . . . . . 250Pay fall semester tuition in September . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,800Pay rent at the beginning of each month . . . . . . . . . . . . . . . . . . . . . . . . . . . 600Pay for food each month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 550Pay apartment deposit on September 2 (to be returned December 15) . 600Part-time job earnings each…arrow_forwardPersonal Budget At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,860 Purchase season football tickets in September 120 Additional entertainment for each month 310 Pay fall semester tuition in September 4,800 Pay rent at the beginning of each month 430 Pay for food each month 240 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,100 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOY Cash Budget For the Four…arrow_forward
- Personal Budget At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $5,750 Purchase season football tickets in September 210 Additional entertainment for each month 275 Pay fall semester tuition in September 3,700 Pay rent at the beginning of each month 600 Pay for food each month 235 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 1,400 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. Katherine Malloy Cash Budget For the Four…arrow_forwardPersonal Budget At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,680 Purchase season football tickets in September 120 Additional entertainment for each month 300 Pay fall semester tuition in September 4,700 Pay rent at the beginning of each month 420 Pay for food each month 240 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,080 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOY Cash Budget For the Four Months Ending…arrow_forwardAt the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $5,750 Purchase season football tickets in September 210 Additional entertainment for each month 275 Pay fall semester tuition in September 3,700 Pay rent at the beginning of each month 600 Pay for food each month 235 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 1,400 Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?Static c. Malloy can see that her present plan will not provide sufficient cash. If Malloy did not budget but went ahead with the original plan, she would be $fill in…arrow_forward
- At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $5,750 Purchase season football tickets in September 210 Additional entertainment for each month 275 Pay fall semester tuition in September 3,700 Pay rent at the beginning of each month 600 Pay for food each month 235 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 1,400 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. Katherine MalloyCash BudgetFor the Four Months Ending December 31…arrow_forward1. At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,060arrow_forwardAt the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,380 Purchase season football tickets in September 100 Additional entertainment for each month 260 Pay fall semester tuition in September 4,000 Pay rent at the beginning of each month 360 Pay for food each month 200 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 920 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOY Cash Budget For the Four Months Ending December…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education