Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*.39 10 11 124 5 6 740 60 304020 7050Period1Gross requirements 202*Holding cost = $1.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).PeriodGross requirementsOn-hand at beginning of period 40On-hand at end of periodOrder receiptOrder release1202 3408456 740 60 3089 10 11 1220 7050

Ans) Concept: Gross Requirements is first satisfied by on hand at beginning of period. On hand at…

Answered: Period Gross requirements 1 20 total…

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...

See similar textbooks

Similar questions

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 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…
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…
1. Why is accurate inventory such an important issue at Wheeled Coach? 2. Why does Wheeled Coach have excess inventory, and what kind of a plan would you suggest for dealing with it? 3. Be specific in your suggestions for reducing inventory and how to implement them. *You may wish to view the video that accompanies this case before
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
Flora's Fabulous Fontains top product is its Model A. Flora is preparing for her busy season and is building 1,800 Model A fountains. Calculate the gross requirements for each component assuming that there is no beginning inventory. Use the following information: Component Immediate Parent Usage per Parent A none - B A 2 C A 1 D A 3 E A 2 F B 4 G B 2 H D 4 I D 2 J E 1 K E 6 L E 2 M F 3 N F 5 O H 2 P K 1 Q K 2 Put the answers down into the table: (If answer is zero, please enter 0, do not leave any fields blank) Component Gross Requirement A enter the gross requirement B enter the gross requirement C enter the gross requirement D enter the gross requirement E enter the gross requirement F enter the gross requirement G enter the gross requirement H enter the gross requirement I enter the gross requirement J enter the gross requirement…
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 40 30 20 20 10 40 50 *Holding cost=$1.50/unit/week; setup cost=$150; lead time=1 week; beginning inventory=40. What is the average demand per week? (enter your responses with 2 decimal places): enter your response here Calculate Economic Order Quantity (EOQ) (enter your responses as whole numbers): enter your response here Calculate the number of periods for POQ (enter your responses as whole numbers): enter your response here Develop a POQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20…
The time-phased net requirements for the base assembly in a table lamp over the next six weeks areWeek 1 2 3 4 5 6Requirements 335 200 140 440 300 200The setup cost for the construction of the base assembly is $200, and the holding cost is $0.30 per assembly per week.a. What lot sizing do you obtain from the EOQ formula?b. Determine the lot sizes using the Silver–Meal heuristic.c. Determine the lot sizes using the least unit cost heuristic.d. Determine the lot sizes using part period balancing.e. Compare the holding and setup costs obtained over the six periods using the policies found in parts (a) through (d) with the cost of a lot-for-lot policy.
a. If demand for the new videotape recorder is expected to be constant with a rate of 20 units per month, what is the recommended order quantity for the videotape recorder? b. What are the estimated annual inventory holding and ordering costs associated with this product? c. How many orders will be placed per year? d. With 250 working days per year, what is the cycle time for this product?
Consider an item that is ordered per month. The daily requirement is 200 andthe lead time for the supply is 2 days. There are 25 working days in a month. Thecost of ordering is INR 300 per order and the cost of carrying is INR 150 per unitper year.a. Draw a sketch showing the cyclic and pipeline inventory in the system.b. What6 is the reordered point of the system?c. What will be the cost of the plan?
Operations Manager of PT Radio Gaga is calculating production costsa telecommunication radio taking into account the following needs:i. Week 1 : 20 unitsii. Week 2 : 36 unitsiii. Week 3 : 46 unitsiv. Week 4 : 45 unitsv. Week 5 : 20 unitsvi. Week 6 : 26 unitsIt is known that there is inventory from the previous week as many as 20 units. Assuming 52week per year, lead time booking for 1 week, setup cost of $40 andholding cost of $0.75 per week, you are required to assist the Operations Manager of PTRadio Gaga to calculate the estimated production cost as follows: a. Calculate EoQ b. Create a 6-week MRP Lot Sizing Table with EoQ method c. Calculate Total Production Cost using EoQ method d. Create a 6-week MRP Lot Sizing Table using the Lot methodfor Lot e. Calculate Total Production cost by using Lot for Lot methodF. Which method will PT Radio Gaga's Operations Manager take?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS