D M Widgets R US Corp. Master Budget 2020 4 Sales Budget (Part 1) Data Input 01 02 03 04 Year Sales Price $380.00 6 7 8 9 Sales in Units 10 Selling price/unit 11 Grass Revenue 12 Cash Collections: 13 Collections of Accounts Receivable 14 75% Current Quarter's Sales 15 25% Previous Quarter's Sales 16 Total Cash Collections 17 18 Unit Sales 01 92 CB 04 600X 50,000 75,000 80,000 Unit Materials cast $65.00 01 2020 sales production 70,000 80 000 Direct Labor Rate $21.00 Per Hour $3,250,000.00 Olrly Dividend $200,000.00 Variable Overhead $6.00 /oir, Labor Hri Production Budget IPart 2) Variable 5 & A Exp $8.00 unit sold 01 02 03 64 Year 19 20 21 22 23 Budgeted Unit Sales 24 Add: Desired End. Inv 25 of finished goods 26 Total units needed 27 Less: Beg. Inv. 28 Budgeted production 90 30 31 32 33 34 35 Budgeted production 13,000 + Direct Materials Purchases Budget IPart 3) 01 az os 20 Luncted production 30 Direct Materials Purchases Budget (Part 3 01 02 04 Year 36.000 29,800 $1,500,000.00 33 14 35 Budgeted production 36 Raw materiais needed/Unit 37 Total needed for production 38 Add: Desired raw materials 39 ending inventory 40 Tatal Direct Materials needed 41 Less: Beginning inventory 42 Total D.M. Purchased 43 Unit materials cast 44 Total Direct Materials Cost 45 Cash Disbursements for D.M 46 85% Current Quarter's Purchases 47 15% Previous Quarter's Purchases 48 Total Cash Disbursements for D.M. 19 50 51 52 53 54 55 Budgeted Production 56. Direct inbor hours per unit 57 Total Direct Labor Hours Needed 58 Hourly Wage Rate 59 Budgeted Direct Labor Costs 60 61 62 63 5 Direct Labor Budget (Part 4 01 Q3 04 Year 2.50 Factory Overhead Budget (Part 1 01 02 03 65 66 Budgeted Direct Labor Hours 67 Variable Overhead Rate per Master Budget Additional Info Check Figures Factory Overhead Budget Part 5) ol 02 03 04 VT x 61 62 63 614 55 66 Budgeted Direct Labor Hours: 67 Variable verhead Rate per 68 Direct Labor Hour 69 Total Variable Mife, Overhead 70 Fixed Mfg. Overhead: 71 Depreciation 72 Other Fixed Overhead Expenses 73 Total Fixed Overhead 74 Total Mfg. Overhead 75 Less: non-cash exp (depreciation) 76 Cash Disbursements for 77 Factory Overhead 75 79 80 1 Selling and Administration Expense Budget (Part 6) EZ 91 02 03 04 Year X x 83 84 Budgeted Units Sold 85 Varinble Selling and Administration 85 Expenses per Unit 87 Total Variables & A Expenses 88 Fixed Selling and Administration Exp 89 Depreciation 90 Other Fixed & A Expense 91 Total Fixed Selling and Admin. Exp. 92 Total Selling and Administration Exp. 93 Less: non-cash exp (depreciation) 94 Cash Disbursements for 95 Selling and Administration Expenses 96 97 Master Budget Additional info Check Figures Administration MIE 104 Sales Volume 10 Cast per unit (Schedule Cash Budget 02 IL O C 156 M N 13B 139 Income Statement Year 2019 IM Uncollected balance of 4th otr Sales 141 Gross Sales RevenuelPart 1 142 Less: 143 cost of Goods Sold Part 8] 144 Gross Profit 145 Selling and Admin Exp (Part 6) 146 Operating Profit 14. Less 148 Income Taxes 149 Net Income 150 151 152 Balance Sheet 153 12/31/2019 154 155 Assels 156 Current Assets 157 Cash (Part 9) 158 Arcounts Receivable 159 Materials Inventory 160 Finished Gouds Inventory (Part 7 161 Total Current Assets 162 Plant and Equipment (Net of Alcum Depr.) 534,500 000.00 162 Total Assets 164 165 Liabilities & S.E. Equity 166 Current Liabilities 167 Accounts Payable 168 Total Current Liabilities 169 Capital Stock $27,000,000 1/0 Retained Earnings (Schedule 21 171 Total limbilities and Equity 172 173 174 175 Schedule $14,095 52.03 2018 Ending Retained Earnings Add 2019 Net Income Deduct 20:9 Dividends 2019 Ending Recained Earnings * Unpaid balance of that materials purchases check Figures D M Widgets R US Corp. Master Budget 2020 4 Sales Budget (Part 1) Data Input 01 02 03 04 Year Sales Price $380.00 6 7 8 9 Sales in Units 10 Selling price/unit 11 Grass Revenue 12 Cash Collections: 13 Collections of Accounts Receivable 14 75% Current Quarter's Sales 15 25% Previous Quarter's Sales 16 Total Cash Collections 17 18 Unit Sales 01 92 CB 04 600X 50,000 75,000 80,000 Unit Materials cast $65.00 01 2020 sales production 70,000 80 000 Direct Labor Rate $21.00 Per Hour $3,250,000.00 Olrly Dividend $200,000.00 Variable Overhead $6.00 /oir, Labor Hri Production Budget IPart 2) Variable 5 & A Exp $8.00 unit sold 01 02 03 64 Year 19 20 21 22 23 Budgeted Unit Sales 24 Add: Desired End. Inv 25 of finished goods 26 Total units needed 27 Less: Beg. Inv. 28 Budgeted production 90 30 31 32 33 34 35 Budgeted production 13,000 + Direct Materials Purchases Budget IPart 3) 01 az os 20 Luncted production 30 Direct Materials Purchases Budget (Part 3 01 02 04 Year 36.000 29,800 $1,500,000.00 33 14 35 Budgeted production 36 Raw materiais needed/Unit 37 Total needed for production 38 Add: Desired raw materials 39 ending inventory 40 Tatal Direct Materials needed 41 Less: Beginning inventory 42 Total D.M. Purchased 43 Unit materials cast 44 Total Direct Materials Cost 45 Cash Disbursements for D.M 46 85% Current Quarter's Purchases 47 15% Previous Quarter's Purchases 48 Total Cash Disbursements for D.M. 19 50 51 52 53 54 55 Budgeted Production 56. Direct inbor hours per unit 57 Total Direct Labor Hours Needed 58 Hourly Wage Rate 59 Budgeted Direct Labor Costs 60 61 62 63 5 Direct Labor Budget (Part 4 01 Q3 04 Year 2.50 Factory Overhead Budget (Part 1 01 02 03 65 66 Budgeted Direct Labor Hours 67 Variable Overhead Rate per Master Budget Additional Info Check Figures Factory Overhead Budget Part 5) ol 02 03 04 VT x 61 62 63 614 55 66 Budgeted Direct Labor Hours: 67 Variable verhead Rate per 68 Direct Labor Hour 69 Total Variable Mife, Overhead 70 Fixed Mfg. Overhead: 71 Depreciation 72 Other Fixed Overhead Expenses 73 Total Fixed Overhead 74 Total Mfg. Overhead 75 Less: non-cash exp (depreciation) 76 Cash Disbursements for 77 Factory Overhead 75 79 80 1 Selling and Administration Expense Budget (Part 6) EZ 91 02 03 04 Year X x 83 84 Budgeted Units Sold 85 Varinble Selling and Administration 85 Expenses per Unit 87 Total Variables & A Expenses 88 Fixed Selling and Administration Exp 89 Depreciation 90 Other Fixed & A Expense 91 Total Fixed Selling and Admin. Exp. 92 Total Selling and Administration Exp. 93 Less: non-cash exp (depreciation) 94 Cash Disbursements for 95 Selling and Administration Expenses 96 97 Master Budget Additional info Check Figures Administration MIE 104 Sales Volume 10 Cast per unit (Schedule Cash Budget 02 IL O C 156 M N 13B 139 Income Statement Year 2019 IM Uncollected balance of 4th otr Sales 141 Gross Sales RevenuelPart 1 142 Less: 143 cost of Goods Sold Part 8] 144 Gross Profit 145 Selling and Admin Exp (Part 6) 146 Operating Profit 14. Less 148 Income Taxes 149 Net Income 150 151 152 Balance Sheet 153 12/31/2019 154 155 Assels 156 Current Assets 157 Cash (Part 9) 158 Arcounts Receivable 159 Materials Inventory 160 Finished Gouds Inventory (Part 7 161 Total Current Assets 162 Plant and Equipment (Net of Alcum Depr.) 534,500 000.00 162 Total Assets 164 165 Liabilities & S.E. Equity 166 Current Liabilities 167 Accounts Payable 168 Total Current Liabilities 169 Capital Stock $27,000,000 1/0 Retained Earnings (Schedule 21 171 Total limbilities and Equity 172 173 174 175 Schedule $14,095 52.03 2018 Ending Retained Earnings Add 2019 Net Income Deduct 20:9 Dividends 2019 Ending Recained Earnings * Unpaid balance of that materials purchases check Figures