# Help!! - I need excel with formula shown 1) Sungram, an active lifestyle company, manufactures three models of novel fitness

###### 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 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

##### 4. (a) The density of a Poisson (-1) random variable is f1(y;) = t4e-1/ Use this...
4. (a) The density of a Poisson (-1) random variable is f1(y;) = t4e-1/ Use this density to find the MLE for and the MLE for u = 1-1. Hint: you might want to find the MLE for u first, and then apply the principle of invariance to find the MLE for 1. (b) Find the MLE for u = 1-1 using the original sa...
##### SHORT ANSWER  28: Draw a full mechanism for the following transformation Aldol condensation reaction and...
SHORT ANSWER  28: Draw a full mechanism for the following transformation Aldol condensation reaction and predict the product. Show all the elementary step(s) being sure to include all arrows, important electron pairs and any formal charges if needed. (8 points) NaOH, HẠO heat Aldol condensati...
##### The classic experiment that examined DNAse I sensitivity of chicken embryonic DNA from different tissues and...
The classic experiment that examined DNAse I sensitivity of chicken embryonic DNA from different tissues and at different developmental stages shows that: (Select all that apply.) A. the gene expression pattern changes during development. B. DNAse I sensitivity comes from sporadic mutations occurred...
##### A chord of a circle is a line segment whose endpoints are on the circle. Find the length of the common chord of the two circles whose equations are x^2 + y^2 =4 and x^2 +y^2 -6x +2 = 0?
A chord of a circle is a line segment whose endpoints are on the circle. Find the length of the common chord of the two circles whose equations are x^2 + y^2 =4 and x^2 +y^2 -6x +2 = 0?...
##### 2. For each of the following situations, determine the amount of gross income that the taxpayers...
2. For each of the following situations, determine the amount of gross income that the taxpayers Explain why any amounts are excluded from gross income. a. Harvey is injured in an automobile accident. The driver of the other car is found to be judge awards Harvey $10,000 for pain and suffering,$20,...
##### How does temperature affect cell membrane?
How does temperature affect cell membrane?...
##### Write a java program to remove duplicate elements from an array. Do not use Java library...
Write a java program to remove duplicate elements from an array. Do not use Java library utilities or 3rd party tools to solve this problem. You need to use the “for loop” and manage the index as you traverse thru the array [i ] while looking for duplicates. For example: Example 1 ------...
##### Write an essay comparing Baldwin's account of the Titanic with Rosenthal's account of his visit to Auschwitz
Write an essay comparing Baldwin's account of the Titanic with Rosenthal's account of his visit to Auschwitz.In your paragraph, explain how the tone and purpose of each essay is different. Support your argument with at least one example from each essay....
##### The following questions concern experimental parameters for obtaining 13C spectra and how to expl...
The following questions concern experimental parameters for obtaining 13C spectra and how to explain unexpected results. The first spectrum is a standard broadband decoupled spectrum of camphor Collection parameters 45o tip angle, D16 s Low power broadband 1H irradiation during D1 to buildup NOE (30...
##### Given that V. - 5 V in the network in the figure, find Vs. +-WSW 51...
Given that V. - 5 V in the network in the figure, find Vs. +-WSW 51 6ko + o Vs 4kn 10ka 5mA 9kn V. - 5 V...
##### (1 point) If C is the curve given by r (t) = (1 + 4 sin...
(1 point) If C is the curve given by r (t) = (1 + 4 sin t)i + (1+2 sin’t)j + (1 + 3 sinºt) k, 0 <15 and F is the radial vector field F(x, y, z) = xi + yj + zk, compute the work done by F on a particle moving along C....
##### 11. Write out a step wise synthesis of the following compounds starting from acetylene. You may...
11. Write out a step wise synthesis of the following compounds starting from acetylene. You may use any other reagents necessary. a. b. HO...
##### Question 3 0/1 pts You can buy 98 yen for a dollar today, and can enter...
Question 3 0/1 pts You can buy 98 yen for a dollar today, and can enter into a one year forward contract with a rate of 118 yen per dollar. A one year riskless zero coupon bond denominated in yen has a yield to maturity of 1%. What must the YTM be on a similar dollar-denominated bond to avoid an arb...