In a memo, summarize the results of your customer analysis from requirement 2 (please see attached). Assume that the excel file is not be attached to the memo and that you should summarize information in the memo using data visualization.Make sure answer the following question: what actions would you recommend Carolina Creations Marketing department take with respect to each customers .

ner Analysis Southeast Furniture Mart Indianapolis Interiors Sales San Diego Interiors 437,500 $ 131,250 $ 87,500 Cost of goods sold 250,000 75,000 50,000 Gross margin 187,500 $ 56,250 $ 37,500 Activity Cost Pool: Sales Calls 22,473 28,894 12,842 Contract Negotiations 1,250 S 4,063 3,125 Order Processing 4,328 14,124 683 Warehouse Activities 30,016 S 9,005 S 6,003 New Customer 9,615 5 Shipping 1,835 4,862 4,692 6 Post-Sale Support 328 1,361 1,454 7 Other 26,116 7,835 5,223 8 Total Operating Expenses Allocated 86,347 $ 70,143 43,638 9 10 Operating Income 101,153 $ (13,893) $ (6,138) 12 yellow cells formula only 24 link formula only as needed