Write out objective function as the linear functions

Assignment Help Operation Management
Reference no: EM132131230

Assignment

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 ccntcr has on hand 400 chairs-200 cach 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.

Questions:

I) Please formulate this problem and write out objective function and constraints as the linear functions of decision variables.

2) Set up the problem in excel and solve it using solver. What are the optimal solution and optimized Z value? Please save your optimal solution in your submitted file.

Reference no: EM132131230

Questions Cloud

Population standard deviation : Using a random sample of n = 36, the sample mean is 2.92. Suppose that the population standard deviation is s=0.18.
What are the null and alternative? hypotheses : What are the null and alternative? hypotheses? Upper H0?: p=0.53 versus Upper H1?: p?0.53 ?(Round to two decimal places as? needed.)
How nurses can assist in effectively managing patient care : Review the Institute of Medicine's 2010 report "The Future of Nursing: Leading Change, Advancing Health." Write a 750-1500 word paper discussing the influence.
What score cuts off the bottom : The population standard deviation of the test is s=14. What score (rounded to two decimals) cuts off the bottom 5% of the scores?
Write out objective function as the linear functions : The property manager of a city government issues chairs, desks, and other office furniture to city buildings from a centralized distribution center.
State the null and alternate hypothesis : (a) State the null and alternate hypothesis. (b) Determine which distribution to use for the test statistic, and state the level of significance.
Write the law of motion for k : Assume there is no population growth or technological progress. Capital depreciation rate delta = 20%, saving rate s = 10%. Write the law of motion for k
What is the probability that a park in california : a. What is the probability that a park in California is selected? b. What is the probability that a park is selected from California, New York, or Texas?
Develope a memo to a prospective employer : Outline what you specifically accomplished, assuming these projects were implemented, and their estimated impacts on the business.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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