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

2 ERP articles review.
Why is there a need for aggregate planning?
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
Write short scenario explain the check sheet?
Distinguish between Store Layout and Store Design.
Problem 1 Given the following information: Inventory on Hand: None Bill of Materials: Routing File: Lot D(2) F(2) Part Size WC Setup (min) Run Time (min/unit) 50 30 45 4.0 F(1) D 80 40 30 4.0 F 90 50 45 2.0 Work Center Master File: Work Center Available Time Ave. Efficiency* 30 7000 min. 1.10 40 7000 min. .90 50 7000 min. 1.05 *Aaverage efficiency is based on processing time only. A. Create a Capacity Bill (using lot sizes) for Z in the box provided. How much nominal capacity (in hours) is required of Work Center 40 to complete an order for 500 Z's. (Consider both set-up and run time) В. Given the current resources and inventories available, how many Z's could be produced if all resources are utilized for their production? С.
Demonstrate why it is important to analyze requirements?