Question

In: Statistics and Probability

Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned that the...

Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned 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 Specialty discovers a new toy with good market potential, it chooses an October market entry date. In order to get toys in its stores by October, Specialty places one-time orders with its manufacturers in June or July of each year. 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 Specialty stuck with high levels of inventory that must be sold at reduced prices. The most important question the company faces is deciding how many units of a new toy should be purchased to meet anticipated sales demand. If too few are purchased, sales will be lost; if too many are purchased, profits will be reduced because of low prices realized in clearance sales. For the coming season, Specialty plans to introduce a new product called Weather Teddy. This variation of a talking teddy bear is made by a company in Taiwan. When a child presses Teddy’s hand, the bear begins to talk. A built-in barometer selects one of five responses that predict the weather conditions. The responses range from “It looks to be a very nice day! Have fun” to “I think it may rain today. Don’t forget your umbrella.” Tests with the product show that, even though it is not a perfect weather predictor, its predictions are surprisingly good. Several of Specialty’s managers claimed Teddy gave predictions of the weather that were as good as many local television weather forecasters. As with other products, Specialty faces the decision of how many Weather Teddy units to order for the coming holiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or 28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. The product management team asks you for an analysis of the stock-out probabilities for various order quantities, an estimate of the profit potential, and to help make an order quantity recommendation. Specialty expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains after the holiday season, Specialty will sell all surplus inventory for $5 per unit. After reviewing the sales history of similar products, Specialty’s senior sales forecaster predicted an expected demand of 20,000 units with a .95 probability that demand would be between 10,000 units and 30,000 units. Managerial Report Prepare a managerial report that addresses the following issues and recommends an order quantity for the Weather Teddy product.

1 . Use the sales forecaster’s prediction to describe a normal probability distribution that can be used to approximate the demand distribution. Sketch the distribution and show its mean and standard deviation.

2 . Compute the probability of a stock-out for the order quantities suggested by members of the management team.

3 . Compute the projected profit for the order quantities suggested by the management team under three scenarios: worst case in which sales = 10,000 units, most likely case in which sales = 20,000 units, and best case in which sales = 30,000 units.

4 . One of Specialty’s managers felt that the profit potential was so great that the order quantity should have a 70% chance of meeting demand and only a 30% chance of any stock-outs. What quantity would be ordered under this policy, and what is the projected profit under the three sales scenarios?

5 . Provide your own recommendation for an order quantity and note the associated profit projections. Provide a rationale for your recommendation.

*IF THERE IS ANYWAY YOU CAN SHOW HOW TO DO ON EXCEL. if not it is fine but would be greatly appreciated. :)

Solutions

Expert Solution


Related Solutions

Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned that the...
Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned 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 Specialty discovers a new toy with good market potential, it chooses an October market entry date. In order to get toys in its stores by October, Specialty places one-time orders with its manufacturers in June or July...
Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned that the...
Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned that the pre holiday 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 Specialty discovers a new toy with good market potential, it chooses an October market entry date. In order to get toys in its stores by October, Specialty places one-time orders with its manufacturers in June or...
Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned that the...
Specialty Toys, Inc., sells a variety of new and innovative children’s toys. Management learned that the pre holiday 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 Specialty discovers a new toy with good market potential, it chooses an October market entry date. In order to get toys in its stores by October, Specialty places one-time orders with its manufacturers in June or...
Specialty Toys, Inc. sells a variety of new and innovative children’s toys. Management learned that the...
Specialty Toys, Inc. sells a variety of new and innovative children’s toys. Management learned 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 Specialty discovers a new toy with good market potential, it chooses an October market entry date. In order to get toys into its stores by October, Specialty places one-time orders with its manufacturers in June or July...
specialty toys, Inc. sells a variety of new and innovativ children’s toys. Management learned that the...
specialty toys, Inc. sells a variety of new and innovativ children’s toys. Management learned 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 specialty discovers a new with good market potiential, it chooses an October, market entry date. In order to get toys in stores by October, Specialty places one-time orders with its; manufacturers in June or July of eacjh...
Case Study Toys-4-Children Ltd (T4C) manufactures and sells children’s toys in Australia. The company currently faces...
Case Study Toys-4-Children Ltd (T4C) manufactures and sells children’s toys in Australia. The company currently faces the following core issues and challenges: • T4C aims to introduce a new product – ‘Gold Fish’ – and it needs to develop some preliminary cost estimates. • T4C faces increasing competition from new competitors who are importing children’s toys from China and selling them at low prices in the Australian market. • T4C is struggling with decision making and control over operations in...
Question 1 The management at Luke Products Inc. is looking at the financials for an innovative...
Question 1 The management at Luke Products Inc. is looking at the financials for an innovative new diaper-changing station. The expected life cycle forthe product is four years. The initial projected product design costs are $500,000. Management typically uses a discount rate of 10% for allnew product financials. a. Using the table below: Calculate the projected NPV, Payback time and IRR. Year Projected Cash In-Flows 1 130,000 2 250,000 3 300,000 4 100,000 b. Using the table below: If the...
Innovative Component Inc. needed financing to build a new manufacturing plant. On June 30th, 2014, Innovative...
Innovative Component Inc. needed financing to build a new manufacturing plant. On June 30th, 2014, Innovative Component issued $2,300,000 of 8-year bonds with a 6% coupon rate (payments due on December 31st and June 30th). The effective interest rate was 8%. Required: Prepare a bonds amortization table. Use the financial statement effects template below to record the bond issue and Innovative Component’s first two interest payments.
Innovative Component Inc. needed financing to build a new manufacturing plant. On January 1, 2014, Innovative...
Innovative Component Inc. needed financing to build a new manufacturing plant. On January 1, 2014, Innovative Component issued $400,000 of 8% bonds that pay interests semiannually and mature in 10 years. The bonds were sold for $428,400to yield a 7% annual rate. Fill out the basic information needed for pricing the bonds Innovative Component issued in January 20014.        Principal amount: __________________           Semiannual coupon rate: __________________ Semiannual market rate: ___________________        Discount periods: _____________________ b. Fill out the amortization...
Innovative Component Inc. needed financing to build a new manufacturing plant. On January 1, 2014, Innovative...
Innovative Component Inc. needed financing to build a new manufacturing plant. On January 1, 2014, Innovative Component issued $400,000 of 8% bonds that pay interests semiannually and mature in 10 years. The bonds were sold for $428,400 to yield a 7% annual rate. Fill out the basic information needed for pricing the bonds Innovative Component issued in January 2014.             Principal amount: ____________________             Semiannual coupon rate: __________________   Semiannual market rate: ___________________               Discount periods: _____________________   b. Fill out the amortization table. Round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT