Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Overview Once youve uncovered inefficiencies in sales, you can look at average costs and profits to figure out where the inefficiencies are in these areas.

Overview

Once you’ve uncovered inefficiencies in sales, you can look at average costs and profits to figure out where the inefficiencies are in these areas. Again, it’s important to know what data to analyze and what tools you can use to do so. It’s also important to know how to describe the impacts that the inefficiencies have on the organization.

Directions

In this assignment, you’ll use your findings and raw data from Milestone One to dive deeper into the types of wine and distribution centers. You’ll need to analyze these factors to figure out average costs and profits. All of your analyses need to be submitted in an annotated Excel file. Each analysis must include your reasons for using the appropriate Excel functions.

Specifically, you must address the following rubric criteria:

  1. 1. Calculate the costs of shipping to Portland and Riverside by pallets and frequency. Show your results in a table. Use the bin sizes from Milestone One, step five.
  2. 2. Calculate the cost of production for the wine varieties sold in Portland and Riverside. Show your results in a table.
  3. 3. Generate a labeled table that shows gross profit for each variety of wine for each distribution center. Explain why this information is important for informing operation efficiencies.
  4. 4. Generate a labeled table that shows the profit after state taxes. For Portland, use a tax rate of 6.6%. For Riverside, use 8.8%.
  5. 5. Write a summary statement that describes the inefficiencies in the organizational cost and profit analysis. 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

Business Communication Essentials a skill based approach

Authors: Courtland L. Bovee, John V. Thill

6th edition

978-0132971324

More Books

Students also viewed these General Management questions

Question

How the organization is designed and structured

Answered: 1 week ago