Question: Solve in Excel using the Solver Feature and provided detailed steps that are easy to follow throughout the process. In the razorsandblades.xls file example, suppose
Solve in Excel using the Solver Feature and provided detailed steps that are easy to follow throughout the process.
In the razorsandblades.xls file example, suppose the cost to produce a blade is $0.20. If you charge $0.35 for a blade, a customer buys an average of 50 blades from you. Assume the price elasticity of demand for blades is 3. What price should you charge for a razor and for a blade?
No Blade:
Price: $5, $5.05
Demand: $6, $5.88
unit cost: $ 2.00
Price: $ 4.75
demand: 6.6
Profit: $ 18.15
Blades
| price | demand |
| 5 | 6 |
| 5.05 | 5.88 |
| unit cost | $ 2.00 |
| blades per razor | 50 |
| profit per blade | $ 0.15 |
| price | $ 1.00 |
| demand | 15.6 |
| profit | $ 101.40 |
Demand for razors Demand for razors Demand for razors Demand for razors
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help