QUESTION 30 5. (15 pts.) Hanton is a start-up company that produces mobile phone accessories. The company has estimated the following data to produce a new product they are planning to sell: Fixed cost of production = $78,500 Material cost per unit = $4.15 Labor cost per unit = $3.27 Revenue per unit = $24.99 Note that, fixed cost is incurred regardless of the amount of units produced. Variable cost per unit is made up of per-unit labor and material costs. It is assumed that Hanton sells all the units they produce. Therefore, the profit is calculated by subtracting the total costs from the total revenue. Note that there is no data file for this problem - create an Excel spreadsheet model to answer the following questions. (4 pts.) Setup a spreadsheet model using the principles covered in the lectures and tutorial videos. (2 pts.) Using the spreadsheet model setup above, what would be the total profit if the company decides to produce 3,500 units? (3 pts.) Create a one-way data table varying the production amount from 0 to 20,000 in increments of 1,000. Use the production amount as the column input and the total profit as the output. (2 pts.) Using the one-way data table, identify the interval of production amount where breakeven happens. (Breakeven is when the total profit goes from negative to positive) (4 pts.) Find the exact breakeven point using Goal Seek. (Round your answer to the nearest integer) Set cell: location of profit, To value: 0, By changing cell: location of the production amount Attach File