O Rucklehouse Public Relations has contracted to do a survey following an election primary in NewHampshire. The firm must assign interviewers to carry out the survey. The interviews are conducted bytelephone and in person. One person can conduct 80 telephone interviews or 40 personal interviews in aday. It costs $50 per day for a telephone interviewer and $70 per day for a personal interviewer. Thefollowing three goals, which are listed in order of their priority, have been established by the firm to ensurea representative survey:a. At least 3,000 total interviews should be conducted.b. An interviewer should conduct only one type of interview each day. The firm wants to maintain its dailybudget of $2,500.c. At least 1,000 interviews should be by telephone.Formulate a goal programming model to determine the number of interviewers to hire to satisfy these goals.

The detailed solution to this question is given in Step 2.

Answered: Rucklehouse Public Relations has…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

An experiment is to be performed to determine the effectiveness of a new product promotion program. The experiment will be used to compare four different promotion techniques. Each customer will be exposed to only one of the four promotions. Customers from five different geographical regions will be considered. Customers will also be divided up into three categories by size as determined from annual sales. Customers can be exposed to their program for either three or six months. How many different configurations are there in this experiment?
A B C D F G H M N O P Raptor Consulting has three (3) projects to complete this year. They have four (4) project teams currently available. Each project team can at most do one project. Based on the mix of skills and experience on each of the teams, Raptor has developed the following estimates on time taken by each team (in days) to 2 complete each proiect. 3 4 5 6 7 8 9 10 Determine the optimal assignment of teams to projects in order minimize the total days taken to complete all the projects. 11 12 Please answer items A-E below 13 A. Formulate the problem as an assignment problem. Use worksheet tab "Q2 SS Model" to develop your formulation. 14 Use worksheet tab "Q2 SS Model" to develop your formulation 15 16 B. Solve the problem using Excel Solver. 17 Use worksheet tab "Q2 SS Model" Teams Project Team 1 Team 2 Project A 50 30 Project B 35 28 Project C 33 37 Ready Title Q1 E Accessibility: Investigate Team 3 Team 4 55 27 25 35 30 23 18 19 C. What is the optimal assignment of teams to…
A company makes 2 products A and B from 2 resources. The products have the following resource requirements and produce the accompanying profits. The available quantity of resources is also shown in the table. Management has developed the following set of goals Product 1 2 avail resources labor (hr/unit) 3 2 150 material (ounce/unit) 1 2 200 Profit($/unit) 7 6 Goal 1: Produce approximately 40 units of product 1. Goal 2: Produce approximately 70 units of product 2. Goal 3: Achieve a profit over $400. Goal 4: Consume less than 150 hours of labor Goal 5: Consume less than 200 ounces of material If the manager now wants to implement the MINIMAX objective, what would be the new objective function and the
Comprehensive Analysis of a Fortune 500 Company For this Individual Project you will Comprehensive Analysis of a Fortune 500 Company For this Individual Project you will analyze publicly available information about a Fortune 500 Company and develop an assessment of the corporate strategy and its ability to increase competitive advantage. This assignment requires you to obtain and analyze information at the company, industry and market levels using various databases and reports found in the AIU library, in addition to at least eight (8) professional or academic peer-reviewed articles.Please follow instructioons. I need 12 pages and no plagiarism. I am willing to pay 40 dololars. Click here for a tutorial on finding company information in the library. Click here for a tutorial on finding industry information in the library. Your analysis should include an in-depth review of the Company’s most recent SEC Form-10k Annual Report and Form DEF-14A Proxy Statement.…
Casper Geriatric Center, a senior medical facility located in a large hospital in New Zealand, started a procedure where their guests receive their meals in their rooms while the food is still as hot as possible. The facility will continue to prepare the food in the commissary, but will now deliver it in bulk (not individual servings) to one of three new meal serving stations in the building. From there, the food will be reheated, meals will be placed on individual trays, loaded onto a cart, and distributed to the various floors and sections of the facility. The three new serving stations are as efficiently located as possible to reach the various hallways in the facility. The purpose of the new procedure is to increase the temperature of the hot meals that the guest receives. Therefore, the amount of time needed to deliver a tray from a serving station will determine the proper distribution of food from serving station to section. The table below summarizes the time associated with…
SCM1012 – SCM Quantitative Techniques Assignment #1 The following table summarizes the key facts about two products, A and B, and the resources, Q, R, and S, required to produce them. Product A Product B Unit Profit $3,000 $2,000 Resource Usage per Unit Produced Product A Product B Amount of Resource Available Resource Q 2 1 2 Resource R 1 2 2 Resource S 3 3 4 All the assumptions of linear programming hold. Formulate and solve a linear programming model for this problem on a spreadsheet by using the Excel Solver. Determine units to produce of each unit. Note: Round your answers to 3 decimal places. Determine the total profit. Note: Round your answer to 2 decimal places.
Alebwelelapo is planning a soccer tournament for the weekend of May 29-30. The club's officers know that by April 30 they must send out acceptances to teams that have applied to enter, and by April 20 they must send out the tournament game schedule to teams that have been selected to play. Their tentative plan is to begin the initial activities for tournament preparation, including sending out the application forms to prospective teams, on January 20. Following is a list of tournament activities, their precedence relationships, and their duration in days. Activity Description A B с D E F G H | J K L M N O P Q R S T U Send application forms Get volunteer workers Line up referees Reserve fields Receive and process forms Determine age divisions Assign fields to divisions Sell program ads Acquire donated items for team gift bags Schedule games Design ads Fill gift bags Process team t-shirt orders Send acceptance letters Design and print programs Put together registration boxes (programs,…
Project management is the discipline of planning, organizing, and managing resources to bring about the successful completion of specific project goals and objectives. It involves a systematic approach to initiating, planning, executing, controlling, and closing projects within defined constraints such as time, budget, and scope. Project managers play a critical role in coordinating the efforts of team members, stakeholders, and resources to ensure that projects are delivered on time, within budget, and to the required quality standards. Effective project management requires a range of skills including leadership, communication, problem-solving, and risk management. Additionally, project managers must be able to adapt to changing circumstances, mitigate risks, and resolve conflicts to keep projects on track. By applying proven methodologies and best practices, project management helps organizations achieve their strategic objectives, improve efficiency, and deliver value to…
Mangement Project management is the discipline of planning, organizing, motivating, and controlling resources to achieve specific goals and objectives within a specified time frame. It involves identifying project requirements, defining scope, establishing timelines, allocating resources, and managing risks. Project managers oversee the execution of projects, ensuring that they are completed on time, within budget, and according to quality standards. Effective project management requires strong leadership, communication, and problem-solving skills, as well as the ability to adapt to changing circumstances and stakeholders' needs. It is crucial for achieving project success and delivering value to stakeholders. Question: How does project management contribute to organizational efficiency and effectiveness?
Jerry Lee loves sports. He has just finished up a degree in sports marketing at Sunway University in Kuala Lumpur and to his great pleasure, he is in the first month of his dream job, a sales person (the title is account manager) for small- and medium-sized accounts for the Harimau Sports Malaysia (his favourite football team). In general, he will be responsible for developing new customer relationships with companies in Kuala Lumpur and the surrounding area, as well as working on enhancing relationships with firms that are already loyal customers of the Harimau. His “product” is blocks of seats, special boxes and events at historic Shah Alam National Sports Complex, as well as Harimau promotions that can be held at various places of businesses as a marketing campaign for the customer’s business.The problem (actually its more of an opportunity) is this is a brand new position. Over the years the team has had a major account position, similar to the one Jerry now has, but more focused…
Casper Geriatric Center, a senior medical facility located in a large hospital in New Zealand, started a procedure where their guests receive their meals in their rooms while the food is still as hot as possible. The facility will continue to prepare the food in the commissary, but will now deliver it in bulk (not individual servings) to one of three new meal serving stations in the building. From there, the food will be reheated, meals will be placed on individual trays, loaded onto a cart, and distributed to the various floors and sections of the facility. The three new serving stations are as efficiently located as possible to reach the various hallways in the facility. The purpose of the new procedure is to increase the temperature of the hot meals that the guest receives. Therefore, the amount of time needed to deliver a tray from a serving station will determine the proper distribution of food from serving station to section. The table below summarizes the time associated with…
What is the difference between the analysis space and design space in an optimization process?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS