The following contains information about April's production for Cabinera, Incorporated.

Units produced	10,000
Units sold	9,000
Sales price	$ 450.00
Direct materials cost per unit	$ 104.00
Direct labor cost per unit	$ 91.00
Variable overhead cost per unit	$ 64.00
Fixed overhead (total)	$ 652,000.00
Variable selling expense per unit sold	$ 22.00
Fixed administrative expense	$ 258,000.00

Required:

1. Prepare a Traditional Income Statement (Absorption Costing).
2. Prepare a Contribution Format Income Statement (Variable Costing).
3. Please show how to solve in excel