Question
Kenya Bike Limited (KBL) assembles motor bikes using spare parts procured from China. The following data relates to the costs and number of motor bikes
Kenya Bike Limited (KBL) assembles motor bikes using spare parts procured from China. The following data relates to the costs and number of motor bikes assembled in 2015/16 financial year.
Month
Total overheads
Number of bikes assembled
Number of hours taken to assemble the bikes
July
460,000
300
900
August
120,000
220
660
September
480,000
330
990
October
550,000
390
1170
November
570,000
410
1230
December
310,000
240
720
January
440,000
290
870
February
455,000
320
960
March
530,000
380
1140
April
250,000
150
450
May
700,000
450
1350
June
490,000
350
1050
(a)Using the conventional high low cost estimation exercise, determine the cost prediction equation for the company using the number of motor bikes assembled as the independent variable (4 marks)
(b)One of the cost elements included in the total overheads in the table above is supervision costs. When the number of hours taken to assemble the motor bikes exceeds 1000, KBL is forced to hire an additional supervisor hence fixed costs increase by 10% (a step of 10% is noted if more than 1000 hours are used). The variable cost of assembling a motor bike is however not affected by the change in the number of hours. Using the high low method of cost estimation with the number of hours taken to assemble the motor bikes as the independent variable, determine:
-The equation to use to predict costs when the number of hours taken to assemble the motor bikes are less than 1000;(6 marks)
-The equation to use to predict costs when the number of hours taken to assemble the motor bikes are more than 1000;(6 marks)
(c)State two limitations of the high low method of cost estimation and for each limitation suggest the steps that as a manager you can take to overcome it.(4 marks)
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