Question: Your assignment is to complete the May billsheet (Tab 3) for a digital campaign that ran on the Atlantic.com, fill in all cells highlighted







Your assignment is to complete the May billsheet (Tab 3) for a digital campaign that ran on the Atlantic.com, fill in all cells highlighted in yellow on Tab 3 and calculate the total billable amount for the month of May. Attached you'll find: Tab 1- An Insertion Order (ie purchase order) for the Cathay Pacific campaign that ran in April & May. Tab 2 & 3 - Two billsheets, a completed one for April, and a blank one for May. Tab 4- Raw data that shows impressions delivered for April and May, broken out by day and by placement Important things to know to successfully complete this assignment: Impressions delivered in a month can only be billed for in that month Total campaign billable impressions cannot exceed total campaign contracted impressions. We are unable to charge for any impressions we serve beyond the total "contract impressions." We also cannot charge for impressions we did not deliver! Useful formula: Cost = Billable Impressions * CPM / 1000 Goal: Successfully complete the May billsheet! Let me know the total May billed revenue. Did we deliver in full on the campaign contract OR did we lose money? Please send back a summary of your findings and attach the excel workbook to show your work.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
