Solve the problem using microsoft excel solver

Assignment Help Operation Management
Reference no: EM132677492

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.

a) Write the algebraic formulation for the problem (decision variables, objective function, and constraints).

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?

Reference no: EM132677492

Questions Cloud

Construction performance disputes : Research paper on the construction law topic of "Construction performance disputes". Expand on this topic to include disputes between subcontractors
Provide the relevant journal entries to account for the tax : Castle Towers Ltd, Provide the relevant journal entries to account for the tax effect of each of the on 30 June 2017, showing your calculations
What is the competitive bidding process : What is the competitive bidding process? Why is it used? What tools are used in evaluating suppliers?
What amount should rangoon mine report as depletion : Rangoon Mine Co. purchased a mineral mine for P2,640,000. In its 2011 statement of comprehensive income, what amount should Rangoon Mine report as depletion?
Solve the problem using microsoft excel solver : 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 tota
What are the relevant product markets : What are the relevant product markets? How concentrated is each market, and who are the competitors?
Calculate break-even point of firm and expected profit : A firm produces four products in a repetitive process facility. Product A sells for $60; its variable costs are $45. Product B sells for $150; its variable cost
How do prepare journal entries on october : How do Prepare journal entries on October. on October 1, 2020 the company had a balance of $2200 in its supplies account additional supplies were purchased
Primary concept of total productive maintenance : b) What is the primary concept of total productive maintenance (TPM)? Identify the four elements that productive maintenance includes.

Reviews

Write a Review

Operation Management Questions & Answers

  Complete with foreign key attributes for the given case

The company would also like to have a list of potential sponsors that includes each sponsor's contact information such as the name, phone number, and address.

  Elements of its observable culture as defined by senge

Using an organization with which you are familiar, identify its core culture and the elements of its observable culture as defined by Senge. What do you think would need to be changed in order to facilitate learning? What role would organizational de..

  Local adaptation and the pressure to reduce costs

The global corporate strategy is a tradeoff between the need for local adaptation and the pressure to reduce costs. This leads to the choice of global, multidomestic, transnational, or home replication strategy. Review these corporate strategies in t..

  Self-awareness and effective managerial performance

Self-awareness is a key component and necessity for successful management of oneself and others. The five key areas of self-awareness are important predictors of effective managerial performance. describe each of these areas and discuss why they are ..

  What is the best way to use the gaps model in service market

What is the best way to use the GAPS model in service marketing? Expecially when talking about a bad experience.

  Calculate annual product costs for each alternative

Ergonomics Inc. sells ergonomically designed office chairs. Calculate annual ordering costs for each alternative? Calculate annual product costs for alternative

  Implications for managing employees from such culture

Where does this culture sit in regard to these five dimensions? What are the implications for managing employees from such a culture?

  How barnes-jewish hospital trains nurses to cope

Barnes-Jewish Hospital has been ranked by U.S. News and World Report as one of the best hospitals in the United States and as its top-rated hospital for St. Louis, Missouri. The 1,258-bed not-for-profit hospital is part of the BJC HealthCare chain..

  How would an organization correct such a weakness

You give a compelling argument for your position. How would an organization correct such a weakness if this attitude/thinking actually exist?

  Should osha continue to regulate ergonomic hazards

Do you think Congress was correct in repealing the comprehensive ergonomics standard? Should OSHA continue to regulate ergonomic hazards through the General Duty clause and issue guidelines for specific industries? If not, what approach would you ..

  Where hiring within the host country is advantageous

There are situations where hiring within the host country is advantageous; however, there are also times when it might be better to send expatriate managers already employed with the company. Discuss why both of these human resource management strate..

  Facebook should balance responsibilities to shareholders

How do you think that Facebook should balance its responsibilities to its shareholders - to maximize profits-with its responsibilities to its other stakeholders

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd