Question: Use excel solver for this problem. list steps on which constraints are needed. thanks Futuris Co. considers increasing its level of automation by replacing some
Futuris Co. considers increasing its level of automation by replacing some of its old machines with modem automatic machines that require fewer operators. The company operates 48 weeks per year, 5 days per week, and 1 shift per day. Also, 4 utility workers are employed and 28 similar machines are being used, each operated by 6 direct workers. Each worker's hourly wage is $11.7. Currently, there are two models available in the market with the following specifications: Futuris Co. has allocated an annual budget of $230,000 over five years, and considers improving (decreasing) its manning level by at least 9.2%. Calculate the minimum total number of RX1 and RX 2 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 optimal numbers of RX-1 and RX-2 machines appear on the left and right sides of a decimal symbol, respectively. For example, if three RX-1 and four RX2 machines should be purchased and replaced, then the answer should be entered as 3.4
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
