Question 1
Radar Expert: Radar Expert makes automobile radar detectors and assembles two models LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are given below.
Components Required / Unit
Model A B Profit Per Unit
LaserStop 18 6 $24
SpeedBuster 12 10 $40
Identify the decision variables, objective, and constraints, and enter suitable descriptions in Cells D2:D5 (textual descriptions) and J2:J6 (formulas and constraints) of the spreadsheet named “Radar Expert” inside the file. Then formulate a linear optimization model and implement the model using Microsoft Excel’s Solver feature (do not round any numbers in the spreadsheet; do not restrict any decision variables to be integer). Based on the results, what is the optimal total profit generated? Enter numeric digit(s) in the nearby box and round your answer to two decimal places (do not use any non-numeric symbol except a decimal point).
Question 2
Radar Expert: Based on the linear optimization model implemented in the previous question, how many units of SpeedBuster are produced when the optimal total profit is achieved? Enter numeric digit(s) in the nearby box and round your answer to two decimal places (do not use any non-numeric symbol except a decimal point).
Question 3
Radar Expert: Based on the linear optimization model implemented in the previous question, how many units of LaserStop are produced when the optimal total profit is achieved? Enter numeric digit(s) in the nearby box and round your answer to two decimal places (do not use any non-numeric symbol except a decimal point).
Question 4
Radar Expert: Based on the linear optimization model implemented in the previous question, which constraint(s) is / are binding? Select all that apply.
o o o The constraint on A
o o o The constraint on B
o o o None of the constraints
Question 5
Radar Expert: Based on the linear optimization model implemented in the previous question, what is the slack value in the non-binding constraint? Enter numeric digit(s) in the nearby box and round your answer to two decimal places (do not use any non-numeric symbol except a decimal point).
Question 6
Stock Investment: An MBA student has $2,500 available to invest in three potential stocks, of which their cost per share and expected return over the next 2 years are given in the table below.
Stock A B C
Price / share $25 $15 $40
Return / share $12 $7 $12
Identify the decision variables, objective, and constraints, and enter suitable descriptions in Cells D2:D4 (textual descriptions) and K2:K4 (formulas and constraints) of the spreadsheet named “Stock Investment” inside the same file mentioned in the previous question. Then formulate a linear optimization model and implement the model using Microsoft Excel’s Solver feature (do not round any numbers in the spreadsheet; do not restrict any decision variables to be integer). Based on the results, what is the optimal total return generated? Enter numeric digit(s) in the nearby box and round your answer to two decimal places (do not use any non-numeric symbol except a decimal point).
Question 7
Stock Investment: Based on the linear optimization model implemented in the previous question, how many shares of Stock A are purchased when the optimal total return is achieved? Enter numeric digit(s) in the nearby box and round your answer to two decimal places (do not use any non-numeric symbol except a decimal point).