In the following assignment, you will utilize both Microsoft Word and Microsoft Excel to demonstrate competency in Microsoft Office software.
The purpose of Part 1 is to utilize a template in Microsoft Excel to create a spreadsheet and an associated visual aid. As a sales manager at Lopes Athletic Productions, a company specializing in fitness video production, you are required to report your sales numbers weekly to the vice president of sales.
Create an Excel spreadsheet that provides the following information. Label each column with the following headings:
Total Sales for Each Type of Video
Total Sales of All Videos
Percentage of Total Sales for Each Type of Video
Use Formulas to Calculate All Totals
A Chart That Summarizes the Sales Data
The data needed for the spreadsheet is as follows:
Pilates sold 156 videos at $29.99 each.
Step sold 392 videos at $14.99 each.
Weight Training sold 147 videos at $54.99 each.
Kickboxing sold 282 videos at $29.99 each.
Yoga sold 165 videos at $34.99 each.
Add a second worksheet to your workbook
Insert a chart in a bar format linked to data on your first worksheet.
This bar chart should reflect the total sales of each type of video.
The purpose of Part 2 is to utilize a business memo template in Microsoft Word to create a memo discussing your results. Write a memo (250 words minimum) to inform employees of the importance of fitness in the workplace.
Ensure that the memo contains the following elements:
Fictional company information, including name, phone number, street address, city, state, ZIP, website address, and e-mail address
Logo (Locate and insert an appropriate image.)
The following information should be included in the body of the memo:
The fitness courses will be taught each year by industry professionals and are designed to improve skills
Employees who have been with the company for at least 2 years are eligible to view the videos free of cost.
The video classes provide employees with opportunities to improve their health and achieve fitness certification.
All video courses can be viewed at the Sturgeon Point website.
Interested employees should contact Elana Springs in Human Resources to sign up. Her contact information is [email protected] and her phone extension is 5555.
Informational meetings are being held at 5:30 p.m., according to the following schedule: Television Development on June 15, Motion Picture Production on June 17, and Recording Services on June 21.This information should be presented as a bulleted list.
Viewing the video and completing the survey will qualify employees for a discount on their health insurance.
In addition to the written content, the memo will be assessed on the following formatting criteria.
Use of Times New Roman 12-point font.
Use of left justified margin.
Use of 1-inch margins
Use of single spacing with double spacing between headings and paragraphs and among paragraphs.
Submit only the Microsoft Excel spreadsheet file and the Microsoft Word document files. Both documents should be submitted at the same time. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.
While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.