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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!