In this mission, you'll use your findings and raw data from obligation 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 annotatedExcelfile. Each comment must include your reasons for using the appropriate Excel functions.:

2. Calculate thecosts of shippingto Portland and Riverside by pallets and frequency. Use the bin sizes from obligation One, step five. Show your results in a table.
4. Calculate thecost of productionfor the wine varieties sold in Portland and Riverside. Show your results in a table.
6. Generate a labeled table that showsgross profitfor each variety of wine for each distribution center. Explain why this information is essential for informing operation efficiencies.
8. Generate a labeled table that shows the profit afterstate taxes. For Portland, use a tax rate of 6.6%. For Riverside, use 8.8%.
10. devise a summary statement that describes the inefficiencies in the organizationalcost and profit analysis. 
11. 
    
12. Explain why this information is essential for influencing management decisions.

Answer rating: 100% (QA)

Analyzing Wine Distribution Costs and Profits Please note This response assumes you have access to the data from Obligation One and can reference it in your Excel workbook Cost Analysis Annotated Exce... View the full answer