MASTER BUDGET
NEED MANUFACTURING OVERHEAD BUDGET , CASH BUDGET IN THE GIVEN FORMAT
\fAB95 X C D E 75 76 Finished Goods Inventory 77 March 31 78 79 Production costs per unit Quantity Cost Total per unit Direct materials 1.25 Kg 57.00 $ 71.25 81|Direct labour 3.50 hrs 30.00 105.00 82 | Manufacturing Overhead 75 60 4,470.90 53 $ 4.647.15 84 83 | Budgeted Finished goods Inventory 75 86 |Unit product cost $ 4,647.15 87 Ending finished goods inventory S. 348.536 89 90 Selling and Administrative Budget 91 Quarter ended March 31 2023 92 January February March Total ga | Budgeted sales 80 100 270 94 Variable selling and admin rate 95 Variable expenses 559 559 96 Flied selling and admin 16 95 Total expenses 99 100 101 Depredation 102 Cash disbursements for selling and admin. $ S 103 104 105 Cach Budget 106 Quarter ended March 31 2023 107 January February March Total 108 109 110 111 113 114 115 116 117 118 119 120 121 122 123 Total disbursements 124 Cash in (out) 125 Finandny 126 Borrowing 127 Repayments 128 Interest 129 Total financing 130 Ending cash balance $50,000 min. 131 132 Loan balance EET 134 135 Income Statement 136 Quarter ended March 31 2023 137 138 Sales $ 4,59,000 139| Cost of goods sold 12,54.730 140 Gross margin (7.95.730) 141 Selling and administrative expenses 142 Earnings before interest and taxes (EBIT) (7.95,730) 142 Interest expense 144 Earnings before tax (EBT) (7.95.730)January February March Total 6 Budgeted Sales 90 100 270 7 Selling price per unit 5 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 Total sales $ 1 36,000 $ 153,000 $ 1,70.000 $ 4.59.000 9 10 11 |Expected Cash Collections 12 Quarter ended March 31, 2023 13 January February March Total April Month of sale 59% S 80.240 S 90,270 $ 1,00,300 $ 2,70,810 15 Month following sale 40% 56,000 54,400 61,200 1,71,600 68,000 16 Total expected cash collection: 136 240 $ 144 670 $ 161 500 5 4,42,410 17 18 19 Production Budget 20 Quarter ended March 31, 2023 21 January February March Total April May zz sales(units) 80 90 100 270 110 121 23 Add:desired ending Inventory 25% 23 25 28 75 30 24 Total needed 103 115 128 346 140 25 Less: beginning Inventory (20) (23) (25) (68) (28) 26 Required production (units) 83 92 103 278 112 27 28 29 Direct Materials Budget 30 Quarter ended March 31, 2073 31 January February March Total April 32 Production(units) 83 92 103 278 112 33 Materials per unit in PURCHASE UNIT 1.25 1.25 1.25 1.25 1.25 34 Production(kg 103 115 128 348 140 35 Add: desired ending inventory 40% 46 51 139 236 36 Total needed 149 166 267 584 37 Less beginning Inventory 41 46 51 138 38 Materials to be purchased 108 120 216 446 39 Price per Kg S 57.00 $ 57.00 $ 57.00 $ 57.00 Total materials to be purchased 6.163 5 6.854 5 12,305 5 25 394 41 42 43 Expected Cash Disbursements Budget Quarter ended March 31 2023 January February March Total April 46 Current month 70% S 4,314 $ 4,798 $ 8,613 $ 17,726 Next month 30% 3,200 1,845 2.056 7,105 3,691 Total cash disbursements for materials 7514 5 6.647 5 10 670 5 24,831 49 Direct labour budget Quarter ended March 31 2023 January February March Total Production(units) 92 103 278 Direct labour hours 3.50 3.50 3.50 3.50 Labour hours required 289 322 359 970 57 Wage rate 30.00 $ 30.00 $ 30.00 $ 30.00 58 Total direct labour cost 8,663 5 9,660 5 10 763 $ 29,085 59 60 61 Manufacturing Overhead Quarter ended March 31 63 January February March Total $4 Production(units) 83 92 103 278 65 Variable MOH rate 170.00 5 170.00 5 170.00 5 170,00 66 Variable MOH costs 14,025 5 15,640 $ 17,425 |S 47,260 67 Fixed MOH costs 398550 398550 398550 1195650 Total MOH costs 412575 414190 415975 1242910 69 Loss non cash costs 70 Depredation 1,32,000 1,32,000 1,32,000 3,96,000 71 72 73| Cash disbursements on MOH
