How would an increase in advertising budget affect the optimal production plan?

Assume each department claims to require a proportional amount of advertising budget in order to attain the projected sales for each of their products. Calculate the portion of advertising budget for each product as a percentage of total Sales determine how much advertising budget each product should be allocated. Now, allocate the new advertising budgets for each product proportionally in cells B15 thru E15. Do Not Re-Run Solver! What is the profit impact and are there any issues between the RHS and LHS demand constraints is this a viable approach? (1 points)

DATA

Advertising $18,000

Table $0 Floor $0 Ceiling $0 Pendant $0

max (Profit) = $9,044,480