Reference no: EM132323444
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 = 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 #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 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.
Attachment:- Budget Project.rar