FB8784 Last Modified: 50m ago Fic Home Insert Page Layout Formulas Data Review View & Cut...

Transcribed Image Text:

FB8784 Last Modified: 50m ago Fic Home Insert Page Layout Formulas Data Review View & Cut Arial 10 AA == -4 Copy BIU A A- == Wrap Test Merge & Center Format Painter Capboard Fant 19 Alignment Numer G18 So A B C D G 1 2 3 4 5 6 Sales I See The Light Projected Income Statement For the Period Ending December 31, 20x1 25,000 lamps $15.00 15 Cost of Goods Sold @$30.00 16 Gross Profit 17 Selling Expenses: 18 Fixed $23,000.00 19 Variable (Commission per unit) @ $3.00 75,000.00 $90,000.00 28 Administrative Expenses: 29 Fixed $42,000.00 30 Variable @$2.00 50,000.00 92.000.00 31 32 Total Selling and Administrative Expenses. Net Profit 41 42 43 44 45 54 55 56 57 58 67 I See The Light Projected Balance Sheet As of December 31, 20x1 68 69 70 71 80 81 Current Assets Cash Accounts Receivable Inventory Raw Material 82 Search (Al-Q Conditional Format as Formatting-Table- Style $1,125,000.00 750,000.00 $ 375,000.00 190,000.00 $ 185,000.00 $ 34,710.00 67,500.00 pietro barbagio Comments Share AutoSum Insert Delete Format Clear- Sort & Find & Filler-Select- Edeng Analyze Dala Analy Sensitivity Semillatly K L M N 0 P Q R S T U A Lamp Kits 500 @ $16.00 8,000.00 Made in Brasses. FAQ Ready 1 2 Accessibility instigate 3 4 5 b 7 B 9 10 11 12 13 14 15 10 17 18 Present Value Tables + Type here to search 79F Mostly doudy 4 ING 1:24 PM 4/30/7027 130 FB8784 Last Modified: 50m ago Fic Home Insert Page Layout Formulas Data Review View & Cut Arial 10 AA == -4 Copy BIU A A- == Wrap Test Merge & Center Format Painter Capboard Fant 19 Alignment Numer G18 So A B C D G 1 2 3 4 5 6 Sales I See The Light Projected Income Statement For the Period Ending December 31, 20x1 25,000 lamps $15.00 15 Cost of Goods Sold @$30.00 16 Gross Profit 17 Selling Expenses: 18 Fixed $23,000.00 19 Variable (Commission per unit) @ $3.00 75,000.00 $90,000.00 28 Administrative Expenses: 29 Fixed $42,000.00 30 Variable @$2.00 50,000.00 92.000.00 31 32 Total Selling and Administrative Expenses. Net Profit 41 42 43 44 45 54 55 56 57 58 67 I See The Light Projected Balance Sheet As of December 31, 20x1 68 69 70 71 80 81 Current Assets Cash Accounts Receivable Inventory Raw Material 82 Search (Al-Q Conditional Format as Formatting-Table- Style $1,125,000.00 750,000.00 $ 375,000.00 190,000.00 $ 185,000.00 $ 34,710.00 67,500.00 pietro barbagio Comments Share AutoSum Insert Delete Format Clear- Sort & Find & Filler-Select- Edeng Analyze Dala Analy Sensitivity Semillatly K L M N 0 P Q R S T U A Lamp Kits 500 @ $16.00 8,000.00 Made in Brasses. FAQ Ready 1 2 Accessibility instigate 3 4 5 b 7 B 9 10 11 12 13 14 15 10 17 18 Present Value Tables + Type here to search 79F Mostly doudy 4 ING 1:24 PM 4/30/7027 130