Question
In: Operations Management
The supervisor of a manufacturing plant is trying to determine how many of two parts, Part...
The supervisor of a manufacturing plant is trying to determine how many of two parts, Part X and Part Y, are to be produced per day. Each part must be processed in three sections of the plant. The time required for the production along with the profit contribution for each part are given in the following table.
|
Time required (Minutes/Unit) |
||||
| Section 1 | Section 2 | Section 3 | Profit/Unit | |
| Part X |
50 |
30 |
18 |
$2 |
| Part Y |
80 |
45 |
22 |
$3 |
| Available time (minutes) |
3600 |
2500 |
1200 |
|
No more than 60 units of Part X and up to 70 units of Part Y can be produced per day. The company already has orders for 30 units of Part Y that must be satisfied.
a. Develop a spreadsheet model and find the solution that maximizes total profit contribution. What is the value of the objective function? Enter your answer without a dollar sign.
b. Based on your answer to Question 4, what quantity of Part X should be produced to maximize profit contribution?
c. Based on your answer to Question 4, what quantity of Part Y should be produced to maximize profit contribution?
Solutions
Expert Solution
a.Using excel solver,we find the optimal solution that maximizes total profit.
Total profit=E16=SUMPRODUCT(B13:B14,B8:B9)=$ 138
Objective function value=138
In excel,
B19=SUMPRODUCT(B13:B14,B4:B5)
B20=SUMPRODUCT(B13:B14,C4:C5)
B21=SUMPRODUCT(B13:B14,D4:D5)
B22=B13
B23=B14
B24=B14
b.Quantity of Part X to be produced=24 units
c.Quantity of Part X to be produced=30 units
keosha answered 2 months agoRelated Solutions
The supervisor of a manufacturing plant is trying to determine how many of two parts, Part...
The supervisor of a manufacturing plant is trying to determine
how many of two parts, Part X and Part Y, are to be produced per
day. Each part must be processed in three sections of the plant.
The time required for the production along with the profit
contribution for each part are given in the following table. Time
required (Minutes/Unit) Section 1 Section 2 Section 3 Profit/Unit
Part X 50 30 18 $2 Part Y 80 45 22 $3 Available...
You’re trying to determine whether to expand your business by building a new manufacturing plant. The...
You’re trying to determine whether to expand your business by
building a new manufacturing plant. The plant has an installation
cost of $12.6 million, which will be depreciated straight-line to
zero over its four-year life. If the plant has projected net income
of $1,914,300, $1,967,600, $1,936,000, and $1,389,500 over these
four years, respectively, what is the project’s average accounting
return (AAR)?
Manufacturing Company is trying to decide whether to continue manufacturing a part or to buy it...
Manufacturing Company is trying to decide whether to continue
manufacturing a part or to buy it from an outside supplier. The
part, called CIO, is a component of the company’s finished product.
The following information was collected from the accounting records
and production data for the year ending December 31, 2018. 1. 8,100
units of CIO were produced in the Machining Department. 2. Variable
manufacturing costs applicable to the production of each CIO unit
were: direct materials $4.58, direct labor...
A cyber cafe currently operating from 11am to 8pm daily. The supervisor is trying to determine...
A cyber cafe currently operating from 11am to 8pm daily. The
supervisor is trying to
determine whether they should extend the closing time from 8pm to
12 midnight. He
estimates that the revenue will increase by RM250 per hour if he
extends hours. However,
he will have to pay a part-time worker for 4 additional hours at
RM20/hour.
Additional miscellaneous costs of RM500 will be incurred and
utility costs will be increased
by RM15 per hour.
a) Should they extend...
A local gift shop is trying to determine how many photos frames to order. The shop...
A local gift shop is trying to determine how many photos frames
to order. The shop feels it will sell approximately 800 photos
frames in the next year at a unit price of R18.00.The wholesale
price that the store pays per photo frame is R12.00. The cost of
carrying one photo frame is estimated at R1.60 per year, while
ordering costs are estimated at 825.00 per batch ordered.
REQUIRED
(a) Explain the meaning of economic order quantity (EOQ) and
reorder...
Lemington’s is trying to determine how many Jean Hudson dresses to order for the spring season....
Lemington’s is trying to determine how many Jean Hudson dresses
to order for the spring season. Demand for the dresses is assumed
to follow a normal distribution with mean 400 and standard
deviation 100. The contract between Jean Hudson and Lemington’s
works as follows. At the beginning of the season, Lemington’s
reserves x units of capacity. xxLemington’s must take delivery for
at least 0.8xdresses and can, if desired, take delivery on up to
xdresses. Each dress sells for $160 and...
The management of Shatner Manufacturing Company is trying to decide whether to continue manufacturing a part...
The management of Shatner Manufacturing Company is trying to
decide whether to continue manufacturing a part or to buy it from
an outside supplier. The part, called CISCO, is a component of the
company’s finished product.
The following information was collected from the accounting records
and production data for the year ending December 31, 2020.
1. 8,100 units of CISCO were produced in the Machining
Department.
2. Variable manufacturing costs applicable to the production of
each CISCO unit were:
direct...
The management of Pina Manufacturing Company is trying to decide whether to continue manufacturing a part...
The management of Pina Manufacturing Company is trying to
decide whether to continue manufacturing a part or to buy it from
an outside supplier. The part, called CISCO, is a component of the
company’s finished product.
The following information was collected from the accounting records
and production data for the year ending December 31, 2017.
1. 7,900 units of CISCO were produced in the Machining
Department.
2. Variable manufacturing costs applicable to the production of
each CISCO unit were:
direct...
The management of Shatner Manufacturing Company is trying to decide whether to continue manufacturing a part...
The management of Shatner Manufacturing Company is trying to
decide whether to continue manufacturing a part or to buy it from
an outside supplier. The part, called CISCO, is a component of the
company’s finished product.
The following information was collected from the accounting records
and production data for the year ending December 31, 2020.
1. 8,000 units of CISCO were produced in the Machining
Department.
2. Variable manufacturing costs applicable to the production of
each CISCO unit were:
direct...
The management of Shatner Manufacturing Company is trying to decide whether to continue manufacturing a part...
The management of Shatner Manufacturing Company is trying to
decide whether to continue manufacturing a part or to buy it from
an outside supplier. The part, called CISCO, is a component of the
company’s finished product.
The following information was collected from the accounting records
and production data for the year ending December 31, 2020.
1. 8,000 units of CISCO were produced in the Machining
Department.
2. Variable manufacturing costs applicable to the production of
each CISCO unit were:
direct...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- More and more adults are considering commuting to work by bicycle rather than car, but few...
- Please answer these questions Data Processing and Analysis using python. Thank you In statistics, an outlier...
- Write a function file that accepts each of the four vectors as inputs. The function file...
- Kant says that to act morally is to act out of duty. How does this differ...
- Suppose you are trying to determine the capacity (in gallons) of the gas tank needed on...
- List the arithmetic operators used in BASIC and state their priorities of execution in a statement....
- Describe the espoused values of a company you have worked for (or been exposed to -...
ADVERTISEMENT