Question 1 AA company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergotwo major processes: cutting and pinning operations. The profits per unit are $6 and $4respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutesfor cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60minutes. Determine the optimum quantities of the two boxes to maximize the profits.a. Formulate a linear programming model that can be used to determine the quantities of the twoboxes that should be produced in order to maximize total profit contributionb. Graph the feasible regionc. Determine the coordinates of each extreme point.d. What is the optimal solution.

Decision variables : Let x be corrugated cartons and y be ordinary cartons. Objective function :…

Answered: Question 1 A A company manufactures two…

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

Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard mixes they can produce. • The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts.• The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts.The shop has 100 pounds of raisins and 70 pounds of peanuts. The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no more than 110 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it.
Question 1 A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutes for cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution.b. Graph the feasible region.c. Determine the coordinates of each extreme point.
Question 1 A A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutesfor cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution b. Graph the feasible region. c. Determine the coordinates of each extreme point. d. What is the optimal solution. e. Solve in excel.
QUESTION 2 Samy Company manufactures two types of tables, model K and J. The production of a model K table requires a capital expenditure of RM 6 and 2 hours of labor. The production of a model J table requires a capital of RM 4 and 5 hours of labor. The company has RM 240 capital and 100 hours of labor available for the production of the two models of tables per week. A model K table contributes a profit of RM 30 while model J contributes RM 40. a. Formulate the problem using linear programming model. b. How many of each type of table should the firm produce to maximize the profit? c. What is the maximum profit?
Question 1 B A company produces 2 (two) different grades of gasoline – regular and premium from 3(three) components (1,2,3). The company wants to determine the optimal mix of the three components in each grade of the gasoline that will maximize profit. The maximum quantities available for each component and their cost per gallon are as follows:Component Cost per gallon maximum gallons available per day 1 2.50 5,000 2 2.60 10,000 3 2.84 10,000 In order to ensure the appropriate blend, each grade has certain specifications as follows: Grade Component Specs Selling Price per gallon Regular At most 30% component 1 At least 40% component 2 At most 20% component 3 2.90 Premium At least 25% component 1 At most 45% component 2 At Least 30% component 3 3.00 The company wants to produce at least 10,000 gallons of each grade of gasoline. Formulate a LP model including the ratio constraints, production constraints and the objective function for this question.
question 7 You manage an ice cream factory that makes two flavors: Creamy Vanilla and Continental Mocha. Into each quart of Creamy Vanilla go 2 eggs and 3 cups of cream. Into each quart of Continental Mocha go 1 egg and 3 cups of cream. You have in stock 450 eggs and 750 cups of cream. You make a profit of $3 on each quart of Creamy Vanilla and $2 on each quart of Continental Mocha. How many quarts of each flavor should you make to earn the largest profit? HINT [See Example 2.] (If an answer does not exist, enter DNE.) Creamy Vanilla quartsContinental Mocha quarts
Question 2 A particular road is used by N drivers each day. Each driver obtains a benefit v from the journey and incurs a cost c(N ) that increases with the number of drivers on the road due to congestion. Suppose that the cost incurred is given by c(N) = a+bN, for some positive numbers a, b. If the agent decides not to use the road, they receive 0. You may assume throughout that the number of drivers N can be any real number (rather than an integer). Each driver uses the road at most once. the number of drivers that join the road is Ne = (v−a)/b (iv) Suppose that the government charges a toll t (a congestion charge) for each journey. Find the optimum toll. Interpret your answer in terms of the externality that each driver imposes on others.
Question 1 You may produce seven products by consuming three materials. The unit sales price and material consumption of each product are listed in Table 1. For each day, the supply of these three materials are limited. The supply limits are listed in Table 2. For each day, you need to determine the production quantity for each product. Product Price Material 1 Material 2 Material 3 1 100 0 3 10 2 120 5 10 10 3 135 5 3 9 4 90 4 6 3 5 125 8 2 8 6 110 5 2 10 7 105 3 2 7 Table 1: Product information for Problem 1 Material Supply limit 1 100 2 150 3 200 Table 2: Material information for Problem 1 Formulate a linear integer program that generates a feasible production plan to maximize the total profit (which is also the total revenue, as there is no cost in this problem). Then write a computer program…
dent question I am having trouble formulating the objective function and constraints. Jeremy Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder rods is $1800 and the cost required to set up the production line for the 6-cylinder rods is $3200. Manufacturing costs are $16 for each 4-cylinder connecting rod and $20 for each 6-cylinder connecting rod. The production capacities are 5800 and 7200 for 6 and 4 cylinder rods respectively. The operating budget is $100,000. The selling prices are $55 per 4-cylinder rod and $70 per 6-cylinder rod. What is the optimal number of 4 and 6 cylinder rods that should be produced by the company? Identify the type of integer programming framework (Total Integer, Mixed Integer or Binary) that applies to this problem, develop the appropriate formulation (decision variables, objective function and constraints)
Question Primer Inc. offers plumbing and air conditioning services to customers in Kumasi, Ghana. The company’s product strategy is to solve the customer’s problem irrespective of what it takes, at the time the customer needs it solved. The company provides same day service for customers, and theaim is to make the customer happy before leaving.The services of the company are available 24 hours a day, 7 days a week for customers. There is no extra charge for requests made on holidays, odd hours of the day, or in festive seasons. The company aims to be available at the call of customers without charging a pesewa extra, even at times when rival firms won’t get out of bed. The company fixes the price of the service before it begins, and customers can be assured of no extra charges. Irrespective of the customer’s location in the city, Primer Inc. does not charge additional fees for transportation. For all services, the company provides a one year guarantee on all parts and labour used,…
Question 3: A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Use Excel Solver to solve the problem (provide exact values for all variables and the optimal objective function).
Question 1 PKG Electric makes two types of electric fans, ceiling fan and wall fans. Each ceiling fan requires two circuit boards and four hours assembly time. Each wall fan requires two circuit boards and one-hour assembly time. The profit of each ceiling fan and wall fan are RM25 and RM15 respectively. The company produces its own circuit boards and its capacity is 54 per week. Currently, the company has 48 hours of assembly time per week. The company wishes to maximize the profit. Let x = ceiling fan, y = wall fan Solve: 1. Formulate the problem as a linear programming model. 2. What is the maximum profit? 3. Later, the company was informed by its retailers that the demand for the wall fans is at most 12 units per week. What is the new maximum profit? Question 2 Lee Chong Wei has two photocopy machines P and Q. Machine P can make at most 16 copies per minute, while machine Q can make at most 20 copies per minute. Lee Chong Wei wants to make at least 150 copies in 5 minutes.…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS