A snowmobile manufacturer produces three models, the XJ6, the XJ7, and the XJ8. In any given production-planning

Question:

A snowmobile manufacturer produces three models, the XJ6, the XJ7, and the XJ8. In any given production-planning week, the company has 40 hours available in its final testing bay. Each XJ6 requires 1 hour of testing, each XJ7 requires 1.5 hours, and each XJ8 takes 1.6 hours. The revenue (in $thousands) per unit of each model is defined as ($4 - SO.lXj) for XJ6, ($5 - $0.2X2) for XJ7, and ($6 - $0.2X3) for XJ8, where Xh X2, and X3 are the numbers of XJ6, XJ7, and XJ8 models made, respectively. Formulate this problem to maximize revenue and solve it by using Excel. Use several different starting values for the decision variables to try to identify a global optimal solution.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 9780136115830

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: