Prepare a contribution margin income statement by month with and without the funding. Comment on DLI$$s cost structure.

Table 1 DASHBOARD LOGISTICS INC (DLI) Sales Data Sales Forecast Sales Pipeline without Funding Qualified Customers (Companies) Interested Customers Quoted Customers Paying Customers Sales Pipeline with Funding Qualified Customers (Companies) Interested Customers Quoted Customers Paying Customers Monthly Revenue # Customers Avg Transactions per Customer Avg Selling Price per Transaction Total Monthly Revenue February 246 60 10 1 246 60 10 1 1 1500 $0.50 $750 March 400 120 16 2 1000 300 40 5 5 2000 $0.75 $7,500 August September October November December Table 2 DASHBOARD LOGISTICS INC (DLI) Pro Forma Profit and LOSS Sales Operating Expenses Executive, Sales, & Misc. Expenses Executive Payroll Engineers Marketing Sales Exp Servers/Hosting Travel Expenses Total Executive Expenses Accounting & Legal Expenses Accounting & Legal Payroll Rent Total Accounting & Legal Expenses Total Operating Expenses Profit Before Interest and Taxes January $110 $2,000 $0 $110 $18 $0 $2,129 $0 $2,200 $2,200 $4,329 ($4,218) February $750 $2,000 $0 $0 $150 $20 $0 $2,170 $0 $2,200 $2,200 $4,370 ($3,620) March $7,500 $2,000 $0 $0 $1,000 $45 $500 $3,545 $0 $2,200 $2,200 $5,745 $1,755 April $14,875 $4,000 $0 $0 $1,750 $68 $500 $6,318 $200 $4,000 $4,200 $10,518 $4,358 May $27,000 $6,000 $0 $0 $2,700 $96 $500 $9,296 $0 $4,000 $4,000 $13,296 $13,704 June $36,300 $8,000 $0 $0 $3,630 $124 $500 $12,254 $0 $4,000 $4,000 $16,254 $20,046 July $45,500 $8,000 $5,000 $0 $4,550 $152 $500 $18,202 $200 $4,000 $4,200 $22,402 $23,099 August September October November December Total January 112 5 1 112 40 5 1 1 1103 $0.10 $110 April 800 240 32 4 1400 420 56 7 7 2500 $0.85 $14,875 May 1200 360 48 6 1800 540 72 9 9 3000 $1.00 $27,000 June 1600 480 64 8 2200 660 88 11 11 3300 $1.00 $36,300 July 2000 600 80 10 2600 780 104 13 13 3500 $1.00 $45,500 2400 720 96 12 3000 900 120 15 15 4000 $1.00 $60,000 2800 840 112 14 3400 1020 136 17 17 4500 $1.00 $76,500 3200 960 128 16 3800 1140 152 19 19 4700 $1.00 $89,300 3600 1080 144 18 4200 1260 168 21 21 4800 $1.00 $100,800 4000 1200 160 20 4600 1380 184 23 23 5000 $1.00 $115,000 $60,000 $10,000 $10,000 $0 $6,000 $195 $500 $26,695 $0 $4,000 $4,000 $30,695 $29,305 $76,500 $12,000 $10,000 $6,000 $7,650 $245 $1,500 $37,395 $0 $7,500 $7,500 $44,895 $31,606 $89,300 $12,000 $10,000 $6,000 $8,930 $283 $1,500 $38,713 $200 $7,500 $7,700 $46,413 $42,887 $100,800 $12,000 $10,000 $6,000 $10,080 $317 $1,500 $39,897 $0 $7,500 $7,500 $47,397 $53,403 $115,000 $5,000 $10,000 $6,000 $11,500 $360 $1,500 $34,360 $0 $9,000 $9,000 $43,360 $71,640 $573,635 $83,000 $55,000 $24,000 $58,050 $1,922 $9,000 $230,972 $600 $58,100 $58,700 $289,672 $283,963 *Transactions are orders placed by each customer with DLI.