Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

image text in transcribed
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

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

Horngrens Accounting The Financial Chapters

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura

10th Edition

0133117561, 978-0133117561

More Books

Students also viewed these Accounting questions

Question

7. How can an interpreter influence the utterer (sender)?

Answered: 1 week ago