Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
