Question: Month Sales Orders Order-Processing Costs 1 3,000 $ 82,700 2 1,500 50,375 3 4,400 120,700 4 2,800 81,900 5 2,300 69,775 6 1,200 43,100 7
| Month | Sales Orders | Order-Processing Costs | |
|---|---|---|---|
| 1 | 3,000 | $ 82,700 | |
| 2 | 1,500 | 50,375 | |
| 3 | 4,400 | 120,700 | |
| 4 | 2,800 | 81,900 | |
| 5 | 2,300 | 69,775 | |
| 6 | 1,200 | 43,100 | |
| 7 | 2,000 | 62,500 |
(a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs.
14,000+$24.25X
Need Help with B
b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly order-processing costs. If needed, an Excel worksheet is provided in the following link in order to create the scatter diagram:
$ Blank + $Blank X
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
