Module 9 Project

1. What are various strategies you used in solving this complex problem, and how could you implement these strategies into a real-world project?
2. What are the challenges associated with the strategies you mentioned above?

Microsoft Excel 16.0 Answer Report Worksheet: [SC_EX_9-1.xlsx]Weekly Shipment Worksheet Report Created: 11/24/2023 3:15:34 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.078 Seconds. Iterations: 2 Subproblems: 8 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 0\%, Assume NonNegative Obiective Cell (Max) \begin{tabular}{|c|c|c|c|c|c|c|} \hline 4 & B & C & D & E & F & G \\ \hline 26 & \multicolumn{6}{|l|}{ Constraints } \\ \hline 27 & Cell & Name & Cell Value & Formula & Status & Slack \\ \hline 28 & $E$11 & Total_Volume & & 45$E$11=1 & Not Binding & 2 \\ \hline 31 & $C$9 & Drum_Sets_to_Ship & & 12$C$9>=1 & Binding & 0 \\ \hline 32 & $D$9 & Keyboards_to_Ship & & 9$D$9>=1 & Not Binding & 1 \\ \hline 33 & $C$9 & Drum Sets to Ship & & 12$C$9