Mathematical Model Show your formulated model including its variables
Caiden
test2-problem-.xlsxREAD ME
| IT 608 | Response Workbook for Test Problems |
| * | You have agreed to abide by the GBC Code of Conduct and Academic Honor Code as a Goldey-Beacom College student. Whether your work is performed on campus or remotely, you are held to these standards of behaviour. |
| * | Do NOT share test files at any time. All duplicative work will be thrown out, resulting in 0 points. Further the incident may constitute a violation of the Academic Honor Code. |
| Student: | _REPLACE_THIS_TEXT_WITH_YOUR_FULL_NAME_ |
| _REPLACE_THIS_TEXT_WITH_YOUR_STUDENT_ID_ | |
| To complete this assignment: | |
| 1) | You MUST start from this template response workbook file, as-is, from CampusWeb. |
| 2) | Save this worksheet with YOUR NAME & ID added to the end. (Points will be deducted if missing.) |
| 3) | Enter your name and student ID in the cells, above. |
| 4) | The LP PROBLEM and any QUESTIONS are on the sheet, "Problem Description". |
| 5) | After working through the formulation step, present your complete mathematical model on the sheet, "Formulated Mathematical Model" |
| 6) | Present your complete and working solution on the sheet, "Solution". |
| 7) | Remember to respond respond directly to the question(s) posed in the sheet, "Problem Description". |
| 8) | Upload and submit your test response file on CampusWeb (http://CampusWeb.gbc.edu). Emailed work is NOT acceptable. |
Problem Description
| LP Problem | ||
| Description | ||
| A computer retail store sells two types of flat screen monitors: 22 inches and 25 inches, with a profit contribution of $300 and $250, respectively. The monitors are ordered each week from an outside supplier. | ||
| As an added feature, the retail store installs on each monitor a privacy filter that narrows the viewing angle so that only persons sitting directly in front of the monitor are able to see on-screen data. Each 25" monitor consumes about 30 minutes of installation time, while each 22" monitor requires about 10 minutes of installation time. | ||
| Product | Profit Contribution | Privacy filter install time |
| 22" Monitor | $300 | 30 min |
| 25" Monitor | $250 | 10 min |
| The retail store has approximately 40 hours of labor time available each week. | ||
| The total combined demand for both monitors is at least 40 monitors each week. | ||
| How many units of each monitor should the retail store order each week to maximize its weekly profits and meet its weekly demand? | ||
| Questions | Your Answers | |
| · How many 22" Monitors should be ordered per week? | ||
| · How many 25" Monitors should be ordered per week? | ||
~scratch~notes~
| for your use as needed |
Formulated Mathematic Model
| Mathematical Model |
| Show your formulated model including its variables, equations, clear labels |
Solution
| SOLUTION |
| Design and build a spreadsheet-based solution to on this sheet. |
