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

Question

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

Accepted Answer

The Answer is in the image, click to view ...

Question

2 . Merge Center. $ % Q10 x Condo Format Formatting as Table fx y LMN0a 3 CT 10.1 Actual Master Budget 60 Difference (8)

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Information Technologies In Accounting And Auditing A Post-Soviet Approach

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question