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...
-
Develop and name the type of measuring instrument you would use to tap the following: a. Which brands of beer are consumed by how many individuals; b. Among the three types of exams multiple choice,...
-
Two software companies sell competing products. These products are substitutes, so that the number of units that either company sells is a decreasing function of its own price and an increasing...
-
Cumulative Poisson probabilities can be calculated using MINITAB. Output: Poisson with mean \(=1.64\) Find the cumulative Poisson probabilities for \(x=2\) and \(x=3\) when (a) \(\lambda=2.73\); (b)...
-
a. Firm D has net income of $83,700, sales of $2,790,000, and average total assets of $1,395,000. Calculate the firms margin, turnover, and ROI. b. Firm E has net income of $150,000, sales of...
-
Cherokee Incorporated is a merchandiser that provided the following information: Amount Number of units sold 1 1 , 0 0 0 Selling price per unit $ 1 6 Variable selling expense per unit $ 2 Variable...
-
Select all that apply Actual output is used for variance calculations because Blank______. Multiple select question. budgeted output although useful for planning is outdated for analyzing performance...
-
Make a Rectangle class with properties width and height. Add two prototype methods: getArea and isSquare. The getArea method should return the area of the rectangle, while the isSquare method should...
-
1: Prepare the acquisition analysis as at 1 July 20x3 for the acquisition of B Ltd by A Ltd. Show all calculations. Q2: Prepare the journal entries for these transactions in the records of A Ltd, On...
-
One of your work colleagues has approached you for help with completing a spreadsheet model that they are constructing to determine whether they should sell their existing motor vehicle to NLC and...
-
How to calculate the 5yr returns? BOND Shares National Munt Bond Schwab US TIPS Vanguard Emerg Met Bond Blackrock ESG Bond Shares 1-3 Year Treasury BOND TOTAL MUB SCHF SOMA BIAAX SHY [$117.05]]...
-
For each transaction, indicate in which journal it should be recorded. Sales Journal Cash Receipts Journal Purchases Journal Cash Payments Journal General Journal Returned products to a supplier....
-
During the month of March 2022 the company John Services, Ltd. realized the following transactions March 1, Paid a 12 month insurance policy for $36,000 March 2: Paid the employee $44,000 for their...
-
public class Class extends ClassA public classB ( ( Time left 0 0 : 1 2 : 0 3 int init = 1 0 ; super ( 4 0 ) ; O a . . The method super is not defined. b . . No values may be passed to super. O c . ....
-
If 2 5 9 - k 5 8 = 2 5 8 , what is the value of k?
-
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...
-
Companies are facing a great amount of change in every facet of their operations today. To remain competitive, companies must keep abreast of current developments in several areas. You recently got...
-
For each of the situations listed, identify the primary standard from the IMA Statement of Ethical Professional Practice that is violated (competence, confidentiality, integrity, or credibility.)...
-
Complete the following statements with one of the terms listed here. You may use a term more than once, and some terms may not be used at all. a. To quickly navigate to the end of the data in a...
Study smarter with the SolutionInn App