Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. April Fashions manufactures denim children's clothing for sale through independent retailers. Production will soon begin on a new line of fashions, but April still
1. April Fashions manufactures denim children's clothing for sale through independent retailers. Production will soon begin on a new line of fashions, but April still has a significant supply of fabric for last year's line. They would like to use up what they can, but have allocated only one week of production time before the changeover to the new designs. They have chosen to focus on at most 4 products: pants, skirts, vests and caps. Each item requires denim, cutting, sewing and packaging. A 1 A6-#1 April Fashion Manufacturing 2 3 4 5 6 April formulated the problem as a linear program and used Solver to obtain the solution and sensitivity report below: B C D E F G H N O P K M Microsoft Excel 12.0 Sensitivity Report Worksheet: [1205-SA6-08F.xlsx]A6-#1 Report Created: 10/30/2008 5:37:55 PM Adjustable Cells 12 13 7 Demin (sq m) S Cutting (min) 9 Sewing (min) 10 Packaging (min) 11 14 15 16 17 #made profit S Constraints a) b) Pants Skirts Vests P S V 350 850 3 2 1 3 7 1 0.6 623 1 0 2 0.7 3 36 6 1 Caps C 0 1 0.3 3231 Total 2750 860 2750 5000 1200 1000 3000 5000 1200 Cell Name SBS4 #made P SC$4 #made S SDS4 #made V SES4 #made C Constraints Name Cell SFS7 Demin (sqm) SFS8 Cutting (min) SFS9 Sewing (min) SFS10 Packaging (m 3 1.6667 Final Reduced Objecti Allowah Allowable Value Cost Coeffic Increas Decrease 350 1 850 0 0 2 2 1 0 0 -0.75 -1 1 0.71429 0.75 1E+30 1 1E+30 Final Shadow Constri Allowab Allowable Value Price R.H. Si Increas Decrease 860 0 1000 1E+30 140 2750 0 3000 1E+30 250 5000 0.25 5000 1000 1400 1200 1.25 1200 200 485.714 How many of each product should be made? Suppose that 100 square meters of denim is found to be damaged and cannot be used. What is the impact on total profits? c) Suppose employees on the packaging line are willing to work overtime. The added cost will be $22 per hour. Should you accept their offer? Explain why or why not. If you use the overtime, how much should you use? d) The skirts have met with unexpectedly high interest and it has been possible to increase the price such that the profit is now $2.50 per skirt. Should the quantities of the various products change? Explain. e) A retailer has asked that you make denim jackets. Estimated profit is $5 per jacket, but it will require 1.2 sq meters of denim, 4 minutes of cutting, 6 minutes of sewing and 1 minute of packaging. Should you make the jackets? Explain. If not, how much must the price be increased to make them profitable to make?
Step 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