Purchase Solution

Supply and Demand Decision

Not what you're looking for?

Ask Custom Question

Supply and Demand Decision
Several companies use warehouse inventory to stock company stores to serve the buyers. Shipping fees are a significant cost to the company. Ample Computers has warehouses in Chicago, New York, and San Diego. The firm owns company-owned, retail stores in Houston, Indianapolis, and Miami. Each warehouse has 3,000 computers in inventory. The demand for computers at the store in Miami is 2,500 or more. Indianapolis needs at least 2,500 computers, and a minimum of 4,000 computers has been requested at the Houston store.

Below are the shipping costs for each computer shipped from each warehouse to each company-owned, retail store.

Warehouse Houston Store Indianapolis Store Miami Store
Chicago $1.20 $0.60 $0.50
New York $2.00 $1.10 $0.90
San Diego $3.00 $2.60 $2.80

To minimize the shipping costs, how many computers should be shipped from each warehouse to each company-owned, retail store?

What is the correct method to set up this problem in excel solver?

Purchase this Solution
Solution Summary

A Supply and Demand Decision is studied.

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

View More Free Quizzes
Related BrainMass Solutions

  • Causes of the Changes in Supply and Demand in the Simulation

    263273 Supply and Demand A. What causes the changes in supply and demand in the simulation? b. How do shifts in supply and demand affect your decision making? c. List four key points from that were emphasized in the simulation. d.

  • Supply and Demand

    What causes the changes in supply and demand in the simulation? b. How do shifts in supply and demand affect your decision-making? c. List four key points from the reading assignments that were emphasized in the simulation? d.

  • Supply and Demand Simulation

    How do shifts in supply and demand affect your decision making? 3. List four key points that were emphasized in the simulation? 4.

  • Supply and Demand Simulation.

    How do shifts in supply and demand affect your decision making? The shifts in supply and demand affect my decision making.

  • Quantitative Methods: Transportation Problem

    max demand, however, if we do that and as we are minimizing objective functions, the solution will show all decision variables as zero.

  • Supply and Demand Simulation

    368233 Complete the Supply and Demand Simulation Address the following: What causes the changes in supply and demand in the simulation? How do shifts in supply and demand affect your decision making?

  • Linear Programming Formulation of supply chain

    Carefully define all decision variables. Decision variable Let be the number of units shipped from warehouse i to destination j, where i=1,2 (Dallas and Huntsville), and j=1,2,3(Houston, New Orleans and Atlanta).

  • Movement along and shift of the demand curve

    Difference between movement along and shift of the demand curve; an example of the role of supply and demand in decision making.

  • determine the objective function

    (Demand satisfaction) In words, our objective is to minimize the total shipping cost from sources and customers. The decision variables are shipment from sources to customers. The constraints are source capacity and demand satisfaction.

View More Related Solutions