Need Help With the bottom portion of this section that focuses on schedule of fixed costs.
Page 2 I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $45.00 $30.00 $ 1,125 000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ Cost of Goods Sold @ Gross Profit Selling Expenses Fored Variable (Commission per unit) Administrative Expenses Fixed Variable @ Total Selling and Administrative Expenses Net Profit $3.00 $ 98,000.00 $ 23,000.00 75,000.00 $42.000.00 50.000,00 $2.00 92.000.00 3 190,000.00 135.000.00 I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34.710.00 67.500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 8,000.00 500 @ 3000 @ $16.00 $30.00 $ 90.000.00 200.210.00 $ 20,000.00 6,800.00 Foxed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 13.200.00 $ 213.410.00 $ $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Eamings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147.410.00 $ 159.410.00 213.410.00 Isaiah Rodriguez 5469 See The Light, Inc Schedule of Projected Costs Variable Manufacturing Unit Cost 20x1 Cost Projected Percent Lamp kit 1665 2 45 2012 Cost Rounded to 2 Decimal Places $17.04 (401) $2.09 14021 52134.03) Labor Variable Overhead Projected Variable Manufacturing Cost Per Unit $21.26 (404) Total Variable Cost Per Unit 22 Cast Rounded to 2 Decimal Places 20x Cost Projected Percent Increase 3 3.5 25 Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost 2.10 (406) (404) Projected Total Variable Cost Per Unit 26.47 (4.07) Schedule of Fored Costs 20x1 Cost 2012 Cost Projected Percent Increase (408) Fixed Overhead (normal capacity of Fixed Seling Fixed Administrative lamps @_) (4.09) (4.10) Projected Total Fixed Costs (4.11) Page 2 I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $45.00 $30.00 $ 1,125 000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ Cost of Goods Sold @ Gross Profit Selling Expenses Fored Variable (Commission per unit) Administrative Expenses Fixed Variable @ Total Selling and Administrative Expenses Net Profit $3.00 $ 98,000.00 $ 23,000.00 75,000.00 $42.000.00 50.000,00 $2.00 92.000.00 3 190,000.00 135.000.00 I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34.710.00 67.500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 8,000.00 500 @ 3000 @ $16.00 $30.00 $ 90.000.00 200.210.00 $ 20,000.00 6,800.00 Foxed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 13.200.00 $ 213.410.00 $ $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Eamings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147.410.00 $ 159.410.00 213.410.00 Isaiah Rodriguez 5469 See The Light, Inc Schedule of Projected Costs Variable Manufacturing Unit Cost 20x1 Cost Projected Percent Lamp kit 1665 2 45 2012 Cost Rounded to 2 Decimal Places $17.04 (401) $2.09 14021 52134.03) Labor Variable Overhead Projected Variable Manufacturing Cost Per Unit $21.26 (404) Total Variable Cost Per Unit 22 Cast Rounded to 2 Decimal Places 20x Cost Projected Percent Increase 3 3.5 25 Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost 2.10 (406) (404) Projected Total Variable Cost Per Unit 26.47 (4.07) Schedule of Fored Costs 20x1 Cost 2012 Cost Projected Percent Increase (408) Fixed Overhead (normal capacity of Fixed Seling Fixed Administrative lamps @_) (4.09) (4.10) Projected Total Fixed Costs (4.11)
