The property manager of city government issues chairs

Assignment Help Operation Management
Reference no: EM132186026

Could you please walk me through how to complete this problem using Microsoft Excel Solver?

The property manager of a city government issues chairs, desks, and other office furniture to city buildings from a centralized distribution center. Like most government agencies, it operates to minimize its costs of operations. In this distribution center, there are two types of standard office chairs, Model A and Model B. Model A is considerably heavier than Model B, and costs $20 per chair to transport to any city building; each model B costs $14 to transport. The distribution center has on hand 400 chairs–200 each of A and B.

The requirements for shipments to each of the city's buildings are as follows:

Building 1 needs at least 100 of A

Building 2 needs at least 150 of B.

Building 3 needs at least 100 chairs, but they can be of either type, mixed.

Building 4 needs 40 chairs, but at least as many B as A.

(Hint: there are eight decision variables because we need to know how many of each chair (A and B) to deliver to each of the four buildings).

Reference no: EM132186026

Questions Cloud

Discuss the connection of maslow hierarchy : Discuss the connection of Maslow's hierarchy of needs to the environment of a health care workplace.
Find a speech or a writing topic : Do you have trouble deciding on a topic? Have you used any of the techniques discussed in this week's lesson, or do you plan to try one?
The reason for low organizational performance : Poor written and oral communication of the organization’s objectives is often given as the reason for low organizational performance.
Determine the diluted earnings per share for the year : ABC Company had 3 million shares of common stock outstanding for the entire year. The company reported net income of $8 million. ABC has a tax rate of 40%.
The property manager of city government issues chairs : The property manager of a city government issues chairs, desks, and other office furniture to city buildings from a centralized distribution center.
How international community created a liberal economic order : PSCI 207 International Politics Assignment - Explain how the international community created a liberal economic order and system of trade after WWII
What are netflix internal environment analysis : What are Netflix's Internal Environment Analysis - Resources and Capabilities?
Benefit analysis and cost-effectiveness analysis : What is the difference between cost/benefit analysis and cost/effectiveness analysis? Which would you use and why?
How you developed your target price projection : Referring to Block, Hirt & Danielsen (2017) and your other research you may perform, compute and display your calculations projecting your one-year target.

Reviews

Write a Review

 

Operation Management Questions & Answers

  Why do employees join unions

Joining Unions: Why do employees join unions? What are the advantages and disadvantages of being a union member?

  What is optimal order quantity

EOQ. A jewelry firm buys semiprecious stones to make bracelets and rings. What is the optimal order Quantity?

  Cardiologist to your practice for continuity of care

Your internal medicine practice is considering adding a cardiologist to your practice for continuity of care.

  Objective of financial reporting

Homer Winslow and Jane Alexander are discussing various aspects of the FASB’s concepts statement on the objective of financial reporting.

  Consider the mcdonnell-douglas test

Michael Roberts, an African American truck driver, applied in person for a tractor trailer truck driver position at a trucking company on March 22, 2007 in response to a newspaper advertisement.  What issue(s) are involved in the above case – conside..

  Reimbursement and payment services for insured populations

In the last decade more and more health services are being outsourced to private companies, many of which are located or operational outside of the United States. Examples of this include interpretation of x-rays, data management of health informatio..

  When selecting a candidate for a retail associate position

Discuss your decision-making process for determining a final match when selecting a candidate for a retail associate position.

  Values lie behind attitudes and behaviors

One response to an unfamiliar culture is curiosity. Values lie behind attitudes and behaviors.

  The business of quality attracts many philosophers

The business of quality attracts many philosophers who mostly agree on the basic concepts. It is known, however, that W. Edwards Deming does not emphasize measuring cost of quality while Philip Crosby does. Imagine you have been tasked with creating ..

  Identify the core values of the psychiatry profession

Sarah Harris, your supervisor at the pretrial diversion program where you are interning, obtains a case that she asks you to work on independently.

  Prevent idle time on the part of the power shovel

What is the minimum number of trucks that will prevent idle time on the part of the power shovel?

  Calculate touring enterprises'' weighted average cost of

Calculate Touring Enterprises' weighted average cost of capital (WACC). Work as follows: first, compute the after-tax cost of debt, then compute the cost of equity. Cite both formulas, and show all your work.

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