This model calculates the gross margin contributed by a direct mail campaign.
The model can be run from DS Lab or can be executed from the Excel spreadsheet called mailing.xls (included with the DS Lab sample files)
To run the model from DS Lab click the recalc tool, insert the new inputs and click OK. If you wish to change the mailing cost components and their volume breaks, open the variable elements called "Cost of insertion" and "Brochure, labels and other material" and modify the appropriate values.
To run the model from Excel and for all the DDE links to be established correctly MAILING.LAB must be opened first, followed by MAILING.XLM (the excel macro worksheet) followed by MAILING.XLS (the excel spreadsheet). In MAILING.XLS, change the three values "Percentage Sold", "Number of prospect" and "Percentage Contacted," in the appropriate cells and hit the start simulation button.
The purpose of this model is to show how a DS Lab model can be executed from within an Excel macro.
