A company makes two products (X and Y) using two machines (A and B). Each unit of X that is produced requires 50 minutes of processing time on machine A and 30 minutes of processing time on machine B. Each unit of Y that is produced requires 24 minutes of processing time on machine A and 33 minutes of processing time on machine B. At the start of the current week, there are 30 units of X and 90 units of Y in stock. Available processing time on machine A is forecast to be 40 hours and on the machine, B is forecast to be 35 hours. The demand for X in the current week is forecast to be 75 units and for Y is forecast to be 95 units. Company policy is to maximize the combined sum of the units of X and the units of Y in stock at the end of the week. Formulate the problem of deciding how much of each product to make in the current week as a linear program. Solve this linear program using excel.
A company makes two products (X and Y) using two machines (A and B). Each unit of X that is produced requires 50 minutes of processing time on machine A and 30 minutes of processing time on machine B. Each unit of Y that is produced requires 24 minutes of processing time on machine A and 33 minutes of processing time on machine B. At the start of the current week, there are 30 units of X and 90 units of Y in stock. Available processing time on machine A is forecast to be 40 hours and on the machine, B is forecast to be 35 hours. The demand for X in the current week is forecast to be 75 units and for Y is forecast to be 95 units. Company policy is to maximize the combined sum of the units of X and the units of Y in stock at the end of the week. Formulate the problem of deciding how much of each product to make in the current week as a linear program. Solve this linear program using excel.
Calculus: Early Transcendentals
8th Edition
ISBN:9781285741550
Author:James Stewart
Publisher:James Stewart
Chapter1: Functions And Models
Section: Chapter Questions
Problem 1RCC: (a) What is a function? What are its domain and range? (b) What is the graph of a function? (c) How...
Related questions
Question
A company makes two products (X and Y) using two machines (A and B). Each unit of X that is produced requires 50 minutes of processing time on machine A and 30 minutes of processing time on machine B. Each unit of Y that is produced requires 24 minutes of processing time on machine A and 33 minutes of processing time on machine B.
At the start of the current week, there are 30 units of X and 90 units of Y in stock. Available processing time on machine A is forecast to be 40 hours and on the machine, B is forecast to be 35 hours.
The demand for X in the current week is forecast to be 75 units and for Y is forecast to be 95 units. Company policy is to maximize the combined sum of the units of X and the units of Y in stock at the end of the week.
- Formulate the problem of deciding how much of each product to make in the current week as a linear program.
- Solve this linear program using excel.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, calculus and related others by exploring similar questions and additional content below.Recommended textbooks for you
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus
ISBN:
9781319050740
Author:
Jon Rogawski, Colin Adams, Robert Franzosa
Publisher:
W. H. Freeman
Calculus: Early Transcendental Functions
Calculus
ISBN:
9781337552516
Author:
Ron Larson, Bruce H. Edwards
Publisher:
Cengage Learning