Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

please solve using solver and show all formulas (SUM, SUMPRODUCT, CONSTRAINTS, etc.) image text in transcribed
image text in transcribed
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

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

Million Air Exclusive Strategies For Pilots To Build Significant Wealth

Authors: Andy Garrison

1st Edition

1541383095, 978-1541383098

More Books

Students also viewed these Finance questions

Question

When and how do brain cells die, and what are the consequences?

Answered: 1 week ago