Please provide excel formulas T2034ProofingStatistics56 Sales78910 Merchandise11 Computer1213 Expenses14Cost of Goods15 Cost of Merchandise1617181920212223 Income24Net Income25 Profit Margin26<EspressoDrip CoffeeFood/BeverageATotal Sales◄PayrollInternetBuildingAdvertisingCapital AssetsMiscellaneousTotal Exp>$$$=$$$$$vAccessibilityAccessibilityX VBJAN9,980 $910 $$$$12,000 $325 $2,100 $600 S$ 1,500 $$ 1,300 $$ 28,715 $SC DFirst Quarter ForecastfxFEB$ 3,235 $16,400 $ 17,200 $ 16,500 $7,400 $7,500 $7,800 $6,100 $6,000 $5,800 $1,500 $1,400 $1,300 $750 $ 650 $31,950 $ 32,750 $700 $32,300 $Changes Comment Comment Comment Comment CommentsChangesComments10,150 $980 $12,000 $325 $2,100 $600 $1,500 $1,300 $28,955 $MAR9,945 $1,050 $12,000 $325 $2,100 $600 $1,500 $1,300 $28,820 $3,795 $ 3,480 $ETOTALFirst QFirst Q Goal SeekCalculation Mode: Automatic Workbook StatisticsFAVG50,100 $ 16,70022,700 $ 7,56717,900 $ 5,9674,200 $1,4002,100 $ 70097,000 $32,33330,075 $10,0252,940 $ 98036,000 $12,000975 $ 3256,300 $2,1001,800 $ 6004,500 $, 1,5003,900 $1,30086,490 $28,83010,510 $ 3,503GProportion522318421003534217255100Minivan LoanH+JKLAdd New NetIncome Sparkline forthe months of Jan.to Mar. in Cell H24.NotesM DE3,480 $325 $975 $ 3252,100 $6,300 $2,100600 S1,800 $ 6001,500 $4,500 $1,5001,300 $3,900 $1,30028,820 $ 86,490 $ 28,830F10,510 $ 3,503Q Goal SeekGApply the Goal Seekanalysis to increasethe Profit Margins ofJan., Feb., and Mar. to30% by changing thePayroll in each month.117255100Minivan LoanH+KLAdd New NetIncome Sparkline forthe months of Jan.to Mar. in Cell H24.MYour statement about the 2 Net Income Sparklines:INO

The question deals with budget preparation and goal seek analysis.

5 Sales Espresso Drip Coffee Food/Beverage Merchandise B 3 Computer Total Sales Expenses Cost of Goods Cost of Merchandise Payroll Internet Building Advertising Capital Assets 0 1 2 3 Income 4 Net Income 5 Profit Margin 26 Miscellaneous Total Exp $ $ $ $ $ $ $ es $ 6,100 $ $ 1,300 $ $ 750 $ $ 31,950 $ 32,750 $ $ sss S JAN $ 16,400 $ 7,400 $ es 9,980 $ 910 $ $ 1,500 $ 1,300 $ $ 28,715 $ 2,100 $ 600 $ FEB 9,945 $ 1,050 $ 12,000 $ 12,000 $ 12,000 $ 325 $ 325 $ 325 $ 2,100 $ 2,100 $ 600 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 1,300 $ 28,955 $ 28,820 $ 3,235 $ 17,200 $ 16,500 $ 7,500 $ 7,800 $ 6,000 $ 1,400 $ 650 $ MAR 10,150 $ 980 $ 5,800 $ 1,500 $ 700 $ 32,300 $ 3,795 $ 3,480 $ TOTAL AVG Proportion 50,100 $ 16,700 22,700 $ 7,567 17,900 $5,967 4,200 $1,400 2,100 $ 700 97,000 $32,333 30,075 $ 10,025 2,940 $ 980 36,000 $12,000 975 $ 325 6,300 $2,100 1,800 $ 600 4,500 $, 1,500 3,900 $1,300 86,490 $28,830 10,510 $3,503 = First Q First Q Goal Seek Calculation Mode: Automatic Workbook Statistics 52 23 18 4 2 100 35 3 42 1 7 2 in 5 5 100 Minivan Loan +