Scatter Diagrams and High-Low Cost Estimation Asume the local peace Vision has the following information on the number of sales orders received and ordet-processing costs Manth Sains Orders Order Processing Costs 3000 1 2300 2000 115,00 100 34100 163100 1.SO 5200 12000 2.000 Required a use information from the high and low volume months to develop a cost estimating equation for monthly order processing costs $28.000 +485 (1.) Plot the data on a scatter diagram using the information from representative and low-volane months, develop a cost estimating equation for monthly production costs If needed. an Excel workshoot is provided in the following ink in beder to create the scatter diagram Scatter Diagram X2540483271 XX Check for Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle vision has the following information on the number of sales orders received and order processing costs. Month Sales Orders Order Processing Costs 3.000 $165.400 2 1,500 100,750 4.400 241.400 2800 163.00 2300 139,550 1.200 86,290 7 2.000 125.000 4 5 Required (a.) Use information trom the high and low.volume months to develop a cost-estimating equation for monthly order processing costs. 528,000 $48.5 (6) Plot the data on a scatter diagram. Using the information from representative high-and low vokime months, develop a cost estimating equation for monthly production costs. If neede an Excel worksheet is provided in the following link in order to create the scatter diagram Scatter Diagram 47.864311 XS 28.40483271 XX Chec Partially mimi 100.00