Question
In Week 5 and 6(using the Decision Making Examples manual), you developed a breakeven analysis for Quality Sweaters company, sells hand-knitted sweaters The company is
In Week 5 and 6(using the Decision Making Examples manual), you developed a breakeven analysis for Quality Sweaters company, sells hand-knitted sweaters The company is planning to print a catalogue of its products and undertake a direct mail campaign. The objective of the model is to determine the company's profit and to see how sensitive the profit is to the response rate from the mailing. Now, use the fully developed spreadsheet (after completing the manual) and perform below changes on the model, 1. Export all the results and discussions to below questions How does a change in the response rate affect profit? For what response does the company break even? If the company estimates a response rate of 3%, should it proceed with the mailing?
- Continuing the previous problem use goal seek for each value of number mailed (once for 80000, once for 90000 and so on). For each, find the response rate that allows the company to break even.
- In the quality sweaters model, the range E9:E11 does not have a range name. Open your completed Excel file and name this range Costs. Then look at the formula in cell E12. It does not automatically use the new range name. Modify the formula so that it does.
- As the quality sweaters problem is now modelled, if all inputs remain fixed except for the number mailed, profit will increase indefinitely as the number mailed increased. This hardly seems relative- the company could become infinitely rich. Discuss realistic ways to modify the model so that this unrealistic behaviour is eliminated.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started