Instructions:

Using the four steps to follow in formulating a linear program, model a problem that requires the use of decision-making related to the application of the use of linear programming based on the following case:

Michelle Bob has a florist on South Padre Island, she specializes in arrangements for quinceanera and other events. She usually advertises weekly in local newspapers and he is thinking of increasing the publicity for her. Before doing so she wants to evaluate the historical effectiveness of her ads. 5 weeks were sampled, the money spent and the sales volume for each is presented in the following table: Develop a regression equation that helps Michelle evaluate advertising and find the coefficient of determination for this model.

Sales (1,000) Advertising (1,000)

11 5

6 3

10 7

6 2

12 8

Once I solve it using the Excel program and the data from the problem solved to find the regression model, what does it indicate if I invest 20 dollars in advertising?