Word File Edit View * 100% Sun 1:41 PM E .. AutoSave OFF Insert Format Tools Table Window Help S: 2020-MGMT-6... - Saved to my Mac Q Layout References >> Tell me Share Comments OC AutoSave OF SU Document1 a Home Insert Draw Design Home Insert Draw Design Layout References >> Tell me Share Comments Module 11 - Chapters 20 & 21 Weighted Average Assignment: (6 parts) 1. Complete the following Chart Formulas: A: Grand Sum = Supplier Horizontal/Vertical Calculation + Market Horizontal Vertical Calculation Supplier = Supplier X Tons Market Market X Tons Supplier Summation Weighted Average (Rate & Ton Miles) Warehouse Location Analysis A B C D E Dollar Tons Total Cost Grid Grid Calculation Calculation Rate perton- Caordinate Coordinate Horizontal Vertical mile Horizontal Vertical 2.50 50D 350 200 437,500 250,000 2.15 500 400 500 430,000 537,500 1.80 800 275 500 396,000 720,000 2.50 700 200 420 350,000 735,000 Supplier Total Market Total Take Total Sum and Divide by Summation Total A B C D Calculation - Horizontal Grand Surn/Summation Sum Calculation - Vertical Grand Sum/Summation Market A 1. Plot the coordinates on the graph 2.00 1.90 2.30 2.50 380 320 400 250 600 600 550 700 300 600 700 650 456,000 364,800 500,000 437,500 228,000 364,800 G44,000 406,250 Grid for Location of Facility (Coordinates as provided/calculated on previous page) Sum Grand Sum 1000 900 800 700 600 500 400 300 200 400 100 0 Transportation is a large influencer on our total logistics cost, so it makes sense to calculate the best location for our warehouse/DC that will minimize transportations dollars spent on incoming and outgoing shipments. 2. Calculate the Weighted Moving Average (using formula below) 100 200 300 400 500 600 700 800) 900 1000 2. Insert Into grid based on grid location coordinates supplied. Where would you locate your facility and why? Weighted Moving Average: WMA, W.D Criteria W, weight for period between 0 and 100% 1 3. Develop a definition (Criteria) for the ratings Rating Scale: Rating Low 2 3 4 High 5 Page 1 of 3 126 of 322 words Focus = 118% Page 1 of 1 126 words Focus = 114% 26 etv A 09 W Word File Edit View * 100% Sun 1:41 PM E .. AutoSave OFF Insert Format Tools Table Window Help S: 2020-MGMT-6... - Saved to my Mac Q Layout References >> Tell me Share Comments OC AutoSave OF SU Document1 a Home Insert Draw Design Home Insert Draw Design Layout References >> Tell me Share Comments Module 11 - Chapters 20 & 21 Weighted Average Assignment: (6 parts) 1. Complete the following Chart Formulas: A: Grand Sum = Supplier Horizontal/Vertical Calculation + Market Horizontal Vertical Calculation Supplier = Supplier X Tons Market Market X Tons Supplier Summation Weighted Average (Rate & Ton Miles) Warehouse Location Analysis A B C D E Dollar Tons Total Cost Grid Grid Calculation Calculation Rate perton- Caordinate Coordinate Horizontal Vertical mile Horizontal Vertical 2.50 50D 350 200 437,500 250,000 2.15 500 400 500 430,000 537,500 1.80 800 275 500 396,000 720,000 2.50 700 200 420 350,000 735,000 Supplier Total Market Total Take Total Sum and Divide by Summation Total A B C D Calculation - Horizontal Grand Surn/Summation Sum Calculation - Vertical Grand Sum/Summation Market A 1. Plot the coordinates on the graph 2.00 1.90 2.30 2.50 380 320 400 250 600 600 550 700 300 600 700 650 456,000 364,800 500,000 437,500 228,000 364,800 G44,000 406,250 Grid for Location of Facility (Coordinates as provided/calculated on previous page) Sum Grand Sum 1000 900 800 700 600 500 400 300 200 400 100 0 Transportation is a large influencer on our total logistics cost, so it makes sense to calculate the best location for our warehouse/DC that will minimize transportations dollars spent on incoming and outgoing shipments. 2. Calculate the Weighted Moving Average (using formula below) 100 200 300 400 500 600 700 800) 900 1000 2. Insert Into grid based on grid location coordinates supplied. Where would you locate your facility and why? Weighted Moving Average: WMA, W.D Criteria W, weight for period between 0 and 100% 1 3. Develop a definition (Criteria) for the ratings Rating Scale: Rating Low 2 3 4 High 5 Page 1 of 3 126 of 322 words Focus = 118% Page 1 of 1 126 words Focus = 114% 26 etv A 09 W