Breakeven Analysis allows you to assess how profitable a project will be based on how much...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Breakeven Analysis allows you to assess how profitable a project will be based on how much you sell each unit for and how many units you sell. In the following example, assume you own a small company that has developed a new exercise device-called "The Strider-that tells someone how far they have walked, how many calories they have buned and how many paces per mile they have tallied, Assume the following facts. The machine that makes the device was purchased for $11,500 The microprocessors, the plastic case materials and the labor needed to assemble it costs $15 for each device. You have decided to sell the product directly to the consumer through a website promoted through ads. • The price you intend to charge each buyer for the "Strider" is $42. Before you market the product, you decide to create a spreadsheet to estimate the revenues, costs, profits and "Breakeven Point." Go to the "Bus 1011 Excel Student Spreadsheets" and click on the tab/worksheet labeled "Breakeven Analysis." Enter the following dater • In B3 type 10000 units sold. • In B4 type $42 per unit sales price. In aS enter the formula "83 B4" to calculate the revenue. • In 87 type $11,500 in fixed costs. In B8 type 15 as the variable costs associated with making each unit. In B10 enter the formula "87+B8*83" which is the fixed costs plus the $15 for each unit multiplied by the total number of units sold 10000. . In B12 enter the formula "=BS-810" to calculate the profits as revenues - costs. • B14 calculates the Breakeven Point, which is FIXED COSTS/ (PRICE -VARIABLE COSTS). Enter the formula "87/(B4-B8)" Note that the Breakeven Point is in units and should therefore be rounded. You should set up the spreadsheet with the appropriate formulas to change the price, cost and sales volume quickly. Answer the following questions: 1. What are your revenues, total expenses and profit if you sell 10,000 Striders? 2. What are your revenues, expenses and profit if you sell 15,000 Striders by lowering the price to $35 each? 3. How many Striders do you need to sell at $42 to make $500,000 in profits? (Find the answer by entering different numbers in the appropriate Cell until you get the desired result) 4. How many Striders do you need to sell at $42 to break even? 11 Soo/42-1S 3/ Soo,s00 4 1 Soo Breakeven Analysis allows you to assess how profitable a project will be based on how much you sell each unit for and how many units you sell. In the following example, assume you own a small company that has developed a new exercise device-called "The Strider-that tells someone how far they have walked, how many calories they have buned and how many paces per mile they have tallied, Assume the following facts. The machine that makes the device was purchased for $11,500 The microprocessors, the plastic case materials and the labor needed to assemble it costs $15 for each device. You have decided to sell the product directly to the consumer through a website promoted through ads. • The price you intend to charge each buyer for the "Strider" is $42. Before you market the product, you decide to create a spreadsheet to estimate the revenues, costs, profits and "Breakeven Point." Go to the "Bus 1011 Excel Student Spreadsheets" and click on the tab/worksheet labeled "Breakeven Analysis." Enter the following dater • In B3 type 10000 units sold. • In B4 type $42 per unit sales price. In aS enter the formula "83 B4" to calculate the revenue. • In 87 type $11,500 in fixed costs. In B8 type 15 as the variable costs associated with making each unit. In B10 enter the formula "87+B8*83" which is the fixed costs plus the $15 for each unit multiplied by the total number of units sold 10000. . In B12 enter the formula "=BS-810" to calculate the profits as revenues - costs. • B14 calculates the Breakeven Point, which is FIXED COSTS/ (PRICE -VARIABLE COSTS). Enter the formula "87/(B4-B8)" Note that the Breakeven Point is in units and should therefore be rounded. You should set up the spreadsheet with the appropriate formulas to change the price, cost and sales volume quickly. Answer the following questions: 1. What are your revenues, total expenses and profit if you sell 10,000 Striders? 2. What are your revenues, expenses and profit if you sell 15,000 Striders by lowering the price to $35 each? 3. How many Striders do you need to sell at $42 to make $500,000 in profits? (Find the answer by entering different numbers in the appropriate Cell until you get the desired result) 4. How many Striders do you need to sell at $42 to break even? 11 Soo/42-1S 3/ Soo,s00 4 1 Soo
Expert Answer:
Answer rating: 100% (QA)
Book1 Excel a O FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in ... View the full answer
Related Book For
Legal Research Analysis and Writing
ISBN: 978-1133591900
3rd edition
Authors: William H. Putman, Jennifer Albright
Posted Date:
Students also viewed these accounting questions
-
You are working for a small company that has developed an operating system for PCs that is faster and more stable than Microsoft's Windows operating system. What strategies might the company pursue...
-
You work for a pharmaceutical company that has developed a new drug. The patent on the drug will last 17 years. You expect that the drugs profits will be $2 million in its first year and that this...
-
A firm that has developed a new type of light bulb is interested in evaluating its performance in order to decide whether to market it. It is known that the light output of the bulb depends on the...
-
Solve this system of equations -3x-y 5 -3x - 4y 83 || y = 1 11
-
How might a shareholders agreement influence a companys financial report-ing objectives?
-
Use the most convenient method (Disk or Shell Method) to find the given volume of rotation. Region between x = y(5 y) and x = 0, rotated about the x-axis
-
A six cylinder four stroke I.C. Engine is to develop \(100 \mathrm{~kW}\) i.p. at 800 RPM. The stroke to bare ratio is 1.25. Assuming Mechanical efficiency of \(80 \%\) and break mean effective...
-
Ignatenko Company has several processing departments. Costs charged to the Assembly Department for October 2012 totaled $1,249,500 as follows. Production records show that 25,000 units were in...
-
FIGURE shows a closed loop system with a variable gain element G in the feedback path. (a) Derive an expression for y/x (b) Show that for large values of K1 and K2 the value of y/x can be varied...
-
What are the major causes of information risk? How can information risk be reduced?
-
1 Plastic for casing18000 2 Wages of assembly workers81000 3 Property taxes on factory7000 4 Accounting staff salaries38000 5 Drum stands 1000 stands purchased41000 6 Rent cost of equipment for sales...
-
A wire \(0.70 \mathrm{~m}\) long carries a current of \(1.4 \mathrm{~A}\). The wire is at an angle of \(53^{\circ}\) to a uniform external magnetic field. If the magnitude of the force the field...
-
Discuss the differences between fraud and abuse. During your discussion, provide examples of each and how health care managers might deal with them.
-
Why is emotional intelligence (EI) important for health care managers? Identify three ways someone who is new to the field can assess and develop his or her EI quotient.
-
A circuit consists of an AC source wired in series to a \(1000-\Omega\) resistor and a \(1.00-\mu \mathrm{F}\) capacitor. For a source emf amplitude \(\mathscr{E}_{\max }=35.0 \mathrm{~V}\),...
-
A physician and his colleague decide to set up a laboratory owned by a dummy corporation in their wives names and begin to refer patients to this laboratory. What (if any) laws have they violated?
-
Provide detailed analysis on Luxottica Company's macro environment and PESTEL analysis. What trends in the macro environment would positively/negatively impact the company's products? Provide a five...
-
Prove the result that the R 2 associated with a restricted least squares estimator is never larger than that associated with the unrestricted least squares estimator. Conclude that imposing...
-
Assume there is no written contract. The seller hands Mary a slip of paper upon which he has written, "This is to confirm our oral agreement." He and Mary both sign the paper. Is there an enforceable...
-
Assume this is a valid will, and also that Larry had a previous valid written will. What impact does the nuncupative will have on the written will? What is disposed of by the nuncupative will?
-
When can a husband or wife testify against each other? When are they prohibited from testifying against each other?
-
Consider the flow of a perfect gas along a Fanno line. Show that the pressure at the * reference state is given by the relation 1/2 m 2RT, P Ayge(y+1)
-
Air flows in an 8-cm-inside diameter pipe that is \(4 \mathrm{~m}\) long. The air enters with a Mach number of 0.45 and a temperature of \(300 \mathrm{~K}\). (a) What friction factor would cause...
-
Air enters a duct with a mass flow rate of \(35 \mathrm{lbm} / \mathrm{sec}\) at \(T_{1}=520^{\circ} \mathrm{R}\) and \(p_{1}=20 \mathrm{psia}\). The duct is square and has an area of \(0.64...
Study smarter with the SolutionInn App