I need answer 100 % correct

.....................................................

....................................................

....................................................

....................................................

....................................................

....................................................

....................................................

....................................................

....................................................

....................................................

....................................................

credit sales from: April May June July August credit sales from: April May June July August Total 765,000 510,000 1,190,000 1,105,000 731,000 April May 24% 0% 0% 0% 0% April Percet Collected in June July 46% 24% 0% 0% 0% May $ 183,600.00 $ 351,900.00 $ - $ 122,400.00 $ - $ $ - $ $ - $ $ 183,600.00 $ 474,300.00 29% 46% 24% 0% 0% August 0% 29% 46% 24% 0% Amount collected in June July $ $ $ $ $ $ 221,850.00 234,600.00 285,600.00 742,050.00 $ $ $ $ $ $ 0% 0% 29% 46% 24% August 147,900.00 547,400.00 265,200.00 960,500.00 $ $ $ $ $ $ 345,100.00 508,300.00 175,440.00 1,028,840.00 credit sales from: April May June July August credit sales from: April May June July August Total 765,000 510,000 1,190,000 1,105,000 731,000 April May 24% 0% 0% 0% 0% April Percet Collected in June July 46% 24% 0% 0% 0% May $ 183,600.00 $ 351,900.00 $ - $ 122,400.00 $ - $ $ - $ $ - $ $ 183,600.00 $ 474,300.00 29% 46% 24% 0% 0% August 0% 29% 46% 24% 0% Amount collected in June July $ $ $ $ $ $ 221,850.00 234,600.00 285,600.00 742,050.00 $ $ $ $ $ $ 0% 0% 29% 46% 24% August 147,900.00 547,400.00 265,200.00 960,500.00 $ $ $ $ $ $ 345,100.00 508,300.00 175,440.00 1,028,840.00 next months udgeted sales Ratio of ivetory to future sales udgeted ase edig inventory safety stock udgeted ending inventory April May 3000 24% 720 135 855 June 7000 24% 1680 135 1815 July 6500 24% 1560 135 1695 4300 24% 1032 135 1167 udgeted ending inventory udgeted uit sales Required uits udgeted egiig ivetory udgeted Purchases udgeted cost per uit udgeted cost of purchases May June July 1815 1696 1167 3000 7000 6500 4815 8696 7667 855 1815 1696 3960 6881 5971 $ 110.00 $ 110.00 $ 110.00 $ 435,600.00 $ 756,910.00 $ 656,810.00 credit sales from: April May June July August credit sales from: April May June July August Total 765,000 510,000 1,190,000 1,105,000 731,000 April May 24% 0% 0% 0% 0% April Percet Collected in June July 46% 24% 0% 0% 0% May $ 183,600.00 $ 351,900.00 $ - $ 122,400.00 $ - $ $ - $ $ - $ $ 183,600.00 $ 474,300.00 29% 46% 24% 0% 0% August 0% 29% 46% 24% 0% Amount collected in June July $ $ $ $ $ $ 221,850.00 234,600.00 285,600.00 742,050.00 $ $ $ $ $ $ 0% 0% 29% 46% 24% August 147,900.00 547,400.00 265,200.00 960,500.00 $ $ $ $ $ $ 345,100.00 508,300.00 175,440.00 1,028,840.00 next months udgeted sales Ratio of ivetory to future sales udgeted ase edig inventory safety stock udgeted ending inventory April May 3000 24% 720 135 855 June 7000 24% 1680 135 1815 July 6500 24% 1560 135 1695 4300 24% 1032 135 1167 udgeted ending inventory udgeted uit sales Required uits udgeted egiig ivetory udgeted Purchases udgeted cost per uit udgeted cost of purchases May June July 1815 1696 1167 3000 7000 6500 4815 8696 7667 855 1815 1696 3960 6881 5971 $ 110.00 $ 110.00 $ 110.00 $ 435,600.00 $ 756,910.00 $ 656,810.00 credit Purchases from: May June July credit purchases from: May June July Total 435,600.00 756,910.00 656,810.00 percet paid June July May 60% 0% 0% May 40% 60% 0% 0% 40% 60% amout paid i June July $ 261,360.00 $ 174,240.00 $ $ - $ 454,146.00 $ $ - $ - $ $ 261,360.00 $ 628,386.00 $ 302,764.00 394,086.00 696,850.00 beg cash bal. cash from customers Total cash avail. Cash Disburs: Paymets o purchase sellig ad admi exp iterest exp Total cash dis. Prelimiary cash balace add. Loa (loa repaymet) edig cash balace Loa balace - beg. Moth add. Loa (loa repaymet) Loa balace - ed. Moth June July 110,000.00 742,050.00 852,050.00 110,000.00 960,500.00 1,070,500.00 628,386.00 160,000 542.00 696,850.00 160,000 1050 788,928.00 63,122.00 46,878.00 110,000.00 857,899.51 212,600.49 (96,878.00) 115,722.49 50,000 46,878.00 96,878 (96,878.00) 742050 960500 628386 696850 96,878.00 - January February March Total budgeted uit sales 6750 9000 11500 $ 27,250.00 budgeted uit price $ 52.00 $ 52.00 $ 52.00 $ 52.00 budgeted Total dollars $ 351,000.00 $ 468,000.00 $ 598,000.00 $ 1,417,000.00 next months udgeted sales Ratio of ivetory to future sales budgeted edig inventory budgeted uit sales Required uits budgeted beg. ivetory budgeted Purchases January February 9000 20% 1800 6750 8550 5250 3300 March 11500 20% 2300 9000 11300 1800 9500 10500 20% 2100 11500 13600 2300 11300 budgeted sales Sales comm. Percet Sales comm. Sales Salaries Total sell. Exp. January February 6750 20% 1350 4500 5850 March 9000 20% 1800 4500 6300 11500 20% 2300 4500 6800 Equipmet - beg. Equipmet purchases Equipmet - edd. January February 636,000 669,600 33,600 98,400 669,600 768,000 January Maite expe salaries expe February 2,100 12,000 14,100 ### 12,000 14,100 March 768,000 28,800 796,800 March 2,100 12,000 14,100 January equipmet purchases lad purchases total 33,600 0 33,600 February March 98,400 28,800 0 175,000 98,400 203,800 Aswers are horizotally January Sales I uits sellig price total udgeted sales cash sales sales o credit $ 25% $ 75% $ total acc. Receivale - jauary 1 Credit sales from: January February March total collect. Of receiv. February 6750 52 351,000 $ 87,750 $ 263,250 $ collected i January February 520,000 125,000 395,000 0 $ 171,112.50 0 0 0 0 125,000.00 566,112.50 January Collectio. Of receiv. February $ 125,000.00 $ 566,112.50 January desired edig ivetory budgeted uit sales Required uits budgeted beg. ivetory uits to e Purchased Cost per uit Total cost of purchases February 1800 6750 8550 5250 3300 30 99000 total Accouts Pay. Jauary 1 Merchadise purchased i: January February March 9000 52 468,000 117,000 351,000 January 345,000 2300 9000 11300 1800 9500 30 285000 February 80,000 265,000 0 0 0 19800 0 0 Total cash paid for merch. 80,000 284,800 January beg cash balace cash receipt from customers total cash availale Cash disursemets: Paymet for merchadise Sales commissi sales salaries geeral ad admi maiteace exp iterest o bak loa Taxes payale Purchases of lad Total cash disursemets Prelmiary cash balace add. Loa (loa repaymets) Edig cash balace February 36,500 46,400 125000.00 566112.50 161,500 612,513 80000 1350 4500 12,000 2100 150 0 0 284800 1800 4500 12,000 2100 0 0 0 100100 61,400 -15,000 46,400 305200 307,313 0 307,313 March 11500 52 598,000 149,500 448,500 $ $ $ ollected i 31-Mar Receivale March $ $ 92,137.50 228,150.00 $ 122,850.00 0 $ 448,500 320,287.50 571,350 March $ 320,287.50 March 2100 11500 13600 2300 11300 30 339000 31-Mar March Payales 79200 57000 0 0 228000 339000 136,200 March 307312.5 320287.50 627,600 136200 2300 4500 12,000 2100 0 92,000 175000 424100 203,500 0 203,500 567,000 credit sales from: April May June July August credit sales from: April May June July August Total 765,000 510,000 1,190,000 1,105,000 731,000 April May 24% 0% 0% 0% 0% April Percet Collected in June July 46% 24% 0% 0% 0% May $ 183,600.00 $ 351,900.00 $ - $ 122,400.00 $ - $ $ - $ $ - $ $ 183,600.00 $ 474,300.00 29% 46% 24% 0% 0% August 0% 29% 46% 24% 0% Amount collected in June July $ $ $ $ $ $ 221,850.00 234,600.00 285,600.00 742,050.00 $ $ $ $ $ $ 0% 0% 29% 46% 24% August 147,900.00 547,400.00 265,200.00 960,500.00 $ $ $ $ $ $ 345,100.00 508,300.00 175,440.00 1,028,840.00 next months udgeted sales Ratio of ivetory to future sales udgeted ase edig inventory safety stock udgeted ending inventory April May 3000 24% 720 135 855 June 7000 24% 1680 135 1815 July 6500 24% 1560 135 1695 4300 24% 1032 135 1167 udgeted ending inventory udgeted uit sales Required uits udgeted egiig ivetory udgeted Purchases udgeted cost per uit udgeted cost of purchases May June July 1815 1696 1167 3000 7000 6500 4815 8696 7667 855 1815 1696 3960 6881 5971 $ 110.00 $ 110.00 $ 110.00 $ 435,600.00 $ 756,910.00 $ 656,810.00 credit Purchases from: May June July credit purchases from: May June July Total 435,600.00 756,910.00 656,810.00 percet paid June July May 60% 0% 0% May 40% 60% 0% 0% 40% 60% amout paid i June July $ 261,360.00 $ 174,240.00 $ $ - $ 454,146.00 $ $ - $ - $ $ 261,360.00 $ 628,386.00 $ 302,764.00 394,086.00 696,850.00 beg cash bal. cash from customers Total cash avail. Cash Disburs: Paymets o purchase sellig ad admi exp iterest exp Total cash dis. Prelimiary cash balace add. Loa (loa repaymet) edig cash balace Loa balace - beg. Moth add. Loa (loa repaymet) Loa balace - ed. Moth June July 110,000.00 742,050.00 852,050.00 110,000.00 960,500.00 1,070,500.00 628,386.00 160,000 542.00 696,850.00 160,000 1050 788,928.00 63,122.00 46,878.00 110,000.00 857,899.51 212,600.49 (96,878.00) 115,722.49 50,000 46,878.00 96,878 (96,878.00) 742050 960500 628386 696850 96,878.00 - January February March Total budgeted uit sales 6750 9000 11500 $ 27,250.00 budgeted uit price $ 52.00 $ 52.00 $ 52.00 $ 52.00 budgeted Total dollars $ 351,000.00 $ 468,000.00 $ 598,000.00 $ 1,417,000.00 next months udgeted sales Ratio of ivetory to future sales budgeted edig inventory budgeted uit sales Required uits budgeted beg. ivetory budgeted Purchases January February 9000 20% 1800 6750 8550 5250 3300 March 11500 20% 2300 9000 11300 1800 9500 10500 20% 2100 11500 13600 2300 11300 budgeted sales Sales comm. Percet Sales comm. Sales Salaries Total sell. Exp. January February March 351,000 468,000 598,000 20% 20% 20% 70200 93600 119600 4500 4500 4500 74700 98100 124100 Equipmet - beg. Equipmet purchases Equipmet - edd. January February 636,000 669,600 33,600 98,400 669,600 768,000 January Maite expe salaries expe February 2,100 12,000 14,100 ### 12,000 14,100 March 768,000 28,800 796,800 March 2,100 12,000 14,100 January equipmet purchases lad purchases total 33,600 0 33,600 February March 98,400 28,800 0 175,000 98,400 203,800 Aswers are horizotally January Sales I uits sellig price total udgeted sales cash sales sales o credit $ 25% $ 75% $ total acc. Receivale - jauary 1 Credit sales from: January February March total collect. Of receiv. February 6750 52 351,000 $ 87,750 $ 263,250 $ collected i January February 520,000 125,000 395,000 0 $ 171,112.50 0 0 0 0 125,000.00 566,112.50 January Collectio. Of receiv. February $ 125,000.00 $ 566,112.50 January desired edig ivetory budgeted uit sales Required uits budgeted beg. ivetory uits to e Purchased Cost per uit Total cost of purchases February 1800 6750 8550 5250 3300 30 99000 total Accouts Pay. Jauary 1 Merchadise purchased i: January February March 9000 52 468,000 117,000 351,000 January 345,000 2300 9000 11300 1800 9500 30 285000 February 80,000 265,000 0 0 0 19800 0 0 Total cash paid for merch. 80,000 284,800 January beg cash balace cash receipt from customers total cash availale Cash disursemets: Paymet for merchadise Sales commissi sales salaries geeral ad admi maiteace exp iterest o bak loa Taxes payale Purchases of lad Total cash disursemets Prelmiary cash balace add. Loa (loa repaymets) Edig cash balace February 36,500 31,700 125000.00 566112.50 161,500 597,812.5 80000 70200 4500 12,000 2100 150 0 0 284800 93600 4500 12,000 2100 541.5 0 0 168950 -7,450 39,150 31,700 397541.5 200,271.0 -54,150 146,121 March 11500 52 598,000 149,500 448,500 $ $ $ ollected i 31-Mar Receivale March $ $ 92,137.50 228,150.00 $ 122,850.00 0 $ 448,500 320,287.50 571,350 March $ 320,287.50 March 2100 11500 13600 2300 11300 30 339000 31-Mar March Payales 79200 57000 0 0 228000 339000 136,200 March 146121 320287.50 466,409 136200 119600 4500 12,000 2100 0 92,000 175000 541400 -74,992 106,691.5 31,700 567,000 Sales cost of goods Gross [profit Operatig Exp. Sales Comm Sales Salaries Ge. Adm Mait. Exp. Depre. Exp Iterest. Exp 1,417,000 817,500 599,500 283,400 13,500 36,000 6,300 23,275 691.50 Total Oper. Exp. 363,166.50 Icome efore taxes icome tax expe. et icome 236,333.50 82,716.73 153,616.78 Assets Cash Acc. Receiv. Merchadise ivet. Total curret assets Lad Equipmet Acc. Depreci Equipment - net Total Assets Liailities ad equity liailities Accouts Pay. bak loa payale icome taxes payale Total liailities Stockholders' Equity Commo stock Retaied Earigs Total Stockholders' equity Total liailities ad Equity $ $ 31,700 571,350 63,000 837,850 175,000 796,800 102775 694,025 1,706,875 567,000 106,691.50 82,716.73 756,408.23 474,500 475,966.77 950,466.77 1,706,875