You own a service business in town.  In 2021, you had sales of $3,000,000.  Your scan margin rate was 40%.   Your expenses were $600,000 with half of them in promotional planning components. You are starting the promotional planning process for 2022.  You expect your business to be 15% greater than it  was in 2021.  Set a reasonable promotional planning budget using a % of Sales budgeting approach. Determine the annual budget by promotional planning bucket and build the promotional plan for the full year by  month in excel showing specific activities planned.  Show the promotional spend by month and its percent of total  by month. Consider any seasonality your business may experience throughout the year. Use the template provided to create your promotional plan.   Lastly, create a donut chart with the  % of total promotional dollars spent by bucket.

Business Description: Sales Budget 2022 Promotional Planning Budget Promotional Planning Bucket Promotional Dollars Spent % of total Specific actions/events by month Objective from promotional activity Promotional Dollars Spent % of total Specific actions /events by month. Obiective from promotional activity Promotional Dollars Spent % of total Specific actions/events by month Objective from promotional activity Promotional Dollars Spent % of total Specific actions/events by month Objective from promotional activity Promotional Dollars Spent % of total Specific actions/events by month Objective from promotional activity January February March April May June Advertising Sales Promotion Personal Selling. Public Relations. Direct/Digital Marketing. July August September October November December Total