Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have been hired by Julio Quatorze, owner of Shrub and Trees Landscape Inc., to create a data table that analyzes the break-even point for

You have been hired by Julio Quatorze, owner of Shrub and Trees Landscape Inc., to create a data table that analyzes the break-even point for a new shrub for prices between $3.00 and $9.25 in increments of $0.25. You can calculate the number of units you 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 = $300,000; Price per Unit = $7.50; and Expense per Unit = $2.10. Use the concepts and techniques presented in this chapter 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. For a price per unit of $8.00, the data table should show a break-even point of 50,847 units. Protect the worksheet so that only cells with data can be selected. Submit the workbook as requested by your instructor.

Step by Step Solution

3.34 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

BreakEven Point The Worksheet for determining the BreakEven Point has prepared Steps to create the w... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Business Analytics

Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams

1st Edition

128518727X, 978-1337360135, 978-1285187273

More Books

Students also viewed these Finance questions