I need help with question 5.

7 87% Sat 1:04 AM Q DE Messages File Edit View Buddies Window Help IMG_0513.jpeg Open with Preview coursehero.com () C Details () Homework Help - Q&A from Online Tutors - Course Hero LIBSCDde AMBbCCDdE AaBbCcDe sense to you? Normal Earn by No Spacing Howding 1 Find Ask Study Resources v Expert Tutors Contributing v No because the correlation was positive. This being said the two chemicals did have an impact on the quality. A company business data analyst discovers that units of a product sold in a specific quarter depends on a A seasonal factor (S) help from Expert Tutors b. Adverusing budget for that quarter (adb) Thus, the function which they used to compute a seasonal sale is: Unit Sold = 30 - S * v3200 + Adh The following table shows the seasonal factor (S) for a given year -by-step answers First Second Third Fourth Delivered Quarter Quarter Quarter Quarter 0,8 1.1 9 Yearly profit is calculated based on: Profit = Unit Sold * (Unit Price - Unit Cost) Unit price is $40 and unit cost is $25 and company knows that they cannot spend more than $50,000 on advertising for a given year. , attachments, and requirements so your tutor can provide a complete answer. Company sales executive wants to evenly distribute the advertising budget over 4 quarters. You think there might be a better way! A. Build a spreadsheet to show the processes of computation of profit (build your spreadsheet in Q5 worksheet). What is the objective and objective function? B. What are the Constraint functions? C. Calculate the profit by allocating the advertising budget evenly over the 4 quarters. Save the profit in a different cell as the base-case." D. Use MS Excel's Solver and maximize the profit without increasing total advertising budget and changing unit price and unit cost. Get Answer Answers in as fast as 15 minutes