Editing Conditional Formatting Format as Table aste Font Alignment Number Cells Cell Styles lipboard Styles UPLOAD FAILED You are required to sign in to upload your changes to this location. Sign In X for Budget Worksheet for Next Year Problem #6 Problem worth 60 The Wheatfield Valley golf course has been owned by the Miley family for two generations Currently, it is managed by Cyrus Miley, a graduate of State University, where he majored in hospitality management. Last year was a good one for the golf course. Now Cyrus is preparing next year's operating budget. He has gathered a great deal of information to help him prepare the best budget possible. After carefully analyzing that information, Cyrus predicts that next year the course will experience: A 6 percent increase in food sales A 4 percent increase in beverage sales - No change in food or beverage product cost percentage - Salaries and wages (management and staff) that will increase 5.5 percent - Employee benefits that will increase 10 percent An increase of 3.5 percent in each Other Expense category No change in Occupancy Costs and Depreciation & Amortization Interest payments next year will be $1,100 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. All answers should be rounded to 2 decimal positions. If your rounding is incorrect you will lose the points ... Problem #1 Average: 42983.06818 Problem #2 Prol ... Count: 58 Sum: 945627,5 Type here to search o te Clipboard UPLOAD FAILED Font You are required to sign in to upload your changes to this A17 Budget Worksheet for Next Ye This Year Next Year 19 SALES $185 377 50 20 Food $176,550.00 21 Beverage 58 750.00 22 Total Sales THAI 23 COST OF SALES 24 Food $58,250.00 25 Beverages 11575.00 26 Total Cost of Sales $69.825.0 27 LABORE 28 Management $9,000.00 29 Staff 27.750.00 30 Employee Benefits 6,300.00 31 Total Labor $43.050,00 32 PRIME COST 33 OTHER CONTROLLABLE EXPENSES 34 Direct Operating Expenses $13,200.00 35 Utilities 5,975.00 36 General & Administrative Expense 7.575.00 37. Repairs & Maintenance 1750.00 38 Total Other Controllable Expenses 39 CONTROLLABLE INCOME 40 NON-CONTROLLABLE EXPENSES 41 Occupancy Costs $15,000.00 42 Equipment Leases 0.00 43 Depreciation & Amortization 4,200.00 44 Total Non-Controllable Expenses 45 RESTAURANT OPERATING INCOME 46 Interest Expense $12.000 47 INCOME BEFORE INCOME TAXES 48 Income Taxes 0.00 49 NET INCOME ---- ... Problem #1 Problem #2 Select destination and press ENTER or choose Paste E 000 4,200.00 Problem #3