Mohopo Spreadsheet with Formulas and Scenarios FINAL.xlsx

Mohopo Spreadsheet with Formulas and Scenarios FINAL.xlsx -...

This preview shows page 1 - 3 out of 6 pages.

Scenario Summary Optimist High Optimist Low Normal Changing Cells: Annual Volume Required For Discount 50,000 75,000 100,000 Postage Credit From USPS Y Y N Additional Regional Bank USPS Campaign 15,000 5,000 0 15,000 5,000 0 15,000 5,000 0 Result Cells: Yearly Cost Grand Total $ 305,473 $ 261,508 $ 254,525 Yearly Mail Volume 195,000 165,000 150,000 Year End Jumbo Envelope Inventory (105,000) (75,000) (60,000) Reorder Jumbo Envelopes? Yes Yes Yes Yearly Text Messaging Volume 90,000 90,000 90,000 Yearly Email Volume 160,000 160,000 160,000 Costs Over 2016 values? Yes Yes Yes
Image of page 1

Subscribe to view the full document.

Pessimist 160,000 N 0 0 0 $ 258,200 150,000 (60,000) Yes 90,000 160,000 Yes
Image of page 2
MOHOPO COLLECTIONS INC CONSTANTS 2017 Jumbo Envelope Cost $ 1.00 First Class Postage $ 0.49 Jumbo Envelope Starting Stock 90,000 Discount Rate 5.0% Text Message Cost $ 0.35 E-mail Cost (CPM) $ 20.00 2016 Annual Costs $ 200,000 USPS Postage Credit $ 15,000 Expected Campaign Volumes 17-Jan 17-Feb 17-Mar 17-Apr 17-May Cabal Credit Card USPS 15,000 - 15,000 - 15,000 Cabal Credit Card Texting 5,000 - 5,000 - 5,000 Regional Bank USPS 30,000 15,000 15,000 15,000 - Regional Bank E-mail 20,000 - - - - Oak Knoll Securities Texting 20,000 - - - - Oak Knoll Securities E-mail 10,000 ### 10,000 10,000 10,000 INPUTS 2017 Annual Volume Required For Discount 50,000 NA NA NA ostage Credit From USPS ("Y" = Yes, "N" = No Y NA NA NA
Image of page 3
You've reached the end of this preview.
  • Fall '09

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern