Due to unusual weather conditions in Minneapolis and Buffalo, Sandy-Built has changed the forecasted demand numbers for MeltoMatic snowblowers at its two distribution centers. Complete the following DRP records and master schedule record.
Find the net requirements, planned receipts, planned orders, and project ending inventory for the Minneapolis Distribution Center (enter your responses as whole numbers). Month Week November 45 46 47 48 75 75 75 75 49 95 December January 50 51 52 1 2 3 4 95 115 115 150 150 155 155 Minneapolis Distribution Center Forecasted demand LT(weeks) = 2 Scheduled receipts Projected ending inventory: 155 Minimum Net requirements order = 145 Planned receipts Planned orders Find the net requirements, planned receipts, planned orders, and project ending inventory for the Buffalo Distribution Center (enter your responses as whole numbers). Buffalo Distribution Center Month Week November December January 45 46 47 48 49 50 51 52 1 2 3 4 45 45 65 65 95 95 95 95 100 100 115 115 120 Forecasted demand LT(weeks) = 1 Scheduled receipts Projected ending inventory : 35 Minimum Net requirements order = 75 Planned receipts Planned orders Find the total planned orders, the project ending inventory, and the available to promise numbers for the master schedule (enter your responses as whole numbers). Month November December Week 45 46 47 48 49 50 51 52 Total planned orders Booked orders 110 0 0 0 0 0 0 0 Projected ending inventory: 58 Master production schedule 380 330 300 490 Available to promise i - X More Info Fr your responses as whole numbers) November December January 45 46 47 48 49 50 51 52 1 1. 2 3 4 75 75 75 75 95 95 115 115 150 150 155 155 Month Week Month Minneapolis Distribution Center Week Forecasted demand LT(weeks) = 2 Scheduled receipts Projected ending inventory: 155 Minimum Net requirements Planned receipts order = 145 Planned orders November 45 46 47 48 75 75 75 75 December January 49 50 51 52 1 2 3 4 95 95 115 115 150 150 155 155 Print Done 1 More Info More Info November 46 47 December January 50 51 52 1 2 3 4 95 95 95 100 100 115 115 December 50 51 45 48 49 95 49 November 45 46 47 48 45 45 65 65 120 52 110 Month Buffalo Distribution Center Week Forecasted demand LT(weeks) = 1 Scheduled receipts Projected ending inventory : 35 Net requirements Minimum Planned receipts order = 75 Planned orders Month Week Total planned orders Booked orders Projected ending inventory: 58 Master production schedule Available to promise 0 0 0 0 0 0 0 380 330 300 490 Find the net requirements, planned receipts, planned orders, and project ending inventory for the Minneapolis Distribution Center (enter your responses as whole numbers). Month Week November 45 46 47 48 75 75 75 75 49 95 December January 50 51 52 1 2 3 4 95 115 115 150 150 155 155 Minneapolis Distribution Center Forecasted demand LT(weeks) = 2 Scheduled receipts Projected ending inventory: 155 Minimum Net requirements order = 145 Planned receipts Planned orders Find the net requirements, planned receipts, planned orders, and project ending inventory for the Buffalo Distribution Center (enter your responses as whole numbers). Buffalo Distribution Center Month Week November December January 45 46 47 48 49 50 51 52 1 2 3 4 45 45 65 65 95 95 95 95 100 100 115 115 120 Forecasted demand LT(weeks) = 1 Scheduled receipts Projected ending inventory : 35 Minimum Net requirements order = 75 Planned receipts Planned orders Find the total planned orders, the project ending inventory, and the available to promise numbers for the master schedule (enter your responses as whole numbers). Month November December Week 45 46 47 48 49 50 51 52 Total planned orders Booked orders 110 0 0 0 0 0 0 0 Projected ending inventory: 58 Master production schedule 380 330 300 490 Available to promise i - X More Info Fr your responses as whole numbers) November December January 45 46 47 48 49 50 51 52 1 1. 2 3 4 75 75 75 75 95 95 115 115 150 150 155 155 Month Week Month Minneapolis Distribution Center Week Forecasted demand LT(weeks) = 2 Scheduled receipts Projected ending inventory: 155 Minimum Net requirements Planned receipts order = 145 Planned orders November 45 46 47 48 75 75 75 75 December January 49 50 51 52 1 2 3 4 95 95 115 115 150 150 155 155 Print Done 1 More Info More Info November 46 47 December January 50 51 52 1 2 3 4 95 95 95 100 100 115 115 December 50 51 45 48 49 95 49 November 45 46 47 48 45 45 65 65 120 52 110 Month Buffalo Distribution Center Week Forecasted demand LT(weeks) = 1 Scheduled receipts Projected ending inventory : 35 Net requirements Minimum Planned receipts order = 75 Planned orders Month Week Total planned orders Booked orders Projected ending inventory: 58 Master production schedule Available to promise 0 0 0 0 0 0 0 380 330 300 490
