Scribd
Upload
1K views6 pages

Entrep Table 1 6 2

The document contains 6 tables that provide projections for revenue and costs for a food truck business over 3 years. Table 1 shows the products sold, costs, markups and projected daily sales. Table 2 calculates the monthly and yearly projected revenue. Table 3 breaks down the monthly projected revenue for years 1 to 3. Tables 4 and 5 calculate the monthly costs for goods and freight. Table 6 calculates the monthly costs of goods sold and operating expenses, and totals the costs and expenses for each month over the first 6 months.

Uploaded by

Russel Joseph Dava
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1K views6 pages

Entrep Table 1 6 2

The document contains 6 tables that provide projections for revenue and costs for a food truck business over 3 years. Table 1 shows the products sold, costs, markups and projected daily sales. Table 2 calculates the monthly and yearly projected revenue. Table 3 breaks down the monthly projected revenue for years 1 to 3. Tables 4 and 5 calculate the monthly costs for goods and freight. Table 6 calculates the monthly costs of goods sold and operating expenses, and totals the costs and expenses for each month over the first 6 months.

Uploaded by

Russel Joseph Dava
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

TABLE 1

PRODUCTS Cost Per Unit Mark up Selling price Projected Projected


(A) 50% (C) volume (D) Revenue
(B) (E)
Average No.
of Items sold (Daily)
(Daily)

(A) (B) = (A X .50) (C) = (A + B) (D) (E) = (C X D)

Solo Drink 10 5 15 25 375

Fries 25 12.5 37.5 25 937.5


w/cheese

Onion rings 25 12.5 37.5 25 937.5


w/cheese

Fries and 50 25 75 25 1,875


Onion rings
w/cheese

Fries 35 17.5 52.5 25 1,312.5


w/cheese and
solo drink

Onion rings 35 17.5 52.5 25 1,312.5


w/cheese and
solo drink

Combo meal 55 27.5 82.5 25 2,062.5


(fries, onion
rings
w/cheese, and
drink)

235 117.5 352.5 175 8,812.5


TOTAL:
TABLE 2
Selling Price Monthly Monthly Yearly Yearly

(c) = (A + B) (F) = (D X 30 G = (C X F) H (D X 365 I = (C X H)


days) days)
15 750 11,250 9,125 136,875

37.5 750 28,125 9,125 342,187.5

37.5 750 28,125 9,125 342,187.5

75 750 56,250 9,125 484, 375

52.5 750 39,375 9,125 479,06.5

52.5 750 39,375 9,125 479,062.5

82.5 750 61,875 9,125 752,812.5

TOTAL:

352.5 5,250 264, 375 63,875 3,216,562.5

TABLE 3
1 year
Month Jan Feb March April May June

Revenue 264,375.00 317,250.00 380,700.00 456,840.00 548,208.00 657,849.6

Month July Aug Sept Oct Nov Dec

Revenue 789,419.52 947,303.42 1,136,764.10 1,364,116.92 1,636,940.30 1,964,328.36


2 years
Month Jan Feb March April May June

Revenue 2,357,194.03 2,828,632.84 3,394,359.41 4,073,231.29 4,887,877.55 5,865,453.03

Month July Aug Sept Oct Nov Dec

Revemue 7,038,543.67 8,446,252.40 10,135,502.88 12,162,603.46 14,595,124.15 17,514,148.98

3 years
Month Jan Feb March April May June

Revenue 21,016,978.78 25,220,374.54 30,264,449.45 36,317,339.34 43,580,807.21 52,296,968.65

Month July Aug Sept Oct Nov Dec

Revenue 62,756,362.38 75,307,634.86 90,369,161.83 108,442,994.20 130,131,593.04 156,157,911.65

TABLE 4
PRODUCT Cost per unit Monthly J = (A X F)
(A) (F) = (D X 30 days)

Solo Drink 10 750 7,500

Fries w/cheese 25 750 18,750

Onion rings 25 750 18,750


w/cheese

Fries and Onion 50 750 37,500


rings w/cheese
Fries w/cheese and 35 750 26,250
solo drink

Onion rings 35 750 26,250


w/cheese and solo
drink
Combo meal (fries, 55 750 41,250
onion rings
w/cheese, and
drink)

TABLE 5
PRODUCT Cost F = (D X 30 days) K = (F/12) X 250

Solo Drink 10 750 15,625

Fries w/cheese 25 750 15,625

Onion rings w/cheese 25 750 15,625

Fries and Onion 50 750 15,625


rings w/cheese

Fries w/cheese and 35 750 15,625


solo drink

Onion rings w/cheese 35 750 15,625


and solo drink

Combo meal (fries, 55 750 15,625


onion rings w/cheese,
and drink)

TOTAL: 235 5,250 109,375


TABLE 6
Merchandise Inventory beginning P. 00.00
Add: Net cost of purchases 176,250.00
Freight- in 109,375
Cost of goods available for sale 285,625.00
Less: Merchandise Inventory, end 00.00
Cost of goods sold P
285,625.00

Operating expenses:

Add: Internet connection P 1,500


Utilities (Electricity) 900
Miscellaneous expense P 500
Total operating expense P 2,900

Cost of goods sold


P 285, 625.00
Cost = 288,525
Total operating expense
P 2,900.00

Month Jan Feb March Apr May June


Cost of 285,625.00 342,750.00 411,300.00 493,560.00 592,272.00 710,726.40
Goods
Sold
Expenses 2,900.00 3,480.00 5,011.20 6,013.20 6,013.44 7,216.13

Total of 288,525.00 346,230.00 415,476.00 498,571.20 598,285.44 717,942.53


Cost &
Expenses
Month July Aug Sept Oct Nov Dec
Cost of 852,871.68 1,023,446.02 1,228,135.22 1,473,762.26 1,768,514.71 2,122,217.65
Goods
Sold
Expenses 8,659.36 10,391.23 12,469.48 14,963.38 17,956.06 21,547.27

Total of 861,531.04 1,033,837.25 1,240,604.70 1,488,725.64 1,786,470.77 2,143,764.92


Cost &
Expenses

You might also like