Production Mix Model
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.
Excel 2010/2007 and Excel 93-2003 Versions are now included in the download package. Save the download file and its content files to a known location on your local computer and then from this location select the software file that matches your Excel version.
Download Production Mix Model Excel 30
Compressed Zip file - pmme.zip 225 kb
Software downloaded as a standard Compressed Zip file (.zip) requires unzipping for use. It is suitable for all operating systems. Click the link to download and save the zip file to your computer. Then unzip/extract the downloaded file and save the software spreadsheet file. To use the software open the spreadsheet file.
Download Production Mix Model Excel 30
Self-Extracting Zip file - pmme.exe 288 kb
Software downloaded as a Self-Extracting Zip file (.exe) will self extract the software file. It is suitable for windows operating systems. Click the link to download and save the exe file to your computer. Then open the downloaded file and click Unzip. This will save the software spreadsheet file in the same directory as the Self-Extracting Zip file. To use the software open the spreadsheet file.
You can download Production Mix Model Excel free of charge for evaluation but to fully enable your software requires registration. If you have not already purchased a software license to register your software you can
for full functionality and a 30 day money back guarantee. Evaluation software is fully enabled when you input your registration details.
Only US$69.00 for a Single User Non-Commercial License, plus a 30% discount for Multi User Licenses at just US$48.30. Additional pricing options are provided when you click the Order Now button.
The download package includes both an Excel 2010/2007 .xlsm file and an Excel 97-2003 .xls file. Save the download package and its content files to a known location on your local computer and from this location open the Excel file that corresponds with your Excel version. Macros must be enabled for this software to function. If you cannot access the input sheet or the command buttons do not function macros are not enabled. In this case please refer to the Enable Macros information below.
Enable Macros using Excel 2010/2007 to open a .xlsm file - When you open the .xlsm Excel file with Excel 2010/2007 macro status and options will depend on your system and security settings. The .xlsm extension indicates the file is an Excel Macro-enabled Workbook. If macros are not enabled from the top ribbon click Developer, Macro Security to access the Trust Center. If the Developer tab is not displayed, click the Microsoft Office Button, Excel Options, Trust Center, and the Trust Center Settings Button. From the Trust Center click Trusted Locations, Add new location, browse to the directory in which the Excel software file is saved, select the sub folders option if required, click OK, and then click OK once more to exit the Trust Center. This enables macros for any files saved in a Trusted Location. Only files that you trust should be saved in Trusted Locations, if you save all your Bizpep Excel files to a trusted directory macros will be enabled and they will run correctly. For additional information see Microsoft's Create, remove, or change a trusted location for your files. Alternatively from the Macro Settings category in the Trust Center you can select 'Enable all macros' however this enables macros in files from any location and should only be used when all files you access are trusted.
Enable Macros using Excel 93-2003 to open a .xls file - If when you open the Excel software you are not presented with an option to enable macros you may need to adjust your macro security levels. To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros.
You can download this software free of charge for evaluation. Software is in Microsoft Excel format and Excel is required for use. To register software and enable all functions you must purchase the appropriate license. You can Order online for immediate delivery and receive a 30 day money back guarantee.
Conditions of Use
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 the developer and all associated parties are held harmless from any claims or losses relating to software provided.