MERTON TRUCKS COMPANY Keeping 3000$ and 5000$ as unit contributions respectively for Model 101 and Model 102 trucks‚ formulate the Merton’s product mix decision problem using LP. Present the LP problem in the standard form including all the details and units. Using solver‚ find the optimal product mix of these two trucks? What is the optimum total contribution that Merton can obtain? Tabulate‚ the optimality range for the decision variable coefficients and comment what will happen if the current
Premium Operations research Spreadsheet Optimization
Operations Research Group assignment 2014/2015 Remarks: 1. Students are allowed to do the coursework in groups of up to five elements; 2. Students must use the Microsoft Excel Solver and not any other software; 3. Each group should hand up to its teacher a preliminary report till October‚ 24th. This preliminary report should contain the answer for questions Q1a) and Q2a) and it will be marked; 4. The answers for questions Q1 b)‚ Q1c)‚ Q2b)‚ and Q2c) must be based on the problem formulations
Premium Microsoft Word Optimization Word processor
Nguyễn Hà Dân – SB0768 MSSV:SB60543Ho Hoa Binh la sieu di ngua‚ Ban gai cu cua Hoang Anh chim lonhahahahahaha Find the two lines that are tangent to y = x2- 2x+1 and pass through the point (5‚7). Call (d) is the equation of the tangent to y = x2- 2x+1‚ pass through the point (5‚7) and have slope k y – y0 = k(x – x0) y – 7 = k(x – 5) y = kx – k5 + 7 we slove system of equations The two lines that are tangent is: y=8x – 47 y=2x – 17 Find limx→1x-1x2+3-2 3. The circumference
Premium Maxima and minima Profit maximization Derivative
Stateline Shipping and Transport Company Stateline Shipping and Transport Company School of Business MAT 540 This paper was presented in submission for MAT 540 assignment four (Part 1 Only). Abstract This paper serves as a written response to the instructions and questions asked in assignment four. Assignment four instructed the writer to read the case problem Stateline Shipping and Transport Company from pages 273-274 in the text‚ Introduction to Management Science by Bernard W. Taylor. The
Premium Transport Optimization Costs
Sensitivity Analysis Sensitivity analysis helps to test the sensitivity of the optimum solution with respect to changes of the coefficients in the objective function‚ coefficients in the constraints inequalities‚ or the constant terms in the constraints. For Example in the case study discussed: The actual selling prices (or market values) of the two products may vary from time to time. Over what ranges can these prices change without affecting the optimality of the present solution? Will
Premium Present Operations research Time
3101 MSOM 3rd in-class Group Assignment (Mod B and Ch 4) Q1) 39) A linear programming problem that aims to minimize cost‚ has two constraints 2X + 4Y ≥ 100 and 1X + 8Y ≤ 100. Which of the following statements about its feasible region is true? (2-points) A) There are four corner points including (50‚ 0) and (0‚ 12.5). B) The two corner points are (0‚ 0) and (50‚ 12.5). C) The feasible region is triangular in shape‚ bounded by (50‚ 0)‚ (33-1/3‚ 8-1/3)‚ and (100‚ 0). D) The graphical origin (0‚ 0)
Premium Optimization Exponential smoothing Forecasting
Test Bank for Chapter 4 Problem 4-1: Work through the simplex method (in algebraic form) step by step to solve the following problem. Maximize Z = x1 + 2x2 + 2x3‚ subject to 5x1 + 2x2 + 3x3 ≤ 15 x1 + 4x2 + 2x3 ≤ 12 2x1 + x3 ≤ 8 and x1 ≥ 0‚ x2 ≥ 0‚ x3 ≥ 0. Solution for Problem 4-1: We introduce x4‚ x5‚ and x6 as slack variables for the respective functional constraints. The augmented form of the problem then is Maximize Z = x1 + 2 x2 + 2 x3‚ subject to
Premium Optimization BMW Linear programming
2) A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours‚ and assembly line 2 has 42 available hours. Each product requires 10 hours of processing time on line 1‚ while on line 2‚ product 1 requires 7 hours and product 2 requires 3 hours. The profit for product 1 is $6 per unit‚ and the profit for product 2 is $4 per unit. a. Formulate a linear programming model for this problem. b. Solve this model by using graphical analysis. 6)
Premium Imperial units Assembly line Linear programming
Chapter 3 Modeling & Solving LP Problems In A Spreadsheet 1. In general‚ it does not matter what is placed in a variable (changing) cell. Ultimately‚ Solver will determine the optimal values for these cells. If the model builder places formulas in changing cells‚ Solver will replace the formulas with numeric constants representing the optimal values of the decision variables. An exception to this general principle is found in Chapter 8 where‚ when solving nonlinear programming problems‚ the
Premium Profit maximization Maxima and minima Optimization
| MERTON TRUCK | Memorandum To: President From: Date: ------------------------------------------------- Re: Merton Truck Company Introduction In response to your report and request regarding Merton’s financial performance and product mix‚ I have met with your controller‚ sales manager and production manager‚ and have provided a solution that will improve the company in these two areas. Using a systematic approach‚ I was able to analyze the current machine hours‚ standard costs‚ and
Premium Operations research Linear programming Optimization