Hi,
Any help you can provide would be greatly appreciated. I have no idea where to start.
I am trying to accomplish the following:
We manufacture "wig-its." There is a one time cost to us of x for each unit. There is a x per month cost to us to administrate a subscription. There is a one time customer acquisition fee of X. The customer signs up for 36 months. The customer pays us x every month.
Is there a way to create a spreadsheet that will allow me to sell 50 units this month and show where down the 36 months we reach a break even point? Then next month, lets say we sell 30 units. Is there a way to incorporate the following 36 months into what we sold the previous month (which will now only have 35 months to go)? In the third month, we sell even more units. Is there a way to look 22 months down the line to see where we are in turns of profit or loss, either separately or in aggregate for all three months that we made sales?
It would be great to be able to change any variable, whether it is unit cost, per month cost, acquisition fee, how much the customer pays us, etc. The units sold month to month should also be allowed to be variable.
Like I said, I have no idea where to start, so if you can point me in a direction, that would be great!
Thanks, and all the best,
Robert
Bookmarks