Question: Can someone explain what im doing wrong and why i cant see the outputs (in yellow and green)? im suppose to solve with Solver and


In a small suburban town, firefighters work 8-hour shifts. Assume there are six shifts eachday that are divided into six 4-hour periods. The minimum number of firefighters needed on each shift is illustrated below. Firefighters must report to work at the beginning of the above time periods and must work eight consecutive hours. Use Excel to formulate and solve this labor planning problem to determine the minimum number of firefighters needed on each shift. File Home Insert Draw Page Layo Formulas Data Review View Automate Help H5 fx=SUMPRODUCT(B5:G5) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & [ & E & F & G & H & 1 & J & K & \\ \hline 1 & Minimize & & & & & & & & & & & \\ \hline & & & & & & & & & & & & \\ \hline 3 & & S1 & S2 & s & S4 & S5 & S6 & & & & & \\ \hline & & ShiftMidnight-4am & Shif4an8an & Sh8aNo & ShiftNoon-4pm & Shit4pm8pn & Shift8pm-Midnight & & & & & \\ \hline 5 & Number of Firefighters & 0.0 & 00 & 0 & 0.0 & 00 & 0.0 & $0.0 & & & & \\ \hline 6 & Constraints: & & & & & & & & & & & \\ \hline 7 & Midnight- 4 am & 1 & & & 8 & & 1 & 0.0 & x= & 5 & & \\ \hline 8 & 4am-8am & 1 & 1 & & & & & 00 & >= & 6 & & \\ \hline 9 & 8 am-Noon & & 1 & & & & & 0.0 & x= & 10 & & \\ \hline 10 & Noon- 4pm & & & & 1 & & & 0.0 & x= & 12 & & \\ \hline 11 & 4pm8pm & & & & 1 & 1 & & 0.0 & >= & 8 & & \\ \hline 12 & 8pm-Midnight & & & & & 1 & 1 & 0.0 & x= & 5 & & \\ \hline 13 & & & & & & & & LHS & Sign & RHS & & \\ \hline \end{tabular} Subject to the Constraints: Make Unconstrained Variables Non-Negative Select a Solving Method: Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
