mdg1
asked on
Revenue and cost calculations based on timing of rollout criteria
Please see attached example.
Based on the month that we will rollout our services to particular companies, I need to calculate how much we will be making in revenue and the cost associated with the deployment of hardware. The month of the rollout will be the variable that may change so the revenue and costs all need to be tied to this variable.
Revenue:
For each company, revenue will be ongoing after each rollout. Meaning if we rollout on Month 6 then we will continue our revenue stream on an ongoing monthly basis. Row 26 in the attached spreadsheet will reflect the total revenue for all companies.
Cost:
The cost is for hardware at rollout and an accrual for ongoing replacement. The cost is $1k per car in the month of rollout plus $750 for every 20 units that have already been deployed. Look at:
Row 7 - Car installs - this identifies how many units will be installed based on the month of rollout
Row 8 - Total # of cars - this is a cumulation of all units installed
Row 27 - this is the cost based on $1k per car in the month of rollout plus $750 for every 20 units
I highlighted in yellow the cells that I would need you to calculate (again based on the variable month of rollout). I manually input the amounts to show what they will need to be.
please let me know if you have any questions.
Based on the month that we will rollout our services to particular companies, I need to calculate how much we will be making in revenue and the cost associated with the deployment of hardware. The month of the rollout will be the variable that may change so the revenue and costs all need to be tied to this variable.
Revenue:
For each company, revenue will be ongoing after each rollout. Meaning if we rollout on Month 6 then we will continue our revenue stream on an ongoing monthly basis. Row 26 in the attached spreadsheet will reflect the total revenue for all companies.
Cost:
The cost is for hardware at rollout and an accrual for ongoing replacement. The cost is $1k per car in the month of rollout plus $750 for every 20 units that have already been deployed. Look at:
Row 7 - Car installs - this identifies how many units will be installed based on the month of rollout
Row 8 - Total # of cars - this is a cumulation of all units installed
Row 27 - this is the cost based on $1k per car in the month of rollout plus $750 for every 20 units
I highlighted in yellow the cells that I would need you to calculate (again based on the variable month of rollout). I manually input the amounts to show what they will need to be.
please let me know if you have any questions.
there is no attached file.
ASKER
ooops - here you go. thx
Monthly-Model-Example.xlsx
Monthly-Model-Example.xlsx
Not sure I understand exactly what you are going for here... can you post another sheet, what it would look like if Rollout Month is set to 3?
ASKER
Hi there, I added a new tab and highlighted in green everywhere the change to month 3 rollout effects. Let me know if you need more clarification
Monthly-Model-Example.xlsx
Monthly-Model-Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works great. Can I extend my question? In playing with it, I realize that the variables (% adoption, price, etc) may change after a certain period of time. So can you work in start AND end months into the equation? Then I'll add additional columns to show the new variables.
Or should I start a new question for this?
Thanks,
Janice
Or should I start a new question for this?
Thanks,
Janice
If you agree that my answer is correct for the question you asked, I'd prefer to be awarded the points for correctly answering your question...
If you want to expand with another question, I'd be happy to take a look and see if I can answer that as well.
If you want to expand with another question, I'd be happy to take a look and see if I can answer that as well.
You can just post the url of your new question into a comment here if you want to "notify" me that you've posted a new question.
ASKER
Here is the url for the new question. thx
https://www.experts-exchange.com/questions/28415886/Revenue-and-cost-calculations-based-on-timing-of-rollout-criteria-Part-II.html
https://www.experts-exchange.com/questions/28415886/Revenue-and-cost-calculations-based-on-timing-of-rollout-criteria-Part-II.html
ASKER