Assignment/takeAssignment Main doinvoker takeAssignmentSessionLocator &inprogress=false Updat eBook Show Me How Ofice 365 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 cost. The data for various levels are as follows: production Units Produced Total Costs 93,000 $27,096,000 111,000 30,372,000 124,000 32,738,000 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 Open spreadsheet 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 dolor Variable cost per unit Total fixed cost b. Based on part (), estimate the total cost for 78,000 units of production Round your answer to the nearest dollar Total cost for 78,000 units Check My Work 2 more Check My Work uses remain Assignment/takeAssignment Main doinvoker takeAssignmentSessionLocator &inprogress=false Updat eBook Show Me How Ofice 365 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 cost. The data for various levels are as follows: production Units Produced Total Costs 93,000 $27,096,000 111,000 30,372,000 124,000 32,738,000 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 Open spreadsheet 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 dolor Variable cost per unit Total fixed cost b. Based on part (), estimate the total cost for 78,000 units of production Round your answer to the nearest dollar Total cost for 78,000 units Check My Work 2 more Check My Work uses remain