O E F G H 1 K M N N 1 2 3 CT 10.1 Number of Mares Difference Master Budget 60 Actual 52 Flexible Budget Difference U/F 4 (8) U 5 6 7 9 10 12 13 14 15 10 17 18 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 Variable Expenses (BUDGET based on number of boarding days) Feed $ 104,390 $ 109,500 $ (5,110) F Vet Fees $ 58,838 $ 65,700 $ (6,862) F blacksmith fees $ 4,984 $ 5,475 $ (491) F Supplies $ 10,178 $ 12,045 $ (1,867) F Total Variable $ 178,390 $ 192,720 $ (14,330) F Fixed Expenses Depreciation $ 40,000 $ 40,000 $ Insurance $ 11,000 $ 11,000 $ Utilities $ 12,000 $ 14,000 $ (2,000) F Repairs/Maint $ 10,000 $ 11,000 $ (1,000) F Labor $ 88,000 $ 95,000 $ (7,000) F Advertisements $ 12,000 $ 8,000 $ 4,000 U Entertainment $ 7,000 $ 5,000 $ 2,000 U total Fixed $ 180,000 $ 184,000 S (4,000) F Total Expenses $ 358,390 S 376,720 $ (18,330) F Net Income $ 21,610 $ 170,780 $ (149,170) U 2 Reasons for Sales/Revenue being well under budget 1 2 19 20 un 21 22 *** W X DONNE 23 25 26 27 28 29 30 32 Create a Flexible budget and compare to Actual in the yellow Include totals and U or F for each line 33 34 35