GO 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 cost. The data for various levels of production are as follows: X Open spreadsheet Variable cost: This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Total fixed cost: $ Units Produced a. Determine the variable cost per unit and the total fixed cost. Round your answer for variable cost to the nearest cent. Round your answer for total fixed costs to the nearest dollar. 90,500 100,500 115,500 per unit Total cost for 74,000 units: Total Costs $28,890,000 30,690,000 33,390,000 b. Based on part (a), estimate the total cost for 74,000 units of production. Round your answer to the nearest dollar.

Ziegler. Inc, has decided to use the high-low method to estimate the total cout and the forcd and variatle cost components of she total cost. The cota for various levels of production are as follows: This information has been collected in the Microsof Excet Onane Ne. Open the speadshet, perform the required analyat, and input yove ansers in the questions below. Open sareadsheet a. Determine the variabie cosf per unit and the tetal hixd covt. kound your anwer for variable cout to the neareut cent, hound reur anser for total fised costs to the nearest doliar. Variablecost it per unit Total fined cost! b. Based on part (a), eitimate the total cost for 74,000 units of production. Round your answer to the ne arest qoilar. Total cost for 74,000 units is