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 the static budget report (use formulas and cell referencing whenever possible in your spreadsheet).
2. Based ONLY ON the STATIC 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. In excel or google drive (sheets), complete a flexible budget report (use formulas and cell referencing whenever possible in your spreadsheet).
4. Based ONLY ON the FLEXIBLE budget report, provide your written analysis on the following:
d. What were the reasons for the decline in net income?
e. How effective was management at controlling expenses?
f. Do you think management made good management decisions?
5. 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)?
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
