Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started