please answer these questions

Part # 1561- Exam Care Package Parts List Item # Part # Lead Time Unit Qty UOM Part Description Proc Cat. 1 1 1 1 2 3 1 2 1000 1200 1300 6000 P NH 1 3 1 1 2 Set Each Each Each Packaging Assembly Red Bull Starbucks Gift Card $25 Toblerone Chocolate Bar 3 1 4 2 2 Part # 4575- We Miss You Package Parts List Item # Part # Lead Time Unit UOM Qty Part Description Proc Cat. 1 1 1000 3000 3100 6000 N 1 1 2 2 1 1 $3 NINA WP Set Each Each Each Packaging Assembly No Frills Gift Card $25 Apples Toblerone Chocolate Bar P. 3 4 2 Part # 1234 Let Them Down Gently (Break up) Parts List Item # Part # Lead Time Unit UOM Part Description Qty Proc Cat. 1 2 3 1000 2100 1 1 2 1 2 2. 3 Set Each Each Packaging Assembly Tissue Toblerone Chocolate Bar P P 6000 Part # 1234 Let Them Down Gently (Break up) Parts List Item # Part # Lead Time Unit UOM Part Description Qty Proc Cat. 1 1 P 1 2 3 P 1000 2100 6000 5200 1800 1 2 3 2 Set Each Each Each Each Packaging Assembly Tissue Toblerone Chocolate Bar Breath Mints LCBO Gift Card $10 P 3 P 4 5 2 1 2 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 Q6- Prepare the following inventory records demonstrating different ordering techniques. Hint- consider all elements of lead time. (9 marks) 1. 1200 Red Bull Order Point with safety stock Order Quantity = 10000 Safety stock = 1 week usage The company works a 40-hour week, 50 weeks of the year Q6- Prepare the following inventory records demonstrating different ordering techniques. Hint- consider all elements of lead time. (9 marks) 1. 1200 Red Bull Order Point with safety stock Order Quantity = 10000 Safety stock = 1 week usage Opening inventory = 10500 Page 5 of 8 2. 3100 Apples Min/Max Minimum = 2000 Maximum= 15000 Opening inventory= 8000 Review after 1st issue and every 4 weeks Safety stock = 5000 Opening inventory = 20000 3. 6000 Toblerone Chocolate Bars Periodic Review with Target Place 2 orders for each part. For part usage reference your material plans. Place 2 orders for each part. For part usage reference your material plans. 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 3000 No Frills Gift Card $25 3100 Apples 5200 Breath Mints 6000 Toblerone Chocolate Bar Unit Cost .75 1.50 25 10 .5 25 .50 .60 1.10 Where does annual usage come from? Q8. Given the following count information, calculate inventory accuracy. (5 marks) Description Count Part Number Perpetua 1 Inventory Record 6000 1000 5760 1200 5000 1000 1300 1800 400 Packaging Assembly Red Bull Starbucks Gift Card $25 LCBO Gift Card $10 Tissue No Frills Gift Card $25 Apples Breath Mints Toblerone Chocolate Bar 4875 995 390 18930 1540 2100 3000 19620 1550 1750 6814 3100 1620 5200 6925 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? 09- Jane and John's Goodie Baskets Company has been struggling with meeting production schedules because parts are not available when required. The inventory records show the parts are in inventory but when they go to make the baskets they are not there. Review your inventory accuracy calculations for further clues to the issues. The President has asked you to provide your analysis and recommendations to him on this issue. Please include both short term and long-term recommendations and solutions to these issues. This should be in memo format to Heidi Toblerone, President. This should be supported by at least 3 references from LRC databases that support the recommendations you have given. (16 marks) Part # 1561- Exam Care Package Parts List Item # Part # Lead Time Unit Qty UOM Part Description Proc Cat. 1 1 1 1 2 3 1 2 1000 1200 1300 6000 P NH 1 3 1 1 2 Set Each Each Each Packaging Assembly Red Bull Starbucks Gift Card $25 Toblerone Chocolate Bar 3 1 4 2 2 Part # 4575- We Miss You Package Parts List Item # Part # Lead Time Unit UOM Qty Part Description Proc Cat. 1 1 1000 3000 3100 6000 N 1 1 2 2 1 1 $3 NINA WP Set Each Each Each Packaging Assembly No Frills Gift Card $25 Apples Toblerone Chocolate Bar P. 3 4 2 Part # 1234 Let Them Down Gently (Break up) Parts List Item # Part # Lead Time Unit UOM Part Description Qty Proc Cat. 1 2 3 1000 2100 1 1 2 1 2 2. 3 Set Each Each Packaging Assembly Tissue Toblerone Chocolate Bar P P 6000 Part # 1234 Let Them Down Gently (Break up) Parts List Item # Part # Lead Time Unit UOM Part Description Qty Proc Cat. 1 1 P 1 2 3 P 1000 2100 6000 5200 1800 1 2 3 2 Set Each Each Each Each Packaging Assembly Tissue Toblerone Chocolate Bar Breath Mints LCBO Gift Card $10 P 3 P 4 5 2 1 2 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 Q6- Prepare the following inventory records demonstrating different ordering techniques. Hint- consider all elements of lead time. (9 marks) 1. 1200 Red Bull Order Point with safety stock Order Quantity = 10000 Safety stock = 1 week usage The company works a 40-hour week, 50 weeks of the year Q6- Prepare the following inventory records demonstrating different ordering techniques. Hint- consider all elements of lead time. (9 marks) 1. 1200 Red Bull Order Point with safety stock Order Quantity = 10000 Safety stock = 1 week usage Opening inventory = 10500 Page 5 of 8 2. 3100 Apples Min/Max Minimum = 2000 Maximum= 15000 Opening inventory= 8000 Review after 1st issue and every 4 weeks Safety stock = 5000 Opening inventory = 20000 3. 6000 Toblerone Chocolate Bars Periodic Review with Target Place 2 orders for each part. For part usage reference your material plans. Place 2 orders for each part. For part usage reference your material plans. 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 3000 No Frills Gift Card $25 3100 Apples 5200 Breath Mints 6000 Toblerone Chocolate Bar Unit Cost .75 1.50 25 10 .5 25 .50 .60 1.10 Where does annual usage come from? Q8. Given the following count information, calculate inventory accuracy. (5 marks) Description Count Part Number Perpetua 1 Inventory Record 6000 1000 5760 1200 5000 1000 1300 1800 400 Packaging Assembly Red Bull Starbucks Gift Card $25 LCBO Gift Card $10 Tissue No Frills Gift Card $25 Apples Breath Mints Toblerone Chocolate Bar 4875 995 390 18930 1540 2100 3000 19620 1550 1750 6814 3100 1620 5200 6925 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? 09- Jane and John's Goodie Baskets Company has been struggling with meeting production schedules because parts are not available when required. The inventory records show the parts are in inventory but when they go to make the baskets they are not there. Review your inventory accuracy calculations for further clues to the issues. The President has asked you to provide your analysis and recommendations to him on this issue. Please include both short term and long-term recommendations and solutions to these issues. This should be in memo format to Heidi Toblerone, President. This should be supported by at least 3 references from LRC databases that support the recommendations you have given. (16 marks)