Analytics Exercise: Developing an Aggregate Plan — Bradford Manufacturing

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.




    Individual Problems:

    Chapter 19: Problems 7, 9 and 11

    (Do not use Excel/Solver for solving these problems)



    Group Assignment:

    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.)

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp