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.
What are some unforeseen costs of ERP?
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
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
Week 4 6 7 Gross req. 60 20 150 Item# A A B Item# A B C What is needed# B C с On hand (beginning) inventory# 35 65 110 Quantity needed 1 2 1 Lot Lead sizing# time L4L 30 L4L 1 1 1 The three tables above shows the master production schedule and the bill of materials of part A, and the inventory records of all the parts. There are no scheduled receipts. Given this information, what is the planned order receipt of part A in Week 7?(Only enter a
Question 7 The following Level 0 MRP information is given for a personal computing system. Using a lead time of two weeks, what are the Net Requirements for computing systems based on the MRP table below. Assume any inventory on hand will be used as soon a possible. Group of answer choices a. 2500 in week 3, 3000 in week 4, 4500 in week 5 b. 2500 in week 1, 3000 in week 2, 4500 in week 3 c. 1500 in week 3, 3000 in week 4, 2000 in week 5 d. 1500 in week 1, 3000 in week 2, 2000 in week 3 e. Impossible to determine from this information
Explain in detail each element of an MRP system ?
Distinguish between Store Layout and Store Design.