answer this using ASP solver

On the tab labeled "Original Problem", I have provided the modeling of Case 3.4 on Pages136-138. Carefully read the case in the textbook and then review the model and solver set up to familiarize yourself with the integration of the LP into Excel. On the tab labeled "Case Update", you will see there are 5 changes that must be made in the model. Using the model I have provided on the "Case Update" tab, make the required changes and re-load the solver (on the "Case Update" tab) to determine the new advertising strategy. The model should be solved only one time: after you have incorporated all 5 changes noted on the "Case Update" tab. In addition to updating the model and solver, you should provide a sentence or two to state how you addressed each change within the model. Each question is worth 16 points: 8 points for a clear, concise, grammatically correct description of the mechanical changes made to the model and 8 points for the correct solution resulting from the changes made. Questions should be answered on the "Case Update" tab and typed in unboldedblack fontright after the statement of the question. Please remember that case studies are individual effort, however, if you have questions you are urged to post a note on the course site within the discussion forum. Good luck and as always...HAVE FUN!

*********************************************************************

				Impact	Cost
Advertising Medium	Units	Min	Max	Per Unit	Total	Per Unit	Total
Half-page, Daily paper	46.0	24	48	55	2,530	$800	$36,800
Full-page, Daily paper	2.0	2	48	75	150	$1,400	$2,800
Half-page, Sunday paper	6.0	0	8	65	390	$1,200	$7,200
Full-page, Sunday paper	2.0	2	8	80	160	$1,800	$3,600
Daytime TV spot	29.6	28	84	85	2,513	$2,500	$73,900
Evening TV spot	28.0	28	56	100	2,800	$3,500	$98,000
Highway Billboards	10.0	3	10	35	350	$750	$7,500
15 second Radio spot	140.0	56	140	45	6,300	$150	$21,000
30 second Radio spot	140.0	56	140	55	7,700	$300	$42,000
Half-page, magazine	9.0	0	12	50	450	$500	$4,500
Full-page, magazine	3.0	3	12	60	180	$900	$2,700
Key Totals:	Units	Min	Max	Total:	23,523	Total:	$300,000
Daily paper ads	48.0	24	48			Budget:	$300,000
Sunday paper ads	8.0	2	8
Magazine ads	12.0	3	12

****************************************************************************

				Impact	Cost
Advertising Medium	Units	Min	Max	Per Unit	Total	Per Unit	Total
Half-page, Daily paper	0	24	48	55	0	$800	$0
Full-page, Daily paper	0	2	48	75	0	$1,400	$0
Half-page, Sunday paper	0	0	8	65	0	$1,200	$0
Full-page, Sunday paper	0	2	8	80	0	$1,800	$0
Daytime TV spot	0	28	84	85	0	$2,500	$0
Evening TV spot	0	28	56	100	0	$3,500	$0
Highway Billboards	0	3	10	35	0	$750	$0
15 second Radio spot	0	56	140	45	0	$150	$0
30 second Radio spot	0	56	140	55	0	$300	$0
Half-page, magazine	0	0	12	50	0	$500	$0
Full-page, magazine	0	3	12	60	0	$900	$0
Key Totals:	0	Min	Max	Total:	0	Total:	$0
Daily paper ads	0	24	48			Budget:	$300,000
Sunday paper ads	0	2	8
Magazine ads	0	3	12