Need help with the cash budget on section 8. yellow parts are required but showing work will help as well.

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 Page 7 Isa Rodriguez PART 3 Budgets Division N has decided to develop its budget based upon projected sales of 33.000 lamps at $4900 per lamp The company has requested that you prepare a master budget for the year. This budget is to be used for planning and control of operations and should be composed of 1 Production Budget 2. Materials Budget 3. Direct Labor Budget 4. Factory Overhead Budget 5. Selling and Administrative Budget 6. Cost of Goods Sold Budget 7. Budgeted Income Statement 8. Cash Budget Notes for Budgeting The company wants to maintain the same number of units in the beginning and ending inventories of work-in-process, and electrical parts while increasing the inventory of Lamp Kits to 550 pieces and decreasing the finished goods by 20% Complete the following budgets 1 Production Budget Planned Sales Desired Ending Inventory of Finished Goods Total Needed Less: Beginning Inventory 33.000 2400 315400 -3000 Total Production 327400 un 7.01) 2 Materials Budget 18.011 Langit Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases (803 Cost of Purchases (Round to two places, (806) 3 Direct Labor Buder Labor Cost Per Lamp Production Total Labor Cost (Round to two places. 58 (807) (8.08) ) 4 Factory Overhead Buda Variable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be produced Total Variable Factory Overhead (Round to two places, Fixed Factory Overhead (809) 18.10) Total Factory Overhead (Round to two places, $8.00) Too Factory Number of Units Factory Overhead T ot of one Ronde 6 Sand And W ITO 04 Feeling Variatie Seng Round places Five A r ve Round towe places To Sering and Ad v e Round two place Round dollars to two Sold Budo Beginning inventory Finished Goods Production costs Matias Beginning inventory Purchased AU Ending investory of Lamps Lampk i n Production O o 561576 300 TO 909) ( 10) O To Me Labor Overhead Code Less Ending hertory Fished Goods Cost of Goods Sold 00014 de comment 8 Cash Budget Assume actual cash receipts and disbursements we to the parter below. Not Receivables and Payable of 123 will have a cash impact in 2012) 11.00 for they are made in November December Se Gustomers have 60 day terms Those funds we becocted be and February 2 No purchased the thermoporte pa r February 2 Armancang and p ower when more The bed depreciation pers o ne e manug ande expenses SM Cash Balance needed for 2010.10.000 See The Light Projected Cash Budget For the Year Ending December 31, 202 Round dortowe Beginning Cash Balance Sales Collections Account Reca 11002) ro (10.05) Cash Out Purchases Accounts Payable Purchases last year Purchases made and paid for in 2010 Other Manufacturing Costs Ove Labor Total Manufacturing Overhead Seling and Administrative Los Depreciation Total Cash Outflows 110.05 (10.07) Budged Cash Balance before franang Needed Minimum Balance (10.08 Amount to be borrowed if any) (100) (10.10) Budgeted Cash Balance