Please provide equations and/or explanation on how you found each answer for the following:

(A screenshot of your cell references would be easiest)

A B D E F Name Box jolution 2 #1 Sales Budget 3 4 Guidance: Make sure you are using cell references or formulas throughout your budgets. Manufacturing Inc. Sales Budget For quarter ended June 30, 20XX 5 6 April May 44,000 $124 5,456,000 $ June 45,000 $124 5,580,000 $ Quarter 50,000 $124 6,200,000 $ 139,000 $124 17.236,000 $ April Manufacturing Inc. Production Budget For quarter ended June 30, 20XX May June 44,000 45,000 36,000 40,000 80,000 85,000 35,200 36,000 44,800 49,000 Quarter 50,000 41,600 91,600 40,000 51,600 139,000 117,600 256,600 111,200 145,400 April Manufacturing Inc. Direct Material Purchases Budget For quarter ended June 30, 20XX May June 44,800 49,000 8 8 358,400 392,000 180,000 200,000 592.000 176,000 180,000 362,400 412,000 $6 $6 $2,174,400 $2,472,000 Quarter 51,600 8 412,800 145,400 8 1,163,200 208,000 588,000 7 8 Units 9 Selling Price 10 Sales 11 12 #2 Production Budget 13 14 15 16 17 Sales Budget (Reference Budget 1) 18 Plus desired ending inventory 19 Total Inventory requirements 20 Less: Beginning Inventory 21 Units to be produced 22 23 #3 Direct Material Purchases Budget 24 25 26 27 28 Units to be produced (Reference Budget 2) 29 Direct Materials per unit (pounds) 30 Production needs (pounds) 31 Desired ending inventory (pounds) 32 Total needs (pounds) 33 Less: Beginning inventory (pounds) 34 Purchases needed of Direct materials (pounds) 35 Cost per pound 36 Total purchases of direct materials 37 38 #4 Manufacturing Cost Budget 39 40 41 42 43 Direct Materials: 44 Production needs(pounds)--found on Budget 3 45 Cost per pound 46 Total Cost of material issued to production 47 48 Direct Labor: 49 Units to be produced (Reference Budget 2) 50 Direct labor time per unit (hours) 51 Total hours needed 52 Cost per hour 53 Total cost of Direct Labor 54 55 Manufacturing Overhead: 56 Budgeted direct labor hours needed (Reference Row 51 above) 57 Variable overhead rate 58 Budgeted variable overhead 59 Budgeted Fixed overhead 60 Total Manufacturing Overhead 61 Total Manufacturing Cost 538,400 620.800 200,000 420,800 $6 $2,524,800 1,751,200 556,000 1,195,200 $6 $7,171,200 Manufacturing Inc. Manufacturing Cost Budget For quarter ended June 30, 20XX May June April Quarter 358,400 6. $2,150,400 392,000 6 $2,352,000 412,800 6 $2,476,800 1,163,200 6 $6,979,200 44.800 4 179,200 $12 $2,150,400 49,000 4 196,000 $12 $2,352,000 51,600 4 206,400 $12 $2,476,800 145,400 4 581,600 $12 $6,979,200 179,200 3.10 $555,520 132,000 $687,520 $2,837,920 196,000 3.10 $607,600 132,000 $739.600 $3,091,600 206,400 3.10 $639,840 132,000 $771,840 $3,248,640 581,600 3.10 $1,802,960 396,000 $2,198,960 $9,178,160 B April June Quarter Manufacturing Inc. Selling and Administrative Expenses Budget For quarter ended June 30, 20XX May 44,000 45,000 50,000 $2.10 $2.10 $2.10 $92,400 $94.500 $105,000 65,000 65,000 65,000 $157,400 $159,500 $170,000 139,000 $2.10 $291,900 195,000 $486,900 63 #5 Selling and Administrative Expenses Budget 64 65 66 67 68 Budgeted Sales in units (Reference Budget 1) 69 Variable Selling and Administrative expenses per unit 70 Total variable expenses 71 Fixed Selling and Administrative expenses 72 Total selling and administrative expenses 73 74 #6 Cash Budget 75 76 77 78 79 Beginning cash 80 Add Cash Collections of Sales: 81 Cash sales collected in month sale 82 Credit sales Collected in following month 83 Total Cash receipts 84 85 Cash Available 86 Less Cash Disbursements: 87 Purchases (Budget 3) 88 Direct Labor (Budget 4) 89 Overhead that uses cash 90 Selling and administrative expenses that use cash 91 Total Cash Disbursements 92 Ending Cash Manufacturing Inc. Cash Budget For quarter ended June 30, 20XX May June $150,000 $142,920 April Quarter ($20,740) $272,180 $3,055,360.00 $2,073,280.00 $5,128,640.00 $3,124,800.00 $2,400,640.00 $5,525,440.00 $3,472,000.00 $2,455,200.00 $5,906,460.00 $9,652,160.00 $6,929,120.00 $16,581,280.00 $5,278,640 $5,668,360 $5,906,460 $16,853,460 $2,174,400 2,150,400 $668,520 142,400 $5,135,720 $142.920 $2,472,000 2,352,000 $720,600 144,500 $5,689,100 ($20,740) $2,524,800 2,476,800 $752,840 155,000 $5,909,440 ($2,980) $7,171,200 6,979,200 $2,141,960 441,900 $16,734,260 $119,200 A B C D E 101 #8 Budgeted Income statement for Second quarter 102 103 Manufacturing Inc. Budgeted Income Statement For the Secord Quarter ended June 30, 20XX $ 17,236,000 104 105 106 Sales (Budget #1) 107 Cost of Goods Sold: 108 Beginning Finished Goods 109 Total Manufacturing Costs (Budget #4) 110 Cost of Goods Available for Sale 111 Ending finished goods 112 Budgeted Cost of Goods Sold 113 Gross Profit 114 Less: Selling and administrative expenses (Budget 5) 115 Income before income taxes 5,234,592 $9,178,160 14,412,752