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 - Expenses per Unit)
Assume Fixed Expenses = $7,000; Price per Unit = $14.99 and Expenses per Unit = $8.00
Use the concepts and techniques presented in Module 4 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. Also 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 increments of $250 or varying Expense per Unit between $7.60 and $8.00 in increments of $0.20?
Part 2: What additional break-even points did you calculate, and why?
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 4 images
- Please show workarrow_forwardChapter 13, Question 6. Attached is a similar question with answers. Please answer the same four parts for the new questionarrow_forwardSuppose your company sells a 3 pack of lenses that attach to smart phones to improve the quality of pictures people take. You pay $29.95 for each 3 pack and sell them for $59.95. What is your Cost of Goods Sold Percentage for this item?arrow_forward
- Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. × Answer is complete but not entirely correct. Costs Product Cost / Period Cost Period Cost Product Cost 1. Depreciation on salespersons' cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors' salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for…arrow_forwardDo not use Aiarrow_forwardAngie Silva has recently opened The Sandal Shop in Brisbane, Australia, a store that specializes in fashionable sandals. In time, she hopes to open a chain of sandal shops. As a first step, she has gathered the following data for her new store: Sales price per pair of sandals $ 30 Variable expenses per pair of sandals 15 Contribution margin per pair of sandals $ 15 Fixed expenses per year: Building rental $ 11,300 Equipment depreciation 11,300 Selling 9,000 Administrative 13,400 Total fixed expenses $ 45,000 1. What is the break-even point in unit sales and dollar sales? (Do not round intermediate calculations.)arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education