Can someone help me with Part 7 of Managerial Accounting's "I See the Light"?
I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $30.00 Gross Profit Selling Expenses: Fixed Variable (Commission per unit) @ $3.00 Administrative Expenses: Fixed Variable @ $2.00 Total Selling and Administrative Expenses: Net Profit $ 23,000.00 75,000.00 $ 98,000.00 $ 42,000.00 50,000.00 92,000.00 190,000.00 185.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 @ $16.00 0 3000 @ $30.00 90,000.00 200,210.00 $ $ Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 20,000.00 6,800.00 13,200.00 213,410.00 $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147,410.00 159,410.00 213,410.00 $ PART 7 Capital Decision Making Big Al gives his worker's a one hour lunch and two fifteen minute breaks each day. He believes that a cold soda machine would be appreciated by his workers, and an appreciated worker is a good worker. He has priced a machine at a national member only warehouse for $2,000. The machine should be usable for 3 years, after which it would be inefficient, obsolete and would have to be disposed of at the dump. Big Al believes that 8 cans a day will be purchased. The plant is open five days a week, 50 weeks per year. A case of soda (24 cans) costs $5.52 and Big Al believes that a price of $.80 per can would win him good will. What is the estimated annual sales in cans of soda? {17.01) What is the contribution margin per can of soda? (rounded to two places, $#.##) {17.02) How many cans of soda must be sold each year to breakeven? (Round up to zero places, ### ### cans) {17.03) Annual incremental cash inflows from the soda machine? (rounded to two places, $#.##) {17.04) What is the payback period in years? (rounded to two places, #.## years) {17.05) If the time value of money is 12% per year what is the net present value? Use the tables on page 18. {17.06) What is the internal rate of return. Pick the closest interest rate from the tables on page 18. {17.07) I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $30.00 Gross Profit Selling Expenses: Fixed Variable (Commission per unit) @ $3.00 Administrative Expenses: Fixed Variable @ $2.00 Total Selling and Administrative Expenses: Net Profit $ 23,000.00 75,000.00 $ 98,000.00 $ 42,000.00 50,000.00 92,000.00 190,000.00 185.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 @ $16.00 0 3000 @ $30.00 90,000.00 200,210.00 $ $ Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 20,000.00 6,800.00 13,200.00 213,410.00 $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147,410.00 159,410.00 213,410.00 $ PART 7 Capital Decision Making Big Al gives his worker's a one hour lunch and two fifteen minute breaks each day. He believes that a cold soda machine would be appreciated by his workers, and an appreciated worker is a good worker. He has priced a machine at a national member only warehouse for $2,000. The machine should be usable for 3 years, after which it would be inefficient, obsolete and would have to be disposed of at the dump. Big Al believes that 8 cans a day will be purchased. The plant is open five days a week, 50 weeks per year. A case of soda (24 cans) costs $5.52 and Big Al believes that a price of $.80 per can would win him good will. What is the estimated annual sales in cans of soda? {17.01) What is the contribution margin per can of soda? (rounded to two places, $#.##) {17.02) How many cans of soda must be sold each year to breakeven? (Round up to zero places, ### ### cans) {17.03) Annual incremental cash inflows from the soda machine? (rounded to two places, $#.##) {17.04) What is the payback period in years? (rounded to two places, #.## years) {17.05) If the time value of money is 12% per year what is the net present value? Use the tables on page 18. {17.06) What is the internal rate of return. Pick the closest interest rate from the tables on page 18. {17.07)
