**Project Summary:**

The following data is provided for a product to complete a cost-volume-profit analysis.

Original Data

Sales price per unit $50.00

Variable costs per unit $23.00

Fixed Costs $5,500

Monthly Volume 250 units sold

Target Profit Per Month $1,700

Assumption Changes

Expected Increase in Monthly Volume 10%

Expected Increase in Variable Cost 2%

**Project Requirements:**

Complete the following for the original data and for the assumption change. In your project submission, there will be two sets of calculations and one contribution margin income statement:

- Calculate the Contribution Margin in Units and Contribution Margin Ratio
- Calculate the Breakeven Point in Units Sales and Sales Dollars
- Calculate the Target Sales in Units and Dollars
- Calculate the Margin of Safety in Units and Margin of Safety Percentage
- Calculate the Operating Leverage
- Prepare a Contribution Margin Income Statement for the assumption change only.

Criteria | Ratings | Pts | |
---|---|---|---|

This criterion is linked to a Learning OutcomeOriginal Data - Calculation of Contribution Margin Ratio (3 points)Objectives Compute the contribution margin ratiothreshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeOriginal Data - Calculation of Break-even Point (3 points)Objectives Determine the break-even point in units and dollars threshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeOriginal Data - Calculation of Target Sales (3 points)Objectives Determine the level of sales needed to achieve a desired target profit in units and dollarsthreshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeOriginal Data - Calculation of Operating Leverage (3 points)Objectives Compute the degree of operating leverage at a particular level of salesthreshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeAssumption Change - Calculation of Contribution Margin Ratio (3 points)Objectives Calculate the contribution margin ratio Use the contribution margin ratio to compute changes in contribution margin and net operating income resulting from changes in sales volume threshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeAssumption Change - Calculation of Break-even Point (3 points)Objectives Determine the break-even point in units and dollarsthreshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeAssumption Change - Calculation of Target Sales (3 points)Objectives Determine the level of sales needed to achieve a desired target profit in units and dollarsthreshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeAssumption Change - Calculation of Operating Leverage (3 points)Objectives Compute the degree of operating leverage at a particular level of salesthreshold:2.0pts | 3pts | ||

This criterion is linked to a Learning OutcomeAssumption Change - Contribution Margin Income Statement (6 points)Objectives Prepare a contribution margin income statement Show how changes in sales volume affect contribution margin and net operating income Show the effects on net operating income of changes in variable costs, fixed costs, and selling pricethreshold:4.0pts | 6pts | ||

Total Points:30 |

Answered 3 days AfterMar 03, 2022

Sheet1

Data Given:

Original Assumption Changes

Units Sold 250 275

Selling Price Per Unit: $50.00 $50.00

Variable Cost Per Unit: $23.00 $23.46

Fixed Cost $5,500.00 $5,500.00

Target Profit $1,700.00 $1,700.00

1. Contribution Margin:

Selling Price Per Unit $50.00 $50.00 CONTRIBUTION MARGIN PER UNIT = SELLING PRICE PER UNIT - VARIABLE COST PER UNIT

Less: Variable Cost Per Unit $23.00 $23.46 CONTRIBUTION MARGIN RATIO= (CONTRIBUTION MARGIN PER UNIT/ SELLING PRICE PER UNIT)*100

Contribution Margin Per Unit $27.00 $26.54

Contribution Margin Ratio 54.00% 53.08%

2. Break Even Point:

Fixed Cost $5,500.00 $5,500.00 BREAK EVEN POINT (UNITS) = FIXED COST/CONTRIBUTION MARGIN PER UNIT

Contribution Margin Per Unit $27.00 $26.54 BREAK EVEN POINT (DOLLARS) = FIXED...

Data Given:

Original Assumption Changes

Units Sold 250 275

Selling Price Per Unit: $50.00 $50.00

Variable Cost Per Unit: $23.00 $23.46

Fixed Cost $5,500.00 $5,500.00

Target Profit $1,700.00 $1,700.00

1. Contribution Margin:

Selling Price Per Unit $50.00 $50.00 CONTRIBUTION MARGIN PER UNIT = SELLING PRICE PER UNIT - VARIABLE COST PER UNIT

Less: Variable Cost Per Unit $23.00 $23.46 CONTRIBUTION MARGIN RATIO= (CONTRIBUTION MARGIN PER UNIT/ SELLING PRICE PER UNIT)*100

Contribution Margin Per Unit $27.00 $26.54

Contribution Margin Ratio 54.00% 53.08%

2. Break Even Point:

Fixed Cost $5,500.00 $5,500.00 BREAK EVEN POINT (UNITS) = FIXED COST/CONTRIBUTION MARGIN PER UNIT

Contribution Margin Per Unit $27.00 $26.54 BREAK EVEN POINT (DOLLARS) = FIXED...

SOLUTION.PDF## Answer To This Question Is Available To Download

- 1. Hannah Gilpin is the controller of Blakemore Auto Glass, Inc, a division of Eastern Glass and Window. Blakemore replaces and installs windshields. Her division has been under pressure to improve...SolvedMar 15, 2022
- Sheet1Some Agrobusiness Company"($000)Scroll across to view 5 Excel Charts from Excel TemplatesEXAMPLE...SolvedMar 03, 2022
- CYSE 270: Linux System for Cybersecurity Lab 6 – File PermissionCYSE 270: Linux System for Cybersecurity You need to configure the system to allow three users to perform the shared folder...SolvedFeb 19, 2022
- You are the Controller (or Comptroller if you prefer) for one of five regional plants manufacturing ugly holiday sweaters (the kind they hold contests for), the uglier the better. Unfortunately, while...SolvedFeb 09, 2022
- Chapter 9: Cost Volume Profit (CVP) Analysis and Strategy: The Rialto Square TheatreBackground and History The Rialto Square Theatre (the Rialto) is a 2,000-seat theatre located in Joliet,...SolvedJan 24, 2022
- EQUITY FUNDING CORPORATION OF AMERICAIntroduction:Equity Funding was a financial institution primarily engaged in life insurA?ance. In 1964, its top management commenced to perpetrate a...SolvedDec 31, 2021
- Hokuriku-Seika Co., Ltd., of Yokohama, Japan, is a subcontractor to local manufacturing companies. The company specializes in precision metal cutting using focused high-pressure water jets and...SolvedDec 31, 2021
- Angora Wraps of Pendleton, Oregon, makes fine sweaters out of pure angora wool. The business is seasonal, with the largest demand during the fall, the winter, and Christmas holidays. The company must...SolvedDec 31, 2021
- Assignment 2: Course Project Task 3—Payment for ServicesWhen hospitals are paid for services, it is through payment structures. Payment structures include health maintenance organizations (HMOs),...SolvedDec 31, 2021
- Container Plastics CompanyRon Forlani has just gone public and expanded his container business. As a creative and skilled engineer, Ron develops technologically advanced machinery and moulds, which...SolvedDec 31, 2021

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.