abc

Part # 1561- Exam Care Package Parts List Item # Part # Lead Time Unit Qty UOM Part Description Proc Cat. 1 1 P. 3 P. AWNA 1000 1200 1300 6000 1 2 Set Each Each Each Packaging Assembly Red Bull Starbucks Gift Card $25 Toblerone Chocolate Bar 1 P 2 2 P Part # 4575- We Miss You Package Parts List Item # Part # Lead Time Unit UOM Qty Part Description Proc Cat. 1 1 1 2 1000 3000 3100 6000 1 2 2 Set Each Each Each 1 3 2 3 Packaging Assembly No Frills Gift Card $25 Apples Toblerone Chocolate Bar 4 Part # 1234 Let Them Down Gently (Break up) Parts List Item # Part # Lead Time Unit UOM Part Description Qty Proc Cat. 1 1 P IWNA 1000 2100 6000 1 2 Set Each Each Packaging Assembly Tissue Toblerone Chocolate Bar 2 3 Item # Part # Lead Time UOM Part Description Unit Qty Proc Cat. 1 P 1 2 3 1000 2100 6000 5200 1800 1 1 2 P. 2 3 Set Each Each Each Each Packaging Assembly Tissue Toblerone Chocolate Bar Breath Mints LCBO Gift Card $10 P 4 3 2 P 5 2 1 P Assembly Time per Basket The internal procurement lead time is Exam Care Package 0.3 hours 1) 1 week PR/PO We Miss You Package 0.25 hours 2) as per BOM Let Them Down Gently (Break up) Package 0.40 hours 3) 1 week ship/receive Parts need to be in stock one-week before assembling kits. Baskets are shipped as they are made, so no shipping set back is required. Use MTS for Order Number The company works a 40-hour week, 50 weeks of the year Q7- Given the following costs prepare an ABC analysis of component parts. Use the ABC spreadsheet format used in class. (7 marks) Annual Usage Part # Description 1000 Packaging Assembly 1200 Red Bull 1300 Starbucks Gift Card $25 1800 LCBO Gift Card $10 2100 Tissue Unit Cost .75 1.50 25 10 .5 25 .50 .60 3000 3100 No Frills Gift Card $25 Apples Breath Mints Toblerone Chocolate Bar 5200 6000 1.10 Where does annual usage come from? Q8. Given the following count information, calculate inventory accuracy. (5 marks) Description Count Part Number Perpetua | Inventory Record 1000 6000 5760 1200 4875 1300 995 1800 2100 Packaging Assembly Red Bull Starbucks Gift Card $25 LCBO Gift Card $10 Tissue No Frills Gift Card $25 Apples Breath Mints Toblerone Chocolate Bar 5000 1000 400 19620 1550 1750 6814 3000 390 18930 1540 1620 6925 3100 5200 10475 10396 6000 If A items have a 0% tolerance, B items have a 3% tolerance and C items have a 5% tolerance, what is the inventory accuracy? Part # 1561- Exam Care Package Parts List Item # Part # Lead Time Unit Qty UOM Part Description Proc Cat. 1 1 P. 3 P. AWNA 1000 1200 1300 6000 1 2 Set Each Each Each Packaging Assembly Red Bull Starbucks Gift Card $25 Toblerone Chocolate Bar 1 P 2 2 P Part # 4575- We Miss You Package Parts List Item # Part # Lead Time Unit UOM Qty Part Description Proc Cat. 1 1 1 2 1000 3000 3100 6000 1 2 2 Set Each Each Each 1 3 2 3 Packaging Assembly No Frills Gift Card $25 Apples Toblerone Chocolate Bar 4 Part # 1234 Let Them Down Gently (Break up) Parts List Item # Part # Lead Time Unit UOM Part Description Qty Proc Cat. 1 1 P IWNA 1000 2100 6000 1 2 Set Each Each Packaging Assembly Tissue Toblerone Chocolate Bar 2 3 Item # Part # Lead Time UOM Part Description Unit Qty Proc Cat. 1 P 1 2 3 1000 2100 6000 5200 1800 1 1 2 P. 2 3 Set Each Each Each Each Packaging Assembly Tissue Toblerone Chocolate Bar Breath Mints LCBO Gift Card $10 P 4 3 2 P 5 2 1 P Assembly Time per Basket The internal procurement lead time is Exam Care Package 0.3 hours 1) 1 week PR/PO We Miss You Package 0.25 hours 2) as per BOM Let Them Down Gently (Break up) Package 0.40 hours 3) 1 week ship/receive Parts need to be in stock one-week before assembling kits. Baskets are shipped as they are made, so no shipping set back is required. Use MTS for Order Number The company works a 40-hour week, 50 weeks of the year Q7- Given the following costs prepare an ABC analysis of component parts. Use the ABC spreadsheet format used in class. (7 marks) Annual Usage Part # Description 1000 Packaging Assembly 1200 Red Bull 1300 Starbucks Gift Card $25 1800 LCBO Gift Card $10 2100 Tissue Unit Cost .75 1.50 25 10 .5 25 .50 .60 3000 3100 No Frills Gift Card $25 Apples Breath Mints Toblerone Chocolate Bar 5200 6000 1.10 Where does annual usage come from? Q8. Given the following count information, calculate inventory accuracy. (5 marks) Description Count Part Number Perpetua | Inventory Record 1000 6000 5760 1200 4875 1300 995 1800 2100 Packaging Assembly Red Bull Starbucks Gift Card $25 LCBO Gift Card $10 Tissue No Frills Gift Card $25 Apples Breath Mints Toblerone Chocolate Bar 5000 1000 400 19620 1550 1750 6814 3000 390 18930 1540 1620 6925 3100 5200 10475 10396 6000 If A items have a 0% tolerance, B items have a 3% tolerance and C items have a 5% tolerance, what is the inventory accuracy