using this i need help putting into the 12 month projected cash flow (picture 2)

ocx es New ... 12 B. 7 U A. A DATA FOR STARTUP CAPITAL REQUIREMENTS INFORMATION GATHERED THROUGH MARKET ANALYSIS 1. Company is using a skimming pricing strategy. Initial unit selling price is $150.00 each from January to June, then dropping down to $100.00 from July to December. 2. Projected Units sold are: a) Jan to April 100 units each month, May to Aug - 120 units each month: Sep thru Dec - 150 units each month 3. Operating Expenses a. Direct Labor - $30.00 per unit sold b. Materials - $35.00 per unit sold c. Freight - $3.00 per unit sold d Commissions -5% of gross revenue 4. Fixed Expenses a. Utilities - $100.00 each month b. Salaries - Jan thru April, $3,000.00 per month May thru Dec, $5,500.00 per month c. Insurance - $200.00 each month d. Advertising --Jan thru Jun, $50.00 per month Jul thru Dec, $250.00 per month e. Rent - First six months free, $1,000.00 per month thru December f. Depreciation - $400.00 per month 5. Capital a. Owner capital input- $10,000.00 b. Office Equipment to be bought - $20.000,00 Complete the 12-month projected cash flow and determine if the entire is generating enough cash from operations If it is not what is the additional minimum cash needs of the venture File Edit Insert Formal Help Arial 12 - BIUSA H L K M N B O c D E F G H CASH PROJECTION WORKSHEET Mar Arx May Jun Jul Aug Sop Ecb Now Dec 0 Unti Unit Price Gros Rever 0 0 0 D 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CASA Good DirectLab Marenas 1 Fight 12 Commissions 13 Toul Cost of Goo 14 Gross Profit 15 16 Fixed Costs: 17 Uses wares 19 Ravensing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 21 22 Rent 24 Tom Foxed Costs Pre-Tex Prot 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 O 0 0 O 27 Net Pro 21 Cash Flow Beginning Cash 30 AddDepecon On Less Office Equipment Purchased 0 Revel o Shoot Sheet2 She g > A @ 2 #m $ 4 % 5 & 7