budgeting ASSIGNMENT Final

budgeting ASSIGNMENT Final - Chaires Tables Cabinets...

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

View Full Document Right Arrow Icon
Productions unit Sales 2011 Balance Sheet January 1,2012 October November December Cash 50000 Bank Loan 0 Chaires 900 975 950 Account receivable 575008 Tables 175 188 201 Machinery(net book value 360000 Sare holder equity 985008 Cabinets 90 102 95 Total 985008 Total 985008 Price Carpenter hour Unit of wood Chaires $200 0.4 $15 1 Tables $900 2.5 $65 8 Cabinets $18 6 $135 15 Estimated casdh flow Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Total Column1 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Total Chairs 900 975 950 1020 1191 1179 1195 1200 1204 1194 1199 1222 1219 1207 1192 Tables 175 188 201 200 237 243 250 252 255 242 253 243 248 244 255 Cabinets 90 102 95 109 120 119 126 122 125 123 121 127 126 126 119 Total revenue $499,500 $547,800 $541,900 $580,200 $667,500 $668,700 $690,800 $686,400 $695,300 $678,000 $685,300 $691,700 $693,800 $687,800 $682,100 $8,107,600 Cash sales= 25% of revenue $124,875 $136,950 $135,475 $145,050 $166,875 $167,175 $172,700 $171,600 $173,825 $169,500 $171,325 $172,925 $173,450 $171,950 $170,525 $2,026,900 Credit card sales=35% of rev. $174,825 $191,730 $189,665 $203,070 $233,625 $234,045 $241,780 $240,240 $243,355 $237,300 $239,855 $242,095 $242,830 $240,730 $238,735 $2,837,660 Exporter sales=40% of rev. $199,800 $219,120 $216,760 $232,080 $267,000 $267,480 $276,320 $274,560 $278,120 $271,200 $274,120 $276,680 $277,520 $275,120 $272,840 $3,243,040 Bad Debts=3% of export sales $6,962 $8,010 $8,024 $8,290 $8,237 $8,344 $8,136 $8,224 $8,300 $8,326 $8,254 $8,185 $97,291 Cash Sales Discounts=5% of cash sales $7,253 $8,344 $8,359 $8,635 $8,580 $8,691 $8,475 $8,566 $8,646 $8,673 $8,598 $8,526 $101,345 Credit Card Fees=3% of credit card sales $6,092 $7,009 $7,021 $7,253 $7,207 $7,301 $7,119 $7,196 $7,263 $7,285 $7,222 $7,162 $85,130 Column1 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Total Number of carpenters 9 10 10 11 11 11 11 11 11 11 11 11 Helpers 14 15 15 17 17 17 17 17 17 17 17 17 Used carpenter hours= number of units multiply 172 1562 1788 1793 1859 1842 1869 1820 1838 1858 1863 1848 1828 Normal carpenter hours 1548 1720 1720 1892 1892 1892 1892 1892 1892 1892 1892 1892 Carpenter overtime hours 14 68.9 73.1 0 0 0 0 0 0 0 0 0 5% of regular carpenter hours 77 86 86 94 94 94 94 94 94 94 94 94 Helper hours=172 multiply number of helper 2408 2580 2580 2924 2924 2924 2924 2924 2924 2924 2924 2924 Helper overtime hours 0 103.35 109.65 0 0 0 0 0 0 0 0 0 Cash Flow Out Column1 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-11 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Total Carpenter wages $37,656 $43,760 $43,912 $45,408 $45,408 $45,408 $45,408 $45,408 $45,408 $45,408 $45,408 $45,408 $534,000 Helper wages 33,712 38,290 38,423 40,936 40,936 40,936 40,936 40,936 40,936 40,936 40,936 40,936 478,849 Supplies and other costs 7,810 8,945 8,966 9,295 9,210 9,346
Background image of page 1

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

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

Page1 / 2

budgeting ASSIGNMENT Final - Chaires Tables Cabinets...

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