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 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

1. Which constraint(s) is/are binding (active)?

2. Interpret the dual price of 1.25 for Constraint 1.

Solutions

Expert Solution

1. Binding constraints are those constraints where the slack or surplus is 0. We can see from below table that out of the 4 constraints, Constraint 1 and Constraint 2 have 0 slack/surplus. Hence constraint 1(Advertising budget) and constraint 2 (Expenditure on TV) are binding constraints.

2. Dual price tell us by how much the value of the objective function would change in case of a unit change in the availablity of a constraint with all other conditions kept unchanged. For the given case we can see that for constraint 1, the dual price is 1.25. This means that for every $1 increase in advertising budget the value of objective function would increase by 1.25. For example if the advertising budget available was $75001 instead of $75000, the value of objective function would be 67050+1.25 = 67051.25


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 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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT