Complete the following master schedule record. Click the icon to view the master schedule record. Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 160 Week Forecasted demand Booked orders Projected ending inventory Master production schedule More Info 2 220 250 Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 570 On-hand inventory at end of week 1: 160 Week 2 220 250 3 280 180 570 280 180 Print 4 280 305 680 5 230 320 4 5 280 230 305 320 680 Done 6 280 255 810 6 280 255 810 7 400 140 7 400 140 8 260 295 760 8 260 295 760 125 9 380 340 9 380 340 - X

Complete the following master schedule record. Click the icon to view the master schedule record. Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 160 Week Forecasted demand Booked orders Projected ending inventory Master production schedule More Info 2 220 250 Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 570 On-hand inventory at end of week 1: 160 Week 2 220 250 3 280 180 570 280 180 Print 4 280 305 680 5 230 320 4 5 280 230 305 320 680 Done 6 280 255 810 6 280 255 810 7 400 140 7 400 140 8 260 295 760 8 260 295 760 125 9 380 340 9 380 340 - X

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

Complete the following master schedule record Click the icon to view the master schedule record Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 60 Week 2 3 4 5 6 7 8 9 Forecasted demand 230 390 280 380 400 290 320 370 Booked orders 220 110 100 140 190 340 155 285 Projected ending inventory Master production schedule 860 840 860 Available to promise 850 410
Prepare a master schedule based on the following information: Week 1 2 3 4 5 6 7 8 Forecast 1000 1000 1200 1200 1500 1500 1800 1800 Orders 1060 940 650 400 210 90 20 0 1. Currently there are 1450 units in inventory. Policy calls for a fixed order quantity of 2500 units. 2. Can you receive another order for 500 items in week 1? Why? 3. How many orders can be received in each period without altering the plan. 4. If there are 2500 items in stock, what would be the answer of questions 2 and 3?
14.26. Calculate the available-to-promise row in the following matrix: Period On Hand = 100 1 2 3 4 5 6 Forecast 50 100 50 100 50 100 Customer Orders 50 125 75 175 45 15 Master Production 200 200 Schedule Available-to-Promise
Describe the differences among planned orders, released orders, and firm planned orders. Whocontrols each?
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
Complete the MPS record below for an end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 2 weeks Quantity on Hand: 80 Week 1 2 3 4 5 6 7 8 9 10 Forecast 25 25 35 45 25 20 45 55 Customer orders 25 30 7 11 (booked) Projected on-hand inventory MPS quantity
Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: A Quantity on Hand: 80 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 1 70 40 ☐☐ January 2 70 65 80 Order Policy: 100 units Lead Time: 1 week February Week 4 40 0 5 45 35 50 70 45 0 8 50 0
In reference to the attached image: What would be the impact of a scheduled receipt of 200 units for item B in week 3 (and allother data remained the same) on your calculated planned order receipts and releases?
4. 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. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead 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 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; 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 20 units of A are required in Week 8: C. Draw the low-level-code bill-of-materials here.
4. 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. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead 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 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; 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 20 units of A are required in Week 8: C. Draw the low-level-code bill-of-materials here. d. Develop an MRP table in excel.
What will be projected on hand inventory of item S in week6?
Complete the master productin schedule based on thefollowing information:Week 1 2 3 4 5 6 7 8 9Forecast 320 100 30 110 40 240 290 60 410Customer Orders 60 50 80 20 60 60 0 0 0Projected On-Hand Inventory 600MPS ReleasedMPS DueAvailable-to-promise (ATP) Scheduled production whenever projected on-had inventory drops below 30MPS lot size: 300Production lead time or lead time for MPS releases 1