Gemini plc manufactures four products using the same machinery. The following details relate to its products:      ProductA £ per unit ProductB £ per unit ProductC £ per unit ProductD £ per unit Selling price 28 34 45 46 Direct material 6 7 9 7 Direct labour 5 5 10 10 Variable overhead 3 3 6 6 Fixed overhead * 8 8 16 16 Profit 6 11 4 7 Labour hours 1 1 2 2 Machine hours 4 3 4 5   Units Units Units Units Maximum demand per week 200 180 250 100 *Absorbed based on budgeted labour hours of 1000 per week. There is a maximum of 2000 machine hours available per week. A) Determine the production plan which will maximize the weekly profit of Gemini plc and prepare a profit statement showing the profit your plan will yield.  - ANSWERED, SEE ATTACHED IMAGE Please see the findings of A) as an attachement. Please respond to part B) B) The marketing director of Gemini plc is concerned at the company’s inability to meet the quantity demanded by its customers. One consideration to overcome this is to increase the number of hours worked using the existing machinery by working overtime. Such overtime would be paid at a premium of 50% above normal labour rates, and variable overhead costs would be expected to increase in proportion to labour costs. Requirement: Critically evaluate this strategy and state your findings (quantitative and qualitative) as to the expected increase in contribution (if any) and discuss any issues (in particular in regard to overtime working) that could arise and would need to be resolved.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

Gemini plc manufactures four products using the same machinery. The following details relate to its products:
  

 

ProductA

£ per unit

ProductB

£ per unit

ProductC

£ per unit

ProductD

£ per unit

Selling price

28

34 45 46

Direct material

6 7 9 7

Direct labour

5 5 10 10

Variable overhead

3 3 6 6

Fixed overhead *

8 8 16 16

Profit

6 11 4 7

Labour hours

1 1 2 2

Machine hours

4 3 4 5
  Units Units Units Units

Maximum demand per week

200 180 250 100

*Absorbed based on budgeted labour hours of 1000 per week.

There is a maximum of 2000 machine hours available per week.

A) Determine the production plan which will maximize the weekly profit of Gemini plc and
prepare a profit statement showing the profit your plan will yield.  - ANSWERED, SEE ATTACHED IMAGE

Please see the findings of A) as an attachement. Please respond to part B)

B) The marketing director of Gemini plc is concerned at the company’s inability to meet the
quantity demanded by its customers. One consideration to overcome this is to increase the
number of hours worked using the existing machinery by working overtime. Such overtime
would be paid at a premium of 50% above normal labour rates, and variable overhead costs
would be expected to increase in proportion to labour costs.

Requirement:

Critically evaluate this strategy and state your findings (quantitative and qualitative) as to
the expected increase in contribution (if any) and discuss any issues (in particular in regard
to overtime working) that could arise and would need to be resolved. 

SOLUTION FOR GEMINI PLC MANUFACTURES
CALCULATION OF PROFITABILITY OF EACH PRODUCT
Particulars
A
B
Sale price
Less :- Variable cost
Direct material
Direct labor
Variable overhead
Contribution per unit (Sale - Variable cost)(a)
Machine hours used (b)
Contribution per machine hour (a/b)
Ranking
28.00
34.00
45.00
46.00
6.00
7.00
9.00
7.00
5.00
5.00
10.00
10.00
3.00
3.00
6.00
6.00
14.00
19.00
20.00
23.00
4.00
3.00
4.00
5.00
3.50
6.33
5.00
4.60
| 4th
1st
| 2nd
Зrd
First B product will be produced.
Machine hour used in B product = 180*3 = 540
Machine hours left = 2000 - 540 = 1,460
Secondly C produced will be produced
Machine hours used in C product = 250*4 = 1,000
Machine hours left = 1460 - 1000 = 460
Thirdly D product will be produced.
Number of units of D product = 460/5 = 92 units
Product A will not be produced at all.
Production plan that will maximise the profit will be :-
A = NIL
B = 180 UNITS
C= 250 UNITS
D = 92 UNITS
CALCULATION OF MAXIMUM PROFITS
Contribution From Product A (0*14)
Contribution From Product B (180*19)
3,420.00
Contribution From Product C (250*20)
Contribution From Product D (92*23)
5,000.00
2,116.00
Total contribution
10,536.00
Fixed overhead (8*1000)
Net profit (10536-8000)
-8,000.00
2,536.00
Transcribed Image Text:SOLUTION FOR GEMINI PLC MANUFACTURES CALCULATION OF PROFITABILITY OF EACH PRODUCT Particulars A B Sale price Less :- Variable cost Direct material Direct labor Variable overhead Contribution per unit (Sale - Variable cost)(a) Machine hours used (b) Contribution per machine hour (a/b) Ranking 28.00 34.00 45.00 46.00 6.00 7.00 9.00 7.00 5.00 5.00 10.00 10.00 3.00 3.00 6.00 6.00 14.00 19.00 20.00 23.00 4.00 3.00 4.00 5.00 3.50 6.33 5.00 4.60 | 4th 1st | 2nd Зrd First B product will be produced. Machine hour used in B product = 180*3 = 540 Machine hours left = 2000 - 540 = 1,460 Secondly C produced will be produced Machine hours used in C product = 250*4 = 1,000 Machine hours left = 1460 - 1000 = 460 Thirdly D product will be produced. Number of units of D product = 460/5 = 92 units Product A will not be produced at all. Production plan that will maximise the profit will be :- A = NIL B = 180 UNITS C= 250 UNITS D = 92 UNITS CALCULATION OF MAXIMUM PROFITS Contribution From Product A (0*14) Contribution From Product B (180*19) 3,420.00 Contribution From Product C (250*20) Contribution From Product D (92*23) 5,000.00 2,116.00 Total contribution 10,536.00 Fixed overhead (8*1000) Net profit (10536-8000) -8,000.00 2,536.00
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education