Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started