2013 Budgeting task 2 help
Jobijo
Registered Posts: 7 Regular contributor ⭐
Hi
Can someone help me with task 2 of the new online tests?
On both of them I am stuck on task 2.
I saved the most recent till last so it would be fresh in my mind and now i am worries as my exam is this afternoon!
AAArrrrrrrrr!!!!!
Can someone help me with task 2 of the new online tests?
On both of them I am stuck on task 2.
I saved the most recent till last so it would be fresh in my mind and now i am worries as my exam is this afternoon!
AAArrrrrrrrr!!!!!
0
Comments

Hi Jobijo
How I worked it out was like this,
a)
It says the closing inventory(CI) should be 12.5% of the following weeks sales volume, so ...
Week 1 CI is 12.5% of week 2 sales volume, week 2 450 x 12.5% = 56.25 round up to 57.
Saleable products = sales volume  OI + CI = 382 (400 75 + 57 = 382)
It says 15% of all production fails quality control and is rejected, so therefore the saleable products must equal 85% (100%  15%)
The rejected production is the 15%
Total manufactured is 100%
b)
800 items x 14 litres = 11,200, there is an 8% waste.
So 11,200 / 92% = 12,173.913 or 12,174 ltr
12,174 ltr  OI 700 + CI 500 = 11,974 ltr
c)
65,000 items X 4 minutes = 260,000 minutes
260,000 / 60 = 4,333.33 or 4,334 hours
20 staff X 175 hours = 3,500 hours
4,334  3,500 = 834 hours overtime
d)
7,410 units X 3 minutes = 22,230 minutes
2,230 / 60 = 370.50 hours
370.5  350 hours available = 20.5 hours to be subcontracted
20.5 hours X 60 = 1,230 minutes
1,230 / 3 minutes per unit = 410 units to be subcontracted.
Hope you get this in time.
0 
Hi Luke
Sorry for the delayed reply….I passed!!
Thank you!!
0 
Hi Jobijo
How I worked it out was like this,
a)
It says the closing inventory(CI) should be 12.5% of the following weeks sales volume, so ...
Week 1 CI is 12.5% of week 2 sales volume, week 2 450 x 12.5% = 56.25 round up to 57.
Saleable products = sales volume  OI + CI = 382 (400 75 + 57 = 382)
It says 15% of all production fails quality control and is rejected, so therefore the saleable products must equal 85% (100%  15%)
The rejected production is the 15%
Total manufactured is 100%
b)
800 items x 14 litres = 11,200, there is an 8% waste.
So 11,200 / 92% = 12,173.913 or 12,174 ltr
12,174 ltr  OI 700 + CI 500 = 11,974 ltr
c)
65,000 items X 4 minutes = 260,000 minutes
260,000 / 60 = 4,333.33 or 4,334 hours
20 staff X 175 hours = 3,500 hours
4,334  3,500 = 834 hours overtime
d)
7,410 units X 3 minutes = 22,230 minutes
2,230 / 60 = 370.50 hours
370.5  350 hours available = 20.5 hours to be subcontracted
20.5 hours X 60 = 1,230 minutes
1,230 / 3 minutes per unit = 410 units to be subcontracted.
Hope you get this in time.
Hi Luke,
why do we deduct the open inventory away from the sales volume please? ( i know this is the right answer but can not understand why)
Surely the open inventory is saleable but the closing inventory is not as it needs to be carried over to the next period ..
don't understand this at all
Thanks for calculation above by the way0 
Screen grab of question
0 
You are being asked how many units you need to actually make (not sell) so you delete the amount of opening inventory as you don't need to make them as they are already there. Similarly you add on the amount of inventory you need to open the next period with, as you need to make it in preparation. This then gets deleted off the number that need to be produced in the next period as you already have them, and the cycle continues.0

You are being asked how many units you need to actually make (not sell) so you delete the amount of opening inventory as you don't need to make them as they are already there. Similarly you add on the amount of inventory you need to open the next period with, as you need to make it in preparation. This then gets deleted off the number that need to be produced in the next period as you already have them, and the cycle continues.
Thanks a lot NPS your an absolute wizard makes perfect sense now :001_smile:0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 318 NEW! Qualifications 2022
 156 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 92 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.2K General accounting discussion
 201 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 582 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