Question: The picture below has three (3) budgets to be analyzed and include all three, along with all 3 sections of the budget. 1. Sections I

The picture below has three (3) budgets to be analyzed and include all three, along with all 3 sections of the budget.

1. Sections I and II require to make any changes in order to balance each of the three budgets and close the paper by considering how budgets affect a program as well as children, families and staff in daycare.

2. Section III requires to save each of your revised budgets and submit them.

Sections I & II in Microsoft word and Section III (consisting of revised budgets) in Microsoft Excel.Double check your math to ensure figures are accurate and that each of the three revised budgets are balanced or have a surplus-

The picture below has three (3) budgets to be
A B C D E F 2 Felton Family Preschool 3 Estimated Current Year 'Reasonable" 7 Results Budget C 8 INCOME 9 Tuition 315,000 322, 100 10 Fund-raising 7,000 8,000 11 County Grant 20,000 15,000 12 Other 2,000 2,000 13 14 TOTAL INCOME 344,000 347,100 15 16 EXPENSE 17 Payroll Expense 18 Salaries-Staff 247,227 250, 100 19 Payroll Taxes 22,250 22,509 20 Worker's Comp 9,889 11,500 21 Staff Benefits 22 Health Ins. 25,000 27,000 23 Dental Ins. 4,000 4,500 24 Education Allow. 875 875 25 26 Rent 4,800 4,800 27 Janitor 6,000 6,200 28 Insurance 29 Accident 1,500 1,550 30 Directors Ins. 899 944 31 Liability 2,775 2,914 32 Supplies 14,053 15,550 33 Utilities 2,700 4.800 34 35 Capital Improvement 0 1,000 36 37 TOTAL EXPENSES 341,968 354,242 38 39 SURPLUS (DEFICIT) 2,032 (7, 142) 40 41

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!