Prepare a cost of quality report

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 April May June July August September October Miles Mowed Labor and Cleaned Costs 350 $4,000 300 3,750 400 4,500 250 2,750 375 4,250 200 2,500 100 2,400 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs. Monthly labor costs = $ 1,700 + $ 7 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 $ 0 + $ ox Adjust the equation developed in requirement (b) to…

Please show your work.

Do not give image format

Do not give solution in image

Please do not give solution in image format thanku

Room Revenue Transient Rooms Sold Group Rooms Sold Total Rooms Sold Operating Expenses Linen Cleaning Supplies Guest Supplies Outside Services Laundry Concierge Expense Office Supplies Reservation Expenses Reservation $150,000 Fixed Res Center Cost $180,000 Variable Reser. Center Department Cost at $6 per transient res. Total Reservation Expense 83,730 16,270 100,000 All other Expense $251,200 Total Operating Expenses Total Operating Expense Percentage $31,100 $24,000 $104,800 $24,000 $80,500 $60,000 $19,200 $581,200 $120,000

Please do not give solution in image format thanku

Scatter Diagrams and High-Low Cost EstimationFrom 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 Mowedand Cleaned LaborCosts April 350 $16,000 May 300 15,000 June 400 18,000 July 250 11,000 August 375 17,000 September 200 10,000 October 100 9,600 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.…

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: Cost of food sold Wages and fringe benefits Fees paid delivery help Rent on building Depreciation on equipment Utilities Supplies (soap, floor wax, etc.) Administrative costs Total Monthly sales in units 5,000 8,000 10,000 $15,000 $24,000 $30,000 4,350 4,560 4,700 1,300 2,080 2,600 1.300 1,300 1,300 400 400 400 750 840 900 150 180 200 1.500 1.500 1,500 $24.750 $34,860 $41,600 (a) Identify each cost as being variable, fixed, or mixed. Cost of food sold Wages and fringe benefits Fees paid delivery help Rent on building Depreciation on equipment Variable # Mixed ● Variable ÷ Fixed Fixed