I want to know what is the maximum profit for the solution. Can you please use excel to show steps so I can follow? Thank You.
Table 109 Ahaberdashery produces scarves, ascots, and capes. The haberdashery makes $4 prot for each scarf, $2 for an ascot, and $5 for a cape. In addition, they are able to enjoy some economies of scale if the batch exceeds one scan', ascot, or cape so they always make at least two consecutive units of each item. For a scarf, the additional prot is 23 2; for an ascot, the prot made by making consecutive Items results in an extra 1.1A2; and for a cape, the bump is 0.80 2. There is also an extra profit due to the synergy of the scarves, ascots, and capes that adds an additional SAC. It takes 9 minutes to produce a scarf, 13 minutes to produce an ascot and 30 minutes to produce a cape. There is also a nonlinear element to the usage oftime govemed by the double the product of scarves, ascots and capes produced. There is a total of 50 hours available for labor each week. Shipping poses another issue for the haberdashery, packaging and loading trucks for online orders is time consuming and that function is handled by the haberdashery owner's mother who comes in after her afternoon walk around a local almostideserted mall. it takes 1.5 minutes to pack and load a scarf, 2.5 minutes to pack and load an ascot, and 3.5 minutes to pack and load a cape. There is also a cross product term for packing and loading that is 0.158A+ 0.0?580 + 0.025AC that must be considered. The haberdasher's mother is available only 30 hours a week, but the haberdasher is prepared to lay down the law and insist she stop this mall walking foolishness and devote herself completely to his business. For the time being, consider her time as only 30 hours. Thanks to some arcane law governing haberdasheries, there must be at least 50 scarves, 100 ascots, and 25 capes produced each week. Use Solver to determine an integer solution to the haberdashery problem described in Table 109. What is the maXimum profit? 0 $142,025.00 0 $191,345.00 0 $197,616.80 0 $266,736.80