Question: Solve in Excel through solver Aviation electronics produces three types of switching devices. Each type involves a two step assembly operation. The assembly times are
Solve in Excel through solver
Aviation electronics produces three types of switching devices. Each type involves a two step assembly operation. The assembly times are shown in the following table
Assembly time per unit minutes
Station Station
Model a
Model b
Model c
Each workstation has a daily working time of hours. Manager wants to obtain the greatest possible profit during the next working days. Model a yields a profit of Rs per unit, Model b yields a profit of Rs per unit, Model c yields a profit of Rs per unit. Assume that the firm can sell all its produces during this time but it must fill outstanding orders for units of each model type. Formulate the linear programming model of this problem.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
