Question

In: Operations Management

The XYZ Company plans to allocate some or all of its monthly advertising budget of $75,000...

The XYZ Company plans to allocate some or all of its monthly advertising budget of $75,000 in the Mankato area. It can purchase local radio spots at $120 per spot, local TV spots at $500 per spot, and local newspaper advertising at $260 per insertion.

     The company's policy requirements specify that the company must spend at least $30,000 on TV and allow monthly newspaper expenditures up to $15,000. The company’s internal policy also requires that the company must buy at least 100 radio spots.

The payoff from each advertising medium is a function of the size of its audience. The general experience of the firm is that the values of insertions and spots in terms of "audience points" (arbitrary unit), are as given below:

        ---------------------------------------------------------------------------

         Radio                            150 audience points per spot

         TV                                180 audience points per spot

         Newspapers                   280 audience points per insertion

        ---------------------------------------------------------------------------

Let x1 = no. of Radio spots to be purchased,

        X2 = no. of TV spots to be purchased, and

        X3= no. of Newspaper insertions.

Max    150x1+ 180x2 + 280x3

s.t.

      (1)      120x1 + 500x2 + 260x3 <= 75,000     (Advertising Budget)

      (2)                      500x2                  ≥ 30000      (Expenditure on TV)

          (3)                                      260x3 <= 15000      (Expenditure on Newspaper)

          (4)                  x1                            ≥   100         (Number of radio spots)

              X1, x2, x3 >= 0

LINEAR PROGRAMMING PROBLEM

MAX 150X1+ 180X2 + 280X3

Subject to:

  1. 120X1 + 500X2 + 260X3 < 75000
  2. 500X2 > 30000
  3. 260X3 < 15000
  4. 1X1 > 100

      OPTIMAL SOLUTION

      Objective Function Value =       67050.000

                Variable                   Value                   Reduced Costs

              -------------                 ---------                --------------------

                 

                    X1                        375.000                     0.000

                    X2                          60.000                     0.000

                    X3                            0.000                   45.000

               Constraint               Slack/Surplus            Dual Prices

             ---------------            -------------------          ---------------

                      1                             0.000                          1.250

                      2                             0.000                        - 0.89

                      3                     15000.000                          0.000

                      4                         275.000                          0.000

    

                            

  OBJECTIVE COEFFICIENT RANGES

      Variable               Lower Limit          Current Value            Upper Limit

   ---------------           ------------------      -------------------      ----------------------

            X1                            129.231                   150.000           No Upper Limit

            X2                 No Lower Limit                 180.000                        625.000

            X3                 No Lower Limit                 280.000                        325.000

RIGHT HAND SIDE RANGES

       Variable               Lower Limit          Current Value            Upper Limit

   ---------------           ------------------      -------------------      ----------------------

            1                        42000.000               75000.000           No Upper Limit

            2                                0.000               30000.000                    63000.000

            3                                0.000               15000.000           No Upper Limit

            4                 No Lower Limit                 100.000                        375.000

11. Suppose that the rating of the newspaper is increased from 280 to 330 audience points. Which one of the following is true? (4 points)

  1. Current optimal solution remains unchanged because 330 is outside the range of optimality for x3.
  2. Current optimal solution will be changed because 330 is outside the range of optimality for x3.
  3. Current dual prices should be changed because 330 is outside the range of optimality for x3.
  4. Current optimal solution remains unchanged because x3= 0.
  5. The Optimal value of the objective function (i.e., 67,050 points) remains unchanged because x3 = 0.

12. Suppose that the company eliminates the requirement that the company must buy at

     least 100 radio spots (Constraint 4)? Which one of the following is true? (4 points)

  1. Current optimal solution remains unchanged because Constraint 4 is non-binding.
  2. Current optimal solution will be changed because Constraint 4 is non-binding.  
  3. Current dual prices should be changed because Constraint 4 is non-binding. .
  4. The sensitivity analysis cannot be conducted because Constraint 4 is non-binding.
  5. The problem must be re-solved.

Solutions

Expert Solution

Question 11:

Answer: b. Current optimal solution will be changed because 330 is outside the range of optimality for x3.

The rating of the newspaper is covered under Objective coefficient ranges. Hence, shadow price is not applicable to this value. The optimum solution will change since allowable upper limit is 325 only and we are increasing beyond 325.

Question 12.

Answer: a. Current optimal solution remains unchanged because Constraint 4 is non-binding.

As seen from the OPTIMAL SOLUTION, there is a slack of 275 available in Constraint 4. Hence, this constraint is non-binding. Change in non-binding constraint does not have an impact if it is deleted.

_______________________________________________________________________________________

In case of any doubt, please ask through the comment section before Upvote/downvote.


Related Solutions

The XYZ Company plans to allocate some or all of its monthly advertising budget of $75,000...
The XYZ Company plans to allocate some or all of its monthly advertising budget of $75,000 in the area. It can purchase local radio spots at $120 per spot, local TV spots at $500 per spot, and local newspaper advertising at $260 per insertion.      The company's policy requirements specify that the company must spend at least $30,000 on TV and allow monthly newspaper expenditures up to $15,000. The company’s internal policy also requires that the company must buy at...
A political candidate has an advertising budget of $250,000. The candidate wishes to allocate the advertising...
A political candidate has an advertising budget of $250,000. The candidate wishes to allocate the advertising money among four media outlined in the table below. The candidate’s goal is to reach the largest possible audience. To ensure the candidate reaches a diverse audience, the table also displays a minimum and maximum level of ads that should be placed. Use Excel’s solver to assist the candidate in spending its advertising budget by selecting an effective media mix. Medium     Audience Cost...
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising...
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least two and a half times the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar...
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising...
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $2,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least three times the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on...
XYZ plans to re-structure its capital due to the demand of some shareholders who would with...
XYZ plans to re-structure its capital due to the demand of some shareholders who would with draw their shares from company’s equities. To maintain a level of total assets, the company should either increase long-term debts or issue common shares to other shareholders (could be through private placement or initial public offering).Explain how does XYZ re-structure its capital ( Using 2 theories of capital structure)
Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of...
Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of 36,000 units. Company policy is to end each month with merchandise inventory equal to 20% of budgeted sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. The company budgets sales of 180,000 units in October. Sales (Units) Purchases (Units) July 210,000 228,000 August 300,000 302,000 September 310,000 284,000 Prepare the merchandise purchases budgets for the months of...
Company XYZ is considering project A. Project A requires an initial investment of $75,000.
Company XYZ is considering project A. Project A requires an initial investment of $75,000. It generates $35,000 each year for the coming 3 years. What is the discounted payback period for this project if the proper discount rate is 18%?
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements and presents the following data for one department for February 2020. Present a schedule that shows the ending inventory at cost and highlight that cell with color and a thick outside border. Label each column and row clearly so your workpaper can be used by other people in Marquette's accounting department. Present the cost to retail percentage as a percentage with two...
In 2017, XYZ Corporation has $75,000 of income before taxes in its accounting records.   In computing...
In 2017, XYZ Corporation has $75,000 of income before taxes in its accounting records.   In computing income tax expense, XYZ makes the following observations of differences between the accounting records and the tax return: An accelerated depreciation method is used for tax purposes. In 2017, XYZ reports $6,000 more depreciation expense for tax purposes than it shows in the accounting records. In 2017, XYZ collected $60,000 from a business that is renting a portion of its warehouse. The $60,000 covers...
In 2017, XYZ Corporation has $75,000 of income before taxes in its accounting records.   In computing income...
In 2017, XYZ Corporation has $75,000 of income before taxes in its accounting records.   In computing income tax expense, XYZ makes the following observations of differences between the accounting records and the tax return: An accelerated depreciation method is used for tax purposes.  In 2017, XYZ reports $6,000 more depreciation expense for tax purposes than it shows in the accounting records. In 2017, XYZ collected $60,000 from a business that is renting a portion of its warehouse.  The $60,000 covers the rental payment...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT