Purchase Solution

Use Excel Solver to Develop Unit Prices for Products and Service

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

Solution Preview

The decision model and solution are in the attached file.

There were ...

Purchase this Solution


Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.