Below is the question:

Cost Estimate - Exercise " Consider each of these scenarios and create an estimate for the planned work. " Create the annual budget estimate for a marketing department - Future Year. You do not need to spread the estimate across the 12 months, just the total amount. The actual spending for the current year through October is shown. The budgeted numbers for November and December are included to reach the forecast. The assumptions for the upcoming year are: a. Current operations should be continued at approximately the same level unless otherwise noted. b. Allow for an average of 2.8% pay increase. C . Two new fulltime staff added in July to support entry into the government sales market. The appropriate escalation in travel and training should be made to account for the increased headcount. d. Continue the shift to social media marketing by moving another $100,000 from Advertising to Social Media. e . Expect 5% increase in convention and tradeshow costs. f . Project Mars is complete. g. Project Jupiter will launch in March. There is an additional $80,000 budgeted for marketing the product launch of Jupiter. h . Project Saturn continue throughout the year. There is $80,000 budgeted for marketing in this project during this time. i. Project Neptune will start in February and launch in November. There is $75,000 budgeted for Marketing in this project. Marketing Department Budget and Actuals ($ thousands) 1-Nov Account Budget Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Forecast Forecast Actuals + Jan Feb Mar Apr May Jun Ju Aug Sep Oct Nov Dec Forecast Variance Headcount - Full time 12 12 11 11 12 11 10 11 12 2 12 12 12 11.5 Headcount - Part time 12 0.5 1 1 2 2 3 3 2 1 2 3 2 2 2.0 0.0 D.O Personnel $1,334.0 $103.3 $94.4 $96.5 $106.1 $99.5 $95.0 $98.1 $106.5 $108.8 $111.1 $111.2 $111.2 $1,241.7 $92.3 Travel $130.0 $13.8 $9.3 $10.3 $11.2 $12.4 $18.8 $9.2 $5.4 $12.3 $11.2 $10.0 $10.0 $133.9 Advertising -$3.9 $400.0 $28.5 $19.2 $19.2 $103.8 $19.2 $19.2 $19.2 $19.1 $19.2 $51.2 $50.0 $30.0 $397.8 $2.2 Social Media $100.0 $5.3 $5.3 $8.3 $5.3 $8.3 $12.7 $5.3 $5.3 $8.3 $5.3 $6.0 $10.0 $85.4 $14.6 Conventions & tradeshows $230.0 $0.0 $5.8 $1.6 $43.5 $94.7 $21.8 $0.0 $o.O $11.2 $42.1 $5.0 so.o $225.7 $4.3 Customer outreach $150.0 $7.5 $10.0 $10.1 $12.2 $21.6 $16.9 $12.5 $9.6 $15.3 $12.8 $10.0 $10.0 $148.5 $1.5 Training & development $30.0 $0.0 SO.O $8.4 $0.0 $0.0 $6.7 $0.0 $0.0 $9.4 $0.0 $5.0 $0.O $29.5 $0.5 Project Mars $38.0 $23.2 $19.7 $6.4 $1.1 $0.0 $0.0 $0.0 $o.0 $0.0 $0.O $0.0 $0.O $50.4 Project Jupiter $12.4 $94.0 $3.4 $3.6 $4.5 $16.3 $8.2 $7.4 $5.6 $4.7 $8.9 $9.7 $10.0 $10.0 $92.3 $1.7 Project Saturn $16.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.O $0.0 $0.0 $0.0 $3.2 $6.0 $6.0 $15.2 $0.8 Total $2,522.0 $185.0 $167.3| $165.3 $299.5 $263.9| $198.5 $149.9 $150.6| $193.4 $246.6 $213.2| $187.2| $2,420.4 | $101.6Marketing Department Estimate Marketing Department Budget E$Thousands] Budget Headcoum - Fumime Headcoum - Pan Time - Travel - Social Media - Customer Outreach - Project Jupiter - Project Neptune Why did the budget increa5e\\decrea5e? Explain ***Fill in green cell with "correct" financial?\" "his is quantity, not dollars 'his is quantity, not dollars 'his is dollars "his is dollars 'his is dollars 'his is dollars "his is dollars 'his is dollars "his is dollars 'his is dollars 'his is dollars "his is dollars 'his is dollars