2018 Actual Data2018ActualAverage animal fee39.1Annual unit sales2,775 Variable cost per animal Feed3.23 Veterinary Fees3.72 Labor1.65 Supplies1.45 Contractors0.75Fixed Costs Depreciation 775 Interest & Penalties 290 Insurance 4,875 Rent 5,890 Advertisement 4,880 Repairs & Maintenance 3,425 Entertainment 4,425 SG&A 2,210 Utilities 3,865 Taxes 7,375 Instructions: Use Excel formulas in all applicable cells.Flexible Budget #11. Prepare a flexible budget using prior year actual accounting data. The only change is annual units sales = 2,900. 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 40-46.Flexible Budget #21a. 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 4%. This applies to all variable cost categories (excluding advertising).1c. The company plans to relocate the business. This may reduce rent by 1,800. 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,200 fixed plus variable costs. The variable cost is equal to .018 per online view plus $4.65 for appointments scheduled online. The company expects 1,900 views and 225 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 40-46.3. Use formulas to compute variances and explain why the variances are positive or negative. Enter formulas in the Flexible Budget tab column J. Write your explanations in column L.