Explore BrainMass
Share

Use Excel Solver to Develop Unit Prices for Products and Service

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com December 20, 2018, 5:40 am ad1c9bdddf
https://brainmass.com/business/finance/excel-solver-develop-unit-prices-products-service-337530

Attachments

Solution Preview

The decision model and solution are in the attached file.

There were ...

Solution Summary

The solution uses Excel Solver to develop unit prices for products and services.

$2.19