question 9 help

High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cont. The data for various levels of rain as follows: Units Produced Total Coats 101,500 $29,350,500 115,500 31,680,500 131,500 34,360,500 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question beton Open spreadsheet a. Determine the variable cost per unit and the total cost Round your answer for variable cost to the nearest cent Round your ner for to do the per unit Variable cost: Total fixed cost: b. Based on port(a), estimate the total cost for 54,000 units of production, Round your answer to the nearest dollar Total cost for 84,000 units