Preparing Budgets: help with a question
milly1998
Registered Posts: 10
Can anyone help solve the whole page in the picture attached. I have filled in the correct answers to the first part but I’m so unsure as to how they are calculated?
I’ve had a look at the answers for the next parts and I’m unsure as to how they were calculated as well.
Help is appreciated.
Thank you x
I’ve had a look at the answers for the next parts and I’m unsure as to how they were calculated as well.
Help is appreciated.
Thank you x
0
Comments
-
a)
Starting with the kg side. You get the total available in the year and subtract what remains. 16,000 - 1,000 = 15,000 used
£
Closing inventory = amount * price per amount
This is valued at purchase price = 35000/14000 = £2.50 kilo
Closing inventory = 1000 * 2.5 = £2,500
Value of used = 39,750 - 2,500 = 37,250 (same logic as for kg)
Labour
Available hours = 160 * 25 = 4000
Hours required = 20,000 *0.25 = 5000 (15/60 = 0.25) converted minutes to hours
Basic Time @8 = 4000 £32000
Overtime 1000 £12000 (5000-4000)*(8*1.5)
Total 5000 £44000
Overhead
Variable £2/hour 5000 £10000
Fixed £7750
Total £17750
I hope this helps if you need any more clarification let me knowAAT Level 4, MAAT
ACCA in progress
F4- Passed Aug 2020
F5- Passed Dec 2020
F6- Passed Sep 2020
F7- Passed June 2021
F8 - Passed Sep 2021
F9 - Passed June 2021
SBL -
SBR - Passed Mar 22
ATX - Passed Dec 21
APM - Passed June 221 -
Amazing thank you!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 328 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 57 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 203 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 584 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