Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please post ALL equations, so I can learn. thank you! Chapter 10. Question 11 The Wheatfield Valley Golf Course F&B Department Budget Worksheet for Next

please post ALL equations, so I can learn.
thank you!
image text in transcribed
image text in transcribed
Chapter 10. Question 11 The Wheatfield Valley Golf Course F&B Department Budget Worksheet for Next Year This Year Actual $ Next Year Budget $ % % $169,250.00 $55,750.00 $225,000.00 75.22% 24.78% 100.00% 58, 250.00 9.375.00 $67,625.00 86.14% 13.86% 100.00% 9,000.00 27.250.00 6,200.00 $42.450.00 Sales Food Beverage Total sales Cost of Sales Food Beverages Total cost of sales Labor Management Staff Employee benefits Total labor Prime Cost Other Controllable Expenses Direct operating expenses Utilities General & administrative expenses Repairs & maintenance Total Other Controllable Expenses Controllable Income Non-controllable expenses Occupancy costs Equipment leases Depreciation & amortization Total Non-Controllable Expenses Restaurant Operating Income Interest expense Income Before Income Taxes Income taxes Net Income 13,200.00 5.975.00 6,375.00 1.750.00 15,000.00 0.00 4,200.00 0.00 4,200.00 12,000.00 $14.106.25 11. 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 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 assump- tions about next year, create Cyrus' new operating budget in dollars and percentages

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Count Down The Past, Present And Uncertain Future Of The Big Four Accounting Firms

Authors: Jim Peterson

2nd Edition

1787147010, 9781787147010

More Books

Students also viewed these Accounting questions

Question

Calculate a utility estimate for a target organization

Answered: 1 week ago