Document Related to Sales Budget

Added on - 28 May 2020

  • 6

    pages

  • 1151

    words

  • 5

    views

  • 0

    downloads

Showing pages 1 to 3 of 6 pages
ANSWERASIAN LIMITED1. Sales BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalSales with2000 increaseevery month£20,000£22,000£24,000£26,000£28,000£30,000£150,000Units Soldincreasing by40 units permonth4004404805205606003000Selling PricePer unit£50£50£50£50£50£50£502. Cash BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalCash Balance,beginning6,00020,50031,00034,50037,00038,5006,000Add: Receipts:Collectionsfrom Debtors£20,000£28,000£20,000£22,000£24,000£26,000£140,000Total CashAvailable£20,000£28,000£20,000£22,000£24,000£26,000£140,000Deduct: Payments:Direct Materials£16,000£20,000£5,000£6,000£7,000£8,000£62,000Direct Labour£6,000£6,000£6,000£6,000£6,000£6,000£36,000ProductionOverheads£2,500£2,500£2,500£2,500£2,500£2,500£15,000Other Expenses£10,000£10,000£10,000£10,000£10,000£10,000£60,000Total£££££££
Disbursements34,50038,50023,50024,50025,50026,500173,000Excess (Deficiency)of Cash Available14,50010,5003,5002,5001,50050033,000Cash Balance,ending20,50031,00034,50037,00038,50039,00039,0003. 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,000Add 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,000Less CashCollected20,00028,00020,00022,00024,00026,000140,000Closing Balance£48,000£42,000£46,000£50,000£54,000£58,000£58,0004. 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,000Add 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,000Less Cash Paid16,00020,0005,0006,0007,0008,00062,000Closing Balance£25,000£11,000£13,000£15,000£17,000£19,000£19,0005. Production BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalDirect material£££££££
Cost7,5007,5007,5007,5007,5007,50045,000Direct labour Cost£6,000£6,000£6,000£6,000£6,000£6,000£36,000ProductionOverheads£2,500£2,500£2,500£2,500£2,500£2,500£15,000Total ProductionCosts£16,000£16,000£16,000£16,000£16,000£16,000£96,0006. Raw Materials and Finished Goods BudgetFor the Period Ending 30-09-2014Partciulars30-4-201431-5-201430-6-201431-07-201431-08-201430-09-2014TotalOpening Balanceof Raw Material£18,000£15,500£14,000£13,500£14,000£15,500£18,000Add 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,000Production Units5005005005005005003000Production costs7,5007,5007,5007,5007,5007,50045,000Closing Balance£15,500£14,000£13,500£14,000£15,500£18,000£18,000
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document