accounting hw

Note:

Read the attached case study and answer the following case question in 1-2 pages word document and excel sheet both. Please make sure to provide me both files. Your answer must be 100% original.

Case Questions:

1. Using the budget data, calculating the following amounts: (a) Contribution margin per unit, (b) Contribution margin ratio, (c) Break-even point in units, and (d) Break-even points in sales.

2. Using the budget data, calculate the total expected cost per unit if all manufacturing costs and overhead (both variable and fixed) were allocated to planned production. Calculate the actual total cost per unit of units produced during 2015. Discuss what is causing the difference in expected and actual total costs per unit.

3. Prepare a flexible budget for the 10,800 bicycles produced in 2015 and calculate flexible budget variances using the actual results for 2015.

4. For each department, calculate material quantity, material price, labor efficiency & labor rate variances for 2015. Also, calculate the overhead spending variances for that year.

5. Discuss some strategies or decisions that Mark Bowman should consider for improving future performance based on the analysis performed in the previous questions.