Question: Which forecasts will the Board be most concerned about accuracy and/or not meeting the projections? Why? How should DLI respond to alleviate some of the

Which forecasts will the Board be most concerned about accuracy and/or not meeting the projections? Why? How should DLI respond to alleviate some of the Board's concerns?

Which forecasts will the Board be most concerned about accuracy and/or notmeeting the projections? Why? How should DLI respond to alleviate some of

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!