Question: For Questions 22-27 The following problems are based on a new version of the Fundraiser model to analyze how many t-shirts and hoodies John and

For Questions 22-27 The following problems are

For Questions 22-27 The following problems are

For Questions 22-27 The following problems are

For Questions 22-27 The following problems are

For Questions 22-27 The following problems are

For Questions 22-27 The following problems are based on a new version of the Fundraiser model to analyze how many t-shirts and hoodies John and Suzy each should make. The Solver Sensitivity Report for the optimal solution to this model is shown below. The actual model is not in the Excel file for this assignment (but you could recreate it if you wanted to). In this formulation, John and Suzy both make $ 10/hr. John prints a t-shirt in 6 minutes and a hoodie in 12 minutes. Suzy prints a t-shirt in 5.4 minutes and a hoodie in 18 minutes. A t-shirt costs $5 and after printing sells for $15. A hoodie costs $10 and after printing sells for $30. The fundraisers forecast that they can sell 150 t- shirts and 125 hoodies. Variable Cells Final Value Reduced Cost Objective Coefficient Allowable increase Allowable Decrease 0 $B$23 Numberto Pruduce-John t-shirts $C$23 Numberto Produce - John hoodies $B$24 Numberto Produce - Surry t-shirts $C$14 Numberto Pruduce-Sury hoodies 100 150 25 18 9.1 17 1130 1130 1 Constraints Naine $B$25 Total Production t-shirts $C$25 Total Production hoodies $B$19 Labor Hours John Used $B$20 Labor Hours Suzy Used Final Value 150 125 20 2 Shadow Price 9.1 17 Constraint Allowable Allowable R IL Side Ingrease Degrease 150 100 125 30 2015 30 1F1309 0 Question 22 2.5 pts If the margin on t-shirts made by John were $10.00, how many t-shirts would he produce? 09 zero 100 more than zero Question 23 2.5 pts If 35 hours of Suzy's time were available, how much could profit increase? $45.50 $0.00 Cannot be determined from the report $85 Question 24 2.5 pts If Suzy's hours were decreased to 20, how much would profit decrease? more than zero, but how much cannot be determined from the shadow price o profit would actually increase zero, because John would produce what Suzy would not produce in that hour zero, because 20 is within the allowable decrease from 30, the current constraint. Question 27 2.5 pts What would we be willing to pay to obtain two additional hours of John's time? $5.00 $10.00 or less Between $5.00 and $6.00 Between $10.00 and $12.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!