Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have no idea where to start. Is this missing data? Overview Finding out about organizational inefficiencies is the first step to improving performance. To

I have no idea where to start. Is this missing data?

Overview

Finding out about organizational inefficiencies is the first step to improving performance. To determine what inefficiencies exist, you need to perform a data analysis. A good place to start is with sales. You have to know what data to study and how to use specific tools for data analysis. It's important to use the IF function, pivot tables, pie charts, bar charts, and histograms. These can help you isolate specific data and organize it in a way that makes it easier to read. Studying measures of central tendency also helps you find out important information. First, you find where inefficiencies in sales exist. Then, you need to be able to talk about the effect this has on the organization.

Directions

For this assignment, you'll use the Vinho Winery Scenario, linked in Supporting Materials, and other course resources to look at raw data sets. These data sets will explain the production, sales, and distribution of wine. You'll need to study the different types of wine and distribution centers to figure out their financial effects on the organization's total profits. All your analyses need to be submitted in an annotated Excel file, and each analysis needs to include your reasons for using the appropriate Excel functions.

Specifically, you must address the following rubric criteria:

  1. Using a pivot table, figure out the percentage of wine varieties sold from each distribution center. Show your results in the form of a pie chart.
    1. Hint: Create a pivot table using the data spreadsheet as a starting point.
  2. Create a labeled bar chart that shows the amount of wine varieties sold to each distribution center.
  3. Use the pivot table already created to calculate the total amount of revenue made for each distribution center. Show your results in a bar chart.
    1. Hint: Production cost data is provided in the Costs & Distances tab. Make sure you don't mix your units of measurement (i.e., pallets, cases, or bottles).
  4. Use the IF function to calculate the central tendencies (mean, median, and mode) of shipment volume for each distribution center. Show your results in a table. (Do NOT use a pivot table or manually identify each cell to be evaluated.)
  5. Analyze the frequency of shipment by size using a histogram. Use the following bin sizes (number of pallets): 72, 48, 24, 18, 12, 6, 3, 1.
  6. Create a shipment histogram to show the distribution of shipments for Portland and Riverside. Use the same bin sizes as you did in step five.
    1. Hint: Use the alphabetical sort for the destination column. Then select Data Analysis to plot the frequency of pallet shipments using the bin sizes listed for the two destinations separately.
  7. Write a summary statement that describes the inefficiencies shown in the organizational sales analysis. In your response, explain why this information is important for influencing management decisions.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting Volume 1

Authors: Thomas H. Beechy, Joan E. Conrod, Elizabeth Farrell, Ingrid McLeod Dick

7th Edition

1260306747, 978-1260306743

More Books

Students also viewed these Accounting questions