Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started