1

# Help!! - I need excel with formula shown 1) Sungram, an active lifestyle company, manufactures three models of novel fitness trackers called Jump (J), Run (R), and Walk (W). They have a limited supply...

## Question

###### Help!! - I need excel with formula shown 1) Sungram, an active lifestyle company, manufactures three models of novel fitness trackers called Jump (J), Run (R), and Walk (W). They have a limited supply...

Help!! - I need excel with formula shown

1) Sungram, an active lifestyle company, manufactures three models of novel fitness trackers called Jump (J), Run (R), and Walk (W). They have a limited supply of common parts---wifi module (450 in inventory), cellular module (250 in inventory), heart rate monitor (800 in inventory), GPS module (450 in inventory), LCD screen (600 in inventory)---that these products use. A Jump model requires a wifi module, 2 heart rate monitors, a GPS module, and 2 LCD screens. A Run model requires a wifi module, a cellular module, 2 heart rate monitors, a GPS, and an LCD screen. A Walk model requires a heart rate monitor and an LCD screen. The profit on the Jump model is \$65, the profit on the Run model is \$75, and the profit on the Walk Model is \$25. The following is a linear programming formulation of the problem.

Let J = Number of Jump models produced R = Number of Run models produced W = Number of Walk models produced We may write a model for this problem as follows. Maximize 65J + 75R + 25W subject to: (wifi module constraint) J + R ≤ 450 (cellular module constraint) R ≤ 250 (heart rate monitor constraint) 2J + 2R + W ≤ 800 (GPS module constraint) J + R ≤ 450 (LCD screen constraint) 2J + R + W ≤ 600 (non-negativity) J, R, W ≥ 0. Implement the above model in Solver (make sure to choose Simplex as the solving method and to choose the option “Make Unconstrained Variables non-negative”---do not explicitly put in the non-negativity constraints in the model) and using the sensitivity report only (do not resolve the problem and explain your calculation using the sensitivity report) answer the following questions.

Does the solution change if only 415 wifi modules are available?

Is it profitable to produce the Walk model? If not, by how much should the profit margin on the Walk model be increased to make it profitable to produce the Walk model?

Because of a change in production technology the profit margin on the Jump model has increased to \$70. Should the production plan of Sungram change? What is their new profit?

100 heart rate monitors were found to be defective, making the number of available heart rate monitors 700. What will the profit be in this situation?

Another supplier is willing to sell cellular modules to Sungram. However, their prices for a cellular module are \$8 higher than what Sungram pays its regular supplier. Should Sungram go ahead and purchase these cellular modules? If yes, at most how many units should they purchase?

Sungram is considering introducing a new fitness tracker model called the RunLite. This product uses a wifi module, a cellular module, a heart rate monitor, and an LCD screen, and is expected to make a profit of \$50. Should Sungram produce the RunLite? Why or Why not?

Make sure to explain how you used the sensitivity report to figure out your answer. Please also attach the solver model and sensitivity report you used for this question.

#### Similar Solved Questions

##### Which expression represents the product of to consecutive odd integers, where n is an odd integers
Which expression represents the product of to consecutive odd integers, where n is an odd integers?1 n(n+1)2 n(n+2)3 n(n+3)4 2n+1...
##### How do you factor # x^2 + x +1#?
How do you factor # x^2 + x +1#?...
##### -lot halt)= lo e uct) 1- Let T= sec and let He(s) = Stlo be an...
-lot halt)= lo e uct) 1- Let T= sec and let He(s) = Stlo be an analog filter a- Find hcn),. design invariance' discrete time filter using impulse b. Find Hce) using bilinear trans tormation, it shouldbe one of the following (circle one) - |- 2-1 z-0-11 C- Using bilnear transtormation, where does...
##### What is 40% of 213?
What is 40% of 213?...
##### A call option exists on British pounds with an exercise price of \$1.70, a 90-day expiration...
A call option exists on British pounds with an exercise price of \$1.70, a 90-day expiration date, and a premium of \$.03 per unit. A put option exists on British pounds with an exercise price of \$1.71, a 90-day expiration date, and a premium of \$.035 per unit. You plan to purchase options to cover yo...
##### Positive cooperativity is when binding of a ligand to a protein results in a conformational change...
Positive cooperativity is when binding of a ligand to a protein results in a conformational change that allows increased binding affinity at other ligand binding sites in the same molecule. Select one: True False...
##### How to find the distance travelled using calculus?
Can someone please explain to me how to do question 7c? Thanks!...
##### Shown below are the amino acid sequences of the wild-type and three mutant forms of a...
Shown below are the amino acid sequences of the wild-type and three mutant forms of a short protein. Each mutation results from a single nucleotide change (transition / transversion / insertion / deletion). Use this information to answer the following questions. Hint: First, reconstruct as much as y...
##### Q2. [20 marks] The Department of Engineering is contemplating the purchase of a top-of-the- line PCB...
Q2. [20 marks] The Department of Engineering is contemplating the purchase of a top-of-the- line PCB drilling machine to be used in its laboratories. The price of the machine is \$5,000. The depreciation rate of the machine follows the SL method over its 10 years life. The market value of the machine...
##### 12.200 * Your answer is incorrect. Try again. H OH xs CrO; H20+ acetone ?
12.200 * Your answer is incorrect. Try again. H OH xs CrO; H20+ acetone ?...