Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company produces three sizes of comforters (full, queen and king size) that it markets to major retail establishment throughout the country. The unit net

image text in transcribed

A company produces three sizes of comforters (full, queen and king size) that it markets to major retail establishment throughout the country. The unit net contribution (profit) of full, queen and king size comforter is $6.5, $9 and $12, respectively. The company can obtain up to 2700 pounds of stuffing and 48,000 square feet of quilted fabric from its suppliers. It has enough labor to provide 50 hours of cutting time and 200 hours of sewing time daily. The following table gives the unit material and labor required for each size comforter. (Note that one hour has 60 minutes.) Stuffing (pounds) Quilted Fabric (square feet) Cutting Time (minutes) Sewing Time minutes) Full 3 55 3 15 Queen 14 16 King 16 95 Assuming the decision variables are continuous. In order to maximize its daily total profit, the company formulates the daily production schedule below in algebraic form: X1 = Number of full comforters produced daily X2 = Number of queen comforters produced daily X3 = Number of king comforters produced daily MAXIMIZE (Total Profit) 6.5X1 + 9X2 + 12X3 S.T. 3X1 + 4X2 + 6X3 2,700 (Stuffing) 55X1 + **X2+ 95X3 48,000 (Fabric) 3X1 + 5X2 + 6X3 3,000 (Cutting minutes) 5X1 + 6X2 + **X3 12,000 (Sewing minutes) All X's >= 0 The company inputs the model in Excel spreadsheet and uses Excel Solver to solve it. After the problem is solved using Solver, PART of the answer and sensitivity reports are given below: What is the optimal production quantity of Queen size? Please keep two decimal places

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

More Books

Students also viewed these Accounting questions

Question

Prepare and properly label figures and tables for written reports.

Answered: 1 week ago