Home Insert J Get Data (Power Queryl 6 7 8 4 10 11 12 A10 + x ✓ fx A 1 cabinet nail type 2 Assembly Time(mins) 3 Polishi

[answerhappygod]

Home Insert J Get Data Power Queryl 6 7 8 4 10 11 12 A10 X Fx A 1 Cabinet Nail Type 2 Assembly Time Mins 3 Polishi 1 (81.33 KiB) Viewed 46 times

The company has 90,000 minutes of assembly time, 50,000 minutesof polishing time, and 53,000 minutes of packing time available.Integer constraints are not needed in this problem.
Complete an optimization model with a sensitivity report inexcel.
What is the total profit in the optimal solution? (Howwould I do this using excel solver? Please answer with screenshotsand formulas.)
Home Insert J Get Data (Power Queryl 6 7 8 4 10 11 12 A10 + x ✓ fx A 1 cabinet nail type 2 Assembly Time(mins) 3 Polishing Time (mirs) 4 Packing Time (mira) 5 Profit (5) #efnails to produce 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 AutoSave arr 37 38 30 40 41 42 OFF A B 2 C .... 43 44 Total Prot 4 Ready Draw Page Layout A Ba Sheet1 Data from Picture + B Brass nail $ V Refresh All Formulas Data Review View 4 2 v 2.5 2.50 $ Queries & Connections Properties Edit Links C Nickel nail D Chrome nail 3 1.5 2.00 $ 3 3 Stocks E Pewter nail 25 2.5 3.50 $ 5 4 5 4.50 Tell me Geography F G Used Optimization Shell File 44 KBY Sort Filter H Available I Clear Reapply Advanced 50,000.00 50,000.00 53,000.00 J 5#*. Text to Columns K L M H What If Analysis N Group Ungroup v Subtotal 0 P +3 3 Analysis Tools 2 Solver Q D 5 Share T Comments U + 100% T VI