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 1 Station 2
Model a 2.53
Model b 1.81.6
Model c 22.2
Each workstation has a daily working time of 7.5 hours. Manager wants to obtain the greatest possible profit during the next 5 working days. Model a yields a profit of Rs.8.25 per unit, Model b yields a profit of Rs.7.50 per unit, Model c yields a profit of Rs.7.80 per unit. Assume that the firm can sell all its produces during this time but it must fill outstanding orders for 20 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!