CSTR sample assessment 2 task 6
BethG
Registered Posts: 5
Hi, can someone please point me in the right direction in the workings out of this question please??
0
Comments

Hi BethG,
Please see the workings below:
Q1  Sales Revenue per mile for the contract of 14,000 miles
A1  I guess this one is pretty straight forward as everything is given:
Sales Revenue: 182,000 / Miles: 14,000 = 13 per mile
Q2  The variable cost per mile if the contract is for 18,200 miles
A2  Variable costs (16,800 +11,200 +15,400) / 14,000 miles = 3.1 per mile
Variable cost per mile remains the same no matter how many miles but the total variable cost increases with output (miles in this case)
So the variable cost per mile is 3.1 for 18,200 miles but the total of variable cost for 18,200 miles would be more since we would need to 18,200 miles x 3.10 = 56,420  but the question is only asking for variable cost per mile
Q3  Fixed cost per mile if the contract is for 15,600 miles
A3  Fixed costs given in the table are: indirect labour and overheads. We need to divide them by number of miles to get a fixed cost per mile
(19,600 +35,000) 54,600 / 15,600 miles = 3.5 per mile
(Fixed cost per mile for 18,200 would be less because as the level of activity increases fixed cost per unit will decrease because it is spread over larger number of miles  54,600 / 18,200 = 3)
Q4  The total cost per mile if the contract is 15,600 miles
A4  We know from A2 that variable cost per mile is 3.1
We also know from A3 that fixed cost per mile for 15,600 miles is 3.5
The total cost per mile for 15,600 miles is then variable cost per mile plus fixed cost per mile: 3.1 + 3.5 = 6.6
Q5  The profit per mile if the contract is 18,200 miles
A5  We know that variable cost is 3.1
We can calculate fixed cost per mile for 18,200 miles: 54,600 / 18,200 = 3
Total cost per mile if the contract is for 18,200 miles
3.1 + 3 = 6.1
Sale revenue per mile is 13 (calculated in A1)
Sale revenue per mile minus total cost per mile = profit per mile
13  6.1 = 6.9
I hope that make sense
0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 314 NEW! Qualifications 2022
 159 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 85 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 273 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 200 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 581 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership