pease solve problem 3 and make sure to use Microsoft Excel with Analytic Solver(or Open Solver) and not Excel Solver.

.. T-Mobile @ 53% 6:04 PM HW #2.pdf a Back Problem (20 points) In a small suburban town, firefighters works-hour shifts. Assume there are 6 shifts cach day that are divided into six 4-hour period. The minimum number of firefighters needed on each shitis illustrated below Shine Midnight4u.m. Number of Firefighters Needed 4.-8.m. 8am-Neon 10 Nooom 4pm-8pm 8pm-Midnight Firefighters must report to work at the beginning of the above time periods and must work eight Formulate the given problem scenario as a linear program so as to determine the minimum number of firefighters across all shifts. Setup sebe the problem using Microsoft Excel with Analytic Solver for Open Satvers. For the mathematical formulation, provide a complete mathematical description of the decision variables (with mix), objective function and constr. You should we expliciter implicit) form. Also the spreadsheet model setup should provide clearly labeled values used for the decision variables, constraints, and objective function Problem 4 (20 points) A manufacturer of rotary pumps is planning production for the next four months. The forecast demand for the rotary pumps is shown in the following table Rotary pump SEP OCT NOV DEC Standard 875 1.100 Heavy duty 900 390 1.200 1.300 At the beginning of September, the warehouse is expected to be completely empty. There is room for no more than 1,800 rotary pumps to be stored. Holding costs for both types are 55 per unit per month. Because workers are given time off during the holidays, the manufacturer wants to have at least 800 standard rotary pumps and 50 heavy duty rotary pumps already in the warehouse at the beginning of January Production costs are $125 per unit for standard rotary pumps and $135 per unit for heavy duty retary pumps. Because demand for materials is rising production costs are expected to rise by 5% per month through the end of the year Labor to make the standard rotary pump is 0.45 hours per unit, making heavy duty rotary pumps takes 0.52 hours per unit of labor. Management has agreed to schedule at least 1.000 hours per month of labor. As many as 200 extra hours per month are available to mastagement at the same cost, except during the month of December, when only 100 extra hours are powable Formulate the given problem scenario as a linear program so as to determine the production schedule for standard and heavy duty rotary pumps for the four months Setup solve the problem using Microsoft Excel with Analytic Solver for Open Solver). For the mathematical formulation, provides complete mathematical descritor the decision variables with its shortive Dashboard Calendar To Do Notifications Inbox .. T-Mobile @ 53% 6:04 PM HW #2.pdf a Back Problem (20 points) In a small suburban town, firefighters works-hour shifts. Assume there are 6 shifts cach day that are divided into six 4-hour period. The minimum number of firefighters needed on each shitis illustrated below Shine Midnight4u.m. Number of Firefighters Needed 4.-8.m. 8am-Neon 10 Nooom 4pm-8pm 8pm-Midnight Firefighters must report to work at the beginning of the above time periods and must work eight Formulate the given problem scenario as a linear program so as to determine the minimum number of firefighters across all shifts. Setup sebe the problem using Microsoft Excel with Analytic Solver for Open Satvers. For the mathematical formulation, provide a complete mathematical description of the decision variables (with mix), objective function and constr. You should we expliciter implicit) form. Also the spreadsheet model setup should provide clearly labeled values used for the decision variables, constraints, and objective function Problem 4 (20 points) A manufacturer of rotary pumps is planning production for the next four months. The forecast demand for the rotary pumps is shown in the following table Rotary pump SEP OCT NOV DEC Standard 875 1.100 Heavy duty 900 390 1.200 1.300 At the beginning of September, the warehouse is expected to be completely empty. There is room for no more than 1,800 rotary pumps to be stored. Holding costs for both types are 55 per unit per month. Because workers are given time off during the holidays, the manufacturer wants to have at least 800 standard rotary pumps and 50 heavy duty rotary pumps already in the warehouse at the beginning of January Production costs are $125 per unit for standard rotary pumps and $135 per unit for heavy duty retary pumps. Because demand for materials is rising production costs are expected to rise by 5% per month through the end of the year Labor to make the standard rotary pump is 0.45 hours per unit, making heavy duty rotary pumps takes 0.52 hours per unit of labor. Management has agreed to schedule at least 1.000 hours per month of labor. As many as 200 extra hours per month are available to mastagement at the same cost, except during the month of December, when only 100 extra hours are powable Formulate the given problem scenario as a linear program so as to determine the production schedule for standard and heavy duty rotary pumps for the four months Setup solve the problem using Microsoft Excel with Analytic Solver for Open Solver). For the mathematical formulation, provides complete mathematical descritor the decision variables with its shortive Dashboard Calendar To Do Notifications Inbox