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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!