Reference no: EM131037020
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?
|
Determine at the instant just alter launch
: With the conventional definitions of r- red θ- coordinates relative to the Oxy coordinate system, determine at the instant just alter launch. Neglect aerodynamic drag.
|
|
Bmw selective target marketing
: 1. What are the pros and cons to BMW's selective target marketing? What has the firm done well over the years and where could it improve? 2. BMW's sales slipped during the worldwide recession in 2008 and 2009. Is its segmentation strategy too sel..
|
|
Research project on the sociology of shyness
: At Cardiff University, Susie Scott has been conducting a doctoral research project on the sociology of shyness, an innovative topic for the sociological imagination. The study involved in-depth interviews and an email discussion group, both with p..
|
|
Determine the magnitude of the total acceleration of a
: determine the magnitude of the total acceleration of A in terms of if the slotted arm revolves with a constant counterclockwise angular rate
|
|
Determining the 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 n..
|
|
Create and maintain an efficient and safe workplace
: Employees have a right to privacy, but employers also have a right to create and maintain an efficient and safe workplace. Do you think that existing laws strike an appropriate balance between employers' rights and employees' rights?
|
|
Determine the magnitude of the acceleration of the pin p
: The slotted arm OA forces the small pin to move in the fixed spiral guide defined by r = Kθ Arm OA starts from rest at θ = π/4 and has a constant counterclockwise angular acceleration.
|
|
Identifying any new relevant job listings
: Monster.com will then search for and list all the jobs that match the criteria. Uses also have the ability to click on the link "Email me Jobs" to send users e-mails identifying any new relevant job listings. Monster.com uses __________ to send it..
|
|
Understanding of omani history and evolution
: Aim To provide the student with good understanding of Omani history and evolution, people of Oman and their culture and heritage - Gain knowledge of global and regional influences on Omani evolution
|