This requires excel solver/filling in the graph to complete.

Problem 2 Given the below data set, calculate the optimal production batch size, the annual set up and holding costs for the optimal policy. 2,508 Input Annual demand, D Production rate, P Cost per unit, Holding cost, h Fixed cost per order, 5 Optimal Lot Size Economic production quantity, Q Number of setups per year Annual setup cost Annual holding cost Problem 2 Given the below data set, calculate the optimal production batch size, the annual set up and holding costs for the optimal policy. 2,508 Input Annual demand, D Production rate, P Cost per unit, Holding cost, h Fixed cost per order, 5 Optimal Lot Size Economic production quantity, Q Number of setups per year Annual setup cost Annual holding cost