# Determine the optimal production of products to maximize total profit

Not what you're looking for?

Instruction:

- Review the attached document.

Problem:

- Recreate the spreadsheet shown in the attached document.

- Change the X2 lower constraint value (cell F12) from 200 units to 100 units.

- 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

##### Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

##### Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

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

Importance of Critical Thinking

##### Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

##### Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.