3. Bit-to- Byte Digital produces two models of electronic tablets, Plain and Fan
ID: 466507 • Letter: 3
Question
3. Bit-to-Byte Digital produces two models of electronic tablets, Plain and Fancy. It wants to plan how many tablets to produce next month to maximize profits. Producing these tablets requires wiring, assembly, and inspection time. Each tablet produces a certain level of profits but faces a limited demand. There are a limited number of wiring, assembly, and inspection hours available next month. The data for this problem is summarized in the following table.
Create an EXCEL spreadsheet of LP model showing attention to both accuracy and presentation
Use Analytic Solver Platform to verify graphical solution (b). Explain comparison—anything different?
Create Answer report [use report to answer following questions]
Which constraints are binding?
Which constraints show slack?
Create a Sensitivity Report; perform an analysis by answering questions below.
Is the optimal solution degenerate? Explain why or why not.
Is the optimal solution unique? If not, identify an alternate optimal solution for the problem.
What is the highest value the objective function coefficient X1 can assume without changing the optimal solution?
Will the current solution remain optimal if a binding constraint is increased by 5 percent? Identify and analyze the chosen constraint and Explain.
Tablet
Profit per
Maximum
demand for
Wiring Hours
Assembly
Hours
Inspection
Hours
Model
Model ($)
product
Required
Required
Required
Plain
30
80
0.4
0.5
0.2
Fancy
40
90
0.5
0.4
0.3
Hours Available
50
50
22
Tablet
Profit per
Maximum
demand for
Wiring Hours
Assembly
Hours
Inspection
Hours
Model
Model ($)
product
Required
Required
Required
Plain
30
80
0.4
0.5
0.2
Fancy
40
90
0.5
0.4
0.3
Hours Available
50
50
22
Explanation / Answer
no, it is not possible at5%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.