# Instead of producing the product mix in part (b), management wishes to use linear programming to find the profit-maximising mix. Write an LP model, and then use Excel’s Solver to determine the optimum weekly mix and the resulting weekly profit before t

01 / 10 / 2021 Assignment

This paper circulates around the core theme of Instead of producing the product mix in part (b), management wishes to use linear programming to find the profit-maximising mix. Write an LP model, and then use Excel’s Solver to determine the optimum weekly mix and the resulting weekly profit before t together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.

Ace Electronics can produce four potential products: MP3 Players, CD Players, Digital Radios and DVD players. There are three major inputs for all products: electronic components, other components and assembly time.

Electronic components cost \$14 each, other components \$10 each and assembly time \$20 per hour. Consumption of theses inputs per unit of product together with total available monthly supply of components are shown below:

MP3 Player CD Player Digital Radio DVD Player Available
Electronic components 3 4 4 3 4,700
Other components 2 2 4 3 4,500
Assembly hours 1 1 3 2 2,500

Selling prices of the products are:

Product Selling Price
MP3 Players \$140
CD Players \$160
DVD Players \$220

Fixed costs per month amount to \$12,000.

(a) Calculate the contribution margin for each product. (2 marks)

(b) If management wishes to produce and sell Mp3s, Cds, Digital Radios and DVDs in the ratio 4:3:2:1, how many units of each should management plan to produce and sell in a month to earn a profit before tax of \$70,000? (3 marks)

(c) Instead of producing the product mix in part (b), management wishes to use linear programming to find the profit-maximising mix. Write an LP model, and then use Excel’s Solver to determine the optimum weekly mix and the resulting weekly profit before tax. (5 marks)

(d) Competitive pressures will probably force management to reduce the price for DVD players. What is the maximum price reduction that can be sustained such that the optimum mix calculated in part (c) remains optimum? (2 marks)

(e) What is the shadow price for Electronic Components? Explain to management how they might use this to increase profits? Calculate the upper limit for which this shadow price is valid. What happens when the upper limit is breached? (3 marks)

(f) Explain why linear programming is referred to as a resource allocation technique? Give examples of three different types of problems that can be solved via linear programming. (5 marks)

International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

Company # 11483120

## Benefits You Get

• Free Turnitin Report
• Unlimited Revisions
• Installment Plan
• Plagiarism Free Guarantee
• 100% Confidentiality
• 100% Satisfaction Guarantee
• 100% Money-Back Guarantee
• On-Time Delivery Guarantee

+44 7340 9595 39
+44 20 3239 6980
[email protected]
AKOSZTEC “International House, 12 Constance Street, London, United Kingdom, E16 2DQ”

Hire Researcher
Rated 4.7/5 based on 8956 Reviews

## Supporting Pages

FLAT 25% OFF ON EVERY ORDER. Use "FLAT25" as your promo code during checkout