Question 1) Jim makes toy trains. Below are observations for ten weeks thenumber of trains produced each week and the total cost of producing these trains.

Weeks

Trains Produced

Manufacturing Cost

1	10	257.40
2	20	601.60
3	30	782.60
4	40	765.40
5	45	895.50
6	50	1133.00
7	60	1152.80
8	55	1132.70
9	70	1459.20
10	40	970.10

1)Using a Simple Linear Model, generate a regression equation.(Show yourcalculations).

2)Generate estimates for each period and show errors on another column

3)Now that you have hand computed the Regression Equation, load this data in Exceland run Regression. Compare the results. Report R-squared, and the t-test results.

Question 2)

HP sells printers for $200. Demand is constant during the year, and annual demand is forecasted to be 600 units. Holding cost is $20 per unit per year, whereas the cost of ordering is $60 per order. Currently, the company is ordering 12 times per year (50 units each time). There are 250 working days per year, and the lead time is 10 days.

1. 1)Given the current policy of ordering 50 units at a time, what is the total of the annual ordering cost and the annual holding cost?

2)If the company used the absolute best inventory policy, what would be the total of ordering and holding costs?

3)What is the reorder point?