Question
Question 6: a. How much is the slope (variable cost rate per unit), using volume of productions as the single cost driver for the year
Question 6:
a. How much is the slope (variable cost rate per unit), using volume of productions as the single cost driver for the year (show your answer with three decimal places)?
b. How much is the slope (variable cost rate per unit), using 'material A' as the single cost driver for the year (show your answer with two decimal places)?
c. How much is the slope (variable cost rate per unit), using 'material B' as the single cost driver for the year (show your answer with two decimal places)?
d. How much is the slope (variable cost rate per unit), using 'direct labour hours' as the single cost driver for the year (show your answer with two decimal places)?
e. How much is the slope (variable cost rate per unit), using 'machine hours' as the single cost driver for the year (show your answer with two decimal places)?
Please show all working and also use the regression method. Unable to attach excel to the question so have copied and pasted the table to the question.
Week | Volume | Mat A (kg) | Mat B (kg) | D Lab Hrs | Mach Hrs | Total Costs | Sale Value |
1 | 590000 | 46 | 52 | 110 | 69 | 920000 | 3540000 |
2 | 283000 | 20 | 28 | 56 | 35 | 469500 | 1698000 |
3 | 618000 | 48 | 58 | 116 | 74 | 972000 | 3708000 |
4 | 207000 | 18 | 21 | 42 | 27 | 355500 | 1242000 |
5 | 165000 | 15 | 17 | 35 | 22 | 292500 | 990000 |
6 | 537000 | 42 | 51 | 101 | 65 | 850500 | 3222000 |
7 | 662000 | 46 | 55 | 119 | 73 | 1000000 | 3972000 |
8 | 310000 | 27 | 32 | 64 | 41 | 540000 | 1860000 |
9 | 482000 | 38 | 46 | 91 | 58 | 768000 | 2892000 |
10 | 279000 | 23 | 27 | 55 | 35 | 460000 | 1674000 |
11 | 256000 | 22 | 27 | 54 | 34 | 450000 | 1536000 |
12 | 224000 | 19 | 23 | 45 | 29 | 381000 | 1344000 |
13 | 504000 | 42 | 48 | 95 | 60 | 801000 | 3024000 |
14 | 483000 | 38 | 46 | 92 | 50 | 768500 | 2898000 |
15 | 537000 | 42 | 51 | 94 | 62 | 850500 | 3222000 |
16 | 528000 | 42 | 53 | 100 | 65 | 837000 | 3168000 |
17 | 416000 | 33 | 40 | 80 | 51 | 669000 | 2496000 |
18 | 328000 | 26 | 36 | 63 | 42 | 527000 | 1968000 |
19 | 612000 | 48 | 57 | 99 | 68 | 963000 | 3672000 |
20 | 352000 | 32 | 34 | 68 | 45 | 573000 | 2112000 |
21 | 629000 | 49 | 59 | 118 | 75 | 988500 | 3774000 |
22 | 188000 | 16 | 19 | 39 | 25 | 327000 | 1128000 |
23 | 560000 | 44 | 53 | 98 | 65 | 885000 | 3360000 |
24 | 385000 | 31 | 37 | 74 | 47 | 622500 | 2310000 |
25 | 375000 | 31 | 36 | 72 | 47 | 607500 | 225000 |
26 | 421000 | 32 | 39 | 77 | 49 | 646500 | 2526000 |
27 | 497000 | 39 | 44 | 94 | 59 | 790500 | 2982000 |
28 | 403000 | 32 | 39 | 77 | 50 | 649500 | 2418000 |
29 | 293000 | 24 | 29 | 58 | 37 | 484500 | 1758000 |
30 | 285000 | 23 | 28 | 56 | 36 | 472500 | 1710000 |
31 | 499000 | 36 | 47 | 95 | 59 | 793500 | 2994000 |
32 | 574000 | 45 | 54 | 99 | 66 | 906000 | 3444000 |
33 | 183000 | 18 | 22 | 38 | 26 | 319500 | 1098000 |
34 | 339000 | 27 | 33 | 66 | 46 | 553500 | 2034000 |
35 | 233000 | 20 | 23 | 47 | 34 | 394500 | 1398000 |
36 | 436000 | 35 | 42 | 83 | 53 | 699000 | 2616000 |
37 | 329000 | 28 | 33 | 67 | 42 | 558500 | 1974000 |
38 | 382000 | 31 | 37 | 74 | 43 | 618000 | 2292000 |
39 | 396000 | 32 | 38 | 76 | 49 | 639000 | 2376000 |
40 | 544000 | 40 | 51 | 90 | 55 | 861000 | 3264000 |
41 | 318000 | 26 | 31 | 62 | 40 | 522000 | 1908000 |
42 | 248000 | 21 | 25 | 47 | 31 | 417000 | 1488000 |
43 | 520000 | 41 | 50 | 99 | 64 | 835000 | 3120000 |
44 | 360000 | 29 | 35 | 70 | 45 | 585000 | 2160000 |
45 | 432000 | 37 | 41 | 83 | 50 | 693000 | 2592000 |
46 | 247000 | 21 | 25 | 51 | 32 | 425500 | 1482000 |
47 | 452000 | 32 | 40 | 86 | 53 | 723000 | 2712000 |
48 | 449000 | 36 | 43 | 86 | 53 | 718500 | 2694000 |
TOTAL | 19350000 | 1543 | 1855 | 3661 | 2336 | 31183500 | 114075000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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