The XYZVBA.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.
This is a model that does the same as the XYZ.XLS model. However, it uses Visual basic macros in Excel to create and run the model.

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


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