Question

Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Papa John's restaurant has the...

Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation
Assume a Papa John's restaurant has the following information available regarding costs at representative levels of monthly sales:

Monthly sales in units
5,000 8,000 10,000
Cost of food sold $10,000 $16,000 $20,000
Wages and fringe benefits 5,150 5,240 5,300
Fees paid delivery help 1,150 1,840 2,300
Rent on building 1,400 1,400 1,400
Depreciation on equipment 800 800 800
Utilities 700 760 800
Supplies (soap, floor wax, etc.) 250 340 400
Administrative costs 1,200 1,200 1,200
Total $20,650 $27,580

$32,200

(b) Use the high-low method to develop a schedule identifying the amount of each cost that is fixed per month 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
Wages and fringe benefits Answer Answer
Fees paid delivery help Answer Answer
Rent on building Answer Answer
Depreciation on equipment Answer Answer
Utilities Answer Answer
Supplies (soap, floor wax, etc.) Answer Answer
Administrative costs Answer Answer
Total costs equation Answer Answer

(c) Predict total costs for a monthly sales volume of 9,400 units.
$Answer

Homework Answers

Answer #1

Working as follows:

Nature Fixed Variable
COGS Variable [10,000/5,000 = 2]
Wages and fringe benefits Mixed 5150 - (0.03*5000) = 5000 [(5240 - 5150) ÷ (8000- 5000)] = 0.03
Fees paid delivery help Variable 1150 ÷ 5000 = 0.23
Rent on building Fixed 1400
Depreciation on equipment Fixed 800
Utilities Mixed [700- (0.02*5000)] = 600 [(760 - 700) ÷ (8000 - 5000)] = 0.02
Supplies Mixed [250- (0.03*5000)] = 100 [(340 - 250) ÷ (8000 - 5000)] = 0.03
Administrative costs Fixed 1200
Total 9100 2.31

_________________________________________________

Compute total cost = 9100 + (2.31   9,400 units)

= 9100 + 21714

= $30814

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Assume a Papa John's restaurant has the following information available regarding costs at representative levels of...
Assume a Papa John's restaurant has the following information available regarding costs at representative levels of monthly sales: Monthly sales in units 5,000 8,000 10,000 Cost of food sold $10,000 $16,000 $20,000 Wages and fringe benefits 5,150 5,240 5,300 Fees paid delivery help 1,150 1,840 2,300 Rent on building 1,400 1,400 1,400 Depreciation on equipment 800 800 800 Utilities 700 760 800 Supplies (soap, floor wax, etc.) 250 340 400 Administrative costs 1,200 1,200 1,200 Total $20,650 $27,580 $32,200 A....
Homework: Cost Behavior and Cost Prediction Jan Feb Change Unit Sales         8,000         6,000 2000...
Homework: Cost Behavior and Cost Prediction Jan Feb Change Unit Sales         8,000         6,000 2000 Cost of Food Sold $    2,000 $    1,500 500 Depreciation            500            500 0 Supplies            400            300 100 Wages and Salaries         5,500         5,000 500 Utilities         1,500         1,400 100 Rent         4,000         4,000 0 Total $ 13,900 $ 12,700 What is the Unit Variable Cost and Fixed Costs? Predict the Average and Total Costs for 9000 units
Assume a local gluten-free pizzeria, on Harrison street, reported the following results for June and July...
Assume a local gluten-free pizzeria, on Harrison street, reported the following results for June and July Jun Jul Unit Sales 2,500 2,900 Cost of Food Sold 10,000 10,600 Wages and Salaries 3,700 4,000 Rent 2,000 2,000 Depreciation 500 500 Utilities 1,400 1,500 Supplies 500 580 Total 18,100 19,180 a. Identify each cost as being fixed, variable or mixed. b. Determine the equation for total operating costs (Fixed + Unit Variable Cost * # of pizzas) c. Predict the total operating...
High-Low Method for a Service Company Continental Railroad decided to use the high-low method and operating...
High-Low Method for a Service Company Continental Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Continental Railroad is a measure of railroad operating activity, termed "gross-ton miles," which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $946,700 261,000 February 1,055,600 292,000 March 746,000 189,000 April 1,012,000 282,000 May 848,800 227,000...
The owner of ManhattanManhattan Restaurant is disappointed because the restaurant has been averaging 7500 pizza sales...
The owner of ManhattanManhattan Restaurant is disappointed because the restaurant has been averaging 7500 pizza sales per month, but the restaurant and wait staff can make and serve 10000 pizzas per month. The variable cost (for example, ingredients) of each pizza is $1.55 Monthly fixed costs (for example, depreciation, property taxes, business license, and manager's salary) are $12000 per month. The owner wants cost information about different volumes so that some operating decisions can be made.Read the requirements 1-Use the...
Can someone make income statement ,balance sheet and cash flow statement based on estimated cost. Estimate...
Can someone make income statement ,balance sheet and cash flow statement based on estimated cost. Estimate your fixed costs (£) Item Fixed Cost Rent 36,000 Insurance 11,000 Salaries 162,000 Utilities (bills) 3500 Marketing 42,700 Depreciation 3,400 TOTAL FIXED COSTS 258600 Estimate Startup Costs (only for the first Year) Item Startup Cost Company Registration & government fees 16,000 Office Supplies (PC, Laptops, Printers, fittings..etc) 17,000 Social Media Campaign 18,000 Video Production… 3000 App Development 40,000 TOTAL STARTUP COSTS 94000 .. Estimate...
Pink House Ltd. sells plastic pink flamingos. The following operating expenses were provided for the month...
Pink House Ltd. sells plastic pink flamingos. The following operating expenses were provided for the month of April 2020: Sales salaries $25,000 Advertising 3% of monthly sales Sales commissions 2.5% of monthly sales Delivery expenses $2,500 Rent expense $10,500 Amortization $580 Utilities $800 Insurance $1,200 Telephone $600 The company budgets cost of goods sold to be 55% of total sales. Expected sales for April and May are $850,000 and $925,000, respectively. The company maintains a merchandise inventory of 20% of...
E5-2 Determining Cost Behavior and Calculating Expected Cost [LO 5-1] Morning Dove Company manufactures one model...
E5-2 Determining Cost Behavior and Calculating Expected Cost [LO 5-1] Morning Dove Company manufactures one model of birdbath, which is very popular. Morning Dove sells all units it produces each month. The relevant range is 0–1,800 units, and monthly production costs for the production of 1,400 units follow. Morning Dove’s utilities and maintenance costs are mixed with the fixed components shown in parentheses.    Production Costs Total Cost Direct materials $ 2,100 Direct labor 7,300 Utilities ($100 fixed) 560 Supervisor’s salary...
Net cash flows from operating activities are....(hint: don’t forget about net income). Moore's Family Restaurant Assets...
Net cash flows from operating activities are....(hint: don’t forget about net income). Moore's Family Restaurant Assets & Liabilities as of 12/31/17 Assets & Liabilities projected to 12/31/18 ASSETS ASSETS Cash $492,118.00 Cash $589,118.00 Accounts Receivable $29,000.00 Accounts Receivable $49,095.00 Inventories $30,000.00 Inventories $30,000.00 Prepaid Expenses $2,000.00 Prepaid Expenses $11,000.00 Total Current Assets $553,118.00 Total Current Assets $679,213.00 Building $727,460.97 Building $760,000.00 Equipment $14,500.00 Equipment $18,000.00 Fixtures $33,320.00 Fixtures $35,500.00 Total Fixed Assets $775,280.97 Total Fixed Assets $813,500.00 Total Assets $1,328,398.97...
Morning Dove Company manufactures one model of birdbath, which is very popular. Morning Dove sells all...
Morning Dove Company manufactures one model of birdbath, which is very popular. Morning Dove sells all units it produces each month. The relevant range is 0–1,500 units, and monthly production costs for the production of 1,200 units follow. Morning Dove’s utilities and maintenance costs are mixed with the fixed components shown in parentheses. Production Costs Total Cost Direct materials $ 1,900 Direct labor 7,500 Utilities ($140 fixed) 570 Supervisor’s salary 2,800 Maintenance ($310 fixed) 460 Depreciation 800 Required: 1. Identify...