Reference no: EM131413031
A gear manufacturer is planning next week's production for four types of gears. Because there are limited resources in the plant for production, the manufacturer can outsource the gears by purchasing these gears from a regional supplier. The regional supplier can supply a maximum of 400 units of each type of gear. The table below shows the exact demand for the gears, the revenue per unit, and the outsource cost per unit if the gears are purchased from the supplier. The manufacturer generates the same revenue per unit for the gears regardless of whether the gear is manufactured in their plant and then sold to their customers or outsourced from their supplier and then sold to their customers.
|
Gear Type
|
Gear A
|
Gear B
|
Gear C
|
Gear D
|
|
Demand
|
650
|
500
|
450
|
550
|
|
Revenue
|
$13.75
|
$12.50
|
$16.90
|
$18.50
|
|
Outsource Cost
|
$9.20
|
$9.75
|
$11
|
$11.75
|
When the gears are manufactured in the own plant, the gears must be processed through three different departments: forming, hardening, and deburring. The table below shows the processing time (in hours) for each type of gear in the departments as well as the capacity for each department and the cost per hour for processing the gears in those departments. The cost per hour for processing the gears is provided so that you can calculate the manufacturing cost.
|
Process
|
Gear A (hrs./unit)
|
Gear B (hrs./unit)
|
Gear C (hrs./unit)
|
Gear D (hrs./unit)
|
Dept. Capacity (hours)
|
Cost ($/hour)
|
|
Forming
|
.37
|
.43
|
.45
|
.52
|
500
|
$9.50
|
|
Hardening
|
.30
|
.25
|
.31
|
.40
|
400
|
$8.75
|
|
Deburring
|
.40
|
.37
|
.42
|
.32
|
400
|
$7.90
|
Formulate and solve this problem in Excel to determine the production and/or outsource plan which will meet the requirements and maximize the profit. (Hint: processing costs in the second table effect only the profit for the gears that are manufactured and not the gears that are outsourced)
a) How much profit does the company for all gears they make and buy in your solution (the value of the objective function)? (enter to the nearest integer)
b) If you could add one hour of capacity to any department to increase profit - adding one hour of capacity to which department would generate the biggest increase in profit: Forming, Hardening, or Deburring?
c) Which of the following constraints have slack? (Choose all constraints with slack): Forming, Hardening, or Deburring
d) In your solution, how many Gear C's should the company make?
e) If the cost per hour of the hardening process increases to $12/hr. - how many Gear D's should the company make with this new process cost?
|
How many are at level 3 of the full tree
: Figure 12.12 shows only part of the decision tree for the first two levels. How many entries are there at the second level of the full tree? How many are at level 3 of the full tree?
|
|
Write about the development of one of these themes
: Write about the development of ONE of these themes over the course of these three scenes. Which character seems most closely tied with your chosen theme? Explore what the character's relationships, traits, motivations, and fears reveal about your ..
|
|
Is it possible that nicoles philosophy makes sense
: If personal freedom exists, then humans are responsible for their actions." Is it possible that Nicole's philosophy makes sense? If so, what does it say about the mind, personal freedom, and responsibility?
|
|
How many entries are there at 8th and final level of tree
: If our 8 Queens algorithm tried every possible square on the board for placing each queen, how many entries are there at the 8th and final level of the full tree? What does our algorithm do to avoid having to explore so many possibilities?
|
|
Which of the following constraints have slack
: If you could add one hour of capacity to any department to increase profit - adding one hour of capacity to which department would generate the biggest increase in profit: Forming, Hardening, or Deburring? Which of the following constraints have s..
|
|
How an obstruction could influence the operation of a system
: Write an essay discussing how an obstruction could influence the operation of a fire protection system in a large, indoor self-storage facility. Discuss the differences between expected outcomes if the notification system worked properly and if th..
|
|
Why there has been such a lack of economic integration
: BUSI 464- Discuss why there has been such a lack of economic integration in the Middle East and North Africa (MENA). Do you think that the lack of integration is a result of MENA nations noninvolvement with the World Trade Organization?
|
|
Translate arguments into symbolic form- national elections
: Translate the following arguments into symbolic form.- If national elections deteriorate into TV popularity contests, then smoothtalking morons will get elected.
|
|
Translate arguments into symbolic form - huge foreign debt
: Translate the following arguments into symbolic form. - Brazil has a huge foreign debt. Therefore, either Brazil or Argentina has a huge foreign debt.
|