w] 5 0 ? X Old Sweet Farm client analysis - Microsoft Word REVIEW VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS Microsoft account - Cut Copy Calibri (Body) - 8 A A Aa- E E 21 ALT . 1 No Spac... Heading 1 Heading 2 Emphasis Find - aac Replace Select Paste BIU - abe x, x? A-aly - A 1 Normal Title Subtitle Subtle Em... Format Painter Clipboard Font Paragraph Average Revenue: calculate considering the monthly revenue divided by the number of shipments. Styles Editing Transport cost North = Distance Shipments Transport cost Transport cost South = Shipments * Transport cost Transport of choice is the cheaper transport company between North and South. (Use the function IF to select between NORTH and SOUTH) Once the cheaper transport company is selected, it is possible to calculate the margin for every shop, using the specific transport company. Margin is the revenue minus the transport cost; make sure you select the cheapest company using the function minimum of MIN(X.) A shop is strategic if the profitability is above the value in table 2. (use the IF function to state YES or NO). Calculate the sum, max, min and average for all the values in the columns that contain numbers. Hint: you need to fill all the pink cells with the proper formula, something like =SUM(A1:A3). Distance (mi) Shipments 301 Discount Average revenue Transport cost North Transport cost 10% $ 4,000 $ 4,500 $ 50 25 Client Alfa Beta Delta Gamma Lambda Pi Theta Omega Total Max Min Average 100 35 2501 5 400 Revenue Tier 5 $ 20,000 Silver 15 4,000 3 $ 250,000 2 s 36,000 31 $ 45,000 61 S 22.000 21 S 320,000 9 $ 120.000 $ 817,000 $ 320,000 S 4,000 $ 102.125 895 Ta Discount Revenue $ Table 2: Profitability Profitable customer $ 10,000 Carrier North Table 1: Discounts Tier Bronze 10,000 Silver 100,000 Gold 300.000 Platinum 5% 10% $ South $ $ 15% 20% PAGE 1 OF 1 179 WORDS * ENGLISH (UNITED STATES) + 100 %