| MOHOPO COLLECTIONS INC |
| CONSTANTS | 2017 |
| Jumbo Envelope Cost |
| First Class Postage |
| Jumbo Envelope Starting Stock |
| Discount Rate |
| Text Message Cost |
| E-mail Cost (CPM) |
| 2016 Annual Costs |
| USPS Postage Credit |
| Expected Campaign Volumes | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Cabal Credit Card USPS |
| Cabal Credit Card Texting |
| Regional Bank USPS |
| Regional Bank E-mail |
| Oak Knoll Securities Texting |
| Oak Knoll Securities E-mail |
| INPUTS | 2017 |
| Annual Volume Required For Discount | | NA | NA | NA |
| Postage Credit From USPS ("Y" = Yes, "N" = No) | | NA | NA | NA |
| | NA | Feb-17 | Mar-17 | Apr-17 |
| Additional Regional Bank USPS Campaign | NA |
| SUMMARY OF KEY RESULTS | Year End |
| Yearly Cost Grand Total |
| Yearly Mail Volume |
| Year End Jumbo Envelope Inventory |
| Reorder Jumbo Envelopes? |
| Yearly Text Messaging Volume |
| Yearly Email Volume |
| Costs Over 2016 values? |
| Calculations |
| Inventory | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Total Jumbo Envelopes Used |
| | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Remaining Jumbo Envelopes |
| Reorder Jumbo Envelopes? |
| USPS Campaign Costs |
| Envelopes | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Cabal Credit Card USPS |
| Regional Bank USPS |
| Postage | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Cabal Credit Card USPS |
| Regional Bank USPS |
| Text Messaging |
| SMS | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Cabal Credit Card Texting |
| Oak Knoll Securities Texting |
| E-mail | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Regional Bank E-mail |
| Oak Knoll Securities E-mail |
| Total Campaign Costs | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Cabal Credit Card |
| Regional Bank |
| Oak Knoll Securities |
| | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 |
| Monthly Grand Total (Minus Applicable Discount) |
| Yearly Cost Grand Total |
| Yearly Total Mail Volume |
| Yearly Total Text Volume |
| Yearly Total Email Volume |
maiezymq12
Case6MohopoSTARTERfile1.xlsx
