please help. its a case study I have a hard time understanding.

Production Report for the Month of August CF Department Weighted Average Method Table 1: Data for the Crushing and Fermenting Department for August 2017 Submit an Excel spreadsheet or other document. Answer the following questions: 1. Prepare a production report under the weighted average method. 2. Determine the cost per bottle. 3. What is considered normal and abnormal spoilage in the wine making industry? 4. How are costs associated with normal and abnormal spoilage treated? 5. What are the possible reasons for managers to state that all spoilage is normal