1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a & b below). This is especially important to show how you used solver.

2. One Excel Spreadsheet with clearly labeled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labeled, with formulas used appropriately. Examples of potential formats can be found in the course materials for linear programming.

Suppose that Spencer Chairs has three media options: radio, TV, and ads in Furniture World (an industry publication). The table below provides information related to the costs, exposure values (how many people see the ad and is typically derived from market research studies), and limitations on the allowable number of ads in each medium desired by the firm. The company would like to achieve a total exposure value of at least 60,000

	medium cost/ad	exposure value/ad	minimum units
radio	$500	2,000	0
tv	$2,000	4,000	10
furniture world	$200	2,700	6

A. How many of each type of ad should be placed to minimize the cost of achieving the minimum required total exposure. Which constraints are binding? Why?

B. Furniture World has instituted a policy where advertisers must run a minimum of 8 ads and has raised the cost per ad to $215. How will this change the mix of ads that Spencer Chairs runs?