Unit 6 Dec 2003 paper
confoosed
Registered Posts: 38 Regular contributor ⭐
Can anyone help pleeeeeeeeze!!!!
Task 2.3 (b) on the Unit 6 December 2003 Past Exam Paper asks us to calculate how many units of products Exe, Wye and Zed should be made and sold each month to maximise it's profits using 3,000 labour hours.
What formula would I need to use, I haven't the faintest idea how to work this question out!
Task 2.3 (b) on the Unit 6 December 2003 Past Exam Paper asks us to calculate how many units of products Exe, Wye and Zed should be made and sold each month to maximise it's profits using 3,000 labour hours.
What formula would I need to use, I haven't the faintest idea how to work this question out!
0
Comments

LIMITING FACTOR
INFORMATION[/………………………...….Alpha……….Beta………Gamma
Sales and production..(Units)………….1,000……….200………...500
Selling price per unit ……(SP)…………...£50………..£120……….£80
Direct Materials per unit (VC) ……….…£11……….£24…………£16
Direct Labour per Unit (Hrs)…(VC)……0.5 Hrs…..4 Hrs………1 Hrs
Direct Labour Rate per Hour ……………£6……….£6………….£6
Direct Labour Cost per Unit ……………..??...........??...............??
Fixed Monthly Overheads…..(£32,000)
Limiting Factor
Shortage of Direct Labour Hours. (Available 1,400 Hrs)
Calculate number of units of each range to make and sell to maximise profit for that month.
Step 1 Calculate contribution per Unit (SPVC=Contribution)
…………………………………………..........…….……….Alpha……….Beta………G amma
.
Selling Price per unit …(£)..……………......………….50…………120………….80
Less Variable costs Material ……………....……….(11)………...(24)………...(16)
Less Variable Cost Labour (Lab Hrs x £6)…….…(..3)…………(24)………...(..6)
.
Contribution per Unit……(£)…………….......…………£36………..£72………….£58
Step 2 Calculate Contribution per Limiting Factor – Direct Labours in this case
.
……………………………………………….…...............…….Alpha……….Bet a………Gamma
Direct Labour per Unit (Hrs)…(VC)…….....…………0.5 Hrs……..4 Hrs………1 Hrs
Divide contribution per unit by Hrs per unit..……£72………….£18……..…..£58
Step 3 Rank products by best contribution per Limiting Factor
.
Rank…………………………………………................……….1………..……3… ...………….2
.
Step 4 Work out how many hours would be required to produce each product based on sales and production.
.
………………………………………………...........…….Alpha……….Beta………Ga mma
Sales and production..(Units)………………….1,000……….200………...500
Direct Labour per Unit (Hrs)…(VC)…………..…0.5 Hrs…..4 Hrs………1 Hrs
Total Hrs Required to produce …………………500 Hrs…..800Hrs…….500Hrs = 1800 Hrs
Step 5 Allocate Limited Resource to products accoutring to step 3 Ranking.
Hours Allocated for production….Rank 1 …....500Hrs
1400 hrs less 500 hrs = 900 Hrs Rank 2………………………………….500Hrs
900 hrs less 500 hrs = 400 Hrs Rank 3…………………400Hrs Remaining Hrs
Step 6 Work out How many units can be produced from remaining Labours Hrs.
………………………………………………….............….Alpha……….Beta……… Gamma
Sales and production..(Units)…………....……….1,000…………..………...50 0
Direct Labour per Unit (Hrs)…(VC)…………..…0.5 Hrs…..4 Hrs…….…1 Hrs
400 hours from rank 3 divide by 4 hrs equals………………100 units production only
Step 7 work out Total Contribution from Total production Possible.
…………………………………………………......….Alpha……….Beta………Ga mma
Sales and production..(Units)…………….1,000……….100………....500
Contribution per Unit……(£)……………………£36………..£72………….£58
.
(important Note – Only use Contribution per UNIT)
.
Total Contribution………………………………£3,600……£7,200…..£29,000.= £39,800
Step 8 Workout possible maximum profit.
.
Less Fixed Cost from Total Contribution…………………………………………..£32,000
Profit……………………………………………………………………………….............… …£7,8000 
You beated me to it Visha
I guess Visha gave you a well organized hint
try it out
hope you get it !!! :thumbup1:0 
Wow! What a concise reply, thanks a million Visha. I would NEVER have worked that out myself.0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 323 NEW! Qualifications 2022
 165 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 88 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
 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