JMerced Assignme... . Last Modified: vie. at 9:22 p. m. V Search AutoSave On Insert Draw Page Layout Formulas Data View Automate Help ile Home a Review Custom Conditiona Calibri - 12 A A = ag $ ~ % 9 Format as Paste B E v 00 Cell Styles Font Alignment Number Sty Clipboard 20 : XVxy B C G H Part 1 of task 4 is to use the regression formula you created above to calculate sales volume (x 10 units) by quarter for 2019, including for the year, based on the various Advertising expenditures (x $10). Next, with a sales value of $250, a margin of $125 per unit, and an annual overhead costs per year of $200 per year (excluding advertising costs), calculate the EBIT Task 4 (Earnings Before Interest, Taxes, and Depreciation for each level of advertising) and Sales $ per year for each level of Advertising Expenditure. Be extra careful of your units. You have a capacity to produce around 2 units per week, what is the maximum you should plan on spending for advertising per year? Sales in Units (X100) See below Advertising Expenditure per Total Year Full Year EBIT Full Year Sales quarter (X $100) Q1 Forecast Q2 Forecast Q3 Forecast Q4 Forecast Forecast (Units) (Units) (Units) (Units) S S (Units) $1.0 2.4 2.4 2.4 2.4 9.7 2,425.5 $1.5 0.0 $3.0 0.0 $3.5 0.0 $4.0 0.0 $4.5 0.0 $5.0 0.0 $5.5 0.0 $6.0 0.0 $6.5 0.0 $7.0 0.0 $7.5 0.0 $9.0 0.0 $10.0 0.0 Simple Lineare Regression Multiple Linear Regression Data Analysis Questions U ... + ady 7x Accessibility: Investigate