ACME Company makes Electrical Motors; you are the new planning engineering and are being asked to prepare a Master Production Schedule for the next 2 weeks. You need to tell production how much they need to produce and Purchasing how much they need to buy. (Since the Suppliers are next door, and have safety stock, there is no lead time for purchased components (Please add your Spreadsheet with all the cells clearly labeled). Here is the important following information Production Capacity 700 motors per day, you assemble the Winding Core and Bearing Assay as well (you have infinite capacity for those) b. Minimum safety stock is in the table below, and every period must end at the safety stock number Finish product Electrical Motor a. C. d. BOM i. Electrical Motor (1) - Made 1. Winding Core (1) - Made a. Copper Cable (30 in) - Purchased b. Core (1) - Purchased 2. Bearing Assembly (1) - Made Top bearing (2) - Purchased b. Bottom bearing (1) - Purchased 3. Packaging (1) - Purchased 4. Label (1) - Purchased a. e. Week 1 Demand 500 / Week 2 Demand 650 f. On Hand inventory/Safety Stock/Yield Component Inventory Safety Stock Yield Electrical Motor 54 50 95% Winding Core 35 20 100% Cooper Cable 680 in 100 in 85% Core 4 2 100% Bearing Assay 100 10 100% Top Bearing 4 2 100% Bottom Bearing 50 2 100% Packaging 100 50 80% Label 300 50 75% ACME Company makes Electrical Motors; you are the new planning engineering and are being asked to prepare a Master Production Schedule for the next 2 weeks. You need to tell production how much they need to produce and Purchasing how much they need to buy. (Since the Suppliers are next door, and have safety stock, there is no lead time for purchased components (Please add your Spreadsheet with all the cells clearly labeled). Here is the important following information Production Capacity 700 motors per day, you assemble the Winding Core and Bearing Assay as well (you have infinite capacity for those) b. Minimum safety stock is in the table below, and every period must end at the safety stock number Finish product Electrical Motor a. C. d. BOM i. Electrical Motor (1) - Made 1. Winding Core (1) - Made a. Copper Cable (30 in) - Purchased b. Core (1) - Purchased 2. Bearing Assembly (1) - Made Top bearing (2) - Purchased b. Bottom bearing (1) - Purchased 3. Packaging (1) - Purchased 4. Label (1) - Purchased a. e. Week 1 Demand 500 / Week 2 Demand 650 f. On Hand inventory/Safety Stock/Yield Component Inventory Safety Stock Yield Electrical Motor 54 50 95% Winding Core 35 20 100% Cooper Cable 680 in 100 in 85% Core 4 2 100% Bearing Assay 100 10 100% Top Bearing 4 2 100% Bottom Bearing 50 2 100% Packaging 100 50 80% Label 300 50 75%