Preview

Case Study

Good Essays
Open Document
Open Document
308 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Case Study
Introduction to Statistics and Econometrics

Case Problem
SPECIALTY TOYS

Specialty Toys

1. 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 15000, 18000, 24000 or 28000 units. The wide range of order quantities suggested indicate 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 0.95 probability that demand would be between 10,000 units and 30,000 units.
Questions
1. Approximate the demand distribution using Normal distribution and sketch the distribution. 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 is 10,000 units, most likely case in which sales is 20,000 units and best case in which sales is 30,000 units

Questions 1. 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? 2. Provide your own recommendation for an order quantity and note the

You May Also Find These Documents Helpful

  • Good Essays

    BUS 475 Final Exam

    • 1852 Words
    • 7 Pages

    14) A company just starting in business purchased three merchandise inventory items at the following prices. First purchase $80; Second purchase $95; Third purchase $85. If the company sold two units for a total of $240 and used FIFO costing, the gross profit for the period would be _____.…

    • 1852 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Acc 422 E9-1 & E9-12

    • 383 Words
    • 2 Pages

    (a) Compute the estimated inventory at May 31, assuming that the gross profit is 25% of sales.…

    • 383 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Bus512

    • 517 Words
    • 3 Pages

    3. Given the use of each resource in the sales fulfillment cycle, determine the profitability of each customer.…

    • 517 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Final

    • 1485 Words
    • 19 Pages

    1. Given the following information about purchases and sales during the year, compute the cost to be assigned to ending inventory under each of three methods: (a) average-cost, (b) FIFO, and (c) LIFO. (Show your work.)…

    • 1485 Words
    • 19 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Bsbwor501 Final Exam

    • 1656 Words
    • 7 Pages

    10. What will be the resultant inventory from the 6-month production plan if the opening inventory is 500 units, sales are forecasted to be 700 per month and production is set at 750 per month?…

    • 1656 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Excel Word

    • 1789 Words
    • 8 Pages

    Your supervisor in the Finance department at Med Supply Online Warehouse has asked you to create a worksheet that will project the annual gross margin, expenses, total expenses, operating income, income taxes, and net income for the next six years based on a table of assumptions he has provided you with. In Part 1 of this project, you will create the worksheet. In Part 2, you will create a chart to present the data. And in Part 3, you will use Goal Seek to analyze a sales scenario.…

    • 1789 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    Sport Obermeyer Case

    • 1324 Words
    • 4 Pages

    In order to determine the quantity of each product that should be purchased at the outset so as to fill half of the total forecasted volume (10,000 units), we need to calculate the purchase price per product (something that isn’t provided in the case) and also the salvage price per product. Let’s start with the cost information of the Rococo Parka. The cost to produce one piece in Hong Kong is $60.08 while the cost in China is $51.92. On the lines of Wally’s plan, let’s assume that half the orders will be fulfilled from Hong Kong and the rest from China. This places the average cost at $56. The total retail price of 112.5$ should equal the sum of cost ($56), profit ($27 as mentioned in the case) and operating expenses (expenses to run the company besides the cost of sourced products). This gives us a figure of $29.5 as the average operating cost, which is about 26% of wholesale price. We’ll apply this percentage across the board to arrive at purchase price per product (Exhibit 1). We’ll also arrive at the salvage price as product cost + operating costs – loss ($9 as mentioned in the case). The mean and std. deviation figures have been provided and it this point, arriving at production quantity per product is a trivial exercise (see results in Exhibit 2), using the template provided in class. Note that increments of 100 have been used.…

    • 1324 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Parts Emporium Synopsis

    • 1331 Words
    • 6 Pages

    The purpose of this case is to allow the student to put together a plan, using either a continuous review system (Q system) or a periodic review system (P system), for two inventory items. Enough information is available to determine the EOQ and R for a continuous review system (or P and T for a periodic review system). Because stockouts are costly relative to inventory holding costs, a 95 percent cycle-service level is recommended. Inventory holding costs are 21 percent of the value of each item (expressed at cost). The ordering costs ($20 for exhaust gaskets and $10 for drive belts) should not be increased to include charges for making customer deliveries. These charges are independent of the inventory replenishment at the warehouse and are reflected in the pricing policy.…

    • 1331 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    In order to decide how many units of each style Wally should make, we should think about their order’s range, we ignore price differences among styles so we need to think about the maximum order and minimum order for each style. First of all, we need to calculate the stock out probability based on benefit percentage and risk percentage. According to the case, Obermeyer earned 24 percent of wholesale price on each parka it sold, and that units left unsold at the end of the season were sold at a loss that average 8 percent of wholesale price. Therefore, the stock out probability equal to 8%/(24%+8%)=25% so there are 75% probability of being less than mean+0.67*SD (standard deviation). According to z table, z equal to 0.67 when probability is 0.75. Therefore, we can calculate quantity for each style include the risk of stock out by using formulate Q*=mean+z*SD. Therefore, we can get the maximum order units for each style in order to avoid stock out.…

    • 1732 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Parts Emporium has engaged Sue McCaskey as materials manager for the company. She recently graduated from a prominent business school. As she is being handed the task of managing the firm’s inventory, she is upset that aggregate information is not available and she decides to randomly select a small sample of approximately 100 items and compile inventory and customer service characteristics to get a feel for “total picture”. From the result of this experiment, it seems that the inventory is in all the wrong places. Although an average of approximately 60 days of inventory is on hand, the firm’s customer service is inadequate. Parts Emporium tries to backorder the customer order not immediately filled from stock, but some 10 percent of demand is being lost to competing distributorship. Because stockouts are costly, relative to inventory holding costs, McCaskey believes that a cycle-service level of at least 95% should be achieved.…

    • 2349 Words
    • 16 Pages
    Good Essays
  • Satisfactory Essays

    In order to determine at which production level Tom will achieve the highest expected profit, it is first necessary to determine the potential profit or loss associated with producing at each demand level. To do this, a discrete probability distribution is composed for each potential level of production. For example, if 200 plain cheese pizzas are produced and 200 are demanded, the potential profit is $400. This profit consists of $1800 in sales revenue minus $1400 in costs ($900+$500 fixed). This profit will result regardless of whether more than 200 are demanded. Accordingly, if 400 cheese pizzas are produced and only 200 demanded, there is a potential loss of $500.…

    • 585 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Lecture 4

    • 1852 Words
    • 29 Pages

    of product at the right time. The goal is to reduce WIP (work-inprocess) inventories to an absolute minimum.…

    • 1852 Words
    • 29 Pages
    Good Essays
  • Satisfactory Essays

    Pepe Jeans- Case Study

    • 773 Words
    • 4 Pages

    1. Acting as an outside consultant, what would you recommend that Pepe do? Given the data in the case, perform a financial analysis to evaluate the alternatives that you have identified. (Assume that the new inventory could be valued at six weeks’ worth of the yearly cost of sales. Use a 30 percent inventory carrying cost rate.) Calculate a payback period for each alternative.…

    • 773 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Ludo Case

    • 567 Words
    • 3 Pages

    1. What is the optimal order quantity that Michelle Peach should use for Dado and for Wedo? What are the resulting expected profits?…

    • 567 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Saferty Stock Problems

    • 309 Words
    • 3 Pages

    Litely Corp sells 1,350 of its special decorator light switch per year, and places orders for 300 of these switches at a time. Assuming no safety stocks, Litely estimates a 50% chance of no shortages in each cycle, and the probability of shortages of 5, 10, and 15 units as 0.2, 0.15, and 0.15 respectively. The carrying cost per unit per year is calculated as $5 and the stockout cost is estimated at $6 ($3 lost profit per switch and another $3 lost in goodwill, or future sales loss). What level of safety stock should Litely use for this product? (Consider safety stock of 0, 5, 10, and 15 units)…

    • 309 Words
    • 3 Pages
    Satisfactory Essays