Using provided data and the text of the case, work together to create a flexible budget analysis, and a spending variance analysis which address the following questions:

1.According to the budget, how many iPhones must be made to break even?

2.What is the total expected cost per unit (including shipping) according to budget?

3.What is the total actual cost per unit (including shipping)?

4.What are some strategies that Wentao Chen should consider in trying to solve the problems with the Apple iPhone 4 contract in the remaining 9 months. How would these strategies change the costs and profitability of Danshui Plant No. 2?

Please read the following and answer the four questions using the xl format below.

Please use the follow xl format for answers:

1]Prep:

2]Flexible:

3]Variances:

Please use the following xl format: