Score: 0 of 7 pts 6 of 7 (6 complete) HW Score: 25%, 23 of 92 p X E3-25A (similar to) Question Help Tran Company, which uses the high-low method to analyze cost behaviour, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow EE Click the Icon to view the data) Requirements Using the high-low method, answer the following questions: 1. What is the variable utilities Cost per machine hour? 2. What is the ixed cost of utilities each month? 3. If Tran Company uses machine hours in a month, what will its total costs be? Requirement 1. What is the variable utilities cost per machine hour? Let's begin by determining the formula that is used to calculate the variable cost (slope) Change in cost Change in volume = Variable cost (slope) Using the high-ow method, the variable utilities cost per machine hour is $(Round the variable cost to the nearest cent.) Requirement 2. What is the fixed cost of utilities each month? Let's begin by determining the formula that is used to calculate the fixed cost component. Totaal operating cost Tolal variable cost = Fixed cost Using the high-on method, the fixed ost of utilities each month is S. (Round the total variable costs to the nearest whole dollar.) Requirement 3. If Tran Company uses machine hours in a month, what will its total costs be7 The total costs when machine hours are incurred is (Round your interim and final calculations to the nearest whole dollar.) X E3-25A (similar to) Question Help Battle Company, which uses the high-low method to analyze cost behaviour, has determined that machine hours best predict the company's total litilities cost. The company's cost and machine hour usage data for the first six months of the year follow (Click the icon to view the data.) Requirements Using the high low method answer the following questions: 1. What is the variatile: utilities cost per machine hour? 2. What is the fixed cost of utilities each month? 3. If Battle Company uses 1,290 machine hours in a month, what will its total costs be? Data Table - X Requirement 1. What is the variable utilities cost per machine hour? Let's begin by determining the formula that is used to calculate the variable cast (slope). = Variable cost slope) Total Cost Maching Hours Month January ...... $ February $ 3,080 1.040 3,780 1,180 1.055 March $ 3,550 $ April. May 3,730 4,300 1,200 1,190 1.640 June $ 4,500 Print Done Choose from any drop down list and then click Check Answer. Activate Windows