Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is the entire question Answer part c) Question part d) Answer part d) Question part e) Answer part e) >>>>> If 20 additional hours

This is the entire question

image text in transcribedimage text in transcribed
Answer part c) Question part d) Answer part d) Question part e) Answer part e) >>>>> If 20 additional hours of cutting capacity became available in a given week, how much additional prot could the company earn? >>>> Suppose another company wanted to use 15 hours ofXYZ's sanding capacity in a week and was willing to pay $400 per hourto acquire it. Should Company XYZ agree to this? Why or why not? >>>> Amanufacturing facility for Company XYZ that produces doors and windows utilizes three manufacturing processes: cutting, sanding and finishing. There are limited resources for each of these processes. Assume that the decision variables are defined to represent the number of doors produced per week and the number of windows produced per week. Assume that the objective function is a profit maximization objective with unit profit for doors being $500 and unit profit for windows being $400. Assume that you are given the Answer report and Sensitivity report in TAB Q25 and Q2A. Answer parts (a)-(e) below Microsoft Excel 16.0 Sensitivity Report Worksheet Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 Variables Qty Doors 20 0 500 300 233.3333333 $C$3 Variables Qty Windows 40 0 400 350 150 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$7 Cutting Used 40 350 40 40 13.33333333 $D$8 Sanding Used 40 300 40 6.666666667 20 SDS9 Finishing Used 50 0 60 1E+30 10 Question part a) If the unit profit on doors increased to $700 would the optimal solution change? Why or why not? Answer part a) > > > > > > Question part b) If the unit profit on doors increased to $700 what is the maximum profit? Answer part b) > > > > Question part c) If the unit profit on windows decreased to $200 would the optimal solution change? Why or why not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart, Daniel K. Clegg, Saleem Watson, Lothar Redlin

9th Edition

1337613924, 978-1337613927

More Books

Students also viewed these Mathematics questions