Jaxworks Dashboard1

Financial Dashboard
Financial Summary
Financial Summary
300,000
250,000
200,000
150,000
100,000
50,000
-
J F M A M J J A S O N D
Total Sales Total All Operating Expenses EBIT

Period Starting: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals
Sales
Sales by Product Line 1 1,600 3,350 5,100 6,850 8,600 10,350 12,100 13,850 15,600 17,350 19,100 20,850 134,700
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Over / (Under Budget) 1,005 1,672 346 349 856 505 1,124 2,618 1,277 1,916 2,557 2,954 (17,179)
Budget 1,595 1,678 2,754 3,168 3,748 4,327 4,907 5,486 6,066 6,645 7,225 7,804 55,401
Over / (Under Budget) 1,005 1,672 1,346 1,682 1,853 2,023 2,194 2,364 2,535 2,705 2,876 3,046 25,299
Budget 1,895 3,678 5,754 7,501 9,431 11,320 13,209 15,099 16,988 18,878 20,767 22,656 147,175
Over / (Under Budget) (295) (328) (654) (651) (831) (970) (1,109) (1,249) (1,388) (1,528) (1,667) (1,806) (12,475)
Budget 2,895 4,678 7,754 6,501 9,431 11,320 13,209 15,099 16,988 18,878 20,767 22,656 150,175
Over / (Under Budget) (1,295) (1,328) (2,654) 349 3,170 (970) 1,891 85 (555) (1,194) (1,834) (2,473) (6,809)
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Over / (Under Budget) 1,005 1,672 346 349 856 505 1,124 2,618 1,277 1,916 2,557 2,954 17,179
Budget 1,595 1,678 4,754 6,501 8,081 9,860 11,639 13,419 14,323 15,434 16,543 17,896 121,722
Over / (Under Budget) 14,405 11,672 10,346 10,349 8,320 6,970 5,621 4,271 1,277 1,916 2,557 2,954 80,658
Total Sales 25,000 30,100 39,600 49,100 60,400 64,580 75,760 82,273 87,433 96,433 105,433 114,433 830,547
Total Sales Budget 9,170 15,068 30,524 36,673 46,177 56,517 64,916 71,566 83,011 90,702 98,387 106,805 709,516
Total Over / (Under Budget) 15,830 15,032 9,076 12,427 14,223 8,063 10,844 10,707 4,423 5,731 7,046 7,629 121,031
Less Cost of Goods Sold

Materials 1,600 3,350 5,100 6,850 8,600 10,350 12,100 13,850 15,600 17,350 19,100 20,850 134,700
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Labor 1,600 3,350 5,100 6,850 8,600 10,350 12,100 13,850 15,600 17,350 19,100 20,850 134,700
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Overhead 1,600 3,350 5,100 6,850 8,600 10,350 12,100 13,850 15,600 17,350 19,100 20,850 134,700
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Other 1,600 3,350 5,100 6,850 8,600 10,350 12,100 13,850 15,600 17,350 19,100 20,850 134,700
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Total Cost of Goods Sold 6,400 13,400 20,400 27,400 34,400 41,400 48,400 55,400 62,400 69,400 76,400 83,400 538,800
Total COG Budget 2,380 6,712 19,016 26,004 30,976 39,380 43,904 44,928 57,292 61,736 66,172 71,584 470,084
Total Over / (Under Budget) 4,020 6,688 1,384 1,396 3,424 2,020 4,496 10,472 5,108 7,664 10,228 11,816 68,716
Operating Expenses
G&A Expenses
Operating Expenses 1,600 3,350 5,100 6,850 8,600 10,350 12,100 13,850 15,600 17,350 19,100 20,850 134,700
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Payroll Salaries 1,600 3,350 5,100 6,850 8,600 10,350 12,100 13,850 15,600 17,350 19,100 20,850 134,700
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Total G&A Expenses 3,200 6,700 10,200 13,700 17,200 20,700 24,200 27,700 31,200 34,700 38,200 41,700 269,400
Total G&A Budget 1,190 3,356 9,508 13,002 15,488 19,690 21,952 22,464 28,646 30,868 33,086 35,792 235,042
Total Over / (Under Budget) 2,010 3,344 692 698 1,712 1,010 2,248 5,236 2,554 3,832 5,114 5,908 34,358
Sales Expenses
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Total Sales Expenses 3,200 6,700 10,200 13,700 17,200 20,700 24,200 27,700 31,200 34,700 38,200 41,700 269,400
Total Sales Expense Budget 1,190 3,356 9,508 13,002 15,488 19,690 21,952 22,464 28,646 30,868 33,086 35,792 235,042
Marketing Expenses
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Total Marketing Expenses 3,200 6,700 10,200 13,700 17,200 20,700 24,200 27,700 31,200 34,700 38,200 41,700 269,400
Total Marketing Expense Budget 1,190 3,356 9,508 13,002 15,488 19,690 21,952 22,464 28,646 30,868 33,086 35,792 235,042
Research & Development Expenses

Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Budget 595 1,678 4,754 6,501 7,744 9,845 10,976 11,232 14,323 15,434 16,543 17,896 117,521
Total Research & Development Expenses 3,200 6,700 10,200 13,700 17,200 20,700 24,200 27,700 31,200 34,700 38,200 41,700 269,400
Total R&D Expenses Budget 1,190 3,356 9,508 13,002 15,488 19,690 21,952 22,464 28,646 30,868 33,086 35,792 235,042
Total Operating Expenses 12,800 26,800 40,800 54,800 68,800 82,800 96,800 110,800 124,800 138,800 152,800 166,800 1,077,600
Total Payroll Salaries 6,400 13,400 20,400 27,400 34,400 41,400 48,400 55,400 62,400 69,400 76,400 83,400 538,800
Total All Operating Expenses 19,200 40,200 61,200 82,200 103,200 124,200 145,200 166,200 187,200 208,200 229,200 250,200 1,616,400
EBIT 5,800 (10,100) (21,600) (33,100) (42,800) (59,620) (69,440) (83,927) (99,767) (111,767) (123,767) (135,767) (785,853)
Interest income (expense) 10,000 10,300 10,609 10,912 11,217 11,521 11,826 12,130 12,435 12,739 13,044 13,348 140,079
Other income (expense) 20,000 20,600 21,218 21,824 22,433 23,042 23,651 24,260 24,869 25,478 26,087 26,696 280,158
Total Nonoperating Income (expense) 30,000 30,900 31,827 32,736 33,650 34,563 35,477 36,390 37,304 38,217 39,131 40,044 420,237
Financial Summary
300,000
250,000
200,000
150,000
100,000
50,000
-
Total Sales Total All Operating Expenses EBIT

Total Sales vs. Total Budget
140,000
120,000
100,000
80,000
60,000
40,000
20,000
-
Total Sales Total Sales Budget Total Over / (Under Budget)
Sales Product 1
25,000
20,000
15,000
10,000
5,000
-
Sales by Product Line 1 Budget Over / (Under Budget)
Sales Product 2
12,000
10,000
8,000
6,000
4,000
2,000
-
Sales Product 3
25,000
20,000
15,000
10,000
5,000
-

Sales Product 4
25,000
20,000
15,000
10,000
5,000
-

Sales Product 5
25,000
20,000
15,000
10,000
5,000
-
Sales Product 6
25,000
20,000
15,000
10,000
5,000
-
Total COG vs. Total COG Budget
90,000
80,000
70,000
60,000
50,000
40,000
30,000
20,000
10,000
-
Total Cost of Goods Sold Total COG Budget Total Over / (Under Budget)
Materials
25,000
20,000
15,000
10,000
5,000
-
Materials Budget Over / (Under Budget)
Labor
25,000
20,000
15,000
10,000
5,000
-
Labor Budget Over / (Under Budget)
Overhead
25,000
20,000
15,000
10,000
5,000
-
Overhead Budget Over / (Under Budget)
Total G&A vs. Total G&A Budget
45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
5,000
-
Total G&A Expenses Total G&A Budget Total Over / (Under Budget)
Operating Expenses
25,000
20,000
15,000
10,000
5,000
-
Operating Expenses Budget Over / (Under Budget)
Payroll Expenses
25,000
20,000
15,000
10,000
5,000
-
Payroll Salaries Budget Over / (Under Budget)
Total Sales vs. Total Budget
45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
5,000
0
1 2 3 4 5 6 7 8 9 10 11 12
Total Sales Expenses Total Sales Expense Budget Total Over / (Under Budget)
Operating Expenses
25,000
20,000
15,000
10,000
5,000
-
Payroll Expenses
25,000
20,000
15,000
10,000
5,000
-
Total Marketing Expenses vs. Total Marketing Expense Budget
45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
5,000
0
Total Marketing Expenses Total Marketing Expense Budget Total Over / (Under Budget)
Operating Expenses
25,000
20,000
15,000
10,000
5,000
-
Payroll Expenses
25,000
20,000
15,000
10,000
5,000
-
Total R&D Expenses vs. Total R&D Expenses Budget
45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
5,000
-
Total Research & Development Expenses Total R&D Expenses Budget Total Over / (Under Budget)
Operating Expenses
25,000
20,000
15,000
10,000
5,000
-
Payroll Expenses
25,000
20,000
15,000
10,000
5,000
-

Jaxworks Dashboard1

Uploaded by

Copyright:

Available Formats

Jaxworks Dashboard1

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Jaxworks Dashboard1

Uploaded by

Copyright:

Available Formats

Financial Dashboard

Total Sales Total All Operating Expenses EBIT

Less Cost of Goods Sold

Research & Development Expenses

Total Sales Total All Operating Expenses EBIT

Sales by Product Line 3 Budget Over / (Under Budget)

Sales by Product Line 4 Budget Over / (Under Budget)

You might also like