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:

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