Question
For this assignment, you are going to create a budget for one of the departments on Netflixs income statement under Technology and Development for 2021
For this assignment, you are going to create a budget for one of the departments on Netflixs income statement under Technology and Development for 2021
The Actual for Technology and Development expenses were 1,829,600. This amount will be broken out into four departments equally:
Cybersecurity 25%
Research 25%
Development 25%
I.T. 25%
The company has decided to use incremental budgeting and is granting each department a 5% increase for 2021. Therefore, the new budget for 2021 is 1,921,080.
Breaking this out evenly across the four departments, the 2021 budget for each is:
Department | % Increase | 2021 Budget |
Cybersecurity | 25% | $480,270 |
Research | 25% | $480,270 |
Development | 25% | $480,270 |
I.T. | 25% | $480,270 |
You are to select one department and create an overhead budget for 2021. To do so, you have to come up with a set of assumptions:
- How many employees are in the department?
- What do they get paid?
- You could make other assumptions such as training sessions for some of the employees
- If there are training sessions, there will be travel involved.
- There will also be meal reimbursements for those that attend the training sessions
- What about supplies for the department?
- What about your department's rent?
You can use the attached Excel spreadsheet, to make assumptions and plot them out onto a one-year budget, by month
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started