Prepare a flexible budget using prior year actual accounting

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.

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

Reference no: EM132323444

Questions Cloud

What hurdles did you have in accomplishing your goal : COM1162 Interpersonal Communication Assignment, Lethbridge College, Canada. What hurdles did you have in accomplishing your goal

Create a graph you will be using in your final project : Create and include an original graph. Input the data into an Excel document and create a graph you will be using in your Final Project.

Explain the purpose of the ryan white care act : HIV/AIDS has affected millions of people in the United States and the world since the 1980s. On a global scale, large numbers of people with HIV/AIDS.

How emerging technologies impact on patient outcomes : Reflect on how emerging technologies such as artificial intelligence may help fortify nursing informatics as a specialty by leading to increased impact on.

Prepare a flexible budget using prior year actual accounting : 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

Potential impact of blogging on the film : purpose of this assignment is for you to develop your big-picture thinking, and to explore various impacts of the ever-changing IT industry

What are the implications of the two studies : Summarize the key findings of each study in one or two comprehensive paragraphs. What are the implications of the two studies you chose in nursing practice?

Charge of design and implementation : How you will steward the plan as the senior staff member in charge of its design and implementation?

Compare figures and state why they are same as given figure : Question - Compare figures 2 and 4 and state why they are the same as figure 1

User Account

All Pages