please help me putting entry for point 2,3,5,8,9

i did rest of the entries.............

1 2 3 4 5 6 Prepare a flexible budget using estimated annual unit sales = 3,500. 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). The company adopted the accrual method of accounting in 2019. The cumulative affect of change in accounting principle, net of tax, equal to $35K was recorded with their GAAP based financial statements. The company purchased equipment equal to $20,000. Terms: 5 year loan with an interest rate equal to 4.8% and $5,000 cash down payment. Depreciation: Straight-line method, 5 year useful life, no residual value. Increase the average animal fee by 1.75% for the first five months and 2.85% for the remaining seven months of the year. The owner's sister is stationed in Europe with the military and wants to open another location or help with animal training for the military after she transitions to civilian life. Estimated start-up costs are $25K. She doesn't know if this will occur nor is the owner definitively planning for this option. The owner is evaluating regional competitors for a potential business acquisition. Approximately $5,000 will be invested with a third party search firm in 2020. Excess cash was invested in an S&P 500 Index fund with estimated annual capital gain and dividend income equal to $11,000. The company sold grooming equipment for a $500 dollar gain. However, the equipment is not expected to be delivered to the buyer nor will the owner receive payment. The company is diversifying into animal training and recorded unearned income in 2019 equal to $175,000 for cash advances from the U.S. government. The company expects to train several animals for special operation forces in 2020. Earned income is estimated to be $125,000. Increase the variable cost per unit (animal) by 2.75%. This applies to all variable cost categories (excluding advertising, bedding, and specialty food). The driver for bedding and specialty food is the number of non-traditional animals. The company expect 320 animals per year at an average cost of $1.75 per animal for bedding and $1.35 per animal for specialty food. The company plans to relocate the business. This may increase rent by $750. 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 $1200 fixed plus variable costs. The variable cost is equal to .05 per online view plus $4.00 for appointments scheduled online. The company expects 1,550 views and 225 scheduled appointments. 7 8 9 10 11 12 13 2020 Annual Budget and Variance Analysis Annual Sales Volume (units) 2800 3500 Enter sales volume in colum H, row 4. Per Flexible Budget Unit Actual Variance Variance Explanation 39.5 1,10,600 1,41,556 11,000 Sales Investment Income Gain - Sale of Equipment Military training - special operations Total Income 1,10,600 Less: Variable Expenses Rewards Feed Veterinary Fees Labor Supplies Contractors Advertisement Bedding Specialty Food 0.07 2.75 3.75 1.25 1.80 0.90 196 7,700 10,500 3,500 5,040 2,520 251.74 9889.69 13485.94 4495.31 6473.25 3236.63 977.5 560 Total Variable Expenses 29,456 39,802 Contribution Margin 81,144 Less: Fixed Expense 350 350 780 435 5,675 Lease Depreciation Interest & Penalties Insurance Acquisition Rent Advertisement Repairs & Maintenance Entertainment SG&A Utilities Taxes 6,700 4,700 3,460 4,075 2,300 3,450 5,800 5675 5000 7,450 1200 3460 4075 2300 3450 Total Fixed Expense 37,725 Net Income (Loss) 43,419 Break Even (Units) 1,302 1 2 3 4 5 6 Prepare a flexible budget using estimated annual unit sales = 3,500. 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). The company adopted the accrual method of accounting in 2019. The cumulative affect of change in accounting principle, net of tax, equal to $35K was recorded with their GAAP based financial statements. The company purchased equipment equal to $20,000. Terms: 5 year loan with an interest rate equal to 4.8% and $5,000 cash down payment. Depreciation: Straight-line method, 5 year useful life, no residual value. Increase the average animal fee by 1.75% for the first five months and 2.85% for the remaining seven months of the year. The owner's sister is stationed in Europe with the military and wants to open another location or help with animal training for the military after she transitions to civilian life. Estimated start-up costs are $25K. She doesn't know if this will occur nor is the owner definitively planning for this option. The owner is evaluating regional competitors for a potential business acquisition. Approximately $5,000 will be invested with a third party search firm in 2020. Excess cash was invested in an S&P 500 Index fund with estimated annual capital gain and dividend income equal to $11,000. The company sold grooming equipment for a $500 dollar gain. However, the equipment is not expected to be delivered to the buyer nor will the owner receive payment. The company is diversifying into animal training and recorded unearned income in 2019 equal to $175,000 for cash advances from the U.S. government. The company expects to train several animals for special operation forces in 2020. Earned income is estimated to be $125,000. Increase the variable cost per unit (animal) by 2.75%. This applies to all variable cost categories (excluding advertising, bedding, and specialty food). The driver for bedding and specialty food is the number of non-traditional animals. The company expect 320 animals per year at an average cost of $1.75 per animal for bedding and $1.35 per animal for specialty food. The company plans to relocate the business. This may increase rent by $750. 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 $1200 fixed plus variable costs. The variable cost is equal to .05 per online view plus $4.00 for appointments scheduled online. The company expects 1,550 views and 225 scheduled appointments. 7 8 9 10 11 12 13 2020 Annual Budget and Variance Analysis Annual Sales Volume (units) 2800 3500 Enter sales volume in colum H, row 4. Per Flexible Budget Unit Actual Variance Variance Explanation 39.5 1,10,600 1,41,556 11,000 Sales Investment Income Gain - Sale of Equipment Military training - special operations Total Income 1,10,600 Less: Variable Expenses Rewards Feed Veterinary Fees Labor Supplies Contractors Advertisement Bedding Specialty Food 0.07 2.75 3.75 1.25 1.80 0.90 196 7,700 10,500 3,500 5,040 2,520 251.74 9889.69 13485.94 4495.31 6473.25 3236.63 977.5 560 Total Variable Expenses 29,456 39,802 Contribution Margin 81,144 Less: Fixed Expense 350 350 780 435 5,675 Lease Depreciation Interest & Penalties Insurance Acquisition Rent Advertisement Repairs & Maintenance Entertainment SG&A Utilities Taxes 6,700 4,700 3,460 4,075 2,300 3,450 5,800 5675 5000 7,450 1200 3460 4075 2300 3450 Total Fixed Expense 37,725 Net Income (Loss) 43,419 Break Even (Units) 1,302