Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Solve ASAP and attach link to Excel file also. Question: Minnesota Fabrics produces three sizes of comforters (full, queen, and king size) that it

Please Solve ASAP and attach link to Excel file also.image text in transcribed

Question: Minnesota Fabrics produces three sizes of comforters (full, queen, and king size) that it markets to major retail establishments throughout the country. Due to contracts with these establishments, Minnesota Fabrics must produce at least 120 of each size comforter daily. It pays S0.50 per pound for stuffing and S0.20 per square foot for quilted fabric used in the production of the comforters. It can obtain up to 2700 pounds of stuffing and 48,000 square feet of quilted fabric from its suppliers Labor is considered a fixed cost for Minnesota Fabrics. 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 as well as the selling price to the retail stores for each size comforter Stuffing (pound) quilted fabric cutting timesewing time Selling price (sq. ft.) (minutes)(minutes) full queen king 75 95 19S 26S 32S 4 a. Write a Linear Programming model and solve it using Excel solver to determine the daily production schedule that maximizes total daily gross profit ( selling price - material costs.). How much of the available daily material and labor resources would be used by this production schedule? b. What is the lowest selling price for queen size comforters that Minnesota Fabrics could charge while maintaining the optimal production schedule recommended in part a

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