Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

A convention center is considering expanding its facilities to include at least 5 small (400 sq ft) conference room, 10 medium (750 sq ft) conference rooms, and 15 large (1050 sq ft) conference rooms. The cost of this expansion is $18,000 for each small conference room, $33,000 for each medium conference room and $45,150 for each large conference room. The budget for this project is limited to one million dollars and the expansion space to 25,000 sq ft. The first goal of the company is to meet the expansion targets for small, medium and large conference rooms with highest priority to the large rooms, followed by the medium rooms and finally the small rooms. As a second goal, the company does not want to exceed the space allocated for expansion and finally its third goal is not go over budget. a) Formulate a goal program to help the company meet its goals according to the given priorities. Clearly define your decision variables, constraints and objective(s) b) Implement the model in Excel and solve it to find the solution. Make sure that you save each scenario or iteration as a separate sheet (within the same file) and include a snapshot of your solution in the report.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92590046

Have any Question?


Related Questions in Operation Management

1 discuss the aspects of total quality management tqm and

1. Discuss the aspects of Total Quality Management (TQM) and how they apply in service- and product-based businesses. 2. Discuss the Importance of Marketing for the Success of a Business? 3. Price discrimination makes pe ...

1 discuss the impact of management myopia and

1) Discuss the impact of management myopia and organizational culture on the globalization of a corporation? 2) Giving examples to show the differences between ethnocentric and polycentric orientation. 3) List and descri ...

1 list and describe in your own words the steps in the

1. List and describe in your own words the steps in the typical buying process. How does the type of buying situation affect these steps? How can a professional sales person add value in each of the steps in the buying p ...

In week one you learned a market consists of consumers and

In week one you learned a market consists of consumers and potential consumers and their desire for specific products. Companies have the tedious task of designing a marketing strategy to place the organization in the co ...

What in your opinion will be the major impact of the

What in your opinion will be the major impact of the Walmart decision to purchase FOB from its suppliers? The current stated objective is to reduce transportation costs on freight inbound to Walmart’s distribution center ...

1 what may be some possible challenges for firms to develop

1. What may be some possible challenges for firms to develop organisational ambidexterity capability? A. Staffs are not able to think out of the box in conducting exploratory innovation. B. Companies, especially small co ...

1 how could a compnies keeping records and information

1. How could a compnies keeping Records and information management could have helped avoiding a bribery scandal. 2. What are the 3 main ways in which we view the world as right / wrong, etc.? 3. Decide which of the three ...

1 in your company what steps would you take to ensure there

1. In your company, what steps would you take to ensure there is no earnings disparity for full-time male and female workers? Explain how prevalent it is or is not in your industry and why? 2. 1. Do you think it is okay ...

1 the manager of electronic instruments retail inc just

1. The manager of Electronic Instruments Retail Inc. just received the forecast for the next year. The company expects to sell around 55000 keyboards, the annual carrying cost is $7 per unit and ordering cost is $300. Ho ...

1 what are intermediate sanctions in what circumstances

1. What are Intermediate sanctions? In what circumstances might intermediate sanctions be appropriate? Explain 2. Is access to health care a right or a privilege? Why? Explain your answer using what you have learned abou ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As