2. A BSA Corporation makes three products and has available 4 workstations. The production time (in minutes) per unit produced varies from workstation to workstation (due to different manning levels) as shown below: Workstation Product 2 4 5 6. 13 4 8 9. 10 12 15 17 3 14 Similarly, the contribution per unit varies from workstation to workstation as below: Workstation Product 3 4 10 8. 9 18 20 15 13 17 17 15 16 If one week, there are 35 working hours (2,100 minutes) available at each workstation how much of each product should be produced given that we need at least 100 units of product 1, 150 units of product 2 and 100 units of product 3. Formulate this problem as a linear program. Formulation: 1. Decision Variables: (hint: product i to make at each workstation j) a. 2. Objective Function: a. Maximize z =, 3. Constraints: Limit on the number of minutes available each week for each workstation: a. b. с. d. Lower limit on the total amount of each product produced:

2. A BSA Corporation makes three products and has available 4 workstations. The production time (in minutes) per unit produced varies from workstation to workstation (due to different manning levels) as shown below: Workstation Product 2 4 5 6. 13 4 8 9. 10 12 15 17 3 14 Similarly, the contribution per unit varies from workstation to workstation as below: Workstation Product 3 4 10 8. 9 18 20 15 13 17 17 15 16 If one week, there are 35 working hours (2,100 minutes) available at each workstation how much of each product should be produced given that we need at least 100 units of product 1, 150 units of product 2 and 100 units of product 3. Formulate this problem as a linear program. Formulation: 1. Decision Variables: (hint: product i to make at each workstation j) a. 2. Objective Function: a. Maximize z =, 3. Constraints: Limit on the number of minutes available each week for each workstation: a. b. с. d. Lower limit on the total amount of each product produced:

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A manufacturing system is used to produce a product.Each unit of product must be processed sequentially through workstations.V -----> W -----> X -----> Y The capacity of each workstation are as follows:Workstation V, 24 units per hour,Workstation W, 16 units per hour, Workstation X, 32 units per hour,Workstation Y, 26 units per hour. The raw material is always available in the front of workstation V. The utilization rate of workstation X is ________ percent. Use at least 4 decimals.You must show your calculation steps and brief explanation on your Excel spreadsheets.
A manufacturing system is used to produce a product.Each unit of product must be processed sequentially through workstations.V -----> W -----> X -----> Y The capacity of each workstation are as follows:Workstation V, 16 units per hour,Workstation W, 22 units per hour, Workstation X, 13 units per hour,Workstation Y, 18 units per hour. The raw material is always available in the front of workstation V. The manufacturing system has a cycle time of __________ minutes per unit. Use at least 4 decimals.You must show your calculation steps and brief explanation on your Excel spreadsheets.
In a factory they have type A machines and type B machines. Last week maintenance was given to 5 type A machines and 4 type B machines at a cost of $3,405,000. The previous week, $3,135,000 was paid to maintain 3 type A machines and 5 type B machines. What is the maintenance cost of the machines of each type?
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The optimum solution is: Number of trucks to be produced per day = ? (round your response to two decimal places).
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. Part 2 The optimum solution is: Number of trucks to be produced per day = ? enter your response here
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/75 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $275 and $225, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. The optimum solution is: Number of trucks to be produced per day = nothing (round your response to two decimal places).
green vehicule Inc. manufactures electric cars and small delivery trucks. it has just opened a new factory where the C1 car and the T1 truck can both be manufactured. to make either vehicle, processing in the assembly shop and the paint shop are required. It takes 1/40 of a day and 1/60 of a paint a truck of type T1 and a car of type C1 in the paint shop, respectively. it takes 1/50 of a day to assemble either type of vehicule in the assembly shop. A t1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicule sold
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many arcs will the network have?
Green Vehicle Inc. manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. a) Define the objective function and constraint equations. b) Graph the feasible region. c) What is a maximum-profit daily production plan at the new factory? d) How much profit will such a plan yield, assuming whatever is produced is sold?
2. As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost. b. Determine the optimal…
Foodie Goodie is a small food processing plant. It produces three kinds of snacks: sunflower seeds, peanuts and broad beans. The plant’s production capacity is as follows: • if all the equipment produces sunflower seeds, it can produce 6 kg a day; • if all the equipment produces peanuts, it can produce 5 kg a day; • if all the equipment produces broad beans, it can produce 3 kg a day. Production is planned on a weekly basis (i.e., 5 working days), and the output of the week must be stored before delivery. It takes • 1.8 litres of space to store 1 kg of sunflower seeds; • 1.9 litres of space to store 1 kg of peanuts; • 1.3 litres of space to store 1 kg of broad beans. The total storage space available is 100 litres. Due to a commercial agreement with a restaurant, Foodie Goodie must deliver at least 5 kg of broad beans every week. The marketing department estimates that the weekly demand for sunflower seeds, peanuts and broad beans does not exceed 11 kg, 15 kg and 8 kg, respectively, so…
Currently they have 5 refrigerated trucks and planning to expand as market for their services ison the rise. The fixed cost of their operations is $1,200,000 per year covering managerial,administrative, insurance, and other related expenses at their headquarters. Every truck hasapproximately $100,000 annual expense for lease, maintenance, and insurance. The variablecost of operation for each truck is $3.50 per mile covering fuel and truck driver’s pay. Themaximum mileage capacity of each truck is 200,000 miles per year and current demand is1,000,000 miles per year. The company charges $10.00 per mile for a fully loaded truckshipment. Construct an Excel cross tabulation table to find profit for this company using 6 to 14trucks and mileage demand of 1,000,000, 1,500,000, 2,000,000, 2,500,000, 3,000,000, and3,500,000 miles per year. Based on the table find the optimal number of trucks needed for abovelisted mileage demands.