Task 5 (c) practice assessment 1 help please!!
HazelFitzell
Registered Posts: 1
Hi,
Can someone please help me calculate the energy cost for the alternative scenario?
Can someone please help me calculate the energy cost for the alternative scenario?
0
Answers

Hi Hazel,
These are my workings:
Selling price per unit £12 * 1.05 (increase by 5%) = £12.60
Sales volume: 80,000 * 0.92 (8% decrease) = 73,600
Sales revenue: 73600 * 12.6 = 927,360
Material: 392000/80000 = 4.9, then * 73600 = 360,640
Labour: 224000/80000 = 2.8, then *73600 = 206,080
Energy: £43,000 = 107.5%. So to get 100%: (7.5/107.5) x 43000 = £40k. Then *1.1 = £44k.
Depreciation: 80,000/6000 = 13.3 , so 14 steps.
New sales volume of 73,600 / 6000 = 12.26, so 13 steps.
13 steps * (£42,000/14) = £39,000
Rest should be self explanatory.
Hope this helps
Regards0 
In the first draft the energy cost is 100% + 7.5% alliwance, therefore
£43000/107.5=£400 per 1 %
We are then told that in the new draft the price rise will be 10%, so
110x400=£44000AAT Level 2. 2018 Distinction
AAT Level 3. 2018 Distinction
AAT Level 4. 2019 FSLC 100% MABU 93% MADC 82% PDSY 80%
Xero Certified Advisor0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 586 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership