Question: Assignment ASSIGNMENT 4 - LP DUE USING EXCEL BY MIDNIGHT NOVEMBER 26TH MOODLE LBC Co. manufactures two different types of chairs: Indoor model and outdoor

Assignment ASSIGNMENT 4 - LP DUE USING EXCEL BY MIDNIGHT NOVEMBER 26TH MOODLE LBC Co. manufactures two different types of chairs: Indoor model and outdoor model. Each chair produced must go through three departments: carpentry, painting, and finishing. The Indoor chair spends 3 hours in Carpentry, 1.5 hours in Painting, 0.75 hours in Finishing. The outdoor chair spends 2 hours in Carpentry, 1 hours in Painting, 0.75 hours in Finishing Department capacity (hours): 360 hrs for Carpentry, 300 hrs for Painting, and 195 hrs for Finishing. Table below contains the profits per each type of chair produced. The owner would like to determine a product mix to maximize his daily revenue. Revenues Requirements: / per 1. Formulate as an LP problem. chair 1. Decision variables Indoor- $28 2. Constraints. Chair 3.Objective function. Outdoor- 2. Solve LP graphically with mentioning what is the optimal product mix. $25 Chair

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 Economics Questions!

ON EXCEL Assignment LBC Co. manufactures two different types of chairs: indoor model and outdoor model. Each chair produced must go through three departments: carpentry, painting, and finishing. The...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

can you solve the maths which are provided in doc file Question 1 Manufacturing Cost Schedule and Income Statement (10marks). This question relates to learning material and objectives from Online...

John's Custom Computer Shop (JCCS) assembles computers for both individual and corporate customers. The company is organized into two divisions: Personal and Business. Once a computer is built, it is...

please help with the questions listed if you can. More importantly I need to know how to make a full AHP analysis from this example. Ergonomies Inc. What industry would you be in if you were...

this is the questionplease help me thanksits a project about renovation one level of a building. project management case . This is a renovation project On the basis of group work as a personal...

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

I need my powerpoint draft edited to ensure all the requirement of the assignment are answered and clearly noted in this powerpoint. I have attached the current Powerepoint draft, the...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-4, Problem 4-6, and Problem 4-8, Problem 4-17, Problem 4-19, and Problem...

'1 A C D E F G H Learning Objectives 1. Understand how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c)...

Goodmonth Tyre Co. uses a standard cost system for its tyres. The company has a normal capacity of 20,000 DL hours . The costs are as follows: Standard Costs Actual Costs Direct Materials 5 kg. of...

Suppose that you wish to fabricate a uniform wire out of 1.00 g of copper. If the wire is to have a resistance R = 0.500 , and if all of the copper is to be used, what will be (a) The length and (b)...

Problem 2 : Analyze the following description and draw class diagram of University Management System. What number of classes can be used in university system and the state the relations between each...

I need help solving by excel only please. You have a $150,000.00 expense budget. In column A, you will enter expenses as they are incurred. Set up a data validation criterion that ensures that the...

The spatial rule: The closer spatial proximity we have to an event, the more importance we will attach to it.

The visual rule: If we observe an event with our own eyes, we will attach more weight to it than if someone else had described it to us.

10. What is meant by the fact that we are socialized into using linear causal thought patterns? Find two examples of this from your everyday life.