Reference no: EM133380357

Assignment:

Obligation Two: Organizational Cost and Profit

I NEED SOME HELP; I fail Part one; how do I go about getting a better grade than a failing grade again?

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 annotated Excel file. Each comment must include your reasons for using the appropriate Excel functions.:

1. Calculate the costs of shipping to Portland and Riverside by pallets and frequency. Use the bin sizes from obligation One, step five. Show your results in a table.
2. Calculate the cost of production for the wine varieties sold in Portland and Riverside. Show your results in a table.
3. Generate a labeled table that shows gross profit for each variety of wine for each distribution center. Explain why this information is essential for informing operation efficiencies.
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. Devise a summary statement that describes the inefficiencies in the organizational cost and profit analysis. Explain why this information is essential for influencing management decisions.