Question: This is the excel project. The wordings is very confusing. Please help out this question Thanks A B C D E F G H J

This is the excel project. The wordings is very confusing. Please help out this question Thanks
A B C D E F G H J L M N 1 Your Name Advertising Company 2 Advertising Sales 3 2019 4 5 Advertising Media 6 Media Category 7 Newspaper Print 8 Flyer Print 9 Coupon Print 10 Radio Audio/Video 11 Mailer Print 12 Poster Print 13 Phone Solicitation Audio/Video 14 Television Audio/Video Annual Cost $2,500.00 $1,500.00 $1,500.00 $5,000.00 $2,500.00 $1,500.00 $3,500.00 $10,000.00 January February $500 $678 $250 $250 $2,000 $780 $900 $1,200 $150 $178 $60 $80 $500 $670 $1,200 $2,500 March $920 $900 $900 $1,000 $200 $100 $800 $3,000 April $2,001 $870 $750 $1,000 $220 $100 $900 $3,500 Sales from Advertising Media May June July August September November December $784 $550 $770 $800 $120 $650 $890 $78 $550 $670 $395 $789 $550 $78 $750 $210 $400 $560 $590 $800 $800 $900 $978 $800 $2,300 $1,700 $1,800 $900 $340 $500 $340 $500 $670 $120 $85 $120 $150 $150 $180 $87 $90 $75 $1,200 $1,200 $1,500 $1,800 $900 $1,200 $1,500 $5,000 $6,000 $3,500 $4,000 $4,200 $1,200 $1,800 15 ADVERTISING SALES project This following is the email you got from your manager who has attached a datasheet in Excel for you analyze. Hello there, This is Frank. I am on vacation and away from my office, but I just got a notification that my annual sale data of different advertising media had arrived. I would like you to use Excel perform the analysis for me, e.g., to build a few tables to show the sale from different media, different category, different media by month, and provide me the best advertising media by sales over investment. I also want to see if the best advertising media varies by month to see if I should change my spending based on seasons. Please create a few tables in ACCESS, which I can store this year and future sales data and a few queries that I can find the best media overall and by month. Oh, right, I also thinking of moving paperless for environmental concerns. Can you build an analysis to suggest which physical media (the more the better) should I eliminate, but would have minimum impact on our sales? Can you have all the work put into one PowerPoint presentation and a business report, which we can bring to the board of directors? Since we will go virtual this year, can you record that as well? Please put everything together by Dec. 16, 2020, 11:59 PM. I will review them on Dec. 17, 2020. Thanks. Regards, Dec. 14, 2020
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
