Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. 다 Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 70 20 10 80 50 *Holding cost = $1.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 70 20 10 80 50 On-hand at beginning of period 40 On-hand at end of period Order receipt Order release

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table. 다 Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 70 20 10 80 50 Holding cost = $1.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 70 20 10 80 50 On-hand at beginning of period 40 On-hand at end of period Order receipt Order release

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 40 70 30 10 70 50 *Holding cost =$ 3.50/unit/week; setup cost =$ 200; lead time =1 week; beginning inventory =40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 40 70 30 10 70 50 On-hand at beginning of period 40 On-hand at end of period…
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 30 60 30 20 70 60 *Holding cost=$3.50/unit/week; setup cost=$150; lead time=1 week; beginning inventory=40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 30 60 30 20 70 60 Scheduled receipt Projected On-hand 40 enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here…
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 70 30 20 80 50 *Holding cost=$1.50/unit/week; setup cost=$200; lead time=1 week; beginning inventory=40. Part 2 Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 70 30 20 80 50 On-hand at beginning of period 40 enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter…
H&M, a Fashion Giant, Has a Problem: $4.3 Billion in Unsold Clothes. This was reported by the New York Times on March 27, 2018. Here is a short excerpt. I have provided the full story in a Word document attached to this discussion. It is a little dated but again inventory issues continued during the pandemic. Overall, this exemplifies the challenges of maintaining correct inventory levels since there is a lot of money held in excess inventory. “In the world of fashion retailing, where shopping is fast moving online and stores try to keep inventories closely matched to sales, even a small stack of unsold clothes can be a bad sign. What about a $4.3 billion pile of shirts, dresses and accessories? That is the problem facing H&M, the Swedish fashion retailer, which is struggling with a mounting stack of unsold inventory. Signs of its expanding unsold inventory began emerging last year, when it reported an unexpected quarterly drop in sales. The decline was the first in two…
H&M, a Fashion Giant, Has a Problem: $4.3 Billion in Unsold Clothes. This was reported by the New York Times on March 27, 2018. Here is a short excerpt. I have provided the full story in a word document attached to this discussion. It is a little dated but again inventory issues continued during the pandemic. Overall, this exemplifies the challenges of maintaining correct inventory levels since there is a lot of money held in excess inventory. “In the world of fashion retailing, where shopping is fast moving online and stores try to keep inventories closely matched to sales, even a small stack of unsold clothes can be a bad sign. What about a $4.3 billion pile of shirts, dresses and accessories? That is the problem facing H&M, the Swedish fashion retailer, which is struggling with a mounting stack of unsold inventory. Signs of its expanding unsold inventory began emerging last year, when it reported an unexpected quarterly drop in sales. The decline was the first in two…
How does the Wilson approach account for perishable or time-sensitive inventory items, and what modifications may be required for such cases?
Complete all work in EXCEL- show formula Demand for a popular athletic shoe is nearly constant at 800 pairs per week for a regional division of a national retailer. The cost per pair is $54. It costs $72 to place an order, and annual holding costs are charged at 22% of the cost per unit. The lead time is two weeks. a. What is the EOQ? b. What is the reorder point? c. What is the cycle time? d. What is the total annual cost?
Do all work in Excel showing formulas An office supply store open 5 days a week must determine the best inventory policy for boxes of copier paper. Weekly demand is nearly constant at 250 boxes and when orders are placed, then entire shipment arrives at once. The cost per box is $22 and the inventory holding cost is 30%. Orders are placed at a cost of $40 each, including preparation time and communication charges, and the lead time is 2 days. a. Find the optimal order quantity. b. What is the reorder point? c. How often should an order be placed? d. What is the cycle time?
Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 *Holding cost =$ 2.50/unit/week; setup cost =$ 150; lead time =1 week; beginning inventory =40. What is the average demand per week? with 2 decimal places): Calculate Economic Order Quantity (EOQ) Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 Scheduled receipt…
The following inventory date have been established for Warriors Company: Order must be placed in multiples of 100 Annual sales are 338,000 units The purchase price per unit is P6 Carrying cost is 20% of the purchase price of the goods Fixed order costs is P48 Three days are required for delivery. What is the EOQ? How many orders should Warriors placed each year? How many units must be order every time? Calculate the total cost of ordering and carrying cost if the order quantity is 4,000 units 4,800 units 6,000 units At EOQ
Emery Pharmaceutical uses an unstable chemicalcompound that must be kept in an environment where both temperatureand humidity can be controlled. Emery uses 800 poundsper month of the chemical, estimates the holding cost to be 50%of the purchase price (because of spoilage), and estimates ordercosts to be $50 per order. The cost schedules of two suppliers areas follows: a) What is the economic order quantity for each supplier?b) What quantity should be ordered, and which supplier should be used?c) What is the total cost for the most economic order size?d) What factor(s) should be considered besides total cost?