Question: please solve using solver and show all formulas (SUM, SUMPRODUCT, CONSTRAINTS, etc.) 22 Consider the Strollers-to-Go production problem (Problem 20). (a) Suppose that Strollers-to-Go could

22 Consider the Strollers-to-Go production problem (Problem 20). (a) Suppose that Strollers-to-Go could purchase additional fabrication time at a cost of $10.50 per hour. Should it be interested? Why or why not? What is the most that it would be willing to pay for an additional hour of fabrication time? (b) Suppose that Strollers-to-Go could only purchase fabrication time in multiples of 40 -hour bundles. How many bundles should it be willing to purchase then? \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & C & D & E & F & G & H \\ \hline 1 & Strollers-to-Go C & & iny & & & 3:10 & in & \\ \hline 2 & & & & & & 3! & & \\ \hline 3 & & \begin{tabular}{|l|l|} TiniTote T \\ \end{tabular} & TubbyTote & ToddleTote & & & & \\ \hline 4 & Solution value & 100.00 & 35.00 & 90.00 & & & & \\ \hline 5 & Selling price per unit & $63.75 & $82.50 & $66.00 & $15,202.50 & & & \\ \hline 6 & Material cost per unit & $4.00 & $6.00 & $5.50 & $1,105.00 & & & \\ \hline 7 & Labor cost per unit & $50.50 & $67.75 & $51.00 & $12,011.25 & & & \\ \hline 8 & Profit & $9.25 & $8.75 & $9.50 & $2,086.25 & & & \\ \hline 9 & Constraints & & & & & & & Cost \\ \hline 10 & Fabrication & 3.0 & 4.0 & 2.0 & 620.00 & & 620 & $8.25 \\ \hline 11 & Sewing & 2.0 & 1.0 & 2.0 & 415.00 & & 500 & $8.50 \\ \hline 12 & Assembly & 1.0 & 3.0 & 2.0 & 385.00 & = & 90 & \\ \hline 18 & Tubbytote min prod & & 1.0 & & 35.00 & >= & 35 & \\ \hline 19. & Toddletote min prod & & & 1.0 & 90.00 & >= & 80 & \\ \hline 20 & & & & & LHS & Sign & RHS & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
