Profit Projections Under Four Order Scenarios $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $- 10000 120 $450,000.00 $100,000.00) $150,000.00 P(Demand sQ)=; A + 1200 14000 16000 18000 Oa 18,980 O b. 22,653 O 17.273 -Q-15,000 -Q-18,000 A common method for determining the order quantity is called the single-period inventory model. This model fits your current situation because you are making only one single order for the holiday season. The maximum expected profit in the single-inventory model is based on the following formula: 8 P(Demand Q)=8+11 = 0.4211 18000 20000 22000 24000 26000 28000 30000 What quantity ordered (0) corresponds to a probability of P-0.4211 in order to maximze profit? Cu + Co where P(Demand s Q) is the probability that demand is less than or equal to the recommended order quantity, Q. The term cu is the cost per unit of underestimating demand (and losing salles because of going out of stock) and co is the cost per unit of overestimating demand (having unsold inventory). So, $24 $16 $8 lost per unit it Weather Teddy runs out of stock and Ku=$16-$5 $11 lost per unit if left-over inventory must be sold at the clearance price. = Therefore SALES (UNITS) 0.4211 -Q-24,000 24 Single-period Inventory Model for Weather Teddy Q=? Q-28,000 0.5789 1 -20.000 What is the optimal production / order quantity in order to maximize profit?

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
Profit Projections Under Four Order Scenarios
$250,000.00
$200,000.00
$150,000.00
$100,000.00
$50,000.00
S-
$450,000.00)
$(100,000.00)
$(150,000.00)
10000 1200 14000 16000 18000 20000 22000 24000 26000 28000 30000
P(Demand ≤ Q°) =
O c. 17,273
O d. 21,024
-
-Q-15,000
3
A common method for determining the order quantity is called the single-period inventory model. This model fits your current situation because you are making only one single order for the holiday season. The maximum expected profit in the single-inventory model is based on the following formula:
cu + co
8
P(Demand ≤ Q¹) = 8 + 11 = 0.4211
What quantity ordered (Q)
corresponds to a probability
of P-0.4211 in order to
maximze profit?
where P(Demand s Q) is the probability that demand is less than or equal to the recommended order quantity, Q. The term cu is the cost per unit of underestimating demand (and losing sales because of going out of stock) and co is the cost per unit of overestimating demand (having unsold inventory). So,
cu=$24- $16 $8 lost per unit if Weather Teddy runs out of stock and
Cu = $16 - $5 = $11 lost per unit if left-over inventory must be sold at the clearance price.
Therefore
SALES (UNITS)
Q-18,000 --Q-24,000
0.4211
Single-period Inventory Model for Weather Teddy
-Q-28,000
0.5789
1
-20,000
What is the optimal production / order quantity in order to maximize profit?
O a. 18,980
O b. 22,653
2
Transcribed Image Text:Profit Projections Under Four Order Scenarios $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 S- $450,000.00) $(100,000.00) $(150,000.00) 10000 1200 14000 16000 18000 20000 22000 24000 26000 28000 30000 P(Demand ≤ Q°) = O c. 17,273 O d. 21,024 - -Q-15,000 3 A common method for determining the order quantity is called the single-period inventory model. This model fits your current situation because you are making only one single order for the holiday season. The maximum expected profit in the single-inventory model is based on the following formula: cu + co 8 P(Demand ≤ Q¹) = 8 + 11 = 0.4211 What quantity ordered (Q) corresponds to a probability of P-0.4211 in order to maximze profit? where P(Demand s Q) is the probability that demand is less than or equal to the recommended order quantity, Q. The term cu is the cost per unit of underestimating demand (and losing sales because of going out of stock) and co is the cost per unit of overestimating demand (having unsold inventory). So, cu=$24- $16 $8 lost per unit if Weather Teddy runs out of stock and Cu = $16 - $5 = $11 lost per unit if left-over inventory must be sold at the clearance price. Therefore SALES (UNITS) Q-18,000 --Q-24,000 0.4211 Single-period Inventory Model for Weather Teddy -Q-28,000 0.5789 1 -20,000 What is the optimal production / order quantity in order to maximize profit? O a. 18,980 O b. 22,653 2
Case Problem: Specialty Toys
You are an inventory specialist for Specialty Toys, Inc. The company sells a variety of new and innovative children's toys. You know that the preholiday season is the best time to introduce a new toy because many families use this time to look for new ideas for
December holiday gifts. When the company discovers a new toy with good market potential, it chooses an October market-entry date.
For you to get toys in your stores by October, you place one-time orders with manufacturers in June or July of each year. You are aware that demand for children's toys can be highly volatile. If a new toy catches on, a sense of shortage in the marketplace often
increases the demand to high levels and large profits can be realized. However, new toys can also flop, leaving the company stuck with high levels of inventory that must be sold at reduced prices.
The most important question you face is deciding how many units of a new toy should be purchased to meet anticipated sales demand. If you order too few, sales will be lost; if you order too many, profits will be reduced because of low prices offered in clearance
sales.
For the coming season, the company plans to introduce a new product called Weather Teddy. This variation of a talking teddy bear will make weather predictions using an internal barometer when its hand is pressed. Tests show the toy's weather predictions are quite
good as compared to local television forecasters.
The sales department has given you the following sales forecast information:
.025
Weather Teddy Sales Forecast in Units
10,000
.95
A = 20,000
30,000
.025
The cost of goods sold for a Weather Teddy is $16. Your company sells the bears at a retail price of $24, for a profit of $8 per unit. However, any Teddys that are not sold during the holiday season are to be quickly sold at a clearance price of $5 for a loss of $11 per
unit.
For reference, the following graph charts expected profits under sales scenarios ranging from 10,000 units to 30,000 units in 2,000 unit increments and four order scenarios: Q = 15,000; 18,000; 24,000; and 28,000 respectively.
Transcribed Image Text:Case Problem: Specialty Toys You are an inventory specialist for Specialty Toys, Inc. The company sells a variety of new and innovative children's toys. You know that the preholiday season is the best time to introduce a new toy because many families use this time to look for new ideas for December holiday gifts. When the company discovers a new toy with good market potential, it chooses an October market-entry date. For you to get toys in your stores by October, you place one-time orders with manufacturers in June or July of each year. You are aware that demand for children's toys can be highly volatile. If a new toy catches on, a sense of shortage in the marketplace often increases the demand to high levels and large profits can be realized. However, new toys can also flop, leaving the company stuck with high levels of inventory that must be sold at reduced prices. The most important question you face is deciding how many units of a new toy should be purchased to meet anticipated sales demand. If you order too few, sales will be lost; if you order too many, profits will be reduced because of low prices offered in clearance sales. For the coming season, the company plans to introduce a new product called Weather Teddy. This variation of a talking teddy bear will make weather predictions using an internal barometer when its hand is pressed. Tests show the toy's weather predictions are quite good as compared to local television forecasters. The sales department has given you the following sales forecast information: .025 Weather Teddy Sales Forecast in Units 10,000 .95 A = 20,000 30,000 .025 The cost of goods sold for a Weather Teddy is $16. Your company sells the bears at a retail price of $24, for a profit of $8 per unit. However, any Teddys that are not sold during the holiday season are to be quickly sold at a clearance price of $5 for a loss of $11 per unit. For reference, the following graph charts expected profits under sales scenarios ranging from 10,000 units to 30,000 units in 2,000 unit increments and four order scenarios: Q = 15,000; 18,000; 24,000; and 28,000 respectively.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE 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.