Use the Table Below to Answer the Following Questions) Use a Linear Optimization Model Based on the Data to Luthiers

question 43

Multiple Choice

Use the table below to answer the following questions) .
Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. ScarCT is assembled elsewhere) . Pickson wants to determine how many guitars to make to maximize monthly profit. $\begin{array} { |l|l|l|l|l|l| } \hline \begin{array} { l } \text {Pickson Luthiers }\\ \text {Corporation }\\\end{array}\\\hline\\\hline \text {Data}\\\hline \text { Guitar Model } & \begin{array}{l}\text { Selling } \\\text { price/Unit }\end{array} & \begin{array}{l}\text { Variable } \\\text { cost/Unit }\end{array} & \text { Min Sales } & \text { Max Sales } \\\hline \text { ScarCT } & 750.00 & 660.00 & 0 & 2500 \\\hline \text { Dela Mort } & 788.00 & 680.00 & 0 & 2000 \\\hline \text { Warax } & 800.00 & 700.00 & 100 & 1000 \\\hline \text { Invazen } & 850.00 & 800.00 & 80 & 500 \\\hline\\\hline \begin{array}{l}\text { Production rates } \\\text { units/hour) }\end{array} & \text { ScarCT } & \text { Dela Mort } & \text { Warax } & \text { Invazen } & \begin{array}{l}\text { Hours } \\\text { Available }\end{array} \\\hline \text { Assembly } & - & 35 & 25 & 20 & 220 \\\hline \text { Painting } & 35 & 20 & 15 & 10 & 220 \\\hline \text { Sound Testing } & 20 & 10 & 20 & 18 & 220 \\\hline \text { Inspection } & 10 & 12 & 8 & 5 & 220 \\\hline \text { Packaging } & 9 & 10 & 5 & 8 & 220\\\hline\end{array}$
Use a linear optimization model based on the data to answer the following question.
-According to the Sensitivity Report, by how much should the unit profit on ScarCT be increased in order for its production to be feasible?

---

Definitions:

Bad Barrel

A metaphor implying that systemic issues within an organization or environment lead to unethical behaviour or corruption, not just individual 'bad apples'.

Corporate Culture

The shared values, beliefs, and practices that shape the social and psychological environment of a business organization.

Observations

The act of carefully watching, monitoring, or noting phenomena or behaviors, often for data collection and analysis.