The Strollers-to-Go Company makes lightweight umbrella-type strollers for three different groups of children. The TiniTote is designed specifically for newborns who require extra neck support. The ToddleTote is for toddlers up to 30 pounds. Finally, the company produces a heavy-duty model called TubbyTote, which is designed to carry children up to 60 pounds. The stroller company is in the process of determining its production for each of the three types of strollers for the upcoming planning period.
The marketing department has forecast the following maximum demand for each of the strollers during the planning period: TiniTote 180, TubbyTote 70, and ToddleTote 160. Strollers-to-Go sells TiniTotes for $63.75, TubbyTotes for $82.50 and ToddleTotes for $66. As a matter of policy, it wants to produce no less than 50% of the forecast demand for each product. It also wants to keep production of ToddleTotes to a maximum of 40% of total stroller production. The production department has estimated that the material costs for TiniTote, TubbyTote, and ToddleTote strollers will be $4, $6, and $5.50 per unit, respectively. The strollers are processed through fabrication, sewing, and assembly workstations. The metal and plastic frames are made in the fabrication station. The fabric seats are cut and stitched together in the sewing station. Finally, the frames are put together with the seats in the assembly station. In the upcoming planning period, there will be 620 hours available in fabrication, where the direct labor cost is $8.25 per hour. The sewing station has 500 hours available, and the direct labor cost is $8.50 per hour. The assembly station has 480 hours available, and the direct labor cost is $8.75 per hour. The standard processing rate for TiniTotes is 3 hours in fabrication, 2 hours in sewing, and

1 hour in assembly. TubbyTotes require 4 hours in fabrication, 1 hour in sewing and 3 hours in assembly, whereas ToddleTotes require 2 hours in each station.
The Excel layout and LP Sensitivity Report for Strollers-to-Go€™s problem are shown in Screenshots 4-12A and 4-12B, respectively. Each of the following questions is independent of the others.
(a) How many strollers of each type should Strollers-to-Go make? What is the profit? Which constraints are binding?
(b) How much labor time is being used in the fabrication, sewing, and assembly areas?
(c) How much would Strollers-to-Go be willing to pay for an additional hour of fabrication time? For an additional hour of sewing time?
(d) Is Strollers-to-Go producing any product at its maximum sales level? Is it producing any product at its minimum level? Source: Professors Mark and Judith McKnew, Clemson University.

Transcribed Image Text:

FG 1 Strollers-to-Go Compar y 4 Solution value 100.00 35.00 90 price per unit $63.75 $82.50 $66.00$15,202.5 6 Material cost per unit SE.00 5.60 $1,105 Labor cost perunit 50,50 £9.25 61 12,011.2 8 Profit 10 Fabrication 12 Assembly 8.76 9.60 S2.086 Constraints 4.0 1.0 3.0 2.0 1.0 1.0 620.00 fzd$8.25 415.00 -60dS8.60 385.00 48058.75 100.00 18 13 Tinitte demand 14 1:6 oddletote demand demand 1.0 35.00 7 90.00 <16 0.4 1.0 max pr 0.4 0 0.00