2 . Merge Center. $ % Q10 x Condo Format Formatting as Table fx y LMN0a 3 CT 10.1 Actual Master Budget 60 Difference (8) U Flexible Budget Number of Mares Difference U/F Number Boarding Days 19,000 21,900 (2,900) U Sales/Revenue 380,000 547,500 (167,500) U $25 per boarding day is budget (5,110) F (6,862) F (491) F (1,867) F 14,330) F Variable Expenses (BUDGET based on number of boarding days) Feed $ 104,390 $ 109,500 $ Vet Fees $ 58,838 $ 65,700 S blacksmith fees $ 4.984 $ 5.475 S Supplies $ 10,178 $ 12.045 S Total Variable $ 178,390 $ 192,720 $ Fixed Expenses Depreciation $ 40,000 $ 40,000 Insurance $ 11,000 $ 11.000 $ Utilities $ 12,000 $ 14,000 $ Repair Maint $ 10,000 $ 11,000 Labor $ 88,000 $ 95,000 Advertisements $ 12.000 $ 8,000 Entertainment $ 7,000 $ 5,000 $ total Fixed $ 180,000 $ 184,000 $ Total Expenses $ 358,390 $ 376,720 S Net Income $ 21,610 $ 170,780 $ 2,000) F (1,000) F (7,000) F 4,000 U 2,000 U (4,000) (18,330) F (149,170) U 2 Reasons for Sales/Revenue being well under budget Create a Flexible budget and compare to Actual in the yellow Include totals and U or Ffor each line Sheet1 2 . Merge Center. $ % Q10 x Condo Format Formatting as Table fx y LMN0a 3 CT 10.1 Actual Master Budget 60 Difference (8) U Flexible Budget Number of Mares Difference U/F Number Boarding Days 19,000 21,900 (2,900) U Sales/Revenue 380,000 547,500 (167,500) U $25 per boarding day is budget (5,110) F (6,862) F (491) F (1,867) F 14,330) F Variable Expenses (BUDGET based on number of boarding days) Feed $ 104,390 $ 109,500 $ Vet Fees $ 58,838 $ 65,700 S blacksmith fees $ 4.984 $ 5.475 S Supplies $ 10,178 $ 12.045 S Total Variable $ 178,390 $ 192,720 $ Fixed Expenses Depreciation $ 40,000 $ 40,000 Insurance $ 11,000 $ 11.000 $ Utilities $ 12,000 $ 14,000 $ Repair Maint $ 10,000 $ 11,000 Labor $ 88,000 $ 95,000 Advertisements $ 12.000 $ 8,000 Entertainment $ 7,000 $ 5,000 $ total Fixed $ 180,000 $ 184,000 $ Total Expenses $ 358,390 $ 376,720 S Net Income $ 21,610 $ 170,780 $ 2,000) F (1,000) F (7,000) F 4,000 U 2,000 U (4,000) (18,330) F (149,170) U 2 Reasons for Sales/Revenue being well under budget Create a Flexible budget and compare to Actual in the yellow Include totals and U or Ffor each line Sheet1