angel34emb
22.02.2021 •
Business
A company is developing its weekly production plan. The company produces two products, A and B, which are processed in two departments. Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80. Each unit of A generates a profit of $17 while a unit of B earns a profit of $21. The company can sell all the units it produces. The data for the problem are summarized below.
Hours required by
Operation A B Hours
Cutting 3 4 48
Welding 2 1 36
The decision variables are defined as:
xi = the amount of product i produced
yi = 1 if xi > 0 and 0 if xi = 0
A spreadsheet implementation of the problem is shown below.
Q1. What is the objective function for this problem?
a. Maximize: 17x1 + 21x2 - 60y1 - 80y2
b. Minimize: 60y1 + 80y2
c. Minimize: 17x1 + 21x2 - 60y1 - 80y2
d. d. Maximize: 17x1 + 21x2
Q2. What is the appropriate formula to use in cell E8 of the Excel implementation of the ILP model for this problem?
a. =SUMPRODUCT(B8:C8,B14:C14) - SUMPRODUCT(B5:C5,B7:C7)
b. =SUMPRODUCT(B5:C5,B7:C7) - SUMPRODUCT(B8:C8,B14:C14)
c. =SUMPRODUCT(B5:C5,B7:C7) - SUMPRODUCT(B8:C8,B15:C15)
d. =SUMPRODUCT(B5:C5,B7:C7) - B8:C8
Q3. Which of the following algebraic constraints creates the link between setting up to produce A's and making some A's for this problem?
a. x1 - 18 y1 > 0
b. x1 - y1 = 0
c. = if(x1 > 0, y1 = 1, y1 = 0)
d. x1 < 16y1
Solved
Show answers
More tips
- H Health and Medicine How to Whiten Teeth and Get the Perfect Smile...
- S Style and Beauty How to Properly Apply Eye Makeup: Tips from a Professional Makeup Artist...
- A Auto and Moto How Can Parking Sensors Help Drivers?...
- C Computers and Internet Make Money Online: Secrets and Essential Ways...
- A Auto and Moto What is the Average Lifespan of an Engine in a Car?...
- H Health and Medicine What You Need to Know About Nasal Congestion in Infants: Causes, Symptoms, and Treatment...
- S Science and Technology Discovering the Anatomy of an LCD TV Screen...
- F Food and Cooking How to Get Reconfirmation of Registration?...
- F Food and Cooking Why Doesn t the Confirmation Link Come to Email?...
- F Food and Cooking Deflope: What is it and how does it work?...
Answers on questions: Business
- B Business PLS HEL TY The industry, which enables workers to electronically exchange data, continues to grow. Its increased use requires more and more as an ever-increasing number of...
- B Business Marginal cost is average variable cost when . A) equal to; average total cost is minimized B) less than; total cost is maximized C) greater than; average fixed cost is minimized...
- B Business You are considering investing in a security that will pay you $80 in interest at the end of each of the next 10 years. If this security is currently selling for $588.81, then...
- C Chemistry 7. A sample of salmon -colored powder contains 0.700 of chromium 0.650 g of sulfur , and 1.30 g oxygen. The molar mass is 392.2g / m * o * l . What is the molecular formula...
- M Mathematics 1st answer of the test I need an 100 or 90+...
- E English Someone who heads a court and interprets the laws is called a_....
- B Business A vertical merger is a merger between firms that operate at different...
- A Arts What are the job prospects of a pastry chef...
- B Biology Is this correct???!!!...
- M Mathematics I need help with this pls...
Ответ:
The responses to this question can be defined as follows:
Explanation:
In question 1, the objective function to solve the given problem is:
In question 2, "
"
is the appropriate choice for the formula, which is using in cell E8, and it is also used in the ILP model.
In question 3, the choice "
" is used in the algebraic constraint for creating the link between setting up to produce A's and making some A's.
Ответ:
4ft
Step-by-step explanation:
A) This is a Pythagorean Triple.
B) 3^2 +x^2=5^2
9+x^2=25
x^2=16
x=4