Question: I want an answer please with steps Problems 16. A company needs to purchase several new machines to meet its future production needs, It can
I want an answer please with steps

Problems 16. A company needs to purchase several new machines to meet its future production needs, It can purchase three different types of machines A, B, and C. Each machine A costs $80,000 and requires 2,000 square feet of floor space. Each machine B costs $50,000 and requires 3,000 square feet of floor space. Each machine C costs $40,000 and requires 5,000 square feet of floor space. The machines can produce 200, 250 and 350 units per day respectively. The plant can only afford $300,000 for all the machines and has at most 20,000 square feet of room for the machines. The company wants to buy as many machines as possible to maximize daily production. What values would you enter in the spreadsheet for the following cells for this Excel spreadsheet implementation of the formulation for this problem? Let X) = number of machines of type i purchased MAX 200%| + 250X2 + 300X3 Subject to: 2X1 + 3X2 +5X3 $ 20 80%| + 50%2 # 40X3 5 500 X1.X2.X320 V C D F Capital 2 3 Machine 4 Machine I Machine 2 Machine 5 Number to Total Output: 6 Machine 200 250 300 7 8 Requirements; Lise Available 9 Square feet 2,00 3,00 5.0 20.00 10 Cost 80.000 50.0 40.000 500.0 A. Objective Cell: B. Variables Cells: C. Constraints Cells
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
