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.

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter4: Accounting For Factory Overhead
Section: Chapter Questions
Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,