Answered step by step
Verified Expert Solution
Link Copied!

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?
image text in transcribed
image text in transcribed
1. April Fashions manufactures denim children's clothing for sale through independent retailers. Production will soon begin on a new line of fashions, but Apriltstill 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. April formulated the nroblem as a linear nomorn and used Solver to ohtain the solution and sensitivitv rebort below: a) How many of each product should be made? b) 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? 1. April Fashions manufactures denim children's clothing for sale through independent retailers. Production will soon begin on a new line of fashions, but Aprilstill has a significant supply of fabric for last year's line. They would like to use up what they can, but bave 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, scwing and packaging. a) How many of each product should be made? b) 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 enployees on the packaging line are willing to work overtime. The added cost will be $22 per bour. Should you aceept their offer? Explain why or why not. If you use the overtime, how much should you use? d) The skirts bave 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 ptoducts change? Explain. c) A retailer has asked that you make denim jackets. Fstimated profit is $5 per jacket, but it will require 1.2 sq meters of denim, 4 minutes of cuting, 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

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_2

Step: 3

blur-text-image_3

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

Principles Of Financial Management

Authors: Haim Levy, Marshall Sarnat

1st Edition

0137097751, 978-0137097753

More Books

Students also viewed these Finance questions

Question

What is a dummy variable?

Answered: 1 week ago

Question

Discuss Ms. Lincolns level of commitment to occupational safety.

Answered: 1 week ago