The following table lists the components needed to assemble an end item, lead times, and quantities on hand.ItemLT (week)Amount on handClick here for the Excel Data FileB (2)Additional unitsEnd ItemEnd1OCThe latest weekB310D (3)C49с425E211F126427GE (2)F (3) G (2)E (2)H (4)E (2)a. If 24 units of the end item are to be assembled, how many additional units of E are needed? (Hint. You don't need to develop anMRP plan to determine this.)H1Ob. An order for the end item is scheduled to be shipped at the start of week 16. What is the latest week that the order can be startedand still be ready to ship on time? (Hint: You don't need to develop an MRP plan for this part either.)

Given data Item End B C D E F G H LT (Week) 1 3 4 4 2 1 2 1 Amount on Hand 0 10 9 25 11 26…

Answered: The following table lists the…

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

3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Week On hand 30 30 30 1 2 3 4 5 6 7 8 40 40 40 45 45 13 8 4 Item: P24 Forecast Orders Projected available balance 20 Available-to-promise MPS a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Amount 40 Order Desired Week 1 4 2 6 3 30 2 4 25 3 30 4882 7623
. Consider the bill of materials (BOM) in Figure 11.33.a. How many immediate parents (one level above) doesitem I have? How many immediate parents does item Ehave?b. How many unique components does product A have at alllevels?c. Which of the components are purchased items?d. How many intermediate items does product A have at alllevels?e. Given the lead times (LT) in weeks noted on Figure 11.33,how far in advance of shipment must a purchasecommitment be for any of the purchased items identifiedin part (c)?
Do it in EXCEL, upload your execl file in the answersheet. P264 20 Case study 5. 2 Finish the following table: Lot size 80 Starting Inv. 5 6 7 8 Forecast 50 50 50 50 Customer orders 0 0 0 Projected on-hand inventory MPS ATP 0 1 50 52 2 50 35 3 4 50 50 20 12 0
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Item: P24 Forecast Orders On hand Week 12345678 30 30 30 40 40 40 45 45 13 8 4 Projected available balance Available-to-promise MPS 20 a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Order 1234 4 Amount 40 30 30 25 Desired Week 4 6 2 3
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
The table given below shows a partially completed MPS record for product A. What is the remaining ATP inventory (discrete) for week 7 after the company receives a 20 units of customer order for week 6? Order policy: 60 units Lead time: 1 week Item: A Quantity on hand: 30 Week 3 30 7. 34 11 4. Forecast requirements Customer orders (booked) Projected on-hand inventory MPS quantity MPS start ATP inventory 22 24 18 27 36 28 26 12 24 O a 59 Ob. 29 OcO Od. 49 Oe. 39
MRP II stands for:a) material resource planning.b) management requirements planning.c) management resource planning.d) material revenue planning.e) material risk planning.
One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. Cis made of two units of Fand one unit of D. E is made of two units of D. Items A. C. D. snd F have one-week lesd times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D: lots of size 50 and 220 are used for Items E and F. respectively. Item C has an on-hand (beginning) inventory of 20; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts. If 25 units of A sre required in Week 8, use the low-level-coded bill-of-materials to find the necessory planned-order relesses for all components. (Leave the cells blank, whenever zero (0) is required.) Perlod: 2 4 5 7 Grass requirements Scheduled receipts Item: A OH: 0 LT: 1 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder…
Pennington Cabinets is a manufacturer of several different lines of kitchen and bathroom cabinets that are sold through major home improvement retailers. Pennington built material requirement planning as follows: Current Jan Feb Mar 1200 1000 Gross requirements Scheduled receipts 800 Projected available balance Net requirements Planned order receipts 820 Planned order release Compute net requirements in Feb. Your Answer: Answer
Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
1. Speedy, Inc. is a company that produces automotive electrical components. AI5I is a common part for all its products. Consider the following grass requirements and inventory data for AISI part: Week 3 6 7 Grass requirements 40 30 30 70 20 Inventory Data: Lead time Beginning inventorry Scheduled receipts Holding cost Setup cost 1 week 40 $2.50/unit/week S150 Based on the L4L. lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A15I part. Item: A151 Week 5 Lot size: L4L 1 2 4 7 8 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts Planned Order Releases (ii) Based on the FOQ - 57 units lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A151 part. Item: A151 Lot size: FOQ 57 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts |Planned Order Releases Week 1 2 4 5 7 8

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