Question: Production and Operations Management TEST I LINEAR PROGRAMMING A kitchen utensils manufacturer produces two products namely: spoon and fork The labor required to produce 1
| Production and Operations Management | ||||||||
| TEST I | LINEAR PROGRAMMING | |||||||
| A kitchen utensils manufacturer produces two products namely: spoon and fork | ||||||||
| The labor required to produce 1 unit of spoon is 3 minutes and 2 minutes for a unit of fork. | ||||||||
| The material cost required to produce a unit of spoon is P5 pesos and P4 pesos for fork | ||||||||
| Labor is limited to 480 mins per day and P2,000 material cost. | ||||||||
| QUESTION | ||||||||
| 1 | What is the optimal number of spoons to produce? | |||||||
| 2 | What is the optimal number of forks to produce? | |||||||
| The objective of the company is profit P5 for spoon and P4.50 for fork. | ||||||||
| 3 | How much the maximized profit for the two products? | |||||||
| Instruction: | ||||||||
| Solve the above problem in Excel and Plot | ||||||||
| the Labor and Cost Constraint. | ||||||||
| Show the combined linear solution in one graph. | ||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
