Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Earl K. Stice, James D. Stice

18th edition

538479736, 978-1111534783, 1111534780, 978-0538479738

More Books

Students also viewed these Accounting questions

Question

7. Is a well-known brand valuable only to the owner of the brand?

Answered: 1 week ago

Question

C# ONLY with Comments

Answered: 1 week ago

Question

What are the three key dimensions of moti vation? (LO 3)

Answered: 1 week ago

Question

How does task control differ from results control? (LO 3)

Answered: 1 week ago