Question

In: Accounting

Scatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Will County Highway Department...

Scatter Diagrams and High-Low Cost Estimation
From April 1 through October 31, Will County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to help her in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations:

Month Miles Mowed
and Cleaned
Labor
Costs
April 350 $14,400
May 300 13,500
June 400 16,200
July 250 9,900
August 375 15,300
September 200 9,000
October 100 8,640


a. Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs.

Monthly labor costs = Answer + Answer X


b. Plot the data on a scatter diagram. Using the information from representative high- and low volume months, use the high-low method to develop a cost-estimating equation for monthly labor costs.

Monthly labor costs = Answer + Answer X


d. Adjust the equation developed in requirement (b) to incorporate the effect of an anticipated 7 percent increase in wages.

Monthly labor costs = Answer + Answer X

Solutions

Expert Solution

SOLUTION:

a) High Low Method :

Variable Cost = (Highest Activity Cost−Lowest Activity Cost)/(Highest Activity Units-Lowest Activity Units)

Highest Activity Units = 400 Miles

Highest Activity Cost = $ 16,200

Lowest Activity Units = 100 Miles

Lowest Activity Cost = $ 8640

Variable Cost = ($16,200 - $8640)/(400-100)

= 7560/300

Variable Cost Per Mile = $ 25.2 per Mile.

Fixed Cost = Highest Activity Cost − (Variable Cost * Highest activity Units)​

Fixed Cost = $ 16,200 - ($25.2*400)

= $ 16,200 - $ 10,080

Fixed Cost = $ 6,120

b) Scatter Diagram :

Equation (y = mx+c ) = Labour Cost = $25.2*(Miles) + Fixed Cost

Eg: Labour Cost at 400 Miles = ($25.2 * 400) + 4800

Labour Cost = $14,880

c) If the wage rate increases by 7%,

Variable cost Per Mile = $25.2 + (25.2*7%)

Revised Variable cost per Mile = $ 25.2 + 1.764 = $ 26.964

Cost Equation will be : Labour Cost = $26.964 * (Miles) + Fixed Cost

  Labour Cost = $26.964 * (Miles) + $ 4,800


Related Solutions

In applying the high-low method of cost estimation to mixed costs, how is the total fixed...
In applying the high-low method of cost estimation to mixed costs, how is the total fixed cost estimated? If fixed costs increase, what would be the impact on the (a) contribution margin? (b) income from operations? An examination of the accounting records of Clowney Company disclosed a high contribution margin ratio and production at a level below maximum capacity. Based on this information, suggest a likely means of improving income from operations. Explain.
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Jimmy John's restaurant has the...
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Jimmy 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 4,250 4,400 4,500 Fees paid delivery help 1,250 2,000 2,500 Rent on building 1,200 1,200 1,200 Depreciation on equipment 600 600 600 Utilities 500 560 600 Supplies (soap, floor wax, etc.) 150...
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 4,200 4,320 4,400 Fees paid delivery help 1,100 1,760 2,200 Rent on building 1,100 1,100 1,100 Depreciation on equipment 900 900 900 Utilities 800 920 1,000 Supplies (soap, floor wax, etc.) 250 340 400 Administrative...
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Potbelly’s restaurant has the following...
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Potbelly’s 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...
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Potbelly’s restaurant has the following...
Cost Behavior Analysis in a Restaurant: High-Low Cost Estimation Assume a Potbelly’s restaurant has the following information available regarding costs at representa- tive 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 ............................4,2004,3204,400 Fees paid delivery help...............................1,100 1,760 2,200 Rent on building ....................................1,100 1,100 1,100 Depreciation on equipment ...........................900900900 Utilities ...........................................8009201,000 Supplies (soap, floor wax, etc.) ........................250340400 Administrative costs.................................1,700 1,700 1,700 Total .............................................$20,050$27,040 $31,700 Required a. Identify each cost...
Cost Estimation; High-Low and Regression Methods The Mac Davis Company specializes in the purchase, renovation, and...
Cost Estimation; High-Low and Regression Methods The Mac Davis Company specializes in the purchase, renovation, and resale of older homes. Mac employs several carpenters and painters to do the work for him. It is essential for him to have accurate cost estimates so he can determine total renovation costs before he purchases a piece of property. If estimated renovation costs plus the purchase price of a house are higher than the house’s estimated resale value, it is not a worthwhile...
Computational Problems: Cost-Volume-Profit Analysis and High-Low Method of Estimation 1. PPP Publishers has collected the following...
Computational Problems: Cost-Volume-Profit Analysis and High-Low Method of Estimation 1. PPP Publishers has collected the following data for recent months: Month Issues Published Total Cost May 20,500 $20,960 June 22,300 $21,428 July 18,750 $20,505 August 21,200 $21,395 Each issue sells for $1.50 Required: a) Using the high-low method, find the following. i. Variable cost per unit (issue): ___________________________ ii. Total fixed cost per month: ____________________________ iii. Cost Equation/Function: ____________________________________ b) i. What is the total estimated cost for a month...
Developing and Using a Predetermined Overhead Rate: High-Low Cost Estimation For years, Mattoon Components Company has...
Developing and Using a Predetermined Overhead Rate: High-Low Cost Estimation For years, Mattoon Components Company has used an actual plantwide overhead rate and based its prices on cost plus a markup of 30 percent. Recently the marketing manager, Holly Adams, and the production manager, Sue Walsh, confronted the controller with a common problem. The marketing manager expressed a concern that Mattoon's prices seem to vary widely throughout the year. According to Adams, "It seems irrational to charge higher prices when...
High-Low Cost Estimation and Profit Planning Comparative 2007 and 2008 income statements for Dakota Products Inc....
High-Low Cost Estimation and Profit Planning Comparative 2007 and 2008 income statements for Dakota Products Inc. follow: DAKOTA PRODUCTS INC. Comparative Income Statements For Years Ending December 31, 2007 and 2008 2007 2008 Unit sales 5,000 8,000 Sales revenue $60,000 $96,000 Expenses (64,000) (76,000) Profit (loss) $(4,000) $20,000 (a) Determine the break-even point in units. Answer 0 units (b) Determine the unit sales volume required to earn a profit of $5,000. Answer 0
Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North...
Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North American automobile manufacturers. Although the company has a capacity of 300,000 units per year, it is currently producing at an annual rate of 180,000 units. SafeRide, Inc. has received an order from a German manufacturer to purchase 60,000 units at $7.00 each. Budgeted costs for 180,000 and 240,000 units are as follows: 180,000 Units 240,000 Units Manufacturing costs Direct materials $450,000 $600,000 Direct labor...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT