Question: Please answer using this format as quickly as possible!! Thank you!! A company needs to purchase several new machines to meet its future production needs.





Please answer using this format as quickly as possible!! Thank you!!
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 300 units per day respectively. The plant can only afford $500,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 Enter the numbers in the appropriate cells of range B5:F10 in the Excel spreadsheet to solve this problem based on the following formulation. Let Xi- number of machines of type i purchased MAX: 200X1+250X2+300X3 Subject to: 2X1 +3X2+5X320 80X1 +50X2 +40X3-500 X1, X2, X3 0 Machine MachineMachine 2 Number to Total 2 Output: buy Machine output 4 5 Requirements: 6 Square feet 7 Cost Used Available What value do you put in cell F6? Answer What value do you put in cell B6? Answer What is the formula that you would put in cell F3? Answer What value do you put in cell C7? Answer: What value do you put in cell C7? Answer What value do you put in cell D3? Answer What value do you put in cell B7? Answer 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 300 units per day respectively. The plant can only afford $500,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 Enter the numbers in the appropriate cells of range B5:F10 in the Excel spreadsheet to solve this problem based on the following formulation. Let Xi- number of machines of type i purchased MAX: 200X1+250X2+300X3 Subject to: 2X1 +3X2+5X320 80X1 +50X2 +40X3-500 X1, X2, X3 0 Machine MachineMachine 2 Number to Total 2 Output: buy Machine output 4 5 Requirements: 6 Square feet 7 Cost Used Available What value do you put in cell F6? Answer What value do you put in cell B6? Answer What is the formula that you would put in cell F3? Answer What value do you put in cell C7? Answer: What value do you put in cell C7? Answer What value do you put in cell D3? Answer What value do you put in cell B7
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
