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?