CT 10.1 Master Actual Budget Difference Flexible Budget Difference U/F Number of Ma 52 60 (8) U Number Board 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) Direct M $ 104,390 $ 109,500 $ (5,110) F Direct La $ 58,838 $ 65,700 $ (6,862) F Indirect I$ 4,984 $ 5,475 $ (491) F Indirect I $ 10,178 $ 12,045 $ (1,867) F Total Variable $ 178,390 $ 192,720 $ (14,330) F Fixed Expenses Deprecia $ 40,000 $ 40,000 $ Insurance $ 11,000 $ 11,000 $ Utilities $ 12,000 $ 14,000 $ (2,000) F Repairs/I $ 10,000 $ 11,000 $ (1,000) F Labor $ 88,000 $ 95,000 $ (7,000) F Advertise $ 12,000 $ 8,000 $ 4,000 U Entertain $ 7,000 $ 5,000 $ 2,000 U total Fixed $ 180,000 $ 184,000 $ (4,000) F Total Expenses $ 358,390 $ 376,720 $ (18,330) F Net Income $ 21,610 $ 170,780 $ (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 F for each line