Develop a spreadsheet model and solve the problem

Reference no: EM131997105

Question: You may use Microsoft Excel or any other technology to complete the question as long as the explanation is clear and a screen shot is included.

Please complete the following problems:

1. The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25 percent 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 twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget to maximize the value of total audience exposure?

a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximaize the value of total audience exposure.

b. Develop a spreadsheet model and solve the problem using Excel Solver.

2. The following questions refer to a capital budgeting problem with six projects represented by binary variables a, b, c, d, e, and f.

a. Write a constraint modeling a situation in which two of the projects 1, 3, 5, and 6 must be undertaken.

b. Write a constraint modeling a situation in which, if project 3 or 5 is undertaken, they must both be undertaken.

c. Write a constraint modeling a situation in which project 1 or 4 must be undertaken, but not both.

d. Write constraints modeling a situation where project 4 cannot be undertaken unless projects 1 and 3 are also undertaken.

e. Revise the requirement in part (d) to accommodate the case in which, when projects 1 and 3 are undertaken, project 4 must also be undertaken.

Reference no: EM131997105

Questions Cloud

Determine how much will you pay for the policy : The Maybe Pay Life Insurance Co. is trying to sell you an investment policy that will pay you and your heirs $29,000 per year forever.

How the borders of the new europe and the us have changed : Discuss the similarities and/or differences between the external borders of New Europe and the U.S. - Mexico border?

Particular emphasis on separation of power : The text highlights which of the following two of our Founding Fathers and the authors of sections of the Federalist Papers who have contributed

What is the discounted payback period : MC Qu. 78 A project has an initial cost of $icos.. A project has an initial cost of $8,700 and produces cash inflows of $2,700, $4,900, and $1,700.

Develop a spreadsheet model and solve the problem : The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio.

Describe the operating leverage of your current employer : In your words, describe operating leverage and how it might be useful to you. How would you describe the operating leverage of your current or previous employer

What additional information would be helpful : From the above statement what additional information would be helpful?

Find increase in company value : The Maxwell Company is financed entirely with equity. The company is considering a loan of $1.9 million. The loan will be repaid in equal principal installments

Confidence interval for the average amount of time : What is the 99% confidence interval for the average amount of time all web customers of her company will spend visiting the new website?

User Account

All Pages