Simple Linear Programming and Optimisation

Assignment Help Case Study
Reference no: EM133043651

PDE4905 Engineering Simulation - Middlesex University London

Problem 1 Simple Linear Programming and Optimisation

A small factory has two products (A and B). In order to keep the factory running, at least 20+k units of products must be produced each day where k is the largest digit of your student number. Product A costs $200 to produce, while Product B costs $100 to produce. The total costs must be less than $8000 as the budget each day. In addition, the market regulations require that the number of Product B cannot exceed twice the number of Product A, but must be at least more than half the number of Product A.

If each Product A gives a profit of $40 and each Product B gives a profit of $60, design a simple daily production portfolio (in terms of the numbers of Products A and B to be produced) so that the total profit is maximized.

- Write this problem as a simple linear programming problem with the objective and all appropriate constraints.
- Find its optimal solution by solving it using two different methods (e.g., graphical method and Excel Solver/Matlab).

Problem 2 Transportation/Resource Allocation

A product has 4 suppliers (A, B, C, D) that produce a total of 1500 units. All the units produced should be distributed to 6 demand stations/customers (P, Q, R, S, T, W). The transportation costs for transporting one unit from a supplier to a station are given in the following table:

 

P

150

Q

440

R

215

S

230

T

225

W

240

Supplier A

S1=300

2

2

5

4

1

2

Supplier B

S2=500

4

5

2

3

7

1

Supplier C

S3=450

a

b

c

d

e

f

Supplier D

S4=250

f

e

d

c

b

a

Thus, its transportation cost matrix is simply

1091_Matrix.jpg

where a, b, c, d, e, and f are the single digits of your student number in the format "M00abcdef". For example, if your number is M00152379, you have a=1, b=5, c=2, d=3, e=7 and f=9.

Let xij be the integer quantities to be distributed from Suppliers (Si=A,B,C,D) to Demand stations (Dj=P,Q,...,W). The objective is to distribute the product such that

Minimize ∑i=14j=16 cij xij,

subject to various constraints.

• Write down the mathematical formulation for this problem with the objective and all relevant constraints and discuss their meaning briefly.
• Solve the problem using either Excel Solver or Matlab/Octave to find its optimal solution. Check if the solution can indeed satisfy all the constraints.

Problem 3 Supermarket Staff Scheduling

A busy supermarket is open 24 hours daily. It has a set of 20 checkout counters, though the actual number of checkouts needed ranges from 2 to 20, depending on the time of day. The number of staff needed to provide a satisfactory service varies at different hours as summarized in the following Table:

Time Periods

Number of counters/staff needed

9:00 am - 10:00 am

10:00 am - 1:00 pm

1:00 pm - 3:00 pm

3:00 pm - 6:00 pm

6:00 pm - 9:00 pm

9:00 pm - 3:00 am

3:00 am - 9:00 am

12

10

16

14

20

5

4

The supermarket employs 10 full-time staff and a large number of part-time staff. Part-time staff typically can work a 6-hour shift every day and can start on the hour between 9:00 am to 1:00 pm, or at 3:00 pm, 6:00 pm, 9:00 pm or 3:00 am.

Full-time staff work at most 40 hours per week between 9:00 am to 5:00 pm with a daily wage of £90 for 8 hours per day, while part-time workers are paid at a standard rate of £8 per hour (i.e., £48 per day for 6 hours). The company policy only permits that up to 80% of the total working hours of any day to be part-time hours.

The main Problem is to schedule the staff so that the total staff costs are minimized on a daily basis.

• Formulate the scheduling problem in terms of a linear programming problem with a correct objective and all appropriate constraints. Explain in detail why your mathematical formulation is appropriate, including any assumptions that you may have used.
• Solve your staff scheduling problem using either Excel Solver or Matlab (intlinprog)/Octave (glpk). Summarize your solution procedure (including screenshots if appropriate) and present the main results with a brief discussion.
• Check if all the required numbers of counters are met.

Problem 4

For this part, you can either choose the LP (Option 4A) or Simulink (Option 4B). You only need to choose one, no additional marks if you choose to do both.

Option 4A: Manufacturing Portfolio

A garden furniture company has 4 products: garden tables, garden chairs, garden benches, and parasols. A garden table takes 8 hours to produce with the material cost of £60. A garden chair takes 6 hours to make with the material cost of £20. A garden bench takes 4 hours to make with the material cost of £25. A parasol takes 2 hours to make with the material cost of £10. Each week, there are 800 hours available with a weekly budget of £3000 for material costs. To make maintain diversity of the products, the company will produce at least 5 units for each product.

A garden table typically comes with 4 chairs, whereas a bench may also have 4 chairs. Thus, the number of chairs should be at least 4 times the total number of tables and benches. Some customers may also wish to buy a parasol if they buy a table. Thus, the number of parasols should not exceed the number of tables.

The profits per unit are £260, £140, £60, and £50 for tables, benches, parasols, and chairs, respectively. The main objective is to organize the production portfolio so as to maximize the profit of the company on a weekly basis.

a) Formulate this problem as an LP with the objective and all the appropriate constraints.
b) Solve the LP and find the maximum profit and discuss your result.
c) The company seems to do well, so it decides to hire more people (thus more available hours) with the same material cost budget. If the number of available hours is now 1000, will it affect the production portfolio? Should the company recruit more people? Discuss and explain.
d) Another strategy is to increase the budget for raw materials to £5000 per week with the available hours unchanged. Will this strategy increase the profit? Discuss your findings.
e) The company later realizes that the garden benches do not sell well, so it may consider not to produce any benches at all. Will this potential change increase or decrease the profit (assuming that the other conditions remain the same)? Discuss and explain briefly.

Option 4B: Simulink Simulation

Check the Simulink model for a simple electric motor that you have built in class.

677_Matrix1.jpg

This model used the trident motor parameters with two different sets of parameters (please choose one):

Voltage

Rotor Inductance

Resistance

Rotor moment of Inertia

Viscous friction

Torque constant

Back-emf constant

Volts (V)

Henri (H)

Ohm (Ω)

(Kgm2)

(Nms)

(Nm/A)

(V/s)

V

L

R

J

f

Kt

Kb

6

0.35*10-3

8.1

1.0*10-8

2.6*10-7

6.6*10-3

6.4*10-3

12

0.1*10-3

29.3

2.9*10-8

2.6*10-7

6.6*10-3

1.2*10-2

Extend and/or reformulate the model to carry out the following scenarios:

• Use a single second-order transfer function

H(s) = Kt/((Ls + R)(Js + f)) = Kt/(LJs2 + (Lf + Rj)s + Rf)

to simulate the motor to see if you can obtain the same result using the same parameters.

2079_Matrix2.jpg

• By applying the voltage of Vnom=5 volts, a robotic arm attached to the motor should rotate θ = 100°, however, at t* = 5 seconds, the robotic arm is disturbed by a vibration that that takes the form

a(t) = θ0 u(t - t*)e-(t - t*)cos(Π(t - t*)) ,   θ0 = -40°,

where u(t) is a Heaviside step function. This disturbance (also called perturbation) causes the robotic arm to bounce back 40 degrees at t* = 5. Implement this perturbed model in your Simulink model and display your results to show the perturbation.

Report and Guidelines

Write a report and explain your understanding of linear programming, Simulink and their applications with the following tasks:
1. Complete Problem 1
2. Complete Problem 2
3. Complete Problem 4
4. Complete Problem 4
Show your results with screenshots and/outputs when appropriate.

The report should include your models/formulations and the main results on a series of tasks. Your mathematical formulations and programs should be clearly presented, and an evaluation of your solutions can be discussed in the light of all assumptions made and if your solutions can indeed satisfy all the constraints.

Your report must be in the form of a standard technical report or article to include:

Title page: The first page with the title of your assignment, your full name and student number.

Abstract: About 100 words, no more than 150 words.

Introduction: Include a brief review of the background and literature, and explanations of linear programming, transport/resources allocation problems, etc., citing relevant references when appropriate.
Methods: Describe your modelling technique, the structure of your model or implementations. Justify your approaches to formulating the model and cite relevant references when appropriate.
Results: Present your main results and explain them in detail. Use graphs and/or tables when appropriate.

Discussion: Discuss your mathematical formulations, solutions to your problems/tasks and their implications for real-world systems, such as the staff scheduling for a large airline or a factory in real time.

Conclusions: Draw brief conclusions and evaluate any possible limitations.

Attachment:- Engineering Simulation.rar

Reference no: EM133043651

Questions Cloud

Basic scientific properties of personnel selection methods : What are the basic scientific properties of personnel selection methods, including reliability, validity, and generalizability?
Determining the educational requirements : There is no standard educational requirement for becoming an officer in the fire department.
Would your firm be better off starting the project : Your firm is considering a project with a discount rate of 9%. ould your firm be better off starting the project now or waiting to start the project in a year
Queen university leadership program : The cost for the 5-day program is $9900. Identify what you think this cost includes. If an employer was paying this fee for a manager, what benefits might they
Simple Linear Programming and Optimisation : Simple Linear Programming and Optimisation - Write this problem as a simple linear programming problem with the objective and all appropriate constraints
Assignment on cognitive ability testing : What are the limitations of cognitive ability testing? Do these limitations outweigh the advantages of selecting employees based on cognitive ability?
What is the default risk premium on the corporate bond : If the liquidity premium for Gator Corporation is 1 percent, what is the default risk premium on the corporate bond
Describe a time when you were involved in a team activity : Describe a time when you were involved in a team activity. What was the activity, was it effective, and what was the purpose?
How do employees in innovatively managed companies : How do employees in innovatively managed companies explain how differences in leader's approach to innovation influence their productivity?

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

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