Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose we are building three types of houses: studio (S), medium (M) and large (L). Assume that, we have three types of resource constraints.
Suppose we are building three types of houses: studio (S), medium (M) and large (L). Assume that, we have three types of resource constraints. Those constraints are based on labor hours, painting hours, and decoration hours. Considering the house type based profits and resources requirements with resource availabilities, you are given the linear programming model below. Besides, you are given the Excel answer and sensitivity reports. Answer the following questions by analyzing the reports MAX Z= 30S+70M+116L s.t. 2S+2.5M+3.5LS60 Labor hours 2.5S+1.5M+4Ls50 Painting hours 2S+1M+4LS40 Decoration hours S,M,L 0 Answer Report: Objective Cell (Max) Cell Name Original Value Final Value $B$10 Pofit objective: 0.00 1790.77 Variable Cells Cell Name Original Value Final Value Integer $B$7 Studio: $B$8 Medium: SB$9 Large: 0.00 0.00 Contin 0.00 15.38 Contin 0.00 6.15 Contin Constraints Cell Name Cell Value Formula Status Slack 60.00 SH$11
Step by Step Solution
★★★★★
3.41 Rating (164 Votes )
There are 3 Steps involved in it
Step: 1
1 The optimal number of studio house 0 The optimal number of the medium house 1538 Rounding off will ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started