Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make a Spreadsheet Model for this problem and find the optimal solution using solver Quick-Print Limited is a garment manufacturing company that specializes in producing
Make a Spreadsheet Model for this problem and find the optimal solution using solver
Quick-Print Limited is a garment manufacturing company that specializes in producing commemorative garments immediately following major sporting events like the World Cup, Asian games, etc. The company has been granted a general license to produce and sell garments featuring the winning cricket team in the coming World Cup. The company has developed four types of garments that are ready for production; T-shirt, Sweatshirt, Polo-shirt, and Crew-shirt. All the above mentioned garments can be made using some of the 2750 sq. meter of the available knitted fabric. The company has to complete all production within 48 hours after the final match, at which time a trailer truck will pick up the shirts. The production team can work around the clock. The truck has enough capacity to accommodate 950 standard-size boxes. A standard-size box holds 12 garments. The company has budgeted a maximum of Rs. 8.5 million for the production run. The management has estimated that there is a sufficiently large demand for T-shirts and Polo-shirts, but not for the other two types. Their forecasted demand is 1200 for Sweat-shirts and 1700 for the Crew-shirts. Moreover, the management has already accepted an order to produce 500 Polo-shirts for one of its clients. The resource requirements, unit costs, and profit for each type of garment are shown in the following table: The company wants to know how many units of each type of garment to produce in order to maximize the total profitStep 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