Question

Linear Programming Problems (150 points) Please describe what you did and turn in either a spreadsheet with the description in the notes or copy- and-paste an image of the model into Word. 1. Optimization problem (75 points) – Your company, Cool Stuff Incorporated, makes air conditioners (AC) and fans. Each AC makes $25 profit per unit and each fan makes $15 profit per unit. Each AC needs 3 hours of assembly and 2 hours for painting. Each fan requires 2 hours of assembly and 1 hour of painting. Each week you have 240 hours of assembly and 140 hours of painting available. a. How many ACs and fans should you make to maximize profit? b. You realized that there is a marketing issue and you need to make sure that you need to produce no more than 80 fans and at least 20 AC units. How many of each should you produce under this scenario to maximize profit?

          Linear Programming Problems (150 points)

Please describe what you did and turn in either a spreadsheet with the description in the notes or copy-
and-paste an image of the model into Word.

1. Optimization problem (75 points) – Your company, Cool Stuff Incorporated, makes air
conditioners (AC) and fans. Each AC makes $25 profit per unit and each fan makes $15 profit per
unit. Each AC needs 3 hours of assembly and 2 hours for painting. Each fan requires 2 hours of
assembly and 1 hour of painting. Each week you have 240 hours of assembly and 140 hours of
painting available.
a. How many ACs and fans should you make to maximize profit?
b. You realized that there is a marketing issue and you need to make sure that you need to
produce no more than 80 fans and at least 20 AC units. How many of each should you
produce under this scenario to maximize profit?

Linear Programming Problems (150 points)

Please describe what you did and turn in either a spreadsheet with the description in the notes or copy-
and-paste an image of the model into Word.

1. Optimization problem (75 points) – Your company, Cool Stuff Incorporated, makes air
conditioners (AC) and fans. Each AC makes 25 profit per unit and each fan makes15 profit per
unit. Each AC needs 3 hours of assembly and 2 hours for painting. Each fan requires 2 hours of
assembly and 1 hour of painting. Each week you have 240 hours of assembly and 140 hours of
painting available.
a. How many ACs and fans should you make to maximize profit?
b. You realized that there is a marketing issue and you need to make sure that you need to
produce no more than 80 fans and at least 20 AC units. How many of each should you
produce under this scenario to maximize profit?

Added by Sara P.

Question

Please give Ace some feedback