# Accounting Week 6 Budgets And Decision Making Worksheet

Anonymous
account_balance_wallet \$25

### Question Description

The purpose of this assignment is to evaluate and prepare a flexible budget.

Resources: Excel File. Tutorials and links to Excel® help files are located via the week one Excel activity.

Instructions:

3. Complete the flexible budget tab.

4. Submit the completed Excel file to the assignments tab.

Based on the example, fixed expenses do not change with volume. Contrary, variable expenses change with volume. With respect to the case study the same principles apply. The only difference is that our variables expenses will change based on sales volume instead of machine hours.

Example:

Sales Volume 2,850

Feed cost per animal 3.23

Total feed cost = 2,850*3.23=9,206

Advertisement is a fixed expense at the 2,850 volume level (column F). However, the expense is considered a mixed cost (fixed and variable) with the second budget (column H).

For further clarification my suggestion is to read the instructions tab, row 35.

### Unformatted Attachment Preview

Austinediene
School: Rice University

let me know where you need further help

2018 Actual Data

Average animal fee
Annual unit sales
Variable cost per animal
Feed
Veterinary Fees
Labor
Supplies
Fixed Costs
Depreciation
Interest & Penalties
Insurance
Rent
Repairs & Maintenance
Entertainment
SG&A
Utilities
Taxes

2018
Actual
38,4
2.675

3,23
3,72
1,65
1,45
10,05
785
325
5.550
6.325
5.950
3.635
5.425
1.905
3.865
7.375

2019 Annual Flexible Budget
Budet #1

Budet #2

Sales Volume

2850
Flexible
Budget

3200
Flexible
Budget

Sales

109.440

122.880

Less: Variable Expenses
Feed
Veterinary Fees
Labor
Supplies
Total Variable Expenses
Contribution Margin

9.206
10602
4702,5
4132,5
5.950
34.593
10

10852,8
12499,2
5544
4872
1.175
34943
11

Less: Fixed Expense
Dep...

flag Report DMCA
Review

Anonymous
Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors