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
Get step-by-step solutions from verified subject matter experts
