Question: Please help with this question, is this correct, if not please correct me. Tran Company, which uses the high-low method to analyze cost behavior, has
Please help with this question, is this correct, if not please correct me.

Tran Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the rst six months follow: a (Click the icon to view the data.) Requirements X Using the high-low method. answer the following questions: 0 Data Table _ 1. What is the variable utilities cost per machine hour? 2. What is the xed cost of utilities each month? 3. If Tran Company uses 1,240 machine hours in a month, what will its total costs be? 1 Month Total Cost Machine Hours Requirement 1. What is the variable utilities cost per machine hour? January ...... $ 3,460 1,090 Let's begin by determining the formula that is used to calculate the variable cost (slope). February ----- 5 3,790 1,100 Change in cost / Change in volume E = Variable cost (slope) March """" $ 3532 Logo April ....... $ 3,790 1,220 (Round the variable cost to the nearest cent.) May ________ 5 4,500 1310 Using the high-low method, the variable utilities cost per machine hour is $ 2-6 . June ~~~~~~ 5 4-192 1-480 Requirement 2. What is the xed cost of utilities each month? 7 . , , . Print ' Done ' Let's begin by determining the formula that is used to calculate the fixed cost component. Total utilities cost v . Total variable cost | = Fixed cost Using the high-low method, the xed cost of utilities each month is $ 344 . Requirement 3. If Tran Company uses 1,240 machine hours in a month, what will its total costs be? (Round the variable cost per unit to two decimal places and round your total costs calculation to the nearest whole dollar.) The total costs when 1,240 machine hours are used is $ 3568 . Choose from any list or enter any number in the input fields and then continue to the next
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
