Question: Solve using excel (linear programming)| A factory wants to automate. The factory operates 50 weeks per year, 6 days per week, and 1 shift per

 Solve using excel (linear programming)| A factory wants to automate. The

Solve using excel (linear programming)| A factory wants to automate. The factory operates 50 weeks per year, 6 days per week, and 1 shift per day. Also, 3 utility workers are employed and 25 similar machines are being used, each operated by 9 direct workers. Each worker's hourly wage is $12.5 Currently, there are two models available in the market with the following specifications: They have an annual budget of $302,000 over five years, and considers improving (decreasing) its manning level by at least 6.3%. Calculate the minimum total number of x and y machines that can be replaced using the allocated budget, while satisfying the manning level target. Report your answer as a single number, in which the numbers of x and y machines appear on the left and right sides of a decimal symbol

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!