Please see attached document.
Develop prices using Excel Solver - Lindo is OK, but Excel Solver is much preferred so that changes can be made.
You will need baselines in terms of units. Please feel free to make the following assumptions for a period of 1 year:
# of units (basic license products): 350
# of units (enterprise license products): 150
# of customers that are "Corporate": 200
# of customers that are "Early Purchasers": 120
# of customers that are "Regular": 180
# of customers that opted for warranty services: 50
# of customers that opted for customer support services: 90.
The decision model and solution are in the attached file.
There were ...
The solution uses Excel Solver to develop unit prices for products and services.