Cost Accounting assistance requested! I need help getting to the green income solution boxes using all the information in the yellow input boxes.

BC NAME: EXCEL ASSIGNMENT 6 2014 22,000 17,000 150 25 2015 22,000 23,000 4 5 INPUT 6 Units Produced 7 Units Sold 8 Selling Price - Prices and Costs Same for both Years 9 Direct Materials and Labor 10 Variable Overhead 11 Variable Marketing Costs 12 Fixed Overhead 13 Fixed Marketing Costs " " 10 " 1.5 " $ $ 1,000,000 600,000 14 15 16 SOLUTIONS 17 Absorption Income - 2014 18 Absorption Income - 2015 19 Variable Income - 2014 20 Variable Income - 2015 21 22 $ 327,272.73 $ 654,545.45 $ 100,000.00 $ 700,000.00