HW11 - 112000 140000 180000 432000 Cash Collections from...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Jack Meehan Accounting 152 C9-23 10/2/2007 Land purch. In May 25000 Section 11 Dividends each month 12000 minimum cash balance each month 10000 Beginning Cash 14000 price per tie 8 Accounts Payable Cash Ba Sales Ending Inv. Cost of ties Revenue of Ties That Month Next Month Collections January 20000 21600 100000 160000 50000 50000 40000 February 24000 25200 120000 192000 60000 60000 128000 March 28000 31500 140000 224000 70000 70000 192000 April 35000 40500 175000 280000 87500 87500 230000 May 45000 54000 225000 360000 112500 112500 286000 June 60000 36000 300000 480000 150000 150000 370000 July 40000 32400 200000 320000 100000 100000 410000 August 36000 28800 180000 288000 90000 90000 352000 September 32000 0 160000 256000 80000 80000 288000 SALES BUDGET April May June Quarter July August Sales 35000 45000 60000 140000 40000 36000 + EI 40500 54000 36000 130500 32400 = Total Needs 75500 99000 96000 270500 72400 - Less BI 31500 40500 54000 126000 36000 Req Production 44000 58500 42000 144500 36400 Schedule of Cash Collections April May June Quarter Cash Collections from this month 70000 90000 120000 280000 Cash Collections from last month
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 112000 140000 180000 432000 Cash Collections from two months ago 48000 56000 70000 712000 Total 230000 286000 370000 1424000 MERCHANDISE PURCHASES BUDGET April May June Quarter Raw Materials units 44000 58500 42000 144500 Raw Materials (dollars) 220000 292500 210000 722500 + EI units 40500 54000 36000 130500 + EI (dollars) 202500 270000 180000 652500 = Total Needs (units) 84500 112500 78000 275000 = Total Needs (dollars) 422500 562500 390000 1375000- Less BI 31500 40500 54000 126000- Less BI (dollars) 157500 202500 270000 630000 Required Purchases 53000 72000 24000 149000 Required Purchases 265000 360000 120000 745000 Schedule of Cash Disbursements April May June Quarter Cash disbursements from this month 110000 146250 105000 361250 Cash disbursements from last month 137200 110000 146250 393450 = Total Cash Disbursements 247200 256250 251250 754700...
View Full Document

Page1 / 2

HW11 - 112000 140000 180000 432000 Cash Collections from...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online