Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Strategy

Authors: Mike W. Peng

5th Edition

0357512367, 978-0357512364

Students also viewed these Accounting questions