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

Mac has been using the home’s interior square feet for his exterior paint cost estimations. Recently he decided to include the number of external openings—the total number of doors and windows in a house—as a cost driver. Their cost is significant because they require time-consuming preparatory work and careful brushwork. The rest of the house usually is painted either by rollers or spray guns, which are relatively efficient ways to apply paint to a large area. Mac has kept careful records of these exterior painting costs on his last 12 jobs:

House	Square Feet	External Openings	Costs
1	2,500	13	$2,810
2	3,010	15	3,742
3	2,800	12	3,100
4	2,850	12	3,150
5	4,600	19	4,700
6	2,700	13	3,225
7	2,600	11	2,920
8	2,550	11	2,836
9	2,600	10	3,242
10	3,700	16	4,112
11	2,650	13	3,210
12	3,550	16	3,965

Required

Using the high-low cost estimation technique and square feet as the independent variable, determine the cost of painting a 3,300-square-foot house with 14 external openings. Also determine the cost for a 2,400-square-foot house with 8 externals openings.
Repeat requirement 1, but use number of external openings as the independent variable.
Plot the cost data against square feet and against openings. Which variable is a better cost driver? Why?
Create a multiple regression model for predicting cost based on openings and square feet. Comment on the statistical reliability and precision of this model.
What are the sustainability issues for this company, and what is the role of cost estimation in this regard?

Solutions

Expert Solution

Colby Messinger answered 5 months ago

Next > < Previous

Related Solutions

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

Developing and Using a Predetermined Overhead Rate: High-Low Cost Estimation For years, Mattoon Components Company has...

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.

Serial Case C6-72Calculate and compare cost estimates using high-low and regression methods (Learning Objectives 4 &...

Serial Case C6-72Calculate and compare cost estimates using high-low and regression methods (Learning Objectives 4 & 5) This case is a continuation of the Caesars Entertainment Corporation serial case that began in Chapter 1. Refer to the introductory story in Chapter 1, here for additional background. (The components of the Caesars serial case can be completed in any order.) Caesar Entertainment Corporation’s Form 10-K contains a variety of data in addition to financial statements. Below is a list that contains...

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

An important application of regression analysis in accounting is cost estimation. By developing an estimated regression...

An important application of regression analysis in accounting is cost estimation. By developing an estimated regression equation relating volume and cost, an analyst can estimate the cost associated with a particular manufacturing volume. Consider the following sample production volumes and total cost data. Production Volume (units) Total Cost ($) 400 6590 450 8235 550 8895 600 9720 700 10,540 750 11,530 a. Use these data to develop an estimated regression equation that could be used to predict the total cost...

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

Subjects