Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial & Managerial Accounting The Financial Chapters

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

0133255573, 978-0133255577

More Books

Students also viewed these Accounting questions

Question

7. One or other combination of 16.

Answered: 1 week ago

Question

5. It is the needs of the individual that are important.

Answered: 1 week ago