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. INSERTION ORDER Advertiser:Campaign:Flight:CatheyPeclifc2015TheAllanticNepalProjnctCampaign41/20165/312018 Agency Contact Mery Hoces 315 W 11h Aver, Naw York, NY 10017 648.750.5647 mincogespomicom Buliling Contact Jackio Walls 60 Madison Awo, Floor a. New York, NY 10010 610.413.3745 inelaghatianticmodia.com Teme a Conditione Acded valua alarnenis are based on proposed spend ioval and will be adjuslad II program is revisad. Raies are NeT USO. Pubisher is not responsele for any rich media fose. AI tage provided must be secure (hetpe nlee mavired) Gidelinat well peeval. Legel Name as Addrese: The Allense Monthly Gooup, inc, 600 Now Hampehira Ava. NW, Washinglon, DC, 20037 Ailing Contact, Incich Woits, 202-268-7214, jwalisegaltanticmadin coom Sales Contact: Heylay Remec, hromerestheattenticont ard will be edvusted if projrem is ivvised. Not Tolas Mecra| 72,900 300 New Mempshira Ave. NW, Weshingion, DC, 20037 bomedin aom wes.,omt Digital IO Template April Billsheet May Bilisheet Delivery Report \begin{tabular}{|l|l|l|l|} Digital IO Template April Billsheet & May Billsheet & Delivery Report \\ \hline \end{tabular} 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. INSERTION ORDER Advertiser:Campaign:Flight:CatheyPeclifc2015TheAllanticNepalProjnctCampaign41/20165/312018 Agency Contact Mery Hoces 315 W 11h Aver, Naw York, NY 10017 648.750.5647 mincogespomicom Buliling Contact Jackio Walls 60 Madison Awo, Floor a. New York, NY 10010 610.413.3745 inelaghatianticmodia.com Teme a Conditione Acded valua alarnenis are based on proposed spend ioval and will be adjuslad II program is revisad. Raies are NeT USO. Pubisher is not responsele for any rich media fose. AI tage provided must be secure (hetpe nlee mavired) Gidelinat well peeval. Legel Name as Addrese: The Allense Monthly Gooup, inc, 600 Now Hampehira Ava. NW, Washinglon, DC, 20037 Ailing Contact, Incich Woits, 202-268-7214, jwalisegaltanticmadin coom Sales Contact: Heylay Remec, hromerestheattenticont ard will be edvusted if projrem is ivvised. Not Tolas Mecra| 72,900 300 New Mempshira Ave. NW, Weshingion, DC, 20037 bomedin aom wes.,omt Digital IO Template April Billsheet May Bilisheet Delivery Report \begin{tabular}{|l|l|l|l|} Digital IO Template April Billsheet & May Billsheet & Delivery Report \\ \hline \end{tabular}