JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows therelated CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete thetask.• Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, =B5" wasentered, the formula would output the result from cell B5. or 75 in this example.• Beslc Math functlons: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: -(plus sign to add). - (minus sign to subtract). * (asterisk sign to multiply). and / (forward slash to divide). From the Excel Simulation below, if ina blank cell "=85+B6" was entered, the formula would add the values from those cells and output the result, or 120 in this example. If usingthe other math symbols the result would output an appropriate answer for its function.国日らCVP Analysis - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSign InCalibri-11A A%PasteBIU-Alignment NumberConditional Format asCellCellsEditingFormatting Table StylesClipboardFontStylesA1fxGiven the following information complete a CVP analysisAD34 Unit sales11,200 units5 Selling price per unit6 Variable expenses per unit7 Fixed expenses$75 per unit$45 per unit$210,0009 Use the data to answer the fallowing.1011 1. Compute the CM ratio and variable expense ratio12 Selling price per unit13 Variable expenses per unit14 Contribution margin per unitper unitper unitper unit1516 CM ratio17 Variable expense ratio1819 2. Compute the break-even paint20 Break-even in unit sales21 Break-even in dollar salesunits2223 3. Compute the margin of safety24 Margin of safety in dollars25 Margin of safety percentage2627 4. Compute the degree of operating leverage28 Sales29 Variable expenses30 Contribution margin31 Fixed expenses32 Net operating income3334 Degree of aperating leverageSheet1READY10%

4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 11,200 units $75 per unit $45 per unit $210,000 Use the data to answer the following 1 1. Compute the CM ratio and variable expense ratio 12 Selling price per unit 3 Variable expenses per unit 14 Contribution margin per unit per unit per unit per unit 15 16 CM ratio 17 Variable expense ratio 18 19 2. Compute the break-even point 20 Break-even in unit sales 21 Break-even in dollar sales units 22 23 3. Compute the margin of safety 24 Margin of safety in dollars 25 Margin of safety percentage 26 27 4. Compute the degree of operating leverage 28 Sales 29 Variable expenses 30 Contribution margin 31 Fixed expenses 22 Net operating income 33 34 Degree of operating leverage

4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 11,200 units $75 per unit $45 per unit $210,000 Use the data to answer the following 1 1. Compute the CM ratio and variable expense ratio 12 Selling price per unit 3 Variable expenses per unit 14 Contribution margin per unit per unit per unit per unit 15 16 CM ratio 17 Variable expense ratio 18 19 2. Compute the break-even point 20 Break-even in unit sales 21 Break-even in dollar sales units 22 23 3. Compute the margin of safety 24 Margin of safety in dollars 25 Margin of safety percentage 26 27 4. Compute the degree of operating leverage 28 Sales 29 Variable expenses 30 Contribution margin 31 Fixed expenses 22 Net operating income 33 34 Degree of operating leverage

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

please answer do not image
please dont provide answer in image format thank you
Here's the second part of the milestone if you could verify these numbers to being accurate?
Please answer in excel with formula
'C QUESTION 8 Sales revenue (30,000 units) Variable costs Contribution margin Fixed costs Operating income At the breakeven point: Sales are equal to total fixed costs. Contribution margin in equal to sales. Contribution margin is equal to total fixed costs. O Sales are equal to total variable costs. Click Save and Submit to save and submit. Click Save All Answers to save all answers. * 구 $ G # % Total $750,000 450,000 300,000 150,000 $150,000 MacBook Pro ^ Per unit 25 15 ? &
Question 4
A company provided the following data: Selling price per unit $80 Variable cost per unit $55 Total fixed costs $490,000 What is the break-even point in units?
RDWMNE769 Corp. sells a single product. Selling price per unit $12 Variable expense per unit $2.00 Current Sales in units 16,000 RDWMNE769's current net operating income is equal to 0.31 of current sales. Q. What is RDWMNE769's fixed cost? A. $
You are provided with the following data. I Unit sales 5 Selling price per unit 5 7 8 Variable expenses per unit Fixed expenses Target Profit 9 10 Required: 11 12 13 Contribution margin per unit 14 15 CM ratio 16 Variable expense ratio 17 18 Compute the break-even. 19 20 Break-even in unit sales $ Dagate ssss is $ 80,000 units 70 per unit 28 per unit Compute the CM ratio and variable expense ratio. $ 2,688,000 $ 1,610,000
G http Chapter Review My... Sales price Contribution margin ratio Fixed costs Tra.. Vernon Company reported the following data regarding the product it sells: a. Break-even point in dollars a. Break-even point in units b. Sales in dollars b. Sales in units c. Break-even point in dollars c. Break-even point in units $60 Man... $ 10% $216,000 M Questio... Required Use the contribution margin ratio approach and consider each requirement separately. b Ans... 2,160,000 36,000 Bes... Saved a. What is the break-even point in dollars? In units? b. To obtain a profit of $54,000, what must the sales be in dollars? In units? c. If the sales price increases to $72 and variable costs do not change, what is the new break-even point in dollars? In units? US fron.
Unit sales (a) Selling price per unit Variable cost per unit Traceable fixed expense TB MC Qu. 12A-46 Woodridge Corporation manufactures numerous... Woodridge Corporation manufactures numerous products, one of which is called Alpha-32. The company has provided the following data about this product Multiple Choice $1,375,220 77,000 76.00 61.00 $1,323,000 $52.220 Help $ $ Management is considering increasing the price of Alpha-32 by 5%, from $76.00 to $79.80. The company's marketing managers estimate that this price hike would decrease unit sales by 5%, from 77,000 units to 73,150 units Assuming that the total traceable fixed expense does not change, what net operating income will product Alpha-32 earn at a price of $79.80 if this sales forecast is correct? Save & Exit
Zachary Company reported the following data regarding the product it sells: 11 Sales price Contribution margin ratio Fixed costs 48 25% $336,000 Required Use the contribution margin ratio approach and consider each requirement separately. a. What is the break-even point in dollars? In units? b. To obtain a profit of $48,0000, what must the sales be in dollars? In units? c. If the sales price increases to $60 and variable costs do not change, what is the new break-even point in dollars? In units? a Break-even point in dollars Break-even point in units b. Sales in dollars Sales in units c Break-even point in dollars Break-even point in units