Did i do these correctly?
Assumptions:
Total Purchases of Direct Materials $ 79,994S 98,221 $ 93,310$ 76,962 $ 67,777 $ 74,257 $ 86,902 $ 110,448 $ 126,003 $ 125,393 $ 129,968$ 138,355$ 1,207,588 $ 107,198 Cash Payments (Accounts Payable) Opening Accounts Payable Current Month Credit Purchases Total Accounts Payable Less Current Month Payments Op Accounts Payable Current Month Purchases Ending Accounts Payable July August September October November December January February March April May June TOTAL $ 122,494 $ 98,221 $ July 93,310 $ 76,962 $ 67,777 $ 74,257 $ 86,902 $ 110,448 $ 126,003 $ 125,393 $ 129,968 $ 138,355 $ 1,207,588 $ $ 122,494 $ 98,221 $ 107,198 93,310 $ 76,962 $ 67,777 $ 74,257 $ 86,902 $ 110,448 $ 126,003 $ 125,393 $ 129,968 $ 244,988 $ 138,355 $ 1,207,588 $ $ 107,198 196,443 $ 186,620 $ 153,924 $ 135,554 $ 148,514 $ 173,804 $ 220,895 $ 252,005 $ 250,785 $ 259,935 $ 276,710 $ 2,415,175 $ $ 24,499'S 214,395 19,644 'S 18,662's 15,392'S 13,555'S 14,851 's 17,380'S 22.090'S 25,201 's 25.079S 25,994 "S 27,671'S 241,518 "S $ 269,486 $ 216,087 $ 21,440 205,282 $ 169,316 $ 149,109 $ 163,365 $ 191,184 $ 242,985 $ 277,206 $ 275,864 $ 285,929 $ 304,381 $ $ 215,589.00 $ 172,869.40 2,656,693 $ 235,835 $164,225.60 $ 135,452.90 $ 119,287.30 $ 130,692.10 $ 152,947.30 $ 194,387.60 $ 221,764.40 $ 220,690.80 $ 228,742.80 $ 243,504.80 $2,125,354.00 $ 188,667.60 $ 53,897 $ 43,217 $ 41,056 $ 33,863 $ 29,822 $ 32,673 $ 38,237 $ 48,597 $ 55,441 $ 55,173 $ 57,186 $ 60,876 $ 531,339 $ 47,167 $ 485,075 $ 388,956 $ 369,508 $ 304,769 $ 268,396 $ 294,057 $ 344,131 $ 437,372 $ 498,970 $ 496,554 $ 514,671 $ 547,886 $ 4,782,047 $ 4,950,347 Total Accounts Payable Payments 100% Cash Payments All Direct Materials purchased on credit Accounts Payable: Paid in month of purchase Paid in the month following purchase 20% 80% Total Purchases of Direct Materials $ 79,994S 98,221 $ 93,310$ 76,962 $ 67,777 $ 74,257 $ 86,902 $ 110,448 $ 126,003 $ 125,393 $ 129,968$ 138,355$ 1,207,588 $ 107,198 Cash Payments (Accounts Payable) Opening Accounts Payable Current Month Credit Purchases Total Accounts Payable Less Current Month Payments Op Accounts Payable Current Month Purchases Ending Accounts Payable July August September October November December January February March April May June TOTAL $ 122,494 $ 98,221 $ July 93,310 $ 76,962 $ 67,777 $ 74,257 $ 86,902 $ 110,448 $ 126,003 $ 125,393 $ 129,968 $ 138,355 $ 1,207,588 $ $ 122,494 $ 98,221 $ 107,198 93,310 $ 76,962 $ 67,777 $ 74,257 $ 86,902 $ 110,448 $ 126,003 $ 125,393 $ 129,968 $ 244,988 $ 138,355 $ 1,207,588 $ $ 107,198 196,443 $ 186,620 $ 153,924 $ 135,554 $ 148,514 $ 173,804 $ 220,895 $ 252,005 $ 250,785 $ 259,935 $ 276,710 $ 2,415,175 $ $ 24,499'S 214,395 19,644 'S 18,662's 15,392'S 13,555'S 14,851 's 17,380'S 22.090'S 25,201 's 25.079S 25,994 "S 27,671'S 241,518 "S $ 269,486 $ 216,087 $ 21,440 205,282 $ 169,316 $ 149,109 $ 163,365 $ 191,184 $ 242,985 $ 277,206 $ 275,864 $ 285,929 $ 304,381 $ $ 215,589.00 $ 172,869.40 2,656,693 $ 235,835 $164,225.60 $ 135,452.90 $ 119,287.30 $ 130,692.10 $ 152,947.30 $ 194,387.60 $ 221,764.40 $ 220,690.80 $ 228,742.80 $ 243,504.80 $2,125,354.00 $ 188,667.60 $ 53,897 $ 43,217 $ 41,056 $ 33,863 $ 29,822 $ 32,673 $ 38,237 $ 48,597 $ 55,441 $ 55,173 $ 57,186 $ 60,876 $ 531,339 $ 47,167 $ 485,075 $ 388,956 $ 369,508 $ 304,769 $ 268,396 $ 294,057 $ 344,131 $ 437,372 $ 498,970 $ 496,554 $ 514,671 $ 547,886 $ 4,782,047 $ 4,950,347 Total Accounts Payable Payments 100% Cash Payments All Direct Materials purchased on credit Accounts Payable: Paid in month of purchase Paid in the month following purchase 20% 80%
