1. The Stratton Company produces two basic types of plastic pipe. Three resources are crucial to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. The Stratton Company produces two basic types of plastic pipe. Three resources are crucial to the output of pipe: extrusion hours, packaging hours, and a special additive to the plastic raw material. The following data represent next week's situation. All data are expressed in units of 100 feet of pipe. Resource Extrusion Packaging Additive Type 4 br 2 hr 21b Product 1 Type 2 6 hr 2 br 1 lb $6 per unit Dark sold $5 per unit Light sold. Resource Availability 48 hr 18 hr 16 lb The contribution to profits and overhead per 100 feet of pipe is $34 for type 1 and $40 for type 2. Formulate a linear programming model to determine how much of each type of pipe should be produced to maximize contribution to profits and to overhead. Please submit your excel file with solver output. Please follow the Linear Programming material pages 10 to 13. 2. Consider a chocolate manufacturing company which produces only two types of chocolate - Dark and Light. Both the chocolates require Milk and Choco only. To manufacture each unit of Dark and Light, following quantities are required: • Each unit of Dark requires 1 unit of Milk and 3 units of Choco • Each unit of Light requires 1 unit of Milk and 2 units of Choco The company kitchen has a total of 5 units of Milk and 12 units of Choco. On each sale, the company makes a profit of Now, the company wishes to maximize its profit. Formulate a linear programming model to determine how many units of Dark and Light should it produce respectively. 3. The Attaran Corporation manufactures two electrical products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. Product Air Cond. Heater Wiring (hours) 3 2 Drilling (hours) 2 1 Each air conditioner sold yields a profit of $25. Each heater assembled may be sold for a $15 profit. Please define the decision variables, the objective function, and formulate the constraints. Next, please formulate the LP model and solve for the optimal values of the decision variables and the maximum profit on Excel Solver. 1. The Stratton Company produces two basic types of plastic pipe. Three resources are crucial to the output of pipe: extrusion hours, packaging hours, and a special additive to the plastic raw material. The following data represent next week's situation. All data are expressed in units of 100 feet of pipe. Resource Extrusion Packaging Additive Type 4 br 2 hr 21b Product 1 Type 2 6 hr 2 br 1 lb $6 per unit Dark sold $5 per unit Light sold. Resource Availability 48 hr 18 hr 16 lb The contribution to profits and overhead per 100 feet of pipe is $34 for type 1 and $40 for type 2. Formulate a linear programming model to determine how much of each type of pipe should be produced to maximize contribution to profits and to overhead. Please submit your excel file with solver output. Please follow the Linear Programming material pages 10 to 13. 2. Consider a chocolate manufacturing company which produces only two types of chocolate - Dark and Light. Both the chocolates require Milk and Choco only. To manufacture each unit of Dark and Light, following quantities are required: • Each unit of Dark requires 1 unit of Milk and 3 units of Choco • Each unit of Light requires 1 unit of Milk and 2 units of Choco The company kitchen has a total of 5 units of Milk and 12 units of Choco. On each sale, the company makes a profit of Now, the company wishes to maximize its profit. Formulate a linear programming model to determine how many units of Dark and Light should it produce respectively. 3. The Attaran Corporation manufactures two electrical products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. Product Air Cond. Heater Wiring (hours) 3 2 Drilling (hours) 2 1 Each air conditioner sold yields a profit of $25. Each heater assembled may be sold for a $15 profit. Please define the decision variables, the objective function, and formulate the constraints. Next, please formulate the LP model and solve for the optimal values of the decision variables and the maximum profit on Excel Solver.
Expert Answer:
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133428704
15th edition
Authors: Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan
Posted Date:
Students also viewed these general management questions
-
What outcomes might the PCBU need to communicate to workers?
-
We will be working with a company called Global Bike Inc., (GBI). Information regarding GBI follows. Company History Global Bike Inc. has a pragmatic design philosophy that comes from its deep roots...
-
Transactions related to revenue and cash receipts completed by Acheville Architects Co. during the period September 2-30, 2014, are as follows: Sept. 2. Issued Invoice No. 793 to Nickle Co., $5,200....
-
Which would run slower: a clock at the center of a rotating space habitat or one at the edge? Or would there be no difference?
-
XYZ Company buys in lots of 500 boxes which is a 3 months supply. The cost per box is Rs 125 and the ordering cost is Rs 150. The inventory carrying cost is estimated at 20% of unit value. What is...
-
A six-cylinder, four-stroke petrol engine develops \(40 \mathrm{~kW}\) when running at \(3000 \mathrm{rpm}\). The volumetric efficiency at NTP is \(85 \%\). Indicated thermal efficiency is \(25 \%\)....
-
Sandy's Cabinet Company uses MRP to schedule its production. Due to the current recession and the need to cut costs, Sandy has targeted the inventory investment area for cost reduction. However, the...
-
Compute the missing amount in the accounting equation for each entity from the financial information presented: Assets Liabilities Equity Your Basket $ ? $ 28,000 46,000 Flowers and Gifts 85,000 ?...
-
Territory and Product Profitability Analysis Pipeline Surfboards Inc. manufactures and sells two styles of surfboards, Atlantic Wave and Pacific Pounder. These surfboards are sold in two regions,...
-
Choose all the correct answers: When atoms share electrons equally they form non-polar covalent bonds. When one atom transfers its electron to another atom, ionic bonds form. Atoms share protons to...
-
A local toolmaker makes the best hammers on the market. The head of the hammer costs $ 32 . 1 1 and the handle costs $ 4 . 3 7 . It takes 1 . 4 minutes to assemble the hammer and the hourly cost is $...
-
Break down what this code means in sections. import java.io. ; import java.util. ; public class ReadFile{ public static void main(String[] args) throws NoSuchElementException { try { File myObj =...
-
Absent convincing evidence that the bureaucracy has ignored legislative intent in writing a rule or set of rules that "fills in the blanks" of a statute (law) that Congress has created, the courts...
-
Your IT department currently rents a server for $10000 per year including all maintenance expenses. It is considering purchasing a more advanced server instead and comparing the two options. The new...
-
What are the precedents (research) about the Fed's bailout? Include two links to research related to when the Fed has invoked emergency powers.
-
Why Christianity is Superior to Other Religious Traditions?
-
A bar of a steel alloy that exhibits the stress-strain behavior shown in Figure 6.22 is subjected to a tensile load; the specimen is 375 mm (14.8 in.) long and has a square cross section 5.5 mm (0.22...
-
Explain why unit costs must often be interpreted with caution.
-
What is the key difference between a static budget and a flexible budget?
-
Outline the steps in preparing an operating budget.
-
What are the different methods of conducting marketing research?
-
What is the main difference between a full-service and a limited-service supplier?
-
What are some of the issues that should be considered when conducting marketing research?
Study smarter with the SolutionInn App