Reference no: EM131922039
The production department for an aluminum valve plant is scheduling its work for next month. Each valve must go through three separate machines during the fabrication process.
After fabrication, each valve is inspected by a human being, who spends 12 minutes per valve. There are 450 inspection hours available for the month.
The time required (in hours) by each machine to work on each valve is shown in the following table. Also shown are the minimum number of valves that must be produced for the month and the unit profit for each valve. PRODUCTS DEPARTMENT V231 V242 V784 V906 CAPACITY OF EACH DEPARTMENT (hours) DRILLING 0.60 0.30 0.45 0.35 700 MILLING 0.60 0.55 0.52 0.52 950 LATHE 1.10 0.60 0.50 0.65 1100 MINIMUM OF EACH PRODUCT TYPE NEEDED 200 300 700 450 PROFIT ($/UNIT) $14 $10 $11 $12 Formulate and solve the problem in Excel to determine the number of each product to manufacture that meets the requirements and maximizes profits.
a) What is the maximum profit based on your optimal solution (the value of the objective function)?
b) How many V231's should be manufactured based on your optimal solution?
c) How many V242's should be manufactured based on your optimal solution?
d) How many V784's should be manufactured based on your optimal solution?
e) How many V906's should be manufactured based on your optimal solution?
f) What is the total number of hours used in the drilling department based on your optimal solution?
g) What is the total number of hours used in the milling department based on your optimal solution?
h) What is the total number of hours used in the lathe department based on your optimal solution?
i) What is the total number of hours used in the inspection department based on your optimal solution?
|
Write a literary analysis over one of pieces of literature
: write a minimum of a 1,000-word literary analysis over one of pieces of literature. What will help you is using the right words when you're doing your search.
|
|
What type of report might a service organization use
: What type of report might a service organization use as a marketing tool to provide potential customers information about the internal controls related.
|
|
What impact will this have on the current objective function
: A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits.
|
|
Prepare journal entries to record the transactions
: Prepare journal entries to record the above transactions assuming Urban Faith has a December 31 year end. Be sure to prepare the appropriate closing entries.
|
|
What is the maximum profit based on your optimal solution
: What is the maximum profit based on your optimal solution (the value of the objective function)?
|
|
Biggest employment challenge at their organization
: In a study of 405 nonprofits? nationwide, 87 indicated that turnover has been the biggest employment challenge at their organization. Complete parts? (a) throug
|
|
Which operation is the bottleneck
: The drilling operation occurs separately from, and simultaneously with, the sawing and sanding operations.
|
|
What is knot operating income the absorption approach for
: In 20x1, its first year of operations, K_not, Inc., manufactured 110,000 units of its single product, ties. Variable manufacturing costs were $6 per unit.
|
|
Create a profesional email asking to confirm a shipping date
: Create a profesional email asking him (Mr. Patterson) to confirm a shipping date and expected arrival date for the order in your facility in Houston.
|