neatfield Valley golf course has been owned by the Mley family for two s managed
ID: 2594831 • Letter: N
Question
neatfield Valley golf course has been owned by the Mley family for two s managed by Cyrus Miley, a graduate of State University, where he mireos Current unversity, where he Last year was a good one for the golf course. Now Cyrus is preparing next years budget. He has gathered a great deal of information to help him prepare the best budget fter carefully analyzing that information, Cyrus predicts that next year the course wi A 5 percent increase in food sales A 3 percent increase in beverage sales No change in food or beverage product cost percentage Salaries and wages (management and staff) that will increase 4.5 percent Employee benefits that will increase 10 percent An increase of 2.5 percent in each Other Expense category No change in Occupancy Costs and Depreciation & Amortization Interest payments of $1,000 per month Tax payments that are estimated to be 25 percent of income before income taxes Calculate this year's operating percentages for the food and beverage department on the budget worksheet provided, and then using his assumptions about next year, create Cyrus's new operating budget in dollars and percentages The Wheatfield Valley Golf Course F&B; Department Budget Worksheet for Next Year This Year Actual $ Next Year Budget $ | % $173,250.00 Food Beverage Total Sales COST OF SALES $58,250.00 ood Beverages Total Cost of Sales LABOR Management Staff Employee Benefits Total Labor 9,000.00 OTHER CONTROLLABLE EXPENSES Utilities General & Administrative Expenses Repairs & Maintenance Total Other Controllable Expenses CONTRO NON-CONTROLLABLE EXPENSES Occupancy Costs $15,000.00 uipment Leases epreciation & Amortization 4,200.00 ERATING INCOME Interest Expense INCOME BEFORE IN Income Taxes NET INCOME INCOMETARES 0.00Explanation / Answer
Current year Next yr budget % on sales Remarks Sales - Food 173,250 181,912.50 5% increase - Beverage 56,750 58,452.50 3% increase Total Sales 230,000 240,365.00 100% Cost of sales: - Food 58,250 33.62% 61,162.50 Same % of 33.62% as in last year - Beverage 9,375 16.52% 9,656.25 Same % of 16.52% as in last year 67,625 70,818.75 29.5% % on sales Labour cost: - Management 9,000 9,405.00 4.5% increase - Staff 27,250 28,476.25 4.5% increase - Employee benefits 6,200 6,820.00 10% increase Total labour cost 42,450 44,701.25 18.6% Prime cost 110,075 115,520 48.1% % on sales Other controllable expenses: - Direct operating expense 13,200 13,530.00 2.5% increase - Utilities 5,975 6,124.38 2.5% increase - General & Admin expense 6,375 6,534.38 2.5% increase - Repairs & maintenance 1,750 1,793.75 2.5% increase Total other controllabe exp 27,300 27,982.50 11.6% Controllable Income 92,625 96,862.50 40.3% (Sales-Prime cost-Other Controllable expense) Non Controllable Expenses: - Occupancy cost 15,000 15,000.00 No change in cost - Equipment leases - - - Depn & Amortization 4,200 4,200.00 No change in cost Total Non controllable expense 19,200 19,200.00 8.0% Restaurant Operating income 73,425 77,662.50 32.3% (Controllable Income-Non controllable expense) Interest Expense 12,000 12,000.00 (1000*12) Income before Taxes 61,425 65,662.50 (Operating income-Interest) Income Taxes - 16,415.63 (25% on Income before taxes) Net Income 61,425 49,246.88 20.5% (Income before taxes- Income tax)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.