Question: PLACE IN LINEAR PROGRAMMING EXCEL :Decision Variables The following decision variables are defined to formulate the LP model: 1. S1: Terminals produced on straight-time in

PLACE IN LINEAR PROGRAMMING EXCEL :Decision Variables The following decision variables are defined to formulate the LP model: 1. S1: Terminals produced on straight-time in Quarter 1 (units) 2. O1: Terminals produced on overtime in Quarter 1 (units) 3. I1: Terminals carried in inventory from end of Quarter 1 to Quarter 2 (units) 4. S2: Terminals produced on straight-time in Quarter 2 (units) 5. O2: Terminals produced on overtime in Quarter 2 (units) 3. Linear Programming Model Parameters: 1. Demand: d1 = 700 (Q1), d2 = 3200 (Q2) 2. Hours per terminal: 5 3. Straight-time capacity: 9000 hours per quarter 4. Overtime capacity: 900 hours per quarter 5. Straight-time cost: R120/hour (R600/unit) i.e. 120hr x 5hrs = R600/unit 6. Overtime cost: R180/hour (R900/unit) i.e. R180 x 5= R900/ units 7. Carrying cost: R500/unit per quarter 4. Objective function: Minimise Z = 600(S1 + S2) + 900(O1 + O2) + 500I1 Subject to constraints: Flow balances: S1 + O1 - I1 = 700 I1 + S2 + O2 = 3200 Capacity: 5S1 9000; 5S2 9000 5O1 900; 5O2 900 Non-negativity: S1, O1, I1, S2, O2 0 4. Solver Results The optimal solution obtained using Solver is: S1 = 1800 O1 = 120 I1 = 1220 S2 = 1800 O2 = 180 Total cost = R3,040,000

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

Ch4, Problem 14: Part a - LP Formulation Write down the formulation in the answer box below. Make sure the following four components are included: Variable definitions: Use a separate line for...

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...

IS 601 Assignment 7 1. The production of car tires in any given year is related to the number of cars produced that year and in prior years. Suppose our econometric model resulted in the following...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

A company produces three types of alarm systems ?S1, S2, and S3 ? and supplies them to a Requirements for Business Intelligence Capstone Project. A company produces three types of alarm systems -S1,...

In the rest of this chapter, we lead the reader through the formulation of several more complicated linear programming models. The most important step in formulating an LP model is the proper choice...

How do I formulate question 3 as a transportation problem? ADM2302 Section M, N and P Solution Assignment # 2 SOLUTION Assignment # 2 LP Formulations and Applications ADM2302 students are reminded...

TACKLE ALL PARTSP5 Problem 1 The Airfare Problem1. You are trying to get the cheapest airfare that you can. You just called up and found that the ticket home will cost $400, and it cannot be refunded...

JUST PART THREE PLEASE A small company named Logr Transit has at present 3 manufacturing facilities (suppliers) called Suppliers #1, 2, and #3 to supply goods to its 3 retail stores (customers) named...

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:...

Accounts receivable transactions of Company B in 2021 Instructions: Write the accounting entries related to the following 1~6 transactions 1. Credit sales of $5,000 at the end of January 2021, 2/10,...

In an industry characterized by perfect competition, wages are increasing for all firms (very realistic right now in many countries). 1. How will this affect AVC, AFC, AC and MC curves for "some"...

E6.24 Consider the system represented in state variable form (a) What is the system transfer function? (b) For what values of k is the system stable? where x(t) Ax(t) + Bu(t) y(t)=Cx(t) + Du(t), 0 1...

For the problems below, choose which technique would provide the best approach: a supervised neural network, an unsupervised technique or non-linear regression with a known functional form. You have...