Question: I have part A done I just need some help with the excel portion of the problem. 1. An e-commerce location has 2,500 cubic feet

I have part A done I just need some help with the

I have part A done I just need some help with the excel portion of the problem.

1. An e-commerce location has 2,500 cubic feet available for storage of its private label computers. The L9 computers cost $400 each and require 6 cubic feet of space; the L6 computers cost $320 each and require 5 cubic feet of space; and the L3 model costs $190 and requires 4 cubic foot of space. The demand for the L9 is at most 50 units per month, limit L9's to no more than 50 units. The wholesaler has $150,000 to spend on computers this month. Each L9 contributes $155, each L6 contributes $90, and each L3 contributes $55. Storage space should not be allocated to a partial computer, constrain the decision variables to be integers. The objective is to maximize total contribution. (10 points) a) Write the algebraic formulation for the problem (decision variables, objective function, and constraints). (5 points) b) Solve the problem using Microsoft Excel solver. How many of each computer should be stored in the space to maximize total contribution? What is the maximum total contribution possible? (5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!