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.

User Account

All Pages