Princetown paints ltd manufactures three basic types of paint. emulsion, gloss, and undercoat. using the same mixing

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Princetown paints ltd manufactures three basic types of paint. emulsion, gloss, and undercoat. using the same mixing machines and direct labour for each of the three products. the Management accountant of Princetown paints was faced with the task of arranging the weekly production for his company. information about the sale price and costs per 100 liters is given in the following table ( all figures in $). sales price per 100 liters ( emulsion 120), ( gloss 126), ( undercoat 110). variable cost per 100 liters ( emulsion 120), ( gloss 126), ( undercoat 110). direct material costs ( emulsion 11), ( gloss 25), ( undercoat 20). direct labour costs ( emulsion 30), ( gloss 36), ( undercoat 24). mixing costs ( emulsion 32), ( gloss 20), ( undercoat 36). other variable costs ( emulsion 12), ( gloss 15), ( undercoat 10). the cost of direct labour is $3 per hour and the variable cost of mixing is $4 per hour. in any one week, direct labour hours are restricted to 8000 hours and mixing machine hours are restricted to 5900 hours. due to contractual arrangements the company must produce exactly 25,000 liters of undercoat each week. there is a maximum weekly demand for emulsion paint of 35,000 litres and for gloss paint of 29,000 liters. (a) formulate the linear programming problem to determine the weekly production levels for emulsion and gloss paint that maximize contribution to profit. (b) solve the problem graphically. state the optimum weekly production levels and the corresponding contribution to profit. (c) calculate by how much the sales price of emulsion paint must change from its current level before the optimal solution will change. (d) suppose that the labour force is prepared to work overtime at a premium of $1 per overtime hour worked. would it be profitable to work overtime? if so , how many hours would you recommend should be worked, and what would be the extra profit from these hours?
QUESTION ONE
Princetown Paints Ltd manufactures three basic types of paint-emulsion, gloss and undercoat-us-
ing the same mixing machines and direct labour for each of the three products. The management
accountant of Princetown Paints was faced with the task of arranging the weekly production for his
company. Information about the sales price and costs per 100 litres is given in the following table (all
figures in £).
Sales price (per 100 litres)
Variable costs (per 100 litres):
Direct material costs
Direct labour costs
Mixing costs
Other variable costs
Emulsion
120
11
30
32
12
Gloss
126
25
36
20
15
Undercoat
110
20
24
36
10
The cost of direct labour is £3 per hour and the variable cost of mixing is £4 per hour. In any one
week, direct labour hours are restricted to 8000 hours and mixing machine hours are restricted to
5900 hours.
Due to contractual arrangements the company must produce exactly 25,000 litres of undercoat
each week. There is a maximum weekly demand for emulsion paint of 35,000 litres and for gloss paint
of 29,000 litres.
Required:
Formulate the linear programming problem to determine the weekly production levels for
emulsion and gloss paint that maximise contribution to profit.
Solve the problem graphically. State the optimum weekly production levels and the correspond-
ing contribution to profit.
(C) Calculate by how much the sales price of emulsion paint must change from its current level
before the optimal solution will change.
Suppose that the labour force is prepared to work overtime at a premium of £l per overtime
hour worked. Would it be profitable to work overtime? If so, how many hours would you
recommend should be worked, and what would be the extra profit from these hours?
Transcribed Image Text:QUESTION ONE Princetown Paints Ltd manufactures three basic types of paint-emulsion, gloss and undercoat-us- ing the same mixing machines and direct labour for each of the three products. The management accountant of Princetown Paints was faced with the task of arranging the weekly production for his company. Information about the sales price and costs per 100 litres is given in the following table (all figures in £). Sales price (per 100 litres) Variable costs (per 100 litres): Direct material costs Direct labour costs Mixing costs Other variable costs Emulsion 120 11 30 32 12 Gloss 126 25 36 20 15 Undercoat 110 20 24 36 10 The cost of direct labour is £3 per hour and the variable cost of mixing is £4 per hour. In any one week, direct labour hours are restricted to 8000 hours and mixing machine hours are restricted to 5900 hours. Due to contractual arrangements the company must produce exactly 25,000 litres of undercoat each week. There is a maximum weekly demand for emulsion paint of 35,000 litres and for gloss paint of 29,000 litres. Required: Formulate the linear programming problem to determine the weekly production levels for emulsion and gloss paint that maximise contribution to profit. Solve the problem graphically. State the optimum weekly production levels and the correspond- ing contribution to profit. (C) Calculate by how much the sales price of emulsion paint must change from its current level before the optimal solution will change. Suppose that the labour force is prepared to work overtime at a premium of £l per overtime hour worked. Would it be profitable to work overtime? If so, how many hours would you recommend should be worked, and what would be the extra profit from these hours?
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.