2. The Queen City Style Company makes several lines of skirts, dresses, and sport coats. Recently,...

90.2K

Verified Solution

Question

Operations Management

2. The Queen City Style Company makes several lines of skirts,dresses, and sport coats. Recently, a consultant suggested that thecompany reevaluate its South Islander line and allocate itsresources to products that would maximize contribution to profitsand to overhead. Each product requires the same polyester fabricand must pass through the cutting and sewing departments. Thefollowing data were collected for the study: Product ProcessingTime (hr) Material (yd) Max. Demand Cutting Sewing Skirt 1 1 1 -Dress 3 4 1 - Sport coat 4 6 4 150 The cutting department has 1000hours of capacity, sewing has 1600 hours of capacity, and 800 yardsof material are available. Each skirt contributes $8 to profits andoverhead; each dress, $10; and each sport coat $35.

a. Specify the objective function and constraints for thisproblem and Use Excel Solver to solve the problem, and thengenerate Answer Report and Sensitivity Report. What is the best mixthat maximizes the profit? What are the binding constraints?

Answer & Explanation Solved by verified expert
3.9 Ratings (404 Votes)
Pleaseplease please LIKE THIS ANSWER so that I can get a small benefitPleasea Specify the objective function and constraints for    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students