Q1: Production Planning (4 points) (LP formulation for this problem is provided. You need to use Solver to find out the optimal solutions. Write the answers in this file and attach the spreadsheet with the solution. I will check your Solver inputs and outputs.) . The National Steel Corporation (NSC) produces a special-purpose steel that is used in the aircraft and aerospace industries. The marketing department of NSC has received orders for 2400, 2200, 2700 and 2500 tons of steel during each of the next four months. NSC can meet these demands by producing the steel, by drawing from its inventory or by a combination of both. The production costs per ton of steel during each of the next four months are projected to be $7400, $7500, $7600 and $7800. Production capacity can never exceed 4000 tons in any month. All production takes place at the beginning of the month and immediately thereafter the demand is met. The remaining steel is then stored in inventory at a holding cost of $120/ton for each month that it remains there. NSC currently has an inventory of 1000 tons of steel. The inventory level at the end of the fourth month must be at least 1500 tons. The NSC wants to find the production plan that will minimize the total cost (production + holding) over the next four months while satisfying the demand. . Below is the linear programming formulation for this problem: (C2) Min z = 7400 P1+ 7500 P2 + 7600 P3 + 7800 P4+ 120 11 + 120 12 + 120 13 + 12014 Sit. P1-11 = 1400 (D1) 11 + P2-12 = 2200 (D2) 12 + P3- 13 = 2700 (D3) 13 + P4-14 = 2500 (DA) 14> 1500 (E5) Pi