Pricing and Sales Volumes
Not what you're looking for?
The following uses the files EXAM.XLS and Developing_Country_Pricing.PDF.
In this simulation, you are about start selling a new product, an MP3 player (YourPlayer). Management has provided you with a proforma income statement to help assess the viability of the product. They need your help to complete the income statement.
There are four decisions to make.
- Sample pricing was obtained from several places in the country. Use this data (on the second tab) to guide your selection of a sales price for your product. Enter this number in the highlighted cell D6.
- Sample sales volumes (the number of units sold in other regions) were also collected. Use this data (on the third tab) to guide you in how many you think you will sell. Enter this number in the highlighted cell D8.
- You have an opportunity to outsource. If you elect to outsource, change the highlighted cell D10 to 0.68 and the highlighted cell I16 to 25000.
- If you elect to outsource, you have select from a location in either the Philippines or Thailand. Summary statistics for the manufacturing expense of a similar product was collected monthly for the past five years. The expense fluctuates because of quality issues, availability of trained staff, and downtime. Using this data, select a manufacturing site.
Write a brief description of how you picked your pricing and sales volume.
Write a brief description of how you selected a site.
Purchase this Solution
Solution Summary
This solution guides selections of sales prices for a product, how many it will sell and whether it will be outsourced and where.
Solution Preview
SOLUTION STEPS
Write a brief (one page) description of how you picked your pricing and sales volume.
1. What is the landscape? Get a "big picture" of the pricing and volume distribution.
a. Calculate descriptive statistics (Mean ± SE) for price and volume. You can do this faster using the "Descriptive Statistics" function of Excel.
b. Use the "Histogram" function of Excel to construct a frequency table and plot it as a bar chart.
(see graphs in attachments .doc and .xls)
Note:
- Pricing distribution does not appear to be normally distributed while sales volumes does
- Mean pricing for all regions is ~ $66 ± $10
- Mean sales volume is 24 ± 4 hundreds of units
2. A closer picture of the market: Per region analysis
a. Descriptive statistics: there seem to be ...
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.