D E 1 Individual Assignment for DRP 2 3 Product ID Product Name Warehouse IDistribution Center 4 1 5 2 A WH1 DC1 B WH2 DC2 7 Demand Forecast 8 9 Product ID Period 1 Dema Period 2 Dem: Period 3 Dema... 10 1 100 150 130 11. 2 200 220 210 12 13 Inventory Levels 14 15 Product ID Warehouse ID Initial Inventory Level 10 1 WH1 500 17 2 WH2 600 18 19 20 Lead Times 21 22 Product ID Warehouse ID Lead Time in Days 23 1 WH1 7 St.d.-2 CSL-90% 24 2 WH2 10 St.d.-1 CSL=95% 25 20 DRP Calculation 27 28 Product ID Warehouse ID Period 1 Period 2 Period 3 29 Beginning Inventory 30 Forecasted Demand 31 32 33 Safety Stock Planned Receipts Ending Inventory Sheet1

D E 1 Individual Assignment for DRP 2 3 Product ID Product Name Warehouse IDistribution Center 4 1 5 2 A WH1 DC1 B WH2 DC2 7 Demand Forecast 8 9 Product ID Period 1 Dema Period 2 Dem: Period 3 Dema... 10 1 100 150 130 11. 2 200 220 210 12 13 Inventory Levels 14 15 Product ID Warehouse ID Initial Inventory Level 10 1 WH1 500 17 2 WH2 600 18 19 20 Lead Times 21 22 Product ID Warehouse ID Lead Time in Days 23 1 WH1 7 St.d.-2 CSL-90% 24 2 WH2 10 St.d.-1 CSL=95% 25 20 DRP Calculation 27 28 Product ID Warehouse ID Period 1 Period 2 Period 3 29 Beginning Inventory 30 Forecasted Demand 31 32 33 Safety Stock Planned Receipts Ending Inventory Sheet1

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

Departmental Cost Allocation Logan Products has two production departments—assembly andfinishing. These are supported by two service departments—sourcing (purchasing and handling ofmaterials and human resources) and operations (work scheduling, supervision, and inspection). Loganhas the following labor hours devoted by each of the service departments to the other departments.Total Labor Hours Used by DepartmentsSourcing Operations Assembly FinishingSourcing — 20,000 40,000 60,000Operations 10,000 — 60,000 50,000The costs incurred in the plant are as follows:Departments Departmental CostsSourcing $165,000Operations 205,000Assembly 410,000Finishing 255,000Total $1,035,000Required Use four decimal places (e.g., 33.3333%) in your calculation of percentages.1. What are the costs allocated to the two production departments using (a) the direct method, (b) the stepmethod, when the sourcing department that provides the greatest percentage of services to other servicedepartments goes first),…
Describe MRP II and its benefits.
Evaluate and compare MRP lot-sizing techniques.g
What are some unforeseen costs of ERP?
When is MRP appropriate?
7 In the following MRP planning schedule for Item J, indicate the correct net requirements, planned-order receipts, and planned-order releases to meet the gross requirements. Lead time is one week. (Leave the cells blank, whenever zero (0) is required.) WEEK NUMBER ITEM J 1 2. 3 4 Gross requirements On-hand Net requirements Planned-order receipt Planned-order release 70 45 30 Period 1 Gross requirements 70 45 65 Scheduled receipts Item: J ОН: 30 LT: 1 SS: 0 Q: L4L Projected available balance Net requirements Planned order receipts Planned order releases 65
2 ERP articles review.
Why is there a need for aggregate planning?
When discussing the MRP system, what exactly does "information processing" mean?
5) How does revenue management impact an aggregate plan?
Question 8 The following Level 0 MRP information is given for a personal computing system. Monitors for these computing systems are a Level 1 item and each computer receives only one monitor. Using a lead time of one week, what are the Level 1 Gross Requirements for Monitors? Assume any inventory on hand will be used as soon a possible. Group of answer choices a. 1100 in week 3, 600 in week 4, 300 in week 5 b. 1100 in week 2, 600 in week 3, 300 in week 4 c. 500 in week 1, 600 in week 2, 200 in week 3 d. 500 in week 2, 600 in week 3, 200 in week 4 e. Impossible to determine from this information
Explain the five precise requirements of an MRP system ?