Static Budget Income Statement Actual Master Difference Favorable Number of Mares 45 68 23 UF Number of Boarding Days 16250 24820 8570 UF Sales $ 568,750 $ 744,600 $ 175,850 UF Variable Expenses Feed $ 146,250 $ 173,740 $ 27,490 F Veterinary Fees $ 97,500 $ 99,280 $ 1,780 F Blacksmith Fees $ 5,688 $ 13,651 $ 7,963 F Supplies $ 4,063 $ 8,687 $ 4,624 F Total Variable Expenses $ 253,500 $ 295,358 $ 41,858 F Contribution Margir $ 315,250 $ 449,242 $ 133,992 UF Less: Fixed Expenses Depreciation $ 40,000 $ 40,000 $ Insurance $ 25,000 $ 11,000 $ 14,000 UF Utilities $ 17,000 $ 14,000 $ 3,000 UF Repairs and Maintenance $ 30,250 $ 11,000 $ 19,250 UF Labor $ 88,000 $ 95,000 $ 7,000 F Advertisement $ 35,000 $ 8,000 $ 27,000 UF Entertainment $ 50,000 $ 5,000 $ 45,000 UF Total Fixed Expenses $ 285,250 $ 184,000 $ 101,250 UF Net Income $ 30,000 $ 265,242 $ 235,242 UF $ Static vs. Flexible Budget Analysis Project BLU-Grass Acres is a 350-acre farm on the outskirts of Louisville, Kentucky, which specializes in the boarding of broodmares and their foals. They have the capacity to board up to 75 horses. The recent economic downturn in the thoroughbred industry has made the boarding business extremely competitive in this area. To meet the competition, BLU-Grass planned in 2022 to entertain clients, advertise more extensively, and absorb expenses formerly paid by clients such as veterinary and blacksmith fees. Jayzee the bookkeeper (sometimes called LAZ-E!) started to prepare some financial analysis and he remembered learning about static and flexible budgets in his college accounting class. Jayzee starts with a static budget report. Unfortunately, he doesn't know how to complete the report and management wants an analysis on the year. The static budget income statement budget for the year is based on an expected 365 boarding days per year for each horse, at a fee of $30 per mare. The variable expenses per mare per day were budgeted: feed $7, veterinary fees $4, blacksmith fees $0.55, and supplies $0.35. All other budgeted expenses were either semifixed or fixed. During the year, management DID NOT replace a worker who quit in June, but it did issue a new advertising brochure and did more entertaining of clients. Jayzee hires you as a consultant and needs your help, quick, to be sure he is prepared for the meeting!! 1. In excel or google drive (sheets), complete a flexible budget report (use formulas and cell referencing whenever possible in your spreadsheet). 2. Based ONLY ON the FLEXIBLE budget report, provide your written analysis on the following: a. What were the reasons for the decline in net income? b. How effective was management at controlling expenses? c. Do you think management made good management decisions? 3. Assuming you are hired as a consultant to help drive profitability, what course of action do you recommend for the management of BLU-Grass Acres (feel free to take reasonable assumptions and be creative with your recommendations though be sure to explain and/or support your reasonings)
