A painting company produces three types of paint (P., P. Ps). Each paint type requires a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A painting company produces three types of paint (P., P. Ps). Each paint type requires a different combination of four different chentical compositions (C₁. C₂. C₁. C₁), as shown in Table 1. The typical working hours needed to produce one cubic meter of each type is also shown in Table 1. The maximum number of working hours available to the company is 1000 hours/week. Based on market research, the company decided to production of any paint type should not exceed 75 m² per week. The cost of each working-hour is expressed as follows: Working hour cost-($ 300-2.5* production in m³) The unit cost and the maximum available supply of each chemical composition is presented in Table 2. You are asked to help the company to develop a weekly production plan so that the company can minimize the weekly expenditures. 1) Find the optimal production policy using the simplex method. 2) Check your solution using Microsoft Excel. (Print and attach your input and answer sheets) Table 1 Paint Chemical Composition Combination (in units) per m' of paint Type G C₁ P₁ 2 P₂ 1 P₁ 3 C₁ 3 Ci C₂ C₂ C₁ 2.5 3 2 3 5 2 3 0.5 Table 2 Chemical composition Cost (S/unit) Supply (units/week) 0.95 600 0.52 400 0.73 610 0.64 420 Working-hours per m' of paint 6 7 4 Page 1/2 A painting company produces three types of paint (P., P. Ps). Each paint type requires a different combination of four different chentical compositions (C₁. C₂. C₁. C₁), as shown in Table 1. The typical working hours needed to produce one cubic meter of each type is also shown in Table 1. The maximum number of working hours available to the company is 1000 hours/week. Based on market research, the company decided to production of any paint type should not exceed 75 m² per week. The cost of each working-hour is expressed as follows: Working hour cost-($ 300-2.5* production in m³) The unit cost and the maximum available supply of each chemical composition is presented in Table 2. You are asked to help the company to develop a weekly production plan so that the company can minimize the weekly expenditures. 1) Find the optimal production policy using the simplex method. 2) Check your solution using Microsoft Excel. (Print and attach your input and answer sheets) Table 1 Paint Chemical Composition Combination (in units) per m' of paint Type G C₁ P₁ 2 P₂ 1 P₁ 3 C₁ 3 Ci C₂ C₂ C₁ 2.5 3 2 3 5 2 3 0.5 Table 2 Chemical composition Cost (S/unit) Supply (units/week) 0.95 600 0.52 400 0.73 610 0.64 420 Working-hours per m' of paint 6 7 4 Page 1/2
Expert Answer:
Answer rating: 100% (QA)
Solution XI Number X 2 x 3 According XIZO X275 x 3 0 Z unit to question ... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
The Growall Fertilizer Company produces three types of fertilizerSupergro, Dynaplant, and Soilsaver. The company has the capacity to produce a maximum of 2,000 tons of fertilizer in a week. It costs...
-
A leading hardware company produces three types of computers: Pear computers, Apricot computers, and Orange computers. The relevant data are given in the file S14_91.xlsx. The equipment cost is a...
-
A photocopy machine company produces three types of laser printersthe Print Jet, the Print Desk, and the Print Prothe sale of which earn profits of $60, $90, and $73, respectively. The Print Jet...
-
Ghana Water Company Limited (GWCL) Profile Ghana Water Company Limited (GWCL) is a utility company, fully owned by the State. The company is responsible for potable water supply to all urban...
-
Estimate a GARCH(1,1) for the S&P 500 index, using data from January 1999 to December 2003.
-
[This problem is for readers who know some calculus.] Suppose that there are only two people in society, Mark and Judy, who must split a fixed amount of income of $ 300. Marks utility function is UM...
-
A conducting bar that is \(\ell=40 \mathrm{~mm}\) long can slide with negligible friction on two parallel conducting rails positioned at an incline of \(\theta=15^{\circ}\) (Figure P29.66)....
-
Melvin Patel bid for and won a concession to rent bicycles in the local park during the summer. During the month of June, Patel completed the following transactions for his bicycle rental business:...
-
a) The trial balance of Nyaguthie enterprises prepared as at 30th April, 2016 failed to balance. The difference was posted to a suspense account. On investigation, the following errors were revealed....
-
Reba Dixon is a fifth-grade school teacher who earned a salary of $38,000 in 2019. She is 45 years old and has been divorced for four years. She receives $1,200 of alimony payments each month from...
-
1. Which of the following structures is an enantiomer of molecule? CL all H (a) Br HII CI H H Br H (b) Br n H H H ||| Br CI e H CI
-
After Hurricane Matthew, more than 2,000 Florida consumers complained of price gouging to the State Attorney General. Two examples: a hotel room normally $65 a night cost $150, and a $1 bottle of...
-
After you have studied Economics in the News on pp. 148149, answer the following questions. a. If Illinois raises its minimum wage to $15 an hour, what do you expect will happen to the states...
-
Explain how a subsidy paid to soybean farmers affects the consumer surplus and the producer surplus from soybean. Does the subsidy make the soybean market more efficient or less efficient? Explain....
-
Explain the effect of the change in the minimum wage on the workers surplus, the firms surplus, and the efficiency of the market for low-skilled workers in Bulgaria and in Greece. Bulgaria has the...
-
What is the effect of the changes in the minimum wage on the quantity of labor employed in Bulgaria and in Greece? Bulgaria has the lowest minimum wage in the European Union (E.U.), but its level has...
-
Interviews can be used as a means of obtaining useful data from a participant. Which way of using an interview is the most common? A. As a supplemental option or follow-up B. As an exploratory means...
-
If |62x|>9, which of the following is a possible value of x? A. 2 B. 1 C. 0 D. 4 E. 7
-
The results we obtain with conditional probabilities can be quite counterintuitive, even paradoxical. This case is similar to one described in an article by Blyth (1972), and is usually referred to...
-
In the pension fund problem, suppose there is a fourth bond, bond 4. Its unit cost in 2010 is $1020; it returns coupons of $70 in years 2011 through 2016 and a payment of $1070 in 2017. Modify the...
-
Several major automobile producers are competing to have the largest market share for sport utility vehicles (SUVs) in the coming quarter. A professional automobile market analyst assesses that the...
-
People with higher resting pulse rates (beats per minute) tend to have higher IQ scores. For Exercises 912, determine whether the stated causal connection is valid. If the causal connection appears...
-
Several things besides smoking have been shown to be probabilistic causal factors in lung cancer. For example, exposure to asbestos and exposure to radon gas, both of which are found in many homes,...
-
Those who favor gun control often point to a positive correlation between the availability of handguns and murder rates to support their position that gun control would save lives. Does this...
Study smarter with the SolutionInn App