Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Star Wear Apparel Co. is known for its fashionable casual wear for men and women. Founded in Vancouver, British Columbia, the company designs and manufactures

Star Wear Apparel Co. is known for its fashionable casual wear for men and women. Founded in Vancouver, British Columbia, the company designs and manufactures hoodies and t-shirts in its Vancouver factory. It distributes these garments to its retail stores globally. The Vancouver factory employs 50 cutters and 100 tailors. Each employee works 170 hours per month. Every month, the factory stocks 10,000 metres of fabric, 60,000 metres of thread, and 5,000 buttons. Its retail stores require at least 1,500 t-shirts monthly. Other information on their operations is displayed in the table below. Use Excel's simplex LP solver tool to help the company determine how many of each garment to make to maximize its monthly profits?

Per Unit Hoodie T-Shirt

labour hours - cutter 1.8 1.25

labour hours - tailor 3.5 2.75

fabric used 2.1 1.38

thread used 12 9.6

buttons used 0 3

Contribution margin $17.68 $10.50

Demand 1,500 950

Can you please explain this in excel?

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

Bitcoin Technical Innovations From The Trenches

Authors: Sjors Provoost

1st Edition

9090360425, 978-9090360423

More Books

Students also viewed these Finance questions

Question

Which virtues characterise you?

Answered: 1 week ago