Ask a question from expert

Ask now

Sales Budget For the Period Ending 30-09-2014 Partciulars 30--4-2014 31-5-2014 30-09-2014 30-07-2014 31-08-2014 30-09-2014

6 Pages1151 Words314 Views
   

Added on  2020-05-28

About This Document

Cash Budget For the Period Ending 30-09-2014 Partciulars 30-4-2014 30-6-2014 31-07-2014 Total Cash Balance, beginning -£6,000 -£ 20,500 -£ 31,000 -£ 34,500 -£ 37,000 -£ 38,500 -£ 36,000 Add: Receipts: Collections from Debtors £ 20,000 £ 28,000 £ 20,000 £ 22,000 £ 24,000 £ 26,000 £ 140,000 Total Cash Available £ 20,000 £ 28,000 £ 20,000 £ 22,000 £ 24,000 £ 26,000 £ 140,000 Deduct: Payments: Direct Materials

Sales Budget For the Period Ending 30-09-2014 Partciulars 30--4-2014 31-5-2014 30-09-2014 30-07-2014 31-08-2014 30-09-2014

   Added on 2020-05-28

BookmarkShareRelated Documents
ANSWERASIAN LIMITED1. Sales BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalSales with 2000 increase every month £ 20,000 £ 22,000 £ 24,000 £ 26,000 £ 28,000 £ 30,000 £ 150,000 Units Sold increasing by 40 units per month4004404805205606003000Selling Price Per unit £ 50 £ 50 £ 50 £ 50 £ 50 £ 50 £ 50 2. Cash BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalCash Balance, beginning-£ 6,000 -£ 20,500 -£ 31,000 -£ 34,500 -£ 37,000 -£ 38,500 -£ 6,000 Add: Receipts: Collections from Debtors £ 20,000 £ 28,000 £ 20,000 £ 22,000 £ 24,000 £ 26,000 £ 140,000 Total Cash Available £ 20,000 £ 28,000 £ 20,000 £ 22,000 £ 24,000 £ 26,000 £ 140,000 Deduct: Payments:Direct Materials £ 16,000 £ 20,000 £ 5,000 £ 6,000 £ 7,000 £ 8,000 £ 62,000 Direct Labour £ 6,000 £ 6,000 £ 6,000 £ 6,000 £ 6,000 £ 6,000 £ 36,000 Production Overheads £ 2,500 £ 2,500 £ 2,500 £ 2,500 £ 2,500 £ 2,500 £ 15,000 Other Expenses £ 10,000 £ 10,000 £ 10,000 £ 10,000 £ 10,000 £ 10,000 £ 60,000 Total £ £ £ £ £ £ £
Sales Budget For the Period Ending 30-09-2014 Partciulars 30--4-2014 31-5-2014 30-09-2014 30-07-2014 31-08-2014 30-09-2014_1
Disbursements34,500 38,500 23,500 24,500 25,500 26,500 173,000 Excess (Deficiency)of Cash Available -£ 14,500 -£ 10,500 -£ 3,500 -£ 2,500 -£ 1,500 -£ 500 -£ 33,000 Cash Balance, ending-£ 20,500 -£ 31,000 -£ 34,500 -£ 37,000 -£ 38,500 -£ 39,000 -£ 39,000 3. Debtors BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalOpening Balance £ 48,000 £ 48,000 £ 42,000 £ 46,000 £ 50,000 £ 54,000 £ 48,000 Add Sales £ 20,000 £ 22,000 £ 24,000 £ 26,000 £ 28,000 £ 30,000 £ 150,000 £ 68,000 £ 70,000 £ 66,000 £ 72,000 £ 78,000 £ 84,000 £ 198,000 Less Cash Collected-£ 20,000 -£ 28,000 -£ 20,000 -£ 22,000 -£ 24,000 -£ 26,000 -£ 140,000 Closing Balance £ 48,000 £ 42,000 £ 46,000 £ 50,000 £ 54,000 £ 58,000 £ 58,000 4. Ceditors BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalOpening Balance £ 36,000 £ 25,000 £ 11,000 £ 13,000 £ 15,000 £ 17,000 £ 36,000 Add Purchases £ 5,000 £ 6,000 £ 7,000 £ 8,000 £ 9,000 £ 10,000 £ 45,000 £ 41,000 £ 31,000 £ 18,000 £ 21,000 £ 24,000 £ 27,000 £ 81,000 Less Cash Paid-£ 16,000 -£ 20,000 -£ 5,000 -£ 6,000 -£ 7,000 -£ 8,000 -£ 62,000 Closing Balance £ 25,000 £ 11,000 £ 13,000 £ 15,000 £ 17,000 £ 19,000 £ 19,000 5. Production BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalDirect material £ £ £ £ £ £ £
Sales Budget For the Period Ending 30-09-2014 Partciulars 30--4-2014 31-5-2014 30-09-2014 30-07-2014 31-08-2014 30-09-2014_2
Cost7,500 7,500 7,500 7,500 7,500 7,500 45,000 Direct labour Cost £ 6,000 £ 6,000 £ 6,000 £ 6,000 £ 6,000 £ 6,000 £ 36,000 Production Overheads £ 2,500 £ 2,500 £ 2,500 £ 2,500 £ 2,500 £ 2,500 £ 15,000 Total Production Costs £ 16,000 £ 16,000 £ 16,000 £ 16,000 £ 16,000 £ 16,000 £ 96,000 6. Raw Materials and Finished Goods BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalOpening Balance of Raw Material £ 18,000 £ 15,500 £ 14,000 £ 13,500 £ 14,000 £ 15,500 £ 18,000 Add Purchases £ 5,000 £ 6,000 £ 7,000 £ 8,000 £ 9,000 £ 10,000 £ 45,000 £ 23,000 £ 21,500 £ 21,000 £ 21,500 £ 23,000 £ 25,500 £ 63,000 Production Units 5005005005005005003000Production costs -£ 7,500 -£ 7,500 -£ 7,500 -£ 7,500 -£ 7,500 -£ 7,500 -£ 45,000 Closing Balance £ 15,500 £ 14,000 £ 13,500 £ 14,000 £ 15,500 £ 18,000 £ 18,000
Sales Budget For the Period Ending 30-09-2014 Partciulars 30--4-2014 31-5-2014 30-09-2014 30-07-2014 31-08-2014 30-09-2014_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Computation of Acquisition Analysis and Consolidation Worksheet Entries
|7
|949
|72