please answer the four parts of the question using formulas. please show work using written formulas, not excel

4-24. 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 waants. Tote, TubbyTote, and ToddleTote strollers will be $4,$6, and $5.$0O or respectively. The strollers are processed through fabrication, assembly workstations. The metal and plastic frames are made in thin, cation station. The fabric seats are cut and stitched together in the station. Finally, the frames are put together with the seats in the sem assempor station. In the upcoming planning period, there will be 620 hours available has 500 hours available, and the direct labor cost is $8.50 per hourtition assembly station has 480 hours available, and the direct labor cost is sin8 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 Figure 4.30: Excel Layout for Strollers-to-Go Company Microboft Excel 14.0 Sensitivity Report Problems 4.24to27. Surollers to.Go Compeny Figure4.31: Solver Sensitivity Report for Strollers-to.Go Company 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? Suppose that Strollers-to-Go could purchase fabrication time only in multiples of 40 -hour bundles. How many bundles should it be willing to purchase then? Suppose that Strollers-to-Go (Problem 4-24) is considering the production TwinTotes for families who are doubly blessed. Each TwinTote would TwinTotes for families who are doubly blessed. Each TwinTote wo $7.10 in materials, 4 hours of fabrication time, 2 hours of sewing time, and, hours to assemble. Would this product be economically attractive to man ture if the sales price were $86 ? Why or why not? 4-24. 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 waants. Tote, TubbyTote, and ToddleTote strollers will be $4,$6, and $5.$0O or respectively. The strollers are processed through fabrication, assembly workstations. The metal and plastic frames are made in thin, cation station. The fabric seats are cut and stitched together in the station. Finally, the frames are put together with the seats in the sem assempor station. In the upcoming planning period, there will be 620 hours available has 500 hours available, and the direct labor cost is $8.50 per hourtition assembly station has 480 hours available, and the direct labor cost is sin8 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 Figure 4.30: Excel Layout for Strollers-to-Go Company Microboft Excel 14.0 Sensitivity Report Problems 4.24to27. Surollers to.Go Compeny Figure4.31: Solver Sensitivity Report for Strollers-to.Go Company 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? Suppose that Strollers-to-Go could purchase fabrication time only in multiples of 40 -hour bundles. How many bundles should it be willing to purchase then? Suppose that Strollers-to-Go (Problem 4-24) is considering the production TwinTotes for families who are doubly blessed. Each TwinTote would TwinTotes for families who are doubly blessed. Each TwinTote wo $7.10 in materials, 4 hours of fabrication time, 2 hours of sewing time, and, hours to assemble. Would this product be economically attractive to man ture if the sales price were $86 ? Why or why not