How would you calculate the SCHEDULE OF EXPECTED CASH COLLECTIONS and CASH BUDGET in this problem or any problem
3: - Google Sheets docs.google.com/spreadsheets/d/1oqQihYOFGLh_EBdecUdERY2-obHSL2PIdCuE818yp31/edit#gid=1442316005 EE 3: File Edit View Insert Format Data Tools Add-ons Help Last edit was 8 minutes ago SHARE M Arial SALES BUDGET April May June Total July Units 20,000 51,000 105,000 45,000 Sales price per unit Total Sales PRODUCTION BUDGET April May June Total August 16 Sales in Units 20,000 34,000 51,000 105,000 45,000 30,000 19 Desired units of 6,800 10,200 9,000 26.000 6.000 20 ending inventory 22 Desired Total Units 26,800 44,200 60,000 131,000 51,000 Less: desired units of 4,000 6,800 10,200 21,000 9,000 beginning inventory Total production units 22,800 37,400 49,800 110,000 42,000 DIRECT MATERIALS BUDGET (No. 208) April May June Quarter July Units to be produced 22,800 37,400 49,800 110,000 42,000 x 4 lbs. Total material needs 91, 200 149.600 199,200 440,000 168,000 Add: desired end. Inv. 74,800 99, 600 84,000 84,000 39 Subtotal 166, 000 249,200 524,000 41 Less: Beginning 46,000 74.800 99.600 46,000 42 Total materals to be 120,000 174,400 183, 600 478,000 purchased 47 $5.00 $5.00 $5.00 $5.00 $5.00 Total cost of purchases $600,000 $872,000 $918,000 $2,390,000 DIRECT MATERIALS BUDGET (No. 311) April June Quarter July Sheet1 + O OM - DOO 4:573: - Google Sheets docs.google.com/spreadsheets/d/1oqQihYOFGLh_EBdecUdERY2-obHSL2PIdCuE818yp31/edit#gid=1442316005 EE 3: File Edit View Insert Format Data Tools Add-ons Help Last edit was 8 minutes ago SHARE M Arial 3 G +MY . E . fx 50 DIRECT MATERIALS BUDGET (No. 311) April May June Quarter July 53 Units to be produced 22,800 37,400 110.000 42,000 x 9 feet 9 Total material needs 205,200 336,600 448,200 990,000 378,000 Add: Desired end. Inv. 112,200 149,400 Subtotal 317,400 486,000 126,000 574,200 126, 000 1, 116,000 61 Less: Beginning Inventory 69,000 112, 200 149,400 69,000 63 Total materials to be purchased 248,400 373,800 424,800 1,047,000 X $2.00 67 69 Total cost of purchased $496,800 $747,600 $849,600 $2,094,000 SCHEDULE OF CASH PAYMENTS FOR DIRECT MATERIALS April June Quarter Accounts Payable 3/31 $351, 200 $351,200 $548,400 $548,400 $1, 096,800 May $809,800 $809,800 $1, 619,600 80 June $883.800 $883.800 6689 Total $1, 358,200 $1,693,600 $3, 951,400 DIRECT LABOR BUDGET April June Quarter 88 Units to be produced 22,800 37,400 49.800 110,000 90 x .25 (Shaping) 0.25 0.25 0.25 0.25 91 Hrs. Shaping Dept. 5.70 9 250 12.450 27.50 x $18.00 $18.00 $18.00 $18.00 $18.00 93 94 Labor cost Shaping dept. $102,600 $168 $224. 100 $495.000 x .70 (Assembly) 0.70 0.70 0.70 0.70 Sheet1 + O OM - DOO 4:573: - Google Sheets docs.google.com/spreadsheets/d/1oqQihYOFGLh_EBdecUdERY2-obHSL2PIdCuE818yp31/edit#gid=1442316005 EE 3: File Edit View Insert Format Data Tools Add-ons Help Last edit was 8 minutes ago SHARE M Arial 3 G + MY . E . fx DIRECT LABOR BUDGET 86 April May June Quarter 88 Units to be produced 22,800 37,400 49.800 110,000 89 90 x .25 (Shaping) 0.25 0.25 91 92 Hrs. Shaping Dept. 5,700 9,350 12.450 x $18.00 $18.00 $18.00 27,500 $18.00 $18.00 94 Labor cost Shaping dept. $102,600 $168,300 $224, 100 $495,000 96 x .70 (Assembly) 0.70 0.70 98 Hrs. Assembly Dept 15,960 26, 180 34,860 77,00 66 x $16.00 $16.00 $16.00 $16.00 $16.00 100 Labor cost for Assembly $255,360 $418,880 $557, 760 $1, 232,000 dept. x .10 (Finishing) 0.10 0.10 0.10 0.10 107 His. Finishing Dept. 2,280 3,740 4,980
