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:
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.