Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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?
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,963Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started