Assignment 1 (Individual Assignment) 25% Marks Due date: 9 July 2012 (no word limit) Case Study: Scottsville Textile Mill _________________________________________________________ This task will relate to analytical skills in solving optimisation problem (linear programming) using Excel with Solver add-in. Scottsville Textile Mill1 1 Case from Anderson‚ D.‚ Sweeney D.‚ Williams T.‚ Martin‚ K. (2010)‚ An Introduction to Management Science Quantitative
Premium Operations research Linear programming Algorithm
Julia’s Food Booth. Parts A thru C. Please provide linear programming model‚ graphical solution‚ sensitivity report‚ and answers to questions A thru C. (Problem on page 2) [pic] [pic] A) Formulate and solve a linear programming model for Julia that will help you advise her if she should lease the booth. Let‚ X1 =No of pizza slices‚ X2 =No of hot dogs‚ X3 = barbeque sandwiches Formulation: 1. Calculating Objective function co-efficients:
Premium Optimization Linear programming
Ye Department of Management Science and Engineering Stanford University Stanford‚ CA 94305‚ U.S.A. http://www.stanford.edu/˜yyye (LY‚ Chapters 2.3-2.5‚ 3.1-3.4) Yinyu Ye‚ MS&E‚ Stanford MS&E310 Lecture Note #05 2 Geometry of linear programming Consider maximize subject to x1 x1 +2x2 ≤1 x2 ≤1 ≤ 1.5 ≥ 0. +x2 x2 x1 x1 ‚ Yinyu Ye‚ MS&E‚ Stanford MS&E310 Lecture Note #05 3 LP Geometry depicted in two variable space If the direction of c is contained by the norm
Premium Optimization Linear programming Mathematical optimization
MERTON TRUCK COMPANY Sol 1 : Given : Selling Price od Model 101 truck : 39000 Selling Price of Model 102 truck : 38000 We know‚ Contribution C = SP – VC VC for Model 101 : Direct Material + Direct Labor + Variable Overhead : 24000 + 4000 + 8000 = $36000 VC for Model 102: Direct Material + Direct Labor + Variable Overhead : 20000+ 4500+8500 = $33000 Let no of Model 101 produced be X Let no of Model 102 produced be Y Z= (39000-36000)X + (38000=33000)Y Z=3000X + 5000Y
Premium Optimization Linear programming 5th millennium
Application of linear functions in Economics (or) Application of straight lines in Economics The linear function is one in which ‘y’ is the first degree expression in ‘x’‚ i.e.‚ y = ax + b. The graph of this function is a straight line. The co-efficient of x represents the slope of the line. If a > 0‚ then the lines are upward sloping‚ and if a < 0‚ then the lines are downward sloping Let us explain certain linear equations used in Economics and business. 1. Linear cost curves
Premium Supply and demand
CONFIDENTIAL CS/SEPT 2014/QMT339 UNIVERSITI TEKNOLOGI MARA FINAL LAB TEST COURSE : SPREADSHEET MODELING AND DECISION ANALYSIS COURSE CODE : QMT339 EXAMINATION : SEPTEMBER 2014 TIME : 3 HOURS NAME : ____________________________________________________________ GROUP : ____________________ STUDENT ID LECTURER : ____________________________________________________________ : _________________________ INSTRUCTIONS TO CANDIDATES 1. 2. This question paper consists of two part: PART
Premium Decision tree Linear programming Decision theory
Section two — facility location Competitive imperatives impacting on location decision Location decision and location factors Service versus industrial locations Location methods for industrial and service companies Factor rating methods Linear programming Transportation method Further explorations on transportation method Centroid method (Centre of gravity method) 7 7 7 10 10 11 13 16 22 23 Section three — operations facility strategies Basic types of layout for manufacturing Some layout
Premium Decision making Costs Decision tree
REPORT ON RED BRAND CANNERS – CASE STUDY Introduction: Red Brand Canners is a medium sized company that cans and distributes a variety of fruit and vegetable products under private brands in the western states. The company makes three different tomato products including whole tomatoes‚ tomato juice and tomato paste. They also distribute Choice peach halves‚ peach nectarine and cooking apple products. As part of their discussion over the amount of tomato products to pack in a particular
Premium Tomato Optimization Profit
purchase more sandwiches. After she pays any funds back that she has borrowed then she will earn a profit of at least $69.20 which is half of the $138.40 borrowed. C) Evaluate the prospect of paying a friend $100/game to assist. The linear programming results show that Julie will have a profit of $2250 minus the $1000 for booth rent for the month which will leave $1150. She only wants to make a profit of $1000 therefore she has at least $150 to keep $50 to purchase more sandwiches and $100
Premium English-language films Sociology American films
the profit function? d. Compute the profit (loss) corresponding to production levels of 12‚ 000 and 20‚ 000 units. QUESTION 3 Solve the following quadratic equations: i. ii. f ( x) x 2 4 x 4 f ( x) 3 x 2 4 x 2 QUESTION 4 a. For the linear program Max 2x + 3y Subject to x + 2y ≤ 6 5x + 3y ≤ 15 x‚ y ≥ 0 Find the optimal solution using the graphical solution procedure. What is the value of the objective function at the optimal solution? b. As part of a quality improvement initiative‚
Premium Optimization Linear programming Operations research