Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PB.9 This problem is in the textbook. Consider the following sales and wage cost information for a restaurant. identify the high and low months Revenue
PB.9 This problem is in the textbook. Consider the following sales and wage cost information for a restaurant. identify the high and low months
Revenue | Wages | High or Low? | ||
January | 11,200 | 5,300 | ||
February | 13,000 | 6,100 | ||
March | 14,900 | 6,200 | ||
April | 19,100 | 7,000 | ||
May | 22,000 | 9,000 | ||
June | 24,200 | 9,600 | ||
July | 26,300 | 9,700 | ||
August | 27,400 | 10,100 | ||
September | 23,500 | 8,300 | ||
October | 20,100 | 7,600 | ||
November | 18,200 | 8,000 | ||
December | 16,000 | 7,100 | ||
Total | $235,900 | $94,000 |
|
Conduct a High-Low analysis of the data to determine Variable Cost % and Fixed Costs in the High and Low months
Revenue | Wages | ||||||||||||||
Maximum | |||||||||||||||
Minimum | |||||||||||||||
Difference or | |||||||||||||||
Variable Cost Percentage | |||||||||||||||
Maximum Labor Cost | |||||||||||||||
Variable Cost for High Data | |||||||||||||||
Fixed Cost | |||||||||||||||
Minimum Labor Cost | |||||||||||||||
Variable Cost for Low Data | |||||||||||||||
Fixed Cost Finally, using the calculated Variable Cost %, give the breakdown of Total Annual Wages into Fixed and Variable components
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started