4.7 Complete the following table. Lead time for the part is 2 weeks. The lot size is 100. What isthe projected available at the end of the week 3? When is it planned to release an order?WeekGross RequirementsScheduled ReceiptsProjected Available 20Net RequirementsPlanned Order ReceiptPlanned Order Release160100250320420

Ans) Lead Time = 2 weeks Lot size = 100 Formula:

Answered: 4.7 Complete the following table. Lead…

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

Product X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made of 2 units of A and 4 units of C. Lead Time of X is 1 week: Y - 2 weeks; Z – 3 weeks; A – 2 weeks; B – 1 week; and C – 3 weeks. Scheduled receipt on week 5 are: A = 250 and Z = 135. If 150 units of X are needed in week 10 & 100 units in week 12, develop a planning schedule showing when each item should be ordered and in what quantity. Use lot for lot except for Y & C which requires minimum of 400 units. Determine the timing of planned release of component Z for the order of 150 units.
Product X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made of 2 units of A and 4 units of C. Lead Time of X is 1 week: Y - 2 weeks; Z – 3 weeks; A – 2 weeks; B – 1 week; and C – 3 weeks. Scheduled receipt on week 5 are: A = 250 and Z = 135. If 150 units of X are needed in week 10 & 100 units in week 12, develop a planning schedule showing when each item should be ordered and in what quantity. Use lot for lot except for Y & C which requires minimum of 400 units. Determine the total gross requirement of “A”
1 Demand planning is an activity to determine what quantity of materials and resources have to be procured and when.Select one:a. Trueb. False
1. Which of the following is a type of inventory All of the above b. Work in Progress c. MRO d. Raw material
1. In an assemble-to-order company, at which level should master scheduling take place? a. The end item level b. The raw material/component level c. None of the above levels d. It does not matter, any level will do e. The component/subassembly level 2. The final assembly schedule (FAS) a. Schedules customer orders as they are received based on components planned in the MPS b. None of the above c. Is used with make-to-stock products d. Is used with make-to-order products e. A and b above 3. The functions of a master production schedule are to: I. Plan material components. II. Plan capacity requirements. III. Keep priorities valid a. II, III and not I b. None of the above is a function of the MPS c. I, II and III d. I, II and III e. I, III and not II 4.The information needed to develop a master production schedule will be got from a. Inventory levels for individual end items b. None of the above c. The production plan d. The forecast of individual end…
What is MRP (Materials Requirement Planning) I and why is it important?
One unit of A is made of three units of B, one unit of C, and two units of D. B is composedof two units of E and one unit of D. C is made of one unit of B and two units of E. E ismade of one unit of F.Items B, C, E, and F have one-week lead times; A and D have lead times oftwo weeks.Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have onhand(beginning) inventories of 10, 50, and 150, respectively; all other items have zerobeginning inventory. We are scheduled to receive 10 units of A in Week 2, 50 units of Ein Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If30 units of A are required in Week 8, use the low-level-coded bill-of-materials to i nd thenecessary planned order releases for all components.
a. Given the following master schedule, fill in the projected available and availableto promise rows: b. A customer wants an order of 100 in period 4. What can you tell him?c. The customer from part (b) cancels his request, but then says he wants 120 in period 5.What do you tell him now?d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs fora sales promotion. What do you tell them and why?e. What action (if any) should be taken in period 11? Why is it okay to take theaction?
SOLVED FIXED TIME PERIOD MODEL PROBLEMS Activities/Assessments:Activity 13• The weekly demand for a product is 770 units. The standard deviation of daily demand is 10 units. The firm reviews its inventory every 28 days. Each order for the product arrives 9 days after placement. At the time of review, there are 10 units backorder. If 95 percent of all demand is to be satisfied from items in stock:a) How many units should be the safety stock?b) What’s the product’s inventory status?c) How many units should be ordered for this period?
Many practitioners currently update MRP weekly or biweekly. Would it be more valuable if it were updated daily? Discuss.
A Corporation assembles two products as shown in the product structures below. It has orders for 480 on period 8 and 100 units on period 9 of product X.. Develop the MRP table for each of the items. Item Amount on hand Schedule receipts Lot-sizing rule X 180 0 L4L A 100 0 Periodic order quantity (2 weeks) B 50 0 100 C 50 0 200 D 50 0 400 X LT = 2 A (2) LT = 2 B (1) LT = 2 C (3) LT = 1 D (1) LT = 3 D (2) LT =2
Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)

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