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
ing particulars, Calculate, BEP (Units and amount) and Margin of 3. From the safety, if actual sales is 13500 units Variable cost per unit OMR 75 Fixed expenses OMR 270000 Selling price per unit OMR 100
Answer it as early as possible?
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
QUESTION #-1 Lucy Company Has the Following Data 5,000 unit Current sales level Birr 20 Selling price per unit Direct material cost per unit Birr 8 Birr 2 Direct labor cost per unit Birr 2 Variable overhead per unit 20,000 Total fixed cost A. Break-Even Units B. Break-Even Sales C. Margin of safety in number of units and Birr. D. Profit if sales are 20% above the Break-Even Sales E. Sales to make a profit of birr 5,000 F. Contribution margin ratio if selling price is increased by G. Breakeven sales if selling price increased by 10% H. Breakeven sales, if fixed cost is increased by 20% I. Degree of operating leverage at the current sales level J. If the company wants to increase the sales level by 259 decision on net operating income of the company. QUESTION #-2: BBF. Inc., a retailing company has two c monthly contribution format income state for the company B Sales $3,000,000 $1 Variable expenses 900,000 40 Contribution margin 2,100,000 60 Fixed expenses 1,400,000 80 Operating income…
Good day Please answer question 3.1.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. $