(Steps Shown) Productions costs for a large number of previous orders of varying sizes for a product are in the file production.xls. An analyst computes
Question: Productions costs for a large number of previous orders of varying sizes for a product are in the file production.xls. An analyst computes the production cost per unit in each order and averages these to get $50. Using this he gives a cost estimate of $24,000 for a new order for 500 units. Is this a reasonable cost estimate? Explain why or why not. Looking at the data in this file, can you give a better cost estimate?
Deliverable: Word Document 
![[All Steps] A manager would like to](/images/solutions/MC-solution-library-47055.jpg "[All Steps] A manager would like to know the relationship between")
[All Steps] A manager would like to know the relationship between
(Solution Library) A Human Resources Director, on learning about
![[Step-by-Step] The president of Dosem Moore Pharmaceuticals,](/images/solutions/MC-solution-library-47057.jpg "[Step-by-Step] The president of Dosem Moore Pharmaceuticals, Inc.")
[Step-by-Step] The president of Dosem Moore Pharmaceuticals, Inc.
![[Solution Library] Cardioelectronics, Inc. wants to establish](/images/solutions/MC-solution-library-47058.jpg "[Solution Library] Cardioelectronics, Inc. wants to establish an")
[Solution Library] Cardioelectronics, Inc. wants to establish an
(Step-by-Step) The Crimson Tide Corporation supplies blood test
Correlation Coefficient Significance Calculator using p-value - MathCracker.com