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

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 show my excel output
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 show my excel output In a small suburban town, firefighters work

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!