A Canadian chocolate and candy confectionary company name "Burdees" operates Distribution Centers for finished goods in three cities across Canada: Mississauga, Montreal, and Calgary. The current inventory levels and demand forecasts are shown in the tables below. A network of 120 Burdees retail outlets order stock from these three DC's. Manufacturing operations are located in Scarborough, Ontario. A Central Supply warehouse located inside the Burdees factory in Scarborough supplies the three regional DC's. Orders from FDM customers (FDM means Food, Drug and Mass 7 Merchants like Shoppers Drug Mart, Hudson Bay Company, and London Drugs) are shipped directly from the Central Supply. 8 9 PART A (TPOP) 15 marks 10 Burdees has chosen to use a DRP approach to managing finished goods inventories, integrated with their MOC System, with a Time-Phased Order Processing (TPOP) methodology. Review the data in the tables below, and complete all relevant fields in each table. Refer to slides 22 to 37 in Lecture 10 especially for guidance. You may also refer to activities on DRP Logic and TPOP that were covered in class. Chapter 14 In the textbook provdes good guidance as well. Some adjustments have been made to the appearance of these tables for simplicity. Summarize the Planned Order Release 11 quantities for each DC and total them. Use these data to build the factory MPS 12 13 14 Lead Time (in weeks) 15 Safety Stock (units) 16 Lot Size 17 On Hand (Units) 18 PRODUCT 19 Gross Requirements 20 Scheduled Receipts 21 Projected Available Balance 22 DRP Planned Order Release 23 24 25 Lead Time (in weeks) 26 Safety Stock (units) 27 Lot Size 28 On Hand (Units) 29 PRODUCT 30 Gross Requirements 31 Scheduled Receipts 32 Projected Available Balance 33 DRP Planned Order Release 34 DC - Mississauga 1 40 500 350 400 g Boxed Chocolates 1 2 3 375 375 375 500 Weekly Periods 4 5 6 7 8 375 375 375 375 375 1 DC - Montreal 20 500 300 Weekly Periods 400 g Boxed Chocolates 1 2 3 4 5 6 7 8 200 200 200 200 250 250 250 250 35 36 Lead Time (in weeks) 2 DC - Calgary 37 Safety Stock (units) 30 38 Lot Size 39 On Hand (Units) 40 PRODUCT 41 Gross Requirements 42 Scheduled Receipts 500 1000 Weekly Periods 400 g Boxed Chocolates 1 2 3 4 5 6 7 8 300 300 300 300 350 400 350 300 43 Projected Available Balance 44 DRP Planned Order Release 45 46 47 Summary 48 49 50 PRODUCT 400 g Boxed Chocolates 1 2 3 4 Weekly Periods 5 6 7 8 51 DC - Mississauga 52 DC- Montreal 53 DC-Calgary 54 55 56 57 58 59 60 61 62 63 64 65 Lead Time (in weeks) TOTAL 2 Direct Sales (FDM) from Central Supply - Scarborough Weekly Periods 1 2 3 4 5 6 7 8 150 150 150 150 150 150 150 150 Factory MPS - Scarborough 66 Safety Stock 67 Lot Size (EPQ) 68 On Hand (Units) 69 PRODUCT 2000 350 Weekly Periods 400 g Boxed Chocolates 1 2 3 4 5 6 7 8 70 Gross Requirements 71 MPS Scheduled Receipts 2000 72 Projected Available Balance 73 MPS Planned Order Release 74 75 PART B (ROP) 76 15 marks Ave. Inv. (Units) Ave. Inv. (Units) Ave. Inv. (Units) Ave. Inv. (Units) Having worked the DRP using the TPOP approach, the Burdees Supply Chain Analyst wants to apply a Re-Order Point (ROP) approach to replenishing DC Inventories, and compare the results to TPOP. Using exactly the same data as were used in Part A (above) calculate the appropriate ROP for each of the three DC's in Mississauga, Montreal and Calgary. Use the tables to show the ordering patterns and PAB's for each DC under Exercise 7 DRP Implosion Select destination and press ENTER or choose Paste Type here to search 85% 1:14 PM