Compute expected operating income for each

Reference no: EM133204432

Assignment - Cost Volume Profit Analysis Worksheet

Description - Nicole Walker owns a small bakery in Georgia. A friend has asked to partner with her in the business. In order to know if she wants to expand the business, Nicole wants to "run" some computations to better understand the existing business.

Budgeted data for the next 12 months includes:

Revenues $600,000

Fixed costs $150,000

Variable costs $425,000

Variable costs will change based on the number of products sold. Use an Excel spreadsheet to compute expected operating income for each of the following scenarios.

A 5% increase in contribution margin, but keeping revenues steady,

A 5% decrease in fixed costs,

1. A 10% increase in units sold,

2. A 15% increase in units sold and a 5% increase in fixed cost, and

3. A 5% decrease in variable costs and a 5% decrease in fixed cost.

Reference no: EM133204432

Questions Cloud

Advantages and disadvantages of holacracy : If I were running my own business, what would I see as the advantages and disadvantages of holacracy (or some other approach to self-management)?

How much should the apartment be worth : In order to buy an apartment unit, Meryl needs to spend a total of $650,000 today and equal monthly payments of $2500 for the next 33 years.

What other insights or observations do you have : What other insights or observations do you have with regard to gross margin and contribution margin? Do those insights change depending on the industry

Obtain recent sustainability report for major corporation : Conduct an Internet search to obtain a recent sustainability report for a major corporation following the GRI guidelines.

Compute expected operating income for each : Variable costs will change based on the number of products sold. Use an Excel spreadsheet to compute expected operating income for each

What steps you take to know your market to a greater degree : If you owned an auto dealership, what steps would you take to know your market to a greater degree, and to revise your marketing actions accordingly?

Research a news article on texting and driving policy : To begin, research a news article on texting and driving policy that impacts population health in your initial post, address the following:

Assignment on policy implementation : What is the most significant problem with top-down models of policy implementation? What other problems exist with this model?

Write about the effect of tourism to the environment : Troy University - Problem: Write about the Effect of Tourism to the Environment.

User Account

All Pages