Herculite suitcase company case

Assignment Help Operation Management

Reference no: EM132267290

Herculite Suitcase Company Case

Herculite Suitcase Company makes four models of suitcase : 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 hours available in each of the department is 730,700,808, and 235, respectively.

Each Standard suitcase requires 0.7 hours of cutting and coloring,0.5 hours assembly, 1 hour of finishing and 0.1 hours of quality and packaging. Each Deluxe suitcase require 1 hour of cutting and coloring,0.83 hours of assembly,0.67 hour 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 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 Cost 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 $44.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 the profit.

1. Use the information given to formulate the appropriate quantitative model to address the problem

Enter the relevant data, set up in excel spreadsheet and use Excel Solver to solve this problem and generate sensitivity and answer report.

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 produce ?

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 and 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?

Reference no: EM132267290

Questions Cloud

Organizational learning takes place at organizational level : Which process of organizational learning takes place at the organizational level?

Whom does he credit with the expansion of democracy : hat was Zinn's main point in the article? Specifically, what or whom does he credit with the expansion of democracy in America?

Describe several operational and behavioral benefits : Describe several operational and behavioral benefits that are generally attributed to a participative budgetary process. Identify at least four deficiencies.

What are the legal implications-record keeping requirements : What are the legal implications/record keeping requirements that were not met by Adam?

Herculite suitcase company case : Herculite Suitcase Company makes four models of suitcase : Standard, Deluxe, Luxury, and Exquisite.

The reasonable person standard does not apply to novices : The reasonable person standard does not apply to novices. What are the foreseeable consequences of the following negligent act?

How do we use technology and data to touch the human soul : What is the correlation between the technology of data to Rembrandt using brushes and paint?

What are the decentralized global branding issue : Developing the appropriate and relevant hypotheses to help guide your market research and strategic decision making is critical. If your hypotheses.

Which of the contract elements : Which of the following "contract elements", if present in the written contract, usually takes the form of stipulating the choice of law,

User Account

All Pages