Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. operations management
  3. 2. the queen city style company makes several line

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

Q

In a large clinical trial, 392,551 children were randomly assigned to two groups. The treatment...

Algebra
Q

why did some particles pass through the foil undeflected. why did some particles pass through the...

Chemistry
Q

O any type of microorganism bacteria O large parasites molds viruses Question 10 A high...

Biology
Q

Find the least squares solution of the system TE 2 P T 1 1 1...

Basic Math
Q

Suppose a designer has a palette of 9 colors to work with, and wants to...

Basic Math
Q

the use of technology in the industry The table below contains the responses to the...

Statistics
Q

Eank Reconclitadon Conway Company reported the following information: Required: 1. Calculate...

Accounting
Q

Cobe Company has already manufactured 25,000 units of Product A at a cost of $25...

Accounting
Q

What would the FUTA & SUTA tax be for an employee whose year-to-date earnings prior...

Accounting
Q

offer your perspective on transparency. In Chapter 3 of their book Trust and Betrayal in...

Accounting
Q

multiple cashflow 0 1 2 3 4 S Cash flow 11,100,000 12,100,000...

Finance
Q

This scenario applies to Questions 5 and 6. A buyer wants to know...

Finance