Select Page

Attached is an excel spreadsheet just needs calculations inputed and spreadsheet completed. It has 2 part questions on the spreadsheet.
budget_project.xlsx

Unformatted Attachment Preview

2018 Actual Data
Average animal fee
Annual unit sales
Variable cost per animal
Feed
Veterinary Fees
Labor
Supplies
2018
Actual
39.75
2,763
3.46
3.65
2.23
1.39
Fixed Costs
Depreciation
Interest & Penalties
Insurance
Rent
Repairs & Maintenance
Entertainment
SG&A
Utilities
Taxes
685
425
4,550
7,325
5,950
4,635
4,425
1,885
4,105
8,175
Instructions: Use Excel formulas in all applicable cells.
Flexible Budget #1
1. Prepare a flexible budget using prior year actual accounting data. The only change is annual units sales = 3,000. Enter th
2. Use the skills you learned from the week five learning team project. Compute the break even point in units and dollars.
Flexible Budget #2
1a. Prepare a second flexible budget using estimated annual unit sales = “X”. This is your choice. Enter your volume choice
Enter all other data and calculations in the appropriate cells (column H).
1b. Increase the variable cost per unit (animal) by 7%. This applies to all variable cost categories (excluding advertising).
1c. The company plans to relocate the business. This may reduce rent by 2,150.
1d. The company uses a dated advertising program including the yellow pages and billboard signs. The company plans to red
The cost structure changes to a mixed cost and includes \$1,250 fixed plus variable costs. The variable cost is equal to .01
The company expects 2,500 views and 310 scheduled appointments.
2. Use the skills you learned from the week five learning team project. Compute the break even point in units and dollars.
en point in units and dollars. Compute the margin of safety. Enter the information in the flexible budget tab, rows 39-45.
en point in units and dollars. Compute the margin of safety. Enter the information in the flexible budget tab, rows 39-45.
, rows 39-45.
b, rows 39-45.
2019 Annual Flexible Budget
Budet #1
Budet #2
Flexible
Budget
Flexible
Budget
Sales Volume
Sales
Less: Variable Expenses
Feed
Veterinary Fees
Labor
Supplies
Total Variable Expenses
Contribution Margin
Less: Fixed Expense
Depreciation
Interest & Penalties
Insurance
Rent
Repairs & Maintenance
Entertainment
SG&A
Utilities
Taxes
Total Fixed Expense
Net Income (Loss)
Break Even (Units)
Break Even (Dollars)
Margin of Safety (Dollars)
Enter sales volume for bu
Enter sales volume for budget #2 in colum H, row 4.