Lab 3: Consider This: Your turn
Apply your creative thinking and problem-solving skills to design and implement a solution.
Determine the Break – Even Point
Part 1: You have been hired by Alison Chang, owner of a small start- up company, to create a data table that analyzes the break-even point for a new product she is developing. She would like you to analyze the break-even point for prices ranging from $12.99 to $17.99 per unit, in $0.50 increments. You can calculate the number of units she must sell to break even (break-even point) if you know the fixed expenses, the price per unit, and the expense (cost) per unit. The following formula determines the break-even point.
Break-Even Point = Fixed Expenses / (Price per Unit – Expense per Unit)
Assume Fixed Expenses = $7,000; Price per Unit =$14.99; and Expense per Unit = $8.00.
Use the concepts and techniques presented in this module to determine the break-even point and then create the data table. Use the Price per Unit as the input cell and the break-even value as the result. Protect the worksheet so that only cells with data can be selected. Submit your assignment in the format specified by your instructor.
You can calculate additional break-even points by using a two-way table and varying Fixed Expenses or Expense per Unit in addition to Price per Unit. Which of the following provides the owner with a wider range of break-even points: varying Fixed Expenses between $6500 and $7000 in increment of $250 or varying Expense per Unit between $7.60 and $8.00 in increments of $0.20?
Part 2: You made several decisions while creating the worksheet for this assignment. How did you set up the worksheet? How did you decide how to create the data table? What additional break-even points did you calculate, and why?
to study the effect of change in (price, fixed expenses and expense per unit) on break even uints, we studied different break even point using sensitivity analysis
thanks
please upvote if it helped
comment for doubts
Lab 3: Consider This: Your turn Apply your creative thinking and problem-solving skills to design and...
Apply your creative thinking and problem-solving skills to design and implement a solution. Part 1: You have just started a new running regimen. You decide to track your progress so that you can evaluate your workouts. You decide to use Excel to track information about time, distance, and frequency of your runs. You plan to record the data for each run and to consolidate data on a weekly basis so that you can see how you are progressing from week...
EX 6-13e In the Lab Design and implement a solution using creative thinking and problem-solving skills. Create and Query an Inventory Problem: A local company would like to be able to search their shipping supplies inventory in an easy manner. They have given you sample data shown in Table 6-7. Table 6–7 Inventory Data Description Inventory Number Unit List Price Quantity in Stock CX1D1 mailing labels carton $12.86 ED7XL bubble wrap roll $27.59 T562W packing tubes single $ 1.75 VP45L...
1. Determine the break-even point. 2. Compute the margin of safety and explain its significance 3. Compute the degree of operating leverage at a particular level of sales and explain how it can be used to predict changes in net operating income CVP Analysis - Excel 7 - 6 X BS.. HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in B I U. 23 - Clipboard A. Alignment Number Conditional Format Cell Cells Formatting" Table Styles Styles Given the...
Mauro Products distributes a single product, a woven basket whose selling price is $21 per unit and whose variable expense is $16 per unit. The company's monthly fixed expense is $10,000. oints Required: 1. Calculate the company's break-even point in unit sales. 2. Calculate the company's break-even point in dollar sales. (Do not round intermediate calculations.) 3. If the company's fixed expenses increase by $600. what would become the new break-even point in unit sales? In dollar sales? (Do not...
JPL, Inc. has provided its sales and expense data for the most
recent period. The Controller has asked you prepare a spreadsheet
that shows the related CVP Analysis computations. Use the
information included in the Excel Simulation and the Excel
functions described below to complete the task.
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” was entered, the formula would
output the result...
please help thank you in advance
Required information Exercise 5-5 (Static) Changes in Variable Costs, Fixed Costs, Selling Price, and Volume [LO5-4) [The following information applies to the questions displayed below) Data for Hermann Corporation are shown below: Selling price Variable expenses Contribution margin Percent Per Unit of Sales $ 90 100% 63 70 $ 27 304 Fixed expenses are $30,000 per month and the company is selling 2,000 units per month Exercise 5-5 (Static) Part 2 2-a. Refer to...
Required information The Chapter 5 Form worksheet is to be used to create your own worksheet version of the Review Problem example in the text. 2. Change all of the numbers in the data area of your worksheet so that it looks like this: Chapter 5: Applying Excel 4 Data Unit sales Selling price per unit Variable expenses per unit Fixed expenses 80,000 units 50 per unit 20 per unit 6 1.800.000 If your formulas are correct, you should get...
1. Determine the break-even point. 2 Compute the margin of safety and explain its significance. 3. Compute the degree of operating leverage at a particular level of sales and explain how it can be used to predict changes in net operating income 5.3 CVP Analysis - Excel Given the following information complete a Cve analysis 2 for JPL, Inc.: 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 11,200 units S75 per unit...
Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to questi Mauro Products distributes a single product, a woven basket whose selling price is $24 per unit and whose variable expense is $17 per unit. The company's monthly fixed expense is $18,900. 2.85 points Required: 1. Calculate the company's break-even point in unit sales 2. Calculate the company's break-even point in dollar sales....
Expand Your Critical Thinking 18-02 The condensed income statement for the Carla Vista and Paul partnership for 2020 is as follows. Carla Vista and Paul Company Income Statement For the Year Ended December 31, 2020 Sales (270,000 units) $1,350,000 Cost of goods sold 900,000 Gross profit 450,000 Operating expenses Selling $270,000 Administrative 189,000 459,000 Net loss $(9,000 ) A cost behavior analysis indicates that 75% of the cost of goods sold are variable, 42% of the selling expenses are variable,...