Benchmark – sales results excel spreadsheet and powerpoint

 

Don't use plagiarized sources. Get Your Custom Essay on
Benchmark – sales results excel spreadsheet and powerpoint
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay

The purpose of this assignment is to utilize Microsoft Excel and PowerPoint to create a business presentation.

Part 1

As a sales manager at Lopes Athletics Productions, you are required to report your sales numbers weekly and share them with the vice president of sales. Create an Excel spreadsheet that provides the following information.

  1. Total sales for each type of video.
  2. Total sales of all videos.
  3. Percentage of total sales for each type of video.
  4. A bar chart that summarizes the sales data.

The data needed for the spreadsheet is as follows. In all, you will need to create at least four columns; Video Type, Unit Price, Total Sales (for each type of video), and Percentage of Total Sales (for each type of video.

  1. Pilates sold 156 videos at $29.99 each.
  2. Step sold 392 videos at $14.99 each.
  3. Weight Training sold 147 videos at $54.99 each.
  4. Kickboxing sold 282 videos at $29.99 each.
  5. Yoga sold 165 videos at $34.99 each. 

Add a second worksheet to your workbook. 

  1. Insert a chart in a bar format linked to data on your first worksheet.
  2. This bar chart should reflect the total sales of each type of video.
  3. Review the rubric to see how the spreadsheet will be assessed

Part 2

Create a PowerPoint presentation with a minimum of five slides based upon the Excel spreadsheet you created in Part 1 of this assignment.

Utilize the bar chart from the spreadsheet as a graphic element on at least one slide in the presentation. The presentation should summarize the following information for the vice president of sales:

  1. Total sales for each type of video.
  2. Total sales of all videos.
  3. Percentage of total sales for each type of video.

In addition to the content, the presentation will be assessed on the following criteria:

  1. Slide structure includes correct use of bullet points and the 6 x 6 rule.
  2. Slide appearance includes consistent theme, text alignment, readable font, clear photos/charts.
  3. Slide content is accurate, concise, and focused on a single topic.
  4. Use of chart enhances the presentation and illustrates slide information.
  5. Speaker notes are appropriate for explaining slide content and add details not presented on the slide.

Submit the PowerPoint presentation file. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

General Requirements

Submit both the Excel spreadsheet file and the Microsoft PowerPoint presentation file. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

Refer to the resource, “Creating Effective PowerPoint Presentations,” located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

APA style is not required, but solid academic writing is expected.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Benchmark Information

This benchmark assignment assesses the following programmatic competencies:

BS Business Secondary Education

7.1:  Demonstrate computer literacy skills.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Professor’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
  • 2-hour delivery
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
Getting into any engagement is not as simple as it sounds, especially when done remotely. Thus, you as our client need solid assurances that your expectations will be met and exceeded. Taking this into consideration, we are very serious when it comes to honoring our end of the bargain. On this page, we have clearly stipulated our assurances to clear any anxiety, doubts, or uncertainties that you may have. We are sure that after reading the below short guarantee highlights, you will be entirely confident that your needs will be exceeded!

Money-back guarantee

Our money-back guarantee assures you of the safety of your money. Several reasons may make you want to get a refund, and we have the best refund system since it works INSTANTLY! Yes, I said instantly! Many of our competitors place complex processes for you to get a refund. Some websites make you wait for 14 days! For what? We know that you obviously have other uses for the money; that is why we refund on the spot. Here at Employed Professors, we simply look into the issue and press a button, and your money is back. No waiting! No back and forth!

Zero-plagiarism guarantee

Being the worst academic offense that is severely punished by all institutions, plagiarism is a NO at Employed Professors! In fact, we are always ready with evidence that your paper is plagiarism-free.

Our elite algorithm for detecting plagiarism is updated regularly, as our developers work 24/7 to make sure that it captures even the slightest instance. We provide a plagiarism report FREE OF CHARGE so that you are confident when submitting your paper to that stickler professor or TA. This way, we ensure that you will never get expelled for this heinous act!

Free-revision policy

Sometimes, for absolutely no reason, your TA or professor might require you to make some changes to your paper. Other times, further customization can be needed as you deem fit; of course, you are the king, and you command, and we obey! As such, if you feel that a specific aspect has not been captured as you like, you can always send the paper back for revision, and this is also FREE OF CHARGE! All you need to clearly state are the new guidelines that you want our professor to use to accomplish your desired objective in the way that you want it.

Privacy policy

Our clients' confidentiality is our priority; this is a fact that is undeniable in our company. We CANNOT give out the data/information that we request from you even at GUNPOINT! This is how far we can go to protect your identity. Furthermore, our databases are regularly services and secured with an impenetrable security system. Over the years that we have been in this essential industry, we have never had a data breach, thanks to our top-notch technical department that ensure the confidentiality of your information. A detailed summary of our privacy policy is as below:

24/7 and on-the-spot-response system

Unlike our competitors who will make you wait even 30 minutes to respond to your inquiries, order messages, and support help, we have developed a seamless communication system that notifies our always-standby support personnel to respond to you. Furthermore, we have given our professors access to this high-tech system so that they can respond promptly to ensure that no time is wasted. Remember, this business' most valuable element is time, and delays are usually catastrophic. The last thing we would imagine is you having to lose points for lateness. Thus, we ensure that prompt communication is ever-present, without failure!

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency