For the question above, how did you calculate in excel. I do not where to start to calculate the datasets

ACC 311 Module Three Assignment Guidelines and Rubric

Overview

This is a Bongo Learn practice assignment that allows you to practice a presentation. You will benefit from getting both the automated feedback from Bongo and instructor feedback prior to producing your final project.

Directions

Using the scenario linked in the Supporting Materials section, assume that you are the cost accountant for your company, and the CFO has asked for your analysis on purchasing materials from an online marketplace.

You will record a presentation in Bongo. You will prepare PowerPoint slides that explain the key points to communicate to the CFO, utilize basic visualizations, and present options for the CFO based on the situation. Then, you will verbally discuss those slides in your Bongo presentation and record the narration. Bongo Learn will provide automated feedback when you complete your presentation. Take a screenshot of the feedback and add the screenshot to the last slide in your slide deck before saving the slide deck.

It is recommended that you try recording several times to feel comfortable with your pace, volume, and diction.

Bongo Learn provides automated feedback about your presentation skills. While this assignment is focused on presenting to stakeholders, the content should be simple and direct. Your objective is to gain the confidence you need to present orally and visually to an audience.

Specifically, you must address the following rubric criteria:

Presentation

1. Explain the key points to communicate to the CFO. Use the data sets linked in the Supporting Materials section to answer questions a, b, and c. Include the following details in your response:
   1. If the company had purchased all its materials from the online marketplace, describe what inventory cost would be shown for all materials on hand based on the average transaction price.
   2. Explain if the inventory cost value is higher or lower than the value of all materials if using their standard price.
   3. If the company can freely choose the lower of the standard price or the average price in the online marketplace, explain what the lowest possible inventory cost of all materials on hand is.
   4. Identify whether there is a particular marketplace vendor who always sells at a price lower than the standard price cost of all materials on hand.
2. Create effective basic visualizations (line chart or column chart) that support key points.
   1. Create a basic visualization for Data Set One, linked in the Supporting Materials section.
   2. Create a basic visualization for Data Set Two, linked in the Supporting Materials section.
3. Present options for the CFO when considering switching to the online marketplace. Answer question d of the textbook problem. Include the following details in your response:
   1. Explain why the competitors are switching to the online marketplace.
   2. Provide recommendations and rationale for the best options moving forward for your company.
4. Create slides that are simple, neat, and only contain relevant information for the needs of the stakeholder.
5. Record narration using Bongo with a clearly articulated and well-paced delivery.
6. Capture a screenshot of the automated feedback from Bongo Learn.