Lp solution with excel solver

Assignment Help Business Management
Reference no: EM133166549

BUS107 Quantitative Methods

1. Linear Programming (LP) Model

2. Graphical LP Solution

3. LP Solution with Excel Solver (Computer Solution)

4. Sensitivity Analysis (Changes in the Constraint Right-Hand Side/Changes in the Objective Function Coefficient)

Study Guide/Textbook: https://www.coursehero.com/file/38932636/BUS107-StudyGuidepdf/

This question is about the application of linear programming (LP). Part (b) is a continuation of Part (a), and Part (c) is not related to Parts (a) and (b). 

(a) DToys is planning a new social media and TV advertising campaign to reach people. A total budget of $30k is allocated to the campaign and the campaign must run on or within the budget. Moreover, to meet the development needs of the company, at least $10k must be allocated to each medium. It is estimated that every $1k spent on social media ad will reach 15 people and every $1k spent on TV ad will reach 10 people.

How should the budgeted amount be allocated between social media and TV? State verbally the objective, constraints and decision variables. Then formulate the problem as an LP model. After that, solve it using the graphical solution procedure. Please limit the answer to within two pages. 

(b) Show that the worth per additional $1k of budget is reaching 15 more people, which is the same as the number of people reached per $1k spent on social media ad. Interpret what this result means in terms of allocating additional budget. Please limit the answer to within one page. 

(c) Suppose your Residents' Committee (RC) invites you to give a speech introducing LP. The purpose of the speech is to attract senior citizens (over 65 years old, working in various industries before retirement, passionate about lifelong learning) to sign up for a basic LP course. The course teaches how to formulate a problem as an LP and how to solve it. Write down your complete speech, no more than four hundred words.

Reference no: EM133166549

Questions Cloud

Advantage of the working conditions : Your company appears to be taking unfair advantage of the working conditions in an overseas subsidiary in which you work. At the same time, however, your compan
Knowledge of human resource management : Take a moment to reflect on your knowledge of human resource management prior to taking this course and on what you have learned during the 10 weeks of the cour
How will artificial intelligence help in health care : How will Artificial Intelligence help in health care administration?
How does the mission and vision defined by mcb drive : 1. How does the mission and vision defined by MCB drive its organizational processes? Why is this important for any business ?
Lp solution with excel solver : 1. Linear Programming (LP) Model 2. Graphical LP Solution 3. LP Solution with Excel Solver (Computer Solution)
What services do they currently like and use : It is important that they understand the needs and preferences of this population in respect to their banking requirements
Discuss a research proposal : Discuss how a Research Proposal and a Research Report is written, highlighting in detail the key components worth noting in each stated document.
Germany on hofstede cultural dimension : Comparison between Namibia and Germany on Hofstede cultural dimension
Define security and privacy : Please answer both questions using complete sentences with at least 150 words (Combined)

Reviews

Write a Review

Business Management Questions & Answers

  Describe the project scope and project management plan

Describe the project scope and project management plan. Align your plan to the overall strategy that you had recommended to the senior executives.

  Change the title of your chart to course availability

Change the title of your chart to "Course Availability". Highlight the entire data set, and insert a pivot table on a new worksheet. For more information on how to create a pivot table.

  Reduction in the cash conversion cycle

Costco carries an average inventory of $3,000,000. Its annual sales are $20 million and its gross profit margin is 45%. The receivables conversion period

  Critically evaluate how monetary and fiscal policies

Critically evaluate how Monetary and Fiscal policies stabilise the economy in the short run and long run due to increasing Inflation rate

  Job satisfaction and organizational commitment

Compare the difference between job satisfaction and organizational commitment. Determine which is more strongly related to performance for your selected company

  Introduction to the four phases of emergency management

Give brief introduction to the four phases of emergency management. They are mitigation (or prevention), preparedness, response and recovery.

  Explore two key factor in organizations external environment

Identify two key factors in the organization's external environment that can affect its success. Provide explanation to support the rationale.

  What are their strong points and their weaknesses

What are the best web servers for e-commerce? What are their strong points and their weaknesses?

  Organizations are most strongly affected by diversity

which practices related to work attitudes in U.S. organizations are most strongly affected by diversity and suggest a strategy to address the effects.

  Cultural intelligence for leaders young

Go to Chapter 7 in the Cultural Intelligence for Leaders Young, Confident, and Moving too Fast.

  Explain the concept of debt financing

Please explain the concept of debt financing versus equity financing in relation to capital structure.

  Explain from utilitarianism point of view

How to explain from Utilitarianism point of view, banning airbnb is right?

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