Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Economics Of Money Banking And Financial Markets

Authors: Frederic Mishkin

10th Global Edition

0273765736, 978-0273765738

More Books

Students also viewed these Finance questions