Fashionables is a franchisee of The UnLimited, the well-known retailer of fashionable clothing. Prior to the winter season, The UnLimited offers Fashionables the choice of five different colors of a particular sweater design. The sweaters are knit overseas by hand, and because of the lead times involved, Fashionables will need to order its assortment in advance of the selling season. As per the contracting terms offered by The UnLimited, Fashionables will also not be able to cancel, modify or reorder sweaters during the selling season. Demand for each color during the season is normally distributed with a mean of 600 and a standard deviation of 175. Further, you may assume that the demand for each sweater is independent of the demand for any other color. The UnLimited offers the sweaters to Fashionables at the wholesale price of $44 per sweater, and Fashionables plans to sell each sweater at the retail price of $74 per unit. The UnLimited does not accept any returns of unsold inventory. However, Fashionables can sell all of the unsold sweaters at the end of the season at the fire-sale price of $18 each. If a part of the question specifies whether to use Table 13.4, or to use Excel, then credit for a correct answer will depend on using the specified method. a. How many units of each sweater-type should Fashionables order to maximize its expected profit? Use Table 13.4 and round to nearest integer. If Fashionables wishes to ensure a 97.5% in-stock probability, what should its b. order quantity be for each type of sweater? Use Table 13.4 and round to nearest integer. C. Say Fashionables orders 750 of each sweater. What is Fashionables' expected profit? Use Table 13.4. d. Say Fashionables orders 750 of each sweater. What is the stockout probability for each sweater? Use Excel. (Round your answer to 4 decimal places.)
Fashionables is a franchisee of The UnLimited, the well-known retailer of fashionable clothing. Prior to the winter season, The UnLimited offers Fashionables the choice of five different colors of a particular sweater design. The sweaters are knit overseas by hand, and because of the lead times involved, Fashionables will need to order its assortment in advance of the selling season. As per the contracting terms offered by The UnLimited, Fashionables will also not be able to cancel, modify or reorder sweaters during the selling season. Demand for each color during the season is normally distributed with a mean of 600 and a standard deviation of 175. Further, you may assume that the demand for each sweater is independent of the demand for any other color. The UnLimited offers the sweaters to Fashionables at the wholesale price of $44 per sweater, and Fashionables plans to sell each sweater at the retail price of $74 per unit. The UnLimited does not accept any returns of unsold inventory. However, Fashionables can sell all of the unsold sweaters at the end of the season at the fire-sale price of $18 each. If a part of the question specifies whether to use Table 13.4, or to use Excel, then credit for a correct answer will depend on using the specified method. a. How many units of each sweater-type should Fashionables order to maximize its expected profit? Use Table 13.4 and round to nearest integer. If Fashionables wishes to ensure a 97.5% in-stock probability, what should its b. order quantity be for each type of sweater? Use Table 13.4 and round to nearest integer. C. Say Fashionables orders 750 of each sweater. What is Fashionables' expected profit? Use Table 13.4. d. Say Fashionables orders 750 of each sweater. What is the stockout probability for each sweater? Use Excel. (Round your answer to 4 decimal places.)
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...
Related questions
Question
Transcribed Image Text:Fashionables is a franchisee of The UnLimited, the well-known retailer of fashionable clothing.
Prior to the winter season, The UnLimited offers Fashionables the choice of five different colors of
a particular sweater design. The sweaters are knit overseas by hand, and because of the lead
times involved, Fashionables will need to order its assortment in advance of the selling season.
As per the contracting terms offered by The UnLimited, Fashionables will also not be able to
cancel, modify or reorder sweaters during the selling season. Demand for each color during the
season is normally distributed with a mean of 600 and a standard deviation of 175. Further, you
may assume that the demand for each sweater is independent of the demand for any other color.
The UnLimited offers the sweaters to Fashionables at the wholesale price of $44 per sweater, and
Fashionables plans to sell each sweater at the retail price of $74 per unit. The UnLimited does not
accept any returns of unsold inventory. However, Fashionables can sell all of the unsold sweaters
at the end of the season at the fire-sale price of $18 each.
If a part of the question specifies whether to use Table 13.4, or to use Excel, then credit for a
correct answer will depend on using the specified method.
a.
How many units of each sweater-type should Fashionables order to maximize its
expected profit? Use Table 13.4 and round to nearest integer.
If Fashionables wishes to ensure a 97.5% in-stock probability, what should its
b. order quantity be for each type of sweater? Use Table 13.4 and round to nearest
integer.
C.
Say Fashionables orders 750 of each sweater. What is Fashionables' expected
profit? Use Table 13.4.
d.
Say Fashionables orders 750 of each sweater. What is the stockout probability for
each sweater? Use Excel.
(Round your answer to 4 decimal places.)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.