Question

1 Approved Answer

Posted on Jul 23, 2024

In the green cells calculate Shipping Expense using the data on the Region and Customer data tables in columns I and J. If Warehouse and

image text in transcribed In the green cells calculate Shipping Expense using the data on the "Region" and "Customer" data tables in columns I and J. If "Warehouse" and "Location" comprise the same letter (i.e., "WarehouseF" and "LocationF"), then Shipping Expense is $20. For every letter in the alphabet further away, add $4.50^X. [EX: If a transaction comprises a sale from "WarehouseA" to "LocationC", then Shipping Expense is equal to $20 + $4.50^2 (where A-->B-->C = 2).

A B D E F G H 1 4 Shipping Exp 5 6 7 8 9 10 11 12 13 14 Date 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 Product Product3 Product7 Product2 Product6 Product3 Product1 Product 10 Product 7 Product10 Producto Product7 Product2 Product Product7 Product2 Products Product 10 Product 4 Product4 Product2 Product7 Region Region3 Region4 Region4 Region4 Region4 Region8 Region8 Region2 Region5 Region4 Region2 Region4 Region4 Region2 Region8 Region8 Region3 Region 6 Region1 Region5 Region1 SalesRep Sales Rep2 SalesRep 15 Sales Rep18 SalesRep14 SalesRep3 SalesRep6 SalesRep 16 SalesRep1 SalesRep6 SalesRep7 SalesRep17 Sales Rep8 SalesRep1 SalesRep6 Sales Rep 16 Sales Rep10 Sales Rep15 Sales Rep3 SalesRep17 SalesRep3 Sales Rep7 Customer Customer 16 Customer72 Customer71 Customer88 Customer65 Customer 100 Customer68 Customer85 Customer6 Customer1 Customer28 Customer16 Customer95 Customer65 Customer69 Customer 10 Customer14 Customer74 Customer69 Customer Customer 49 Sales 14,046 $ 2,504 $ 1,505 $ 4,232 $ 5,947 $ 5,721 $ 14,744 $ 4,018$ 6,442 $ 8,160 $ 7,520$ 11,981 $ 2,468 $ 14,239 $ 2,455$ 11,538 $ 4,341 $ 9,948 $ 6,525 $ 7,354 $ 12,132 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ COGS 5,337 1,703 843 2,793 3,390 3,204 5,308 2,371 4,445 3,509 4,738 8,387 1,209 7,120 1,056 3,577 1,823 5,670 2,675 4,559 7,886 15 16 17 18 19 20 21 22 23 24 25 Narne Box Region Region1 Region2 Region3 Region4 Region5 Region6 Region 7 Region8 Warehouse Warehouse E WarehouseB WarehouseD Warehouse WarehouseC WarehouseF WarehouseC WarehouseB Customer Customer1 Customer2 Customer3 Customer4 Location Locations Locationc LocationB Locationc LocationF LocationA LocationD Customer5 Customer6 Customer7 Customer8 Customer9 Customer10 Customer11 Locations Locationc LocationA Locatione Customer12 Locations A B D E F G H 1 4 Shipping Exp 5 6 7 8 9 10 11 12 13 14 Date 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 11/17/20 Product Product3 Product7 Product2 Product6 Product3 Product1 Product 10 Product 7 Product10 Producto Product7 Product2 Product Product7 Product2 Products Product 10 Product 4 Product4 Product2 Product7 Region Region3 Region4 Region4 Region4 Region4 Region8 Region8 Region2 Region5 Region4 Region2 Region4 Region4 Region2 Region8 Region8 Region3 Region 6 Region1 Region5 Region1 SalesRep Sales Rep2 SalesRep 15 Sales Rep18 SalesRep14 SalesRep3 SalesRep6 SalesRep 16 SalesRep1 SalesRep6 SalesRep7 SalesRep17 Sales Rep8 SalesRep1 SalesRep6 Sales Rep 16 Sales Rep10 Sales Rep15 Sales Rep3 SalesRep17 SalesRep3 Sales Rep7 Customer Customer 16 Customer72 Customer71 Customer88 Customer65 Customer 100 Customer68 Customer85 Customer6 Customer1 Customer28 Customer16 Customer95 Customer65 Customer69 Customer 10 Customer14 Customer74 Customer69 Customer Customer 49 Sales 14,046 $ 2,504 $ 1,505 $ 4,232 $ 5,947 $ 5,721 $ 14,744 $ 4,018$ 6,442 $ 8,160 $ 7,520$ 11,981 $ 2,468 $ 14,239 $ 2,455$ 11,538 $ 4,341 $ 9,948 $ 6,525 $ 7,354 $ 12,132 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ COGS 5,337 1,703 843 2,793 3,390 3,204 5,308 2,371 4,445 3,509 4,738 8,387 1,209 7,120 1,056 3,577 1,823 5,670 2,675 4,559 7,886 15 16 17 18 19 20 21 22 23 24 25 Narne Box Region Region1 Region2 Region3 Region4 Region5 Region6 Region 7 Region8 Warehouse Warehouse E WarehouseB WarehouseD Warehouse WarehouseC WarehouseF WarehouseC WarehouseB Customer Customer1 Customer2 Customer3 Customer4 Location Locations Locationc LocationB Locationc LocationF LocationA LocationD Customer5 Customer6 Customer7 Customer8 Customer9 Customer10 Customer11 Locations Locationc LocationA Locatione Customer12 Locations