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.00