Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image. Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: -> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. -> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. -> If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. -> If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. -> If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. -> If a customer last placed an order ve catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs $2 to send a catalog, and the average profit per order is $30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image.

Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The
following data are available:
-> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.
-> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.
-> If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives.
-> If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives.
-> If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives.
-> If a customer last placed an order ve catalogs ago, there is a 2% chance she will order from the next catalog she receives.

It costs $2 to send a catalog, and the average profit per order is $30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?

**Textbook Problem**

Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company's mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available:

- If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.
- If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.
- If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives.
- If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives.
- If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives.
- If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives.

It costs $2 to send a catalog, and the average profit per order is $30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
Transcribed Image Text:**Textbook Problem** Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company's mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: - If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. - If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. - If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. - If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. - If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. - If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs $2 to send a catalog, and the average profit per order is $30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
Expert Solution
steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Knowledge Booster
Financial management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.