Answered step by step
Verified Expert Solution
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.
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 aStep 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