QEDNCUU'I-hwlva AAAAAAA chm-humao A '1 ) Schedule 1: Sales Budget Q1 Q2 Q3 Q4 Total Sales in Units $2,250 $2,900 $1,750 $1,750 $8,650 Selling Price per Unit $48 $48 $48 $48 48 Sales Revenue $108,000 $139,200 $84,000 $84,000 $415,200 Expected Cash Collections Q1 Q2 Q3 Q4 Total Accounts Receivable $9,000 $9,000 Current month sales $59,400 $76,560 $46,200 $46,200 $228,360 Last month sales $48,600 $62,640 $37,800 149040 $68,400 $125,160 $108,840 $84,000 $386,400 Production Budget Q1 Q2 Q3 Q4 Total Sales in Units $2,250 $2,900 $1,750 $1,750 $8,650 Add: desired ending inventory $725 $438 $438 $575 $2,175 Total needs $2,975 $3,338 $2,188 $2,325 $10,825 Less: beginning nished goods inventory $200 $725 $438 $438 $1,800 Units to be produced $2,775 $2,613 $1,750 $1,888 $9,025 012025 I 2300: 48: 110400: 2300: 575: 2875: $438: $2438: \f19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A? Direct Materials Purchases Q1 Q2 Q3 Q4 Total : Units to be produced $2,775 $2,613 $1,750 $1,888 $9,025 2438: Materials per unit $8 $8 $8 $8 8| 8" Production needs $22,200 $20,900 $14,000 $15,100 $72,200 19504i Add: desired ending inventory $6,270 $4,200 $4,530 $5,851 5851 : Total needed $28,470 $25,100 $18,530 $20,951 $93,051 : Less: Beginning inventory $450 $6,270 $4,200 $4,530 $15,450 : Materials to be purchased $28,020 $18,830 $14,330 $16,421 $77,601 : Materials cost per pound $1.25 $1.25 $1.25 $1.25 1.25 : Total materials purchase cost $35,025 $23,538 $17.913 $20,527 $97,002 : I Cash Purchases Budget Q1 Q2 Q3 Q4 Total : Accounts Payable $2,580 0 0 $0 2580 : Current month purchases $15,761 $10,592 $8,061 $9,237 $43,651 : Last month purchases 0 $19,264 $12,946 $9,852 $42,061 : Total cash disbursements for purchases $18,341 $29,856 3521.006 $19,089 $88,292 : I I Direct Labor Budget Q1 Q2 Q3 Q4 Total : Units to be produced $2,775 $2,613 $1,750 $1,888 $9,025 : DL hours needs per unit $0.80 $0.80 $0.80 $0.80 0.8 : DL hours needed $2,220 $2,090 $1,400 $1,510 $7,220 : DL cost per hour $18.75 $18.75 $18.75 $18.75 18.75 : Total budgeted DL $41,625 $39,188 $26,250 $28,313 $135,375 : 43 44 45 45 47 4a 49 50 51 52 53 54 55 56 57 58 59 so 61 62 63 64 65 66 (:7 Overhead Budget Q1 Q2 Q3 Q4 Total DL hours needed VOH ratel hour Budgeted variable OH Budgeted fixed MOH costs Total budgeted OH expense Less: Depreciation Total cash disbursements for MOH Ending Finished goods Production costs per unit Quantity Cost Total Direct materials Direct labor MOH Selling and Administrative Expense Budget Q1 Q2 Q3 Q4 Total Budgeted sales Variable S&A rate Variable expenses Fixed S&A Total S&A Less: Depreciation Cash S&A Expenses 68 59 70 71 72 73 74 75 75 77 73 79 so 81 82 83 84 85 86 87 88 Cash Budget Beginning cash balance Add: Cash collections Total cash available Less: Cash disbursements Materials Direct Labor MOH S&A Taxes Dividends Equipment purchases Total disbursements Ending cash balance Borrowing Interest Repayments Cash at the end of the period Q1 02 Q3 Q4 Total 90 91 92 93 94 95 96 97 98 99 Budgeted income statement Sales Less: COGS Gross margin S&A expense Interest expense Net income before tax Tax expense Net income 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 Budgeted Balance sheet Cash Accounts receivable Raw materials inventory Finished goods inventory Land Building and Equipment Accumulated Depreciation Accounts payable Tax payable Capital stock RE Total L&SE
