The seasonal demand for a particular product is given below: Period 1, 2, 3 ,4 ,5, 6 Demand 300 ,450 ,100 ,450 ,450 ,100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using the following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity

The seasonal demand for a particular product is given below: Period 1, 2, 3 ,4 ,5, 6 Demand 300 ,450 ,100 ,450 ,450 ,100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using the following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section3.8: A Multiperiod Production Model

Problem 22P

See similar textbooks

Similar questions

Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Period Regular Time Overtime Subcontract Demand Forecast 1 30 15 5 40 2 30 15 5 45 3 30 20 5 50 Initial inventory 20 units Regular-time cost per unit $100 Overtime cost per unit $160 Subcontract cost per unit $200 Carrying cost per unit per month $4 Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Part 2 Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $enter your response here (enter your response as a whole number).
[item no. 8] In a single period inventory model, the demand is assumed to follow a normal distribution with mean=100 and variance=25. The value of ML=2 and the value of MP=4. The company used marginal analysis with the normal distribution to determine the optimal stocking level X*. What is the value of X* a. None of the above b. 111 c. 103 d. 102
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .99. The order interval is 12 days, and lead time is 4 days. Average demand for one item is 63 units per day, and the standard deviation of demand is 6 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Cycle On Hand 1 38 2 10 3 93 Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number) Cycle Units 1 1019 Numeric ResponseEdit Unavailable. 1019 incorrect. 2 1047 Numeric ResponseEdit Unavailable. 1047 incorrect. 3 964 Numeric ResponseEdit Unavailable. 964 incorrect.
The following table lists the demand for Betty’s Deluxe Chocolate Chip Muffins. Unsold muffins are given to a food bank with a salvage value of $1.00 per muffin. The cost is $2.50 per muffin. The muffins sell for $3.50 each. Using the single-period model, what is the optimal order quantity in number of muffins the supermarket should order? Quantity Probability Cumulative Probability 5 0.2 0.2 6 0.3 0.5 7 0.4 0.9 8 0.1 1.02.5 a. 7 b. 6 c. 5 d. 8 e. None of these are correct
PT Cahaya Pintar Utama (PT. CPU) makes special lights that are popular in new homes. PT. CPU demand for two popular lights (VX-1234 and BX-1010) to be the following over the next 12 weeks, as listed in Table 2. Table 2. Demand data Week 1 2 3 4 5 6 7 8 9 10 11 12 VX-1234 82 94 78 96 105 90 86 75 88 98 110 100 BX-1010 250 280 301 312 290 300 275 286 310 334 350 318 A key component in both lights is a light socket that the bulb is screwed into in the base fixture. Each light has one of these sockets. Given the following information (Table 3). Table 3. Information VX-1234 BX-1010 Light Socket On Hand 185 425 620 Lot Size 325 600 500 (purchase quantity) Lead time (week) 1 1 3 Safety Stock 0 10 20 On Order 50 (week 5) 150 (week 4) - Questions: Develop and complete the material requirement planning to plan the production of…
Exercise 14: • __________is an inventory strategy companies employ to increase efficiency and decrease waste by receiving goods only as they are needed in the production process, thereby reducing inventory costs. This method requires producers to forecast demand accurately. • What is its main disadvantage?
a company manufactures an assortment of products for the practice of recreation and leisure. total demand for the next seven months is the following: mois march april may june july aug sept total forecasts 50 44 55 60 60 40 50 359 use the following info to develop aggregate production schedules regular production costs: $240 per unit overtime production cost: $360 per unit regular capacity: 40 units per month overtime capacity: 8 units per month subcontracting cost: $420 per unit subcontract capacity: 12 units per month back order cost: $100 per unit per month initial inventory: 0 End inventory in September: 0 unit storage cost: $30 per unit per month (the monthly inventory cost is calculated based on the final inventory for the month number of employees: 5 workers hiring cost: $2,000 per employee thank you cost: $1,000 per month Prepare an overall production plan using each of the following guidelines and calculate the total cost for each program. Even if backorders are…
Metaverse LLP is a laptop manufacturing company located at Bengaluru, India. One of the main components of the laptop is the Hard Disk Drive (HDD). The inventory of this item is controlled by the EOQ model. Presently the company imports 40 GB HDD from Micron Components and Devices at a unit price of $60 and a 15 day delivery time. Metaverse needs to determine the amount to order each time an order is placed. They also need to determine when to place the order. The forecasted demand for the coming year for the 40GB HDD is 3,000 units. The company incurs a high ordering cost of $225 per order. The average annual inventory holding cost is estimated to be 25% of the item cost and a safety stock of 25 HDDs is maintained. The company operates for 300 days a year. However, Micron wants to drastically increase prices of HDDs which is not acceptable to Metaverse. The purchase officer of Metaverse has identified another supplier Minnesota Data Products. This supplier is willing to supply at…
Skinner's fish market buys fresh boston bluefish daiily for $4.20 per pound and sells it for $5.50 per pound. at the end of each business day any remaining bluefish is sold to a producer of cat food for $1.60 per pound. Daily demand can be approximated by a uniform distribution between 200 and 320 pounds. What is the optimal order qunatity.
A manager receives a forecast for next year. Demand is projected to be 600 units for the first half of the year and 920 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a.Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 100 per month for each of the first six months), determine an order size that will minimize the sum of ordering and carrying costs for each of the six-month periods. (Round your answers to the nearest whole number.) Period Order Size 1 – 6 months?_____units 7 – 12 months?_____units b.If the vendor is willing to offer a discount of $10 per order for ordering in multiples of 50 units (e.g., 50, 100, 150), would you advise the manager to take advantage of the offer in either period? If so, what order size would you recommend? (Round intermediate calculations to 2 decimal places.) Period Order Size 1 – 6 months?____ units 7 – 12 months?____…
A mail-order house uses 17,460 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity __________ boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order _____________ per year
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days