Please only work on the “Analytics Exercise: Developing an Aggregate Plan — Bradford Manufacturing”. No need to work on other assignment problems listed in the attached document. The requirement for this case is to create a Linear Programming Model by listing all the contraints, decision variables and objective fuction. Use Excel Solver to solve the problem. Please let me know if you have any questions.
- HW ASSIGNMENT # 2
Chapter 19: Problems 7, 9 and 11
(Do not use Excel/Solver for solving these problems)
Refer to the “Bradford Manufacturing” case on pp. 510-511 of the text.
(a) Ignore the questions asked on p. 511 and develop a constrained linear optimization model (i.e. clearly define all variables, then construct the objective function and all constraints in algebraic format) for determining the optimal aggregate plan for Bradford Manufacturing.
(b) Using Excel/Solver, find and outline (in tabular form) the optimal aggregate plan resulting from your model in part (a). Attach a copy (or copies) of the Excel worksheet(s) as supporting material.
N.B. Only one submission per group is required.
Due Date: Wednesday, January 27, 2016 (by 4:00 P.M.)