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 Again, its important to know what data to analyze and what tools you can use to do so Its also important to know how to describe the impacts that the inefficiencies have on the organization Directions In this assignment, youll use your findings and raw data from Milestone One to dive deeper into the types of wine and distribution centers Youll 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 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 Calculate the cost of production for the wine varieties sold in Portland and Riverside Show your results in a table 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 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 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 Please give direction on what steps to take in excel to do this C Create a table that calculates Gross Profit and Gross Profit as a percentage of revenue, Gross Profit Revenue (from Milestone One) minus Transport (from part A) and Production (from part B) from Portland and Riverside State the rationale you used D Create a table that calculates Gross Profit (from part C) minus state taxes (from the Costs Distances tab) State the rationale you used

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 06, 2024

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 youve uncovered inefficiencies in sales, you can look at average costs and profits to figure out where the inefficiencies are in these areas. Again, its important to know what data to analyze and what tools you can use to do so. Its also important to know how to describe the impacts that the inefficiencies have on the organization.

Directions

In this assignment, youll use your findings and raw data from Milestone One to dive deeper into the types of wine and distribution centers. Youll 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:

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.
Calculate the cost of production for the wine varieties sold in Portland and Riverside. Show your results in a table.
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.
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%.
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.

Please give direction on what steps to take in excel to do this.

C: Create a table that calculates Gross Profit and Gross Profit as a percentage of revenue, Gross Profit = Revenue (from Milestone One) minus Transport (from part A) and Production (from part B) from Portland and Riverside State the rationale you used. D: Create a table that calculates Gross Profit (from part C) minus state taxes (from the Costs\&Distances tab). State the rationale you used