Reference no: EM131437807
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?
|
Customer profitability segmentation
: Describe the logic behind ‘customer profitability segmentation’ from the company point of view. Do you think this is an effective segmentation strategy? Explain.
|
|
Most of companys profits come from few customers
: The 80/20 concept suggests that most of a company’s profits come from a few customers. Assume literally the 80/20 split is true for a company. As a marketing manager, would you recommend that the company ignores the 80% of customers it makes very lit..
|
|
Review the national transformation program
: Locate strategic goals and targets related for the Ministry of Health. Select a single strategic objective of the Ministry of Health. Search for current policy(ies) related to your selected strategic objective
|
|
Digital research in relation to an underperforming brand
: MKT3001 Marketing Research Assignment. The first assignment will assess your selection, use and presentation of digital research in relation to an "underperforming brand"
|
|
Production department for aluminum valve plant is scheduling
: 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..
|
|
Describe the provisional annual results and revenue
: The total estimated number of visitors (guest nights) for this year is 50,000. The results follow a regular pattern; there are no unexpected cost fluctuations beyond the seasonal trading pattern shown above.
|
|
What is the break-even point
: Assume a fixed cost of $1,200, a variable cost of $7.00, and a selling price of $8.50. What is the break-even point? Break-even point units b. How many units must be sold to make a profit of $500.00? How many units must be sold to average $0.25 prof..
|
|
Calculate safety stock in inventory
: What is the proper formula to use to calculate safety stock in inventory?
|
|
Two key domains of human resource management
: Two key domains of human resource management are workforce planning/ recruitment and employee retention. Describe several human resource functions that fall under each and describe their importance to human resource management.
|