ACWKFI – CVP income statement
Please see the attached excel file and complete it in its entirety (Problems 1 & 2 located at the bottom tabs of the workbook). Any questions, please feel free to contact me.
Problem 1
| Instructions | ||
| A. Prepare a CVP income statement based on these cost estimates. | ||
| B. Commute contribution margin ratio. | ||
| C. Compute the break-even point in (1) units and (2) dollars. | ||
| D. Compute the margin of safety ratio. | ||
| E. Determine the sales dollars required to earn net income of $1,000,000. | ||
Problem 2
|
|||||
| a. Prepare a CVP for Elliott based on the current production. | |||||
| b. Compute contribution margin ratio for current production. | |||||
| c. Compute breakeven dollars for current production. | |||||
| d. Prepare a CVP based on the proposed equipment upgrade. | |||||
| e. Compute contribution margin ratio based on the proposed equipment upgrade. | |||||
| f. Compute breakeven dollars for current production. | |||||
| g. Should Elliott proceed with the proposed upgrade? | |||||
