not incomplete. instructions are listed

Window Macros x x A B C D GHII P TUV Average animal fee Annual unit sales 2019 Actual 38.75 2,640 0.05 Variable cost per animal Rewards Feed Veterinary Fees Labor Supplies Contractors 3.13 3.52 1.45 1.55 0.65 Fixed Costs Lease Depreciation Interest & Penalties Insurance Rent Advertisement Repairs & Maintenance Entertainment SG&A Utilities Taxes 250 770 235 4,885 4,690 5,025 3,460 4,075 2,150 3,250 6,660 Instructions. Use Excel formulas in all applicable cells. 2019 Actual 1. Compute results using the prior year actual accounting data listed above. Enter the information in the Budget and Variance Analysis tab, column F. 2. Use the skills you learned from the week five project. Compute the break even point in units and dollars. Compute the margin of safety. Enter the information in the Budget and Variance Analysis tab, rows 46-52 2020 Hexible Budget la Prepare a flexible budget using estimated annual unit sales - 2,900. Enter volume in the Budget and Variance Analysis tab, column H. row 4. Enter all other data and calculations in the appropriate cells (column H). b. Increase the average animal fee by 3.25%. ic Increase the variable cost per unit (animal) by 2.75%. This applies to all variable cost categories (excluding advertising, bedding, and specialty food). d. The driver for bedding and specialty food is the number of non-traditional animals. The company expect 250 animals per year at an average cost of $1.15 per animal for bedding and $1.32 per animal for specialty to e. The company plans to relocate the business. This may decrease rent by $700. f. 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 $300 fixed plus variable costs. The variable cost is equal to 01 per online view plus $2.75 for appointments scheduled online The company expects 1,400 views and 225 scheduled appointments 2. Use the skills you learned from the week five project. Compute the break even point in units and dollars. Compute the margin of safety. Enter the information in the Budget and Variance Analysis tab, rows 46-52 3. Use formulas to compute variances and explain why the variances are positive or negative. Enter formulas in the Budget and Variance Analysis tab column]. Write your explanations in column Instructions Budget and Variance Analysis dy 1 2020 Annual Budget and Variance Analysis Enter sales volume in columns F and H, row 4. 4 Annual Sales Volume (units) 2019 2020 Flexible Budget Actual Variance Variance Explanation 10 Sales 12 Less: Variable Expenses 13 Rewards 14 Feed 15 Veterinary Fees 16 Labor 17 Supplies 18 Contractors 19 Advertisement 20 Bedding 21 Specialty Food 23 Total Variable Expenses 25 Contribution Margin 26 27 Less: Fixed Expense 29 Lease 30 Depreciation 31 Interest & Penalties 32 Insurance 23 Rent 34 Advertisement 35 Repairs & Maintenance 36 Entertainment SG&A 38 Utilities 39 Taxes 37 41 Total Fixed Expense 43 Net Income (Loss) 46 Break Even (Units) 47 49 Break Even (Dollars) Instruction Rudada