# 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!

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