AIB 9723078 Jan15 1

Part A - AIB January 2015 Course Assessment 1
Failsworth Feeds - Cash Budget for the year to 31st December Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Totals
Notes
Output (total number of products) - - - - 3,000 3,300 3,630 3,993 4,392 4,832 5,315 5,846 34,308
1
Weeks per month
4
4
5
4
4
5
4
4
5
4
4
5
52

CASH IN

Equity 80,000

80,000

Long-term loan 60,000

40,000

100,000

Cash from customers - retailers

22,950 25,245 27,770 30,546 33,601 36,961 40,657 217,731
2
Cash from customers - racing stables

11,204 23,527 25,880 28,468 31,315 34,446 37,891 192,732
2
Cash from customers - shop

16,200 17,820 19,602 21,562 23,718 26,090 28,699 31,569 185,261
2
Total Cash In 140,000

16,200 91,974 68,374 75,212 82,733 91,006 100,107 110,118 775,723

CASH OUT

Cash to suppliers of ingredients

36,000 39,600 43,560 47,916 52,708 57,978 63,776 70,154 70,154 481,846
3
Staff pay - laboratory

10,800 8,640 8,640 10,800 8,640 8,640 10,800 8,640 8,640 10,800 95,040
4
Staff pay - shop

2,000 1,600 1,600 2,000 1,600 1,600 2,000 1,600 1,600 2,000 17,600
4
Staff on-costs - laboratory

3,024 2,419 2,419 3,024 2,419