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 00 8 2 00 8 6 110 5 2 10 7 105 3 2 7 Material 1 2 3 Table 1: Product information for Problem 1 Supply limit 100 150 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 (e.g., using MS Excel solver) to solve this instance and obtain an optimal plan. Do not set the production quantities to be integer; leave them fractional. After you find an optimal solution and its objective value, write down the integer part of the

Algebra and Trigonometry (MindTap Course List)
4th Edition
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
ChapterP: Prerequisites
SectionP.1: Modeling The Real World With Algebra
Problem 23E: Grade Point Average In many universities students are given grade points for each credit unit...
icon
Related questions
Question
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
00
8
2
00
8
6
110
5
2
10
7
105
3
2
7
Material
1
2
3
Table 1: Product information for Problem 1
Supply limit
100
150
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 (e.g., using MS Excel
solver) to solve this instance and obtain an optimal plan. Do not set the production quantities to be integer; leave
them fractional. After you find an optimal solution and its objective value, write down the integer part of the
Transcribed Image Text: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 00 8 2 00 8 6 110 5 2 10 7 105 3 2 7 Material 1 2 3 Table 1: Product information for Problem 1 Supply limit 100 150 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 (e.g., using MS Excel solver) to solve this instance and obtain an optimal plan. Do not set the production quantities to be integer; leave them fractional. After you find an optimal solution and its objective value, write down the integer part of the
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage