Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please fill out the excel sheet clearly bssed on the problem in the first picture 3. What factors, other than the number of units shipped,
please fill out the excel sheet clearly bssed on the problem in the first picture 3. What factors, other than the number of units shipped, are likely to affect the company's total shipping expense? Explain your reasoning EXERCISE 6-5 Applying the High-Low Method; Predicting Cost [LO2-CC7,9) Hoi Chong Transport, Ltd. operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 114.800 kilometres during a year, the average operating cost is 12.5 cents per kilometre. If a truck is driven only 70,000 kilometres during u year, the average operating cost increases to 14.5 cents per kilometre. (The Singapore dollar is the currency used in Singapore.) Note: In your computations, please do not round the decimal places of cost per kilometre. Required: 1. Using the high-low method, estimate the variable and fixed cost elements of the annual cost of truck operation 2. Express the variable and fixed costs in the form Ya+bX 3. If a truck were driven 80,000 kilometres during a year, what total cost would you expect to be incurred? Page 260 EXERCISE 6-6 D Exercise 6-5 H High level of activity Low level of activity Change Kilometres Driven 114 800 20 000 44 800 Total Annual Cost 14 350 10 150 4200 Fixed cost per year: 0.09 correct up to here Total cost Less variable portion 1 435 000 -1076250 358 750 Fixed cost per year 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 3 Fored cost Variable cost 358 750 750 000 Total annual cost 1 108 750 26
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started