# Determine the optimal production of products to maximize total profit

Not what you're looking for?

Instruction:

- Review the attached document.

- Recreate the spreadsheet shown in the attached document.

- Marketing now believes that demand for the CC-7 model (X1 decision variable) will not exceed 200 units per month.

Problem:

- Add a new constraint to the model to restrict production of that product to a maximum of 200 units per month.

- Use the Excel add-in Solver to determine the optimal production of products to maximize total profit.

- Return the spreadsheet showing the optimal solution.

##### Purchase this Solution

##### Solution Summary

You will find the answer to this puzzling question inside.

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

##### Basics of corporate finance

These questions will test you on your knowledge of finance.

##### Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

##### Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

##### Lean your Process

This quiz will help you understand the basic concepts of Lean.