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
