Business Finance Homework Help

Hello, need help with the case study. I have attached the case study, the Excel template that needs to be used for the calculations, and there also should be a Word document with all the explanations. Please, answer the questions below:

1. Using budget data, what was the total expected cost per unit if all manufacturing and shipping overhead (both variable and fixed) were allocated to planned (using 200,000 units) production? What was the actual (using 180,000 units) cost per unit of production and shipping? Include rationale.
2. Prepare a flexible budget for 180,000 iPhone 4s, and calculate flexible budget variances using actual costs for August. Include rationale.
3. For the month of August, calculate the following variances (assuming the standard labor rate is $0.92 per hour):
   1. Material price variance for flash memories
   2. Material usage variance for flash memories
   3. Labor rate variance
   4. Labor usage (efficiency) variance
   5. Overhead spending variance – Include rationale for all sections.
4. What are some strategies or decisions that Wentao Chen should consider when trying to solve the problems with the Apple iPhone 4 contract in the next 9 months? How would these change the costs and profitability of Danshui Plant No. 2 and the iPhone 4 contract? Approach this from both Danshui’s and Apple’s point of view.