The BOM for product A is shown in the following figure, and data from the inventory records are shown in the table. In the master production schedule for product A, the MPS start row has 100 units in week 3 and 200 in week 6. Develop the material requirements plan for the next 8 weeks for items C, D and E. Data Category Lot-sizing rule Lead time C Scheduled receipts Beginning inventory C LAL 2 weeks None 50 D (2) E (4) Item D FOQ = 200 1 week 200 (in week 3) 200 E POQ (P=3 weeks) 1 week 200 (in week 3) 0

The BOM for product A is shown in the following figure, and data from the inventory records are shown in the table. In the master production schedule for product A, the MPS start row has 100 units in week 3 and 200 in week 6. Develop the material requirements plan for the next 8 weeks for items C, D and E. Data Category Lot-sizing rule Lead time C Scheduled receipts Beginning inventory C LAL 2 weeks None 50 D (2) E (4) Item D FOQ = 200 1 week 200 (in week 3) 200 E POQ (P=3 weeks) 1 week 200 (in week 3) 0

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
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
Prepare a master schedule based on the following information: Week 1 2 3 4 5 6 7 8 Forecast 500 500 600 600 750 750 900 800 Orders 540 470 325 200 105 45 10 0 Currently there are 700 units in inventory. Policy calls for a fixed order quantity of 1250 units. Can you receive another order for 250 items in week 1? Why? How many orders can be received in each period without altering the plan. If there are 1250 items in stock, what would be the answer of questions 2 and 3?
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
A factory has just received an order for 100 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Item Lead Time (weeks) On Hand Inventory Scheduled receipts Order Policy Direct Components End item 2 30 lot for lot A(4), B(3), C(2) A 3 20 54 at week 3 lot for lot D(2) B 2 10 68 at week 4 lot for lot D(5) C 1 100 multiple of 60 D 1 20 min. of 500 Develop the material requirements plan (please print out an empty MRP table to work with), and determine what the "projected available balance" is for component D at week 8. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
A company manufactures two wheeler passengers’ helmets. The initial stock on hand is 5000 units. The carrying cost is Rs. 2 per helmet per week and the lead time is two weeks. The ordering cost per order is Rs. 5000. The MPS of the final requirements is shown below. Develop a Material Requirement Plan (MRP I) by using EOQ method and determine the total inventory cost for the same. Week 1 2 3 4 5 6 7 8 Projected requirements 10000 8000 15000 7000 16000 5000 15000 11000
Courtney Kamauf schedules production of a popular Rustic Coffee Table at Kamauf Enterprises, Inc. The tablerequires a top, four legs, 18 gallon of stain, 116 gallon of glue, 2 shortbraces between the legs and 2 long braces between the legs, anda brass cap that goes on the bottom of each leg. She has 100 gallons of glue in inventory, but none of the other components. Allitems except the brass caps, stain, and glue are ordered on a lotfor-lot basis. The caps are purchased in quantities of 1,000, stainand glue by the gallon. Lead time is 1 day for each item. Schedulethe order releases necessary to produce 640 coffee tables on days5 and 6, and 128 on days 7 and 8.
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
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
Suppose we are formulating a Master Production Schedule (MPS) for an item. Week O projected on- hand is 83 units. The lot-size policy for this item calls for L4L ordering. Lead time for this item is one week. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item . Week 2 3 4 5 6 Forecast 60 45 45 45 45 60 Booked 59 48 30 10 What will be the order size of the first MPS Start Quantity that is needed?
A phone production company must prepare the production planning for the next 9 weeks. Complete the below table considering this information: Lead Time = 3 Weeks On-hand inventory of 52 phones from week 1. Receipt from an outside supplier of 15 phones at start of week 7 We need to supply 75 phones on week 4. We need to supply 120 phones on week 9. Product A Week 1 2 3 4 5 6 7 8 9 Gross Requirement On-hand inventory Planned order
Consider the bill of material for a product, A, and the data given in the table that follows. The gross requirements for A are 150 units in week 5 and 200 units in week 8. Item Lead-Time (weeks) On hand quantity A B C A. 60 units B. 200 units C. 90 units D. 100 units A. 50 units B. 10 units OC. 40 units D. 210 units B(1) 1 2 1 What is the planned order release for product A in week four? A. 210 units B. 200 units C. 170 units D. 240 units 60 40 0 What is the projected on hand inventory for component B in week eight? A. 400 units B. 0 units C. 480 units OD. 140 units A Lot size Lot-For-Lot 60 120 What is the planned order receipt for component B in week seven? A. 220 units B. 120 units OC. 140 units D. 0 units What is the gross requirement for component C in week five? What is the planned order receipt for component C in week four? C(1)