In cells K6:K9, add a formula that will return Increase? if the Ads to Place is equal to zero or if the New Cost Per Ad is less than or equal to the Budget +/- in cell H11. Any others should return Decrease?. This column now indicates the media types for which the resort may want to consider an increase or decrease in the Ads to Place, along with any necessary budget adjustment.

Scale: 70% : Print Print Sheet Options Effects . Forward-Backward. Area Titles Pane . Themes Page Setup Scale to Fit Arrange 13 New Budget Analysis Today's Date 2/15/2019 ainted Paradise Past Year, Monthly Advertising New Monthly Advertising Negotiation for Next Fiscal Year Cost Ads Past Guest Amount Cost per New New CostAds To Amount Consider a Anticipated Per Ad Placed Results Type Spent Guest RBudget Per Ad Place to Spend Change? Guest Results 2.09 S 4,000 S 1,3003 3.18 300 3250 3,900 6 Magazine $ 1,20031724.61538 $3,600 $ 7 Radio 300194.3076923 8 Television 5,00011 9 Internet 1,1002 742.153846 $ 2,200 $ 2.96 10 1,868 300 1226.76923 $5,000 $ 4.08 12,000$ 5,5002 $11,000 2,699 405 4,972 1,184 1 $ 1,200 Totals7 3787.84615 11100 12.30858973 $ 18,500 $ 8,325 $ 6 $16,100 2,200$ 1,200 Budget-$ 2,400 Guest Results / PAST VS. ANTICIPATED MONTHLY GUEST RESULTS 12 13 14 15 16 17 18 19 20 Past Guest Results Anticipated Guest Results Type Notes Magazine Lowest Cost per Guest Result, yet same number Ads placed Radio Budget no longer supports even one Ad Television Budget> than doubled, yet highest Cost per Guest Result. Internet | Budget not increased thus #Ads stayed the same 2,699 1724.61 1226.769231 742.153 405 94.307692 Guest Data GuestResultsBySpending AdvertisingPlan MarketingConsultants