Question: Create a Sensitivity Report for Electro-Polys make vs. buy problem in section 3.8 of Chapter 3 and answer the following questions. a. Is the solution

Create a Sensitivity Report for Electro-Poly’s make vs. buy problem in section 3.8 of Chapter 3 and answer the following questions.

a. Is the solution degenerate?

b. How much can the cost of making model 1 slip rings increase before it becomes more economical to buy some of them?

c. Suppose the cost of buying model 2 slip rings decreased by $9 per unit. Would the optimal solution change?

d. Assume workers in the wiring area normally make $12 per hour and get 50% more when they work overtime. Should Electro-Poly schedule these employees to work overtime to complete this job? If so, how much money would this save?

e. Assume workers in the harnessing area normally make $12 per hour and get 50% more when they work overtime. Should Electro-Poly schedule these employees to work overtime to complete this job? If so, how much money would this save?

f. Create a Spider plot that shows the effect of varying each of the wiring and harnessing requirements (in cells B17 thru D18) to 90% of their current levels in 1% increments. If Electro-Poly wanted to invest in training or new technology to reduce one of these values, which one offers the greatest potential for cost savings?

Step by Step Solution

★★★★★

3.40 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

ElectroPoly Corporation Slip Ring Number to Model 1 Model 2 Model 3 Make 3000 550 900 Buy 0 1450 0 Cost to Make 50 83 130 Total Cost Buy 61 97 145 453... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

167-B-M-L-M-D-A (104).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!

Which is not a question addressed by the Balanced Scorecard approach? A. How do we create value? B. How do customers view us? C. How do shareholders view us? D. How do competitors view us? E. What...

Answer the following questions about prepaid expenses: a. On March 1, Blue & Green Travel prepaid $4,800 for six months rent. Give the adjusting entry to record rent expense at March 31. Include the...

Answer the following questions about internal control over cash payments: 1. Payment by check carries three controls over cash. What are they? 2. Suppose a purchasing agent receives the goods that he...

can you please assist in decision analysis area. I have attached the questions, answers and the spreadsheets needed, but not sure how to get the answers in the solver spreadsheet. thanks for your...

I am trying to get help on QSO-320 Week 4 Midterm. I've attached the question that needs to be answered. AppleBerry Case Study QSO 320: Module Four Case Study AppleBerry MP3 Player: Make vs. Buy...

Solve the following problem in Excel:Max Z = 8 x1 + 6 x2s.t. x1 + x2 82 x1 + x2 10 Create the sensitivity report. 1.Check to make sure you got the right solution: x1 = 2; x2 = 6A)Got it! B)If you...

g) Create a Spider Plot illustrating how the optimal profit changes as the availability of each of the four resources varies from \90 to \110 of their given values. Explain the relationship between...

IMPORTANT - This is an ILP problem and the answer that is available on another page is incorrect as it does not account for Fixed Costs. Please make sure to include Fixed cost in all calculations as...

hapter 4 Sensitivity Analysis and the Simplex Method 14. Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3 answer the following questions: a. Is the solution...

Hi Tutor, Please find the attached document. I think you can choose the company for Coca-Cola, because the company information is everywhere. Page 0 of 42 Your Name Here Your Company Name Here Annual...

Two steel spheres approach each other head on with same speed and collide elastically. After the collision one of the sphere's radius 'r' comes to rest. The radius of the other sphere is (A) 31/a (B)...

John Redmond was not paid for trim carpentry work that he did for Brenda Knighton in her home. Ms. Knighton does not dispute that Redmond did the work, but she says that he waited too long to file...

urse Question 1 0 1 pts grity port Thinking about the International Fisher Effect, we are given that the risk free rate in the US is 7 % and the inflation rate in the US is 3 % . What would be the...

56. In Lakes year 3 income statement, how much should be reported for dividend revenue? a. $16,000 b. $2,400 c. $1,000 d. $150

The Orange Blossom Marathon takes place in Orlando, Florida, each December. The organizers of this race are trying to solve a problem that occurs at the finish line each year. Thousands of runners...

State University allows students and faculty to access its mainframe computer by modem. The university has 15 modem connections that can be used. When all of the modem connections are in use, the...

During tax season, the IRS hires seasonal workers to help answer the questions of taxpayers who call a special 800 telephone number for tax information. Suppose that calls to this line occur at a...

A samplemean, samplesize, population standarddeviation, and confidence level are provided. Use this information to complete parts(a) through(c) below. x=53, n=15, =7, confidence level=99% a. Use...

Sandhill Co . had the following assets on January 1 , 2 0 2 5 . During 2 0 2 5 , each of the assets was removed from service. The machinery was retired on January 1 . The forklift was sold on June 3...

The laast time this got answered it was answered with gallons and it looked copied and pasted. Pleasea help. Liquid ethanol is pumped from a large storage tank through a 2.00 - inch ID pipe at a rate...