PLEASE SHOW SOLUTION ON EXCEL WITH FORMULAS

Home Insert Draw Page Layout Formulas Data Review View Tell me X y Calibri (Body) v 11 vi #Insert v V General === 22 y Conditional Formatting Format as Table v E 2700 SX Delete v LV Paste v V V $ % ) V 2,00 Cell Styles Format v Sort & Filter Find & Select y E36 X A C D E F G M R V 2 o a u A company is going to produce an item in four different production plants. Labor needed, materials used, and production cost in each production plant, to produce one unit, are different and provided below: , Plant 1 Plant 2 Plant Plant 4 Production quantity 7 PLANT 1 PLANT 2 PLANT 3 PLANT 4 4 Labor (hr) 4 5 3 6 Materials (lb) Cost/unit 4 $5 5 $8 8 $7 1 $5 R 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 25 27 28 29 30 31 32 The company has to produce at least 350 units at plant 2. The demand is forecasted to be 1000 units. The total available labor and materials are 5000 hours and 4000 pounds, respectively. Assume that we want to minimize the production cost; by using Solver, calculate how many units the company needs to produce in each production plant. The rubric Correct answer 3 points Attempt 0.5 to 3 points no attempt Opoint The Problem A K 35 36 37 35 39 40 41 42 43