Can you please complete the assignment using excel solver?
boat variable cost selling price minimum
bass 12,500.00 23,000.00 70
ski 8,500.00 18,000.00 50
speed 13,700.00 26,000.00 50
fixed cost of 2,800,000.00
no more than 120 of any one boat
determine the number of boats that is must sell to break even while minimizing it total variable cost
A) formulate a linear programming model for this problem
B) solve the linear programming model that formulated