Production Mix Model Excel

Maximize overall profit by optimizing resource use, for products or services.

This model calculates the Product or Service Mix that maximizes overall profit considering available resources. It will identify the mix (number) of each Production Item to produce and any remaining resource. Up to six unique Production Items can be handled with ten specific resource inputs. Production Items can be considered as the output of any process including manufactured items and the provision of services. Resources are anything that is needed to produce or provide the Production Item. This may include materials, labor, machine time, floor space, transportation services etc. The model applies Linear Programming to identify the optimum result. It considers the resource demand, profit contribution and any minimum or maximum production requirements for each Production Item. By using the Solver Add-in included with Microsoft Excel the optimum solution is identified and can then be manually adjusted to test alternative scenarios. Operation is fully automated with tabular inputs and outputs. No knowledge of Linear Programming or Excel is required for use.

Changes: Evaluation Mode with Excel 2007 and Excel 97-2003 versions.

Minimum requirements: Microsoft Excel

Operating system: Win2000,Win98,WinOther,WinServer,WinVista,WinVista x64,WinXP,Other

Program URL: http://www.bizpeponline.com/ProductionMix.html

Production Mix Model Excel screenshot

...

Special permissions

You may freely distribute this software in Evaluation form without Registration Codes. Any software distributed must require the user to provide payment to Bizpep to maintain software beyond the Evaluation Period as originally designed. You may not sell or require payment in any form for Bizpep software. Evaluation software must be distributed without cost or penalty to the user.

EULA

Software is provided free for Evaluation. Payment is required to Register and fully enable this software. The specific suitability of this software must be independently assessed. Software is provided as is, use is entirely at the users risk, and use acknowledges that Bizpep and all associated parties are held harmless from any claims or losses relating to software provided.

Read more