Calendar, Budget, & CC

    create a Gantt Chart style Calendar using MS Excel, a operating Budget using MS Excel, and a Communication Confirmation Table using MS Word. You have an operating budget of $250,000 You may also use other departments operating budget to offset the cost of executing your strategies and tactics, but your actual expenses must total $250,000. With this assignment you will write the next section of your Action Plan. This section is based on the Strategies and Tactics you previously wrote in the Action Planning II section. Refer to Chapter 10 of your text and the sample papers to help you see how to add the strategies and tactics to your Calendar and Budget tables. Remember to utilize the content you have already written to help you create the overall Communication Confirmation to prove to the client that you have summarized a strategic communication plan for them. - otherwise we fall short of executing a strategic plan that is completed for our client. Calendar - Create a Gantt Chart style Calendar through public specific means, including strategies and tactics for each public. Show months, and weeks. Make it clear when you will execute both prep tactics and execution tactics. Create Calendars that are Monthly - this means you should have an operating Calendar that sees you from now - through the dates you selected in your objectives. As a reminder some of what you create is hypothetical. List the first key public in row 1 List the first strategy for that key public in row 2 List the correlating tactics for the strategy in row 2 in row 3, 4, 5, and 6 under the Tactic Column Continue listing all the strategies and Tactics that correlate with the first key public you listed Do these steps for each key public. See example Summarize Tactics for spacial purposes on your Calendar Table. Create using Excel Make sure the table is in Landscape format, Save as a PDF, merge with your written text so that you have one PDF file. Budget - Create a spreadsheet that has the following columns: Key Publics, Tactics, Detail, Quantity, Per Item Cost, Total Projected, Sponsord Credit, and Actual Projected List the first key public in row 1 List the first strategy for that key public in row 2 List the correlating tactics for the strategy in row 2 in row 3, 4, 5, and 6 under the Tactic Column Continue listing all the strategies and Tactics that correlate with the first key public you listed Do these steps for each key public. See example Include the costs for each tactic under the columns, along with the quantity - that can include hours Summarize Tactics for spatial purposes on your Budget Table. Put the total projected cost and subtotal each strategy Put the Actual projected cost and subtotal each strategy Your overall total for every tactic, for every public, should be the total budget you have been allotted. Your budget must account for every cost, this includes labor cost.- Be very detailed in the cost of executing your tactics (Remember that operating social media is not free, someone has to do it so there is a labor cost involved. Create using Excel, Make sure the table is in Landscape format, Save as a PDF, merge with your written text so that you have one PDF file. Creating the Communication Confirmation Table: Communication Confirmation Table - include all columns. Create a table in MS Word Have 7 Columns Names of the Columns: Key Public, Objectives, Self-interests, Primary Messages, Opinion Leaders, Strategies, Tactics Name of Rows: Each Key Public should be on their own Row Fill in each column based on the key public Include all tactics that you have written, summarize each one. Table needs to be in Landscape format. Include a title page Use Microsoft Excel - do not use Google Spreadsheets PAGES MUST BE IN LANDSCAPE - NO EXCEPTIONS Calendar Table in Gantt format- Made in Excel and converted to PDF Budget Table - Made in Excel and converted to PDF Communication Confirmation Table - Made in MSWord and converted to PDF Reference Page APA format Title page Abstract page Reference page Citation for all sources 12 pt. font Times New Roman font Double Space Follow the 10 step P.R. Matrix Header at the top of each page in the upper left corner Page number at the top of each page in the upper right corner Running Head Individual Case Assignment Use Microsoft Excel - do not use Google Spreadsheets Submit in CANVAS, assignment will be graded via UNICHEK Merge all of your PDF tables with your PDF text file. You may only submit one document, if you submit more than one document you will receive a zero. You will not be able to submit multiple files to Canvas, simply upload your written document, include the following: calendar, budget, communication confirmation graphs from Excel - convert them to PDF and add them to the PDF of your written document. You can do this through Adobe Acrobat or search online for a PDF Merger, The entire assignment should be submitted through CANVAS & will be graded via Turn-it-in.