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
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
