Accounting Week 6 Budgets And Decision Making Worksheet

Anonymous
timer Asked: Feb 8th, 2019
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:

1. Download the Excel file posted to the week 6 projects thread.

2. Read the instructions tab.

3. Complete the flexible budget tab.

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

https://www.accountingcoach.com/blog/flexible-budget

https://www.bing.com/videos/search?q=flexible+budget+example&view=detail&mid=98726F764585A5D5CDA998726F764585A5D5CDA9&FORM=VIRE

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

Tutor Answer

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
Advertisement
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
Advertisement
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.

Similar Questions
Hot Questions
Related Tags
Study Guides

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