Draw a graph of the system

Assignment Help Project Management
Reference no: EM13512999

Linear Programming

SM Furniture Ltd manufacturestwo models of display cabinets, Basic(X) and Superior (Y). On a weekly basis the firm must produce at least 2 of each type, but not more than 5 Basic or more than 6 Superior. It takes 4 hours to produce the Basic model and 5 hours for the Superior model in a 40 hour working week. At least 12 workers are needed with 2 working on the Basic model and 3 on the Superior model at any one time.

Tasks

Part 1

1. Represent the above information as a system of inequalities.

2. Draw a graph of the system and indicate the feasible region clearly.

3. If the profit (P) on the Basic model is £800 and on the Superior model is £1000, write down the objective function in the form P = ax + by

4. Enter the relevant information into an Excel spreadsheet paying particular information to the layout of the sheet. It is important that this must be readable

5. Determine the number of each type that must be produced each week to make a maximum profit. Determine the maximum profit.

Part 2

1. Critically reflect on the use of Excel to provide a solution to this problem detailing any issues in either formulating the problem or determining the solution.

2. Critique the model which you have used in solving this using Excel. In particular comment on the setting used in setting up Solver.

3. Investigate the use of other software in solving linear programming problems in general.

Reference no: EM13512999

Questions Cloud

Compute the return on investment for each division : Assume that each division is provided with an investment opportunity that could produce 20 percent return on investment. Which divisions would accept or reject it?
Culminated in the theory of cultural materialism : A very influential anthropologist, Marvin Harris, focused his research on trying to understand why societies responded to issues the way they did. His work culminated in the theory of cultural materialism,
Explain the reaction of the appropriate strong acid : Write a balanced chemical equation showing the formation of the salt, Na3PO4, from the reaction of the appropriate strong acid and strong base, and name each compound in the equation.
Find the force on an electron passing between the plates : The metal plates of a TV tube are parallel and 12 mm apart. The potential difference between them is 12 kV. Find the force on an electron passing between the plates
Draw a graph of the system : Draw a graph of the system and indicate the feasible region clearly - Critically reflect on the use of Excel to provide a solution to this problem detailing any issues in either formulating the problem or determining the solution.
Which is the more successful division in terms of koi : Using 16 percent as the minimum required rate of return, compute the residual income for each division. Which division is more successful under this rate?
Explain the size of hydrocarbon molecules : Give a theoretical explanation for the difference between the boiling point of propane and wax. Describe and explain the relationship between the size of hydrocarbon molecules and their boiling point
How much total work is done on the box in moving : Dirk pushes on a packing box with a horizontal force of 52.0 N as he slides it along the floor. How much total work is done on the box in moving it 3.20 m along the floor
Conversation analysis is a methodological approach : Conversation Analysis is a methodological approach that considers talk-in-interaction only, without resorting to contextualization, interviews or any ethnographic methods.

Reviews

Write a Review

 

Project Management Questions & Answers

  Bratland j 2010 capital concepts as insights into the

bratland j. 2010 capital concepts as insights into the maintenance and neglect of infrastructure independent review 15

  What are the different types or varieties of terminating a

what are the different types or varieties of terminating a project? explain when each type of project termination

  Describe the business problem

Describe the business problem and parties involved in conducting the research, and find the methods used to conduct the research project.

  Forecasts are more accurate using the concept of mad

Forecast registration for the last six weeks (5-10) using a two-week and a four-week moving average. Which forecasts are more accurate using the concept of MAD?

  Evaluate the operating cash flow for a projectkurts

evaluate the operating cash flow for a projectkurts kabinets is looking at a project that will require 80000 in fixed

  Final project part vi want to discuss senior managements

final project part vi want to discuss senior managements ability to communicate with its employees.1. is the internet

  System for project management purposes

Show and describe the need for an integrated information system for project management purposes

  A project can be closed for several reasons.

A project can be closed for several reasons.

  Calculate annual project free cash flow

Evaluate the project's annual project free cash flow for each of the next five years

  Analyzing firm-s commitment to quality

You are to choose a publicly-traded company and analyze the firm's commitment to quality, based upon the principles learned in this course.

  Affect the project''s ability to succeed

Cultural barriers to projects' success - What cultural barriers may adversely affect the project's ability to succeed?

  Asked of the executive director of research and development

Develop a list of 10 questions that will be asked of the executive director of research and development and the executive director of Sales in a joint interview.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd