Question
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Potbellys restaurant has the following information available regarding costs at representative levels of monthly
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Potbellys restaurant has the following information available regarding costs at representative levels of monthly sales (meals served):
Monthly sales in units | |||
---|---|---|---|
5,000 | 7,000 | 10,000 | |
Cost of food sold | $ 7,500 | $10,500 | $15,000 |
Wages and fringe benefits | 5,900 | 5,940 | 6,000 |
Fees paid delivery help | 6,000 | 8,400 | 12,000 |
Rent on building | 3,500 | 3,500 | 3,500 |
Depreciation on equipment | 850 | 850 | 850 |
Utilities | 600 | 640 | 700 |
Supplies (soap, floor wax, etc.) | 400 | 480 | 600 |
Administrative costs | 1,200 | 1,200 | 1,200 |
Total | $25,950 | $31,510 | $39,850 |
(a) Use the high-low method to develop a schedule identifying the amount of each cost that is mixed or variable per unit. Total the amounts under each category to develop an equation for total monthly costs.
Round variable cost answers to two decimal places.
Fixed Costs | Variable Costs | ||
---|---|---|---|
Cost of food sold | Answer
| Answer
| X |
Wages and fringe benefits | Answer
| Answer
| X |
Fees paid delivery help | Answer
| Answer
| X |
Rent on building | Answer
| Answer
| X |
Depreciation on equipment | Answer
| Answer
| X |
Utilities | Answer
| Answer
| X |
Supplies (soap, floor wax, etc.) | Answer
| Answer
| X |
Administrative costs | Answer
| Answer
| X |
Total costs equation | Answer
| Answer
| X |
* where X = Unit sales
(c) Predict total costs for a monthly sales volume of 8,500 units. $Answer
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