Question: Please solve using excel solver, show steps and graph in excel. *Please type, DO NOT Draw* Elizabeth Bailey is the owner and general manager of

Please solve using excel solver, show steps and graph in excel. *Please type, DO NOT Draw*

Elizabeth Bailey is the owner and general manager of Princess Brides, which provides a wedding planning service in southwestern Louisiana. She uses radio advertising to market her business. Two types of ads are availablethose during prime-time hours and those at other times. Each prime-time ad costs $390 and reaches 8,200 people, while the off-peak ads each cost $240 and reach 5,100 people. Bailey has budgeted $1,800 per week for advertising. Based on comments from her customers, Bailey wants to have at least two prime-time ads and no more than six off-peak ads.

(a). Formulate this as a linear program.

(b). Find a good or optimal integer solution for part (a) by rounding off or making an educated guess at the answer.

(c.) Solve this as an integer programming problem using a computer.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!