Explore BrainMass
Share

Explore BrainMass

    Use Excel Solver to Develop Unit Prices for Products and Service

    This content was COPIED 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 October 10, 2019, 1:30 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