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 (SP-VC=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 (Covid-19)
- 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 off-topic 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