Hwk 6: CVP Income Statement

Hwk 6: CVP Income Statement -

20253_14097 ACCT-410: Foundations of Accounting

Requirements: Create an excel spreadsheet that meets following requirements:

• 1: SEPARATE TAB A: Prepare a Contribution approach income statement in good form with detailed VC and detailed FC.
  • CVP income statement should allow changes the following inputs:
    • Units Sold
    • Unit Sales Price
    • Unit VC
    • Total FC
  • Given the above changes the excel model should be able to properly :
    • Sales Revenue
    • Variable Costs (individually and in total)
    • Contribution Margin (per unit and total)
    • Net Income
    • Break-Even in Units and Sales Revenue
• 2. SEPARATE TAB B: A condensed contribution approach income statement that shows calculations for requirements 2a thru 2d
  • Note: Condensed Contribution Approach Income Statement shows
    • Units Sold
    • Sales Revenue - Unit & Total
    • Variable Costs in one line - Unit & Total
    • Contribution Margin - Unit & Total
    • Fixed Costs in total
    • Net Income in total
    • You do not have to model Requirement 3

TAB A is based on the ability to correctly process changes and calculate net income (30 points)

TAB B should be set up to show calculations for the correct answers. (20 points)

Notes:

Please follow all the assingment directions and make sure it Excel file only.