Reference no: EM131121378
Herculite Suitcase Company makes four models of suitcases: Standard, Deluxe, Luxury and Exquisite. Each suitcase goes through four production stages: (1) Cutting and coloring, (2) Assembly, (3) Finishing, and (4) Quality and Packaging. The total number of hours available in each of the departments is 730, 700, 808, and 235, respectively.
Each Standard suitcase requires 0.7 hours of cutting and coloring, 0.5 hours of assembly, 1 hour of finishing and 0.1 hours of quality and packaging. Each Deluxe suitcase requires 1 hour of cutting and coloring, 0.83 hours of assembly, 0.67 hour of finishing and 0.25 hours of quality and packaging. Each Luxury suitcase requires 1 hour of cutting and coloring, 0.67 hours of assembly, 0.9 hours of finishing and 0.4 hours of quality and packaging. Each Exquisite suitcase requires 1.2 hours of cutting and coloring, 0.75 hours of assembly, 0.8 hours of finishing and 0.55 hours of quality and packaging.
The hourly cost of labor for each department is: Cutting and coloring $10; Assembly $6; Finishing $9; and Quality and packaging $8.
Material costs for each type of suitcase is as follows: Standard $6.25; Deluxe $7.50; Luxury $8.50 and Exquisite $9.50.
The sales revenue for each type of suitcase is as follows: Standard $36.50; Deluxe $39.50; Luxury $43.30 and Exquisite $55.10.
Marketing has indicated that it can sell as many units as possible of all models and must have at least 10 Deluxe models available for a favored customer
Management would like to determine how many of each type of suitcase should be produced in order to maximize profit.
1. Use the information given to formulate the appropriate quantitative model to address the problem
2. Enter relevant data, set up in Excel spreadsheet and use Excel Solver to solve the problem and generate Sensitivity and Answer reports.
3. Use the Excel Sensitivity and Answer reports to answer the following questions:
Report complete answers in your spreadsheet
a. What is the optimal solution and the maximum objective achievement?
b. How much does the profit have to increase for Luxury models in order for them to be produced?
c. What would be the effect on profit if 14 Deluxe models were required?
d. If Herculite could obtain more time in the Assembly department, what would be its value?
e. Herculite is able to obtain more labor time in the Cutting & coloring department at a cost of $1.00 per hour. Should they go ahead and add the C & C labor time? Why or why not?
|
Writing a persuasive business letter
: The purpose of this assignment is to write a persuasive letter explaining a topic to the University president "John Doe" about something you want to do or some action you would like to see occur at the university. (example: could be funding for a mob..
|
|
Continued to misunderstand
: Discuss a time at work, home, or school when you attempted to communicate with someone who failed to pay attention and/or continued to misunderstand. How did you feel?
|
|
Think about the diversity
: Take a few minutes to think about diversity and what it means to you. Write down your own definition of diversity. During the past week, in what situations have you encountered someone from a different culture, group, or background in the workplace o..
|
|
Vegetable standardization act
: Bruce Church, Inc. is a company engaged in extensive commercial farming in Arizona and California. A provision of the Arizona Fruit and Vegetable Standardization Act requires that all cantaloupes grown in Arizona "be packed in regular compact arrange..
|
|
Makes four models of suitcases
: Herculite Suitcase Company makes four models of suitcases: Standard, Deluxe, Luxury and Exquisite. Each suitcase goes through four production stages: (1) Cutting and coloring, (2) Assembly, (3) Finishing, and (4) Quality and Packaging. The total numb..
|
|
Determine sizes of first and second stages of digester
: A two stage digester is to be designed with a volatile solids loading of 0.10 lb VS/ft3/day. The first stage is to digest the sludge and the second stage is to provide 30 days storage. FLow to the digester is 12000 gal/day at 5% solids with 70% volat..
|
|
Conflict can be beneficial to organizations
: Conflict can be beneficial to organizations, stimulating cohesiveness and creativity. Of course, it can have the opposite effect. List the positiveresults that can come from organizational conflict.
|
|
Conservative-liberal and moderate
: Name two beliefs of one of the positions mentioned above (conservative, liberal, moderate) about sexual morality. What are your views on gay marriage and back up your position with some reasons?
|
|
Staying up to date in the field of marketing
: In this simulation, you continue in your role of Senior Vice President for Marketing at Enhanced Analytics, Inc., a provider of marketing and consulting services, with headquarters in Austin, Texas. Lifelong Learning - explain the importance of conti..
|