Need a Budget completed by 11PM EST Monday

Anonymous
timer Asked: Dec 14th, 2018

Question Description

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 the information in the flexible budget tab, column F.
2. Use the skills you learned from the week five learning team project. Compute the break even point in units and dollars. Compute the margin of safety. Enter the information in the flexible budget tab, rows 39-45.
Flexible Budget #2
1a. Prepare a second flexible budget using estimated annual unit sales = “X”. This is your choice. Enter your volume choice in the flexible budget tab, column H, row 4.
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 reduce costs and increase effectiveness by investing in an online campaign.
The cost structure changes to a mixed cost and includes $1,250 fixed plus variable costs. The variable cost is equal to .019 per online view plus $6.60 for appointments scheduled online.
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. Compute the margin of safety. Enter the information in the flexible budget tab, rows 39-45.

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 Advertisement 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 Advertisement Total Variable Expenses Contribution Margin Less: Fixed Expense Depreciation Interest & Penalties Insurance Rent Advertisement 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.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags

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