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

 

Transcribed Image Text:

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 Labor and Cleaned Costs 350 $6,400 300 6,000 400 7,200 250 4,400 April May June jy August September October 375 6,800 200 4000 100 3840 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs. Monthly labor costs $ 2.720 11.2 X 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-5 2.720 x 1 112 x X Adjust the equation developed in requirement (b) to incorporate the effect of an anticipated 7 percent increase in wages, Monthly labor costs - ON S oxx 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 Labor and Cleaned Costs 350 $6,400 300 6,000 400 7,200 250 4,400 April May June jy August September October 375 6,800 200 4000 100 3840 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs. Monthly labor costs $ 2.720 11.2 X 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-5 2.720 x 1 112 x X Adjust the equation developed in requirement (b) to incorporate the effect of an anticipated 7 percent increase in wages, Monthly labor costs - ON S oxx