Reference no: EM13966354
Bose makes extreme hi-end noise cancelling headphones for use in professional studios. The demand for the head phone model BHP-301 is dependent on the price it charges as defined by the equation, P = 2,700 - 0.0135 D, where P is the price in dollars and D is the demand in units. The fixed cost is $18.6 million per year. Variable cost = $1,080 per headphone. You are asked to develop an XL solution, like the way we did in the class.
Print the following columns with proper headings: Price, Demand, Revenue and Total Cost. Let the price change by one dollar between the rows (you will have lot of rows, but that is fine, you are printing only a select few as explained below.
Print only the following rows. This can be accomplished by hiding the other rows (use Format to do this)
The first three rows showing the row headings
The row corresponding to the maximum revenue, along with the one or two rows above and below that row
The row corresponding to the maximum profit, along with the one or two rows above and below that row
The row corresponding to the first break-even, along with the one or two rows above and below that row
The row corresponding to the second break-even, along with the one or two rows above and below that row
The last three rows
So overall, you will print enough rows that can be easily printed on a page, portrait mode. The entire thing can be neatly laid out on one page. To improve readability you may colorize those using different colors for revenue, profit and break-even. You may use very light shade if you don’t have color printer. It is your responsibility to make the lines clearly distinguishable.
Create a good looking graph. The graph should show demand on the x-axis and revenue curve and total cost line on y-axis. Show proper titles for the graph and the two axes
|
Which stand should the company produce
: What would be the incremental benefit of obtaining 15 additional labor hours Which stand(s) should the company produce?
|
|
Construct a stem-and-leaf display of the data
: a. Construct a stem-and-leaf display of the data. b. What is a typical, or representative, ow rate? c. Does the display appear to be highly concentrated or spread out?
|
|
Describe the stages of group development
: Describe the stages of group development. For each, discuss what questions the individual asks at that stage, and what the leader should do to facilitate it.
|
|
Business manager for a medium-sized firm
: If you were a business manager for a medium-sized firm, how would you decide where to purchase your indirect inputs – from an e-distributor or an e-procurement Net marketplace?
|
|
Proper titles for the graph and the two axes
: Bose makes extreme hi-end noise cancelling headphones for use in professional studios. The demand for the head phone model BHP-301 is dependent on the price it charges as defined by the equation, P = 2,700 - 0.0135 D, where P is the price in dollars ..
|
|
Expected sales-expected overstock and expected profit
: AspenWear, a retailer of ski wear needs to place an order for the Mirabelle, a designer ski jacket for the high-end market. The jacket retails for $600 and costs AspenWear $250 from a source in China. Compute the order quantity that will maximize Asp..
|
|
How would you define globalization
: Your readings offered some insight into the forces that drive companies to expand globally. Based upon the readings, what are the three sets of forces that drive, constrain, and shape entities to compete globally?
|
|
Sampling an existing population-conceptual population
: a. Why are these measurements not identical? b. Does this study involve sampling an existing population or a conceptual population?
|
|
List alternatives facing greenfield industries
: An outside company, McDonald Inc., made the machine seven years ago and can easily do the same modifications for $60,000. The cooling system used for this machine is not environmentally safe and would require some disposal costs. McDonald Inc. has..
|