Question: please don't solve the question with excel or lingo. A paint company produces three grades of paintsinner paint, ceiling paint, and wall paint. The production

please don't solve the question with excel or lingo.

A paint company produces three grades of paintsinner paint, ceiling paint, and wall paint. The production process is run on a three shift basis. The limited resources with their requirements in each paint production and availability are shown below: Inner Paint Ceiling Paint Wall Paint Availability per Month Resource Requirement Special additive (kg/L) Processing (KL/shift) Packaging (KL/shift) 0.65 0.25 3.0 10.0 0.15 4.0 10.0 6.0 550 tonnes 90 shifts 75 shifts 10.0 There are no limitations on other resources. The demands and profits of these products are estimated as follows: Inner Paint Wall Paint Demand per month (KL) Profit ($/KL) 150 5000 Ceiling Paint 350 4000 550 3000 As per the contract signed, a minimum of 250 KL per month of wall paint must be delivered to Home Mart. If the company is unable to meet the market demand from its monthly production, it is the com- pany policy that the percentage of demand unmet must be same for all paints. Formulate an LP model for determining the monthly production plan in order to maximize the overall profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Justin Matthews is a waiter at the Duluxe Lounge. In his first weekly pay in March, he earned $300.00 for the 40 hours he worked. In addition, he reports his tips for February to his employer...

Due Sunday, 11/20: Problems from Zimmerman text: 2-11, 2-44, Case 2-3, 7-7, and 7-20 Chapter Two The Nature of Costs Chapter Outline A. Opportunity Costs 1. Characteristics of Opportunity Costs 2....

SOLVE THE QUESTION USING EXCEL SHOW THE RELEVANT FORMULAS USED AND SHOW USE OF SOLVER PLEASE Vinay Plc produces three grades of their products at the same factory: the Standard; Deluxe and Super. The...

kindly solve this paper Question 1 Sticky Wicket (SW) manufactures cricket bats using high quality wood and skilled labour using mainly traditional manual techniques. The company has two departments,...

I need help with section B, C, and D of the question below on Patrick Industries Inc 10-k. I have attached the link to the 10-k and screenshots of the full assignment....

I need someone that has excellent Microsoft skill and a general budgeting and accounting knowledge. I have attached the necessary files and the excel column turns green when the answer is right....

I am working on the Dupont Buyout Case study, I see documents uploaded by by Jameszs- I am wondering how he arrived at the answers in the tables he provided. Is there an excel spread sheet that I can...

Please help me to compute (show computation). If i want to steal share the market of BMW and other SUV vehicle, how many percent would it be? using the case study of Porsche Macan and how do you see...

Jacques has just been notified that the combined principal and interest on an amount he borrowed 19 months ago at 8.4% compounded monthly is now $2297.78. How much of this amount is principal and how...

The waves from a radio station can reach a home receiver by two different paths. One is a straight-line path from the transmitter to the home, a distance of 30.0 km. The second path is by reflection...

NOWLEDGE CHECK Joaquim recently leamed about a fund that bousted a 2 5 % return in bs marketing meterials. Engerly, he hvested $ 1 0 0 , 0 0 0 Whout doing ray research into. the fund. A year leter,...

What is an example of constructive feedback? provide reference