300

250

IT 608
SOLUTION
Mathematical Model
Show your formulated model including its variables, equations, clear labels
Student:
Design and build a spreadsheet-based solution to on this sheet.
1)
2)
3)
4)
Save this worksheet with YOUR NAME & ID added to the end. (Points will be deducted if missing.)
5)
Response Workbook for Test Problems
6)
7)
Present your complete and working solution on the sheet, ”
Solution
“.
8)
After working through the formulation step, present your complete mathematical model on the sheet, ”
Formulated Mathematical Model
”
The LP PROBLEM and any QUESTIONS are on the sheet, ”
Problem Description
“.
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.
*
To complete this assignment:
You MUST start from this template response workbook file, as-is, from CampusWeb.
Upload and submit your test response file on CampusWeb (http://CampusWeb.gbc.edu).
Emailed work is NOT acceptable.
_REPLACE_THIS_TEXT_WITH_YOUR_STUDENT_ID_
_REPLACE_THIS_TEXT_WITH_YOUR_FULL_NAME_
Enter your name and student ID in the cells, above.
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…