The XYZ.xls Model
XYZ Corporation

View the model
Download the model


In this model, you are the production manager at XYZ Corporation and you are responsible for determinimg the quantities of your two computer models to build. The Standard has a profit per unit of $300 and the Deluxe has a profit per unit of $500. The two models are produced from three components: the Standard Chassis, the Deluxe Chassis, and Disk Drives. You need to determine what combination of Standard and Deluxe Models will maximize XYZ's profit from the components currently in stock.
A: Adjustable cells,
B: Objective function,
C: Constraints.

Objective of Optimization:
The objective is to maximize the profit.


Keywords:
Break Even Point | Inventory | Marketing | Product Management | Product Mix | Production | Sales