Can someone tell me how to calculate the following entries A

Can someone tell me how to calculate the following entries?

Accounts Receivable (total sales dollars 4th qtr * Percent of credit sales collected QTR after sale),
Accounts payable (you figure out),
Retained earnings (you figure out….hint, back into this)

Summer Flowers Company is preparing the budget for the year ended 12/31/2018 Sales projections are as follows: 3ra 38,000 Unit Sales 25,000 18,000 39,000 26,000 22,000 40,000 . Unit sales price is $29.00 Percent of cash sales collected in the period 40% Percent of credit sales collected in period of sale 40% Percent of credit sales collected after quarter of sale 20% Desired ending inventory percentage of next quarters production needs 20% Amount of materials needed for unit to be produced is 8 pounds Desired ending inventory percentage of next quarters materials needs 15 Cost of raw materials to purchased per unit $.16, which is the same cost as the materials purchased in 2017 Percentage of purchases paid for in the period of purchase 60% Percentage of purchase paid for in the subs Direct lahor hours required to produce one unit .25 hours sequent quarter 40% Cost per direct labor hour $18.00 . Cost of variable factory overhead per direct labor hour $2.80 .Cost of Variable SG&A; per unit sold 53.00 Minimum required cash balance $20,000 Quarterly interest rate on loans outstanding charged from the beginning of the quarter 3% .Cost per unit of the prior year finished goods inventory $8.00

Solution

Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Unit sales 18000 39000 38000 26000 121000 Unit Selling Price 29 29 29 29 29 Budgeted Sales 522000 1131000 1102000 754000 3509000 Schedule of cash colections 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Cash sales 208800 452400 440800 301600 1403600 Credit Sales: 4th qrtr last year 145000 145000 1st qrtr curent year 208800 104400 313200 2nd qrtr curent year 452400 226200 678600 3rd qrtr curent year 440800 220400 661200 4th qrtr curent year 301600 301600 Total Collections 562600 1009200 1107800 823600 3503200 Receivables 104400 226200 220400 150800 150800 Production budget 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Budgeted unit sales 25000 18000 39000 38000 26000 121000 Add:Desired Ending inventory 3600 7800 7600 5200 4400 4400 Total units neded 28600 25800 46600 43200 30400 125400 Less: Beginning inventory 5000 3600 7800 7600 5200 3600 Budgeted production units 23600 22200 38800 35600 25200 121800 Raw material budget 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Budgeted Production 23600 22200 38800 35600 25200 121800 Raw material per unit - pounds 8               8.00                 8.00                8.00                8.00           8.00 Raw material required for production 188800 177600 310400 284800 201600 974400 Add:Desired ending inventory 26640 46560 42720 30240 30720 30720 Total raw material needed 215440 224160 353120 315040 232320 1005120 Less: Beginning raw materi inventory 28320 26640 46560 42720 30240 26640 Budgeted raw material purchases - units 187120 197520 306560 272320 202080 978480 Cost per unit of raw material - $ 0.16 0.16 0.16 0.16 0.16 0.16 Budgeted raw material purchases - dollars 29939 31603 49050 43571 32333 156557 Schedule of payments for raw materials 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total 4th quarter of previous year 11976 11976 1st Quarter current year 18962 12641 31603 2nd Quarter current year 29430 19620 49050 3rd Quarter current year 26143 17428 43571 4th Quarter current year 19400 19400 Total Payments 30938 42071 45763 36828 155599 Payables 12641 19620 17428 12933 12933 Direct labor budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Budgeted Production 22200 38800 35600 25200 121800 Direct labor hours per unit 0.25 0.25 0.25 0.25 0.5 total direct labor hours for production 5550 9700 8900 6300 60900 Direct labor hour rate - $ 18 18 18 18 18 Budgeted Direct Labor Cost 99900 174600 160200 113400 1096200 Manufacturing overhead budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Variable overhead rate per direct labor hour 2.8 2.8 2.8 2.8 3 Budgeted Variable overhead - $ 15540 27160 24920 17640 85260 Fixed overhead 0 Depreciation Expense 15000 15000 15000 15000 60000 Security expense 18000 18000 18000 18000 72000 Indirect labor 40000 40000 40000 40000 160000 Total manufacturing overhead 88540 100160 97920 90640 377260 Cash payment for manufacturing overhead 73540 85160 82920 75640 317260 S G & A expenses 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Variable cost per unit sold $3.00 $3.00 $3.00 $3.00 $3.00 Total variable expenses 54000 117000 114000 78000 363000 Fixed Expenses: Advertising 30000 30000 30000 30000 120000 Executive Salaries 95000 95000 95000 95000 380000 Insurance Expense 20000 20000 20000 20000 80000 Prpoerty Taxes Expenses 14000 14000 14000 14000 56000 Depreciation Expense 10000 10000 10000 10000 40000 Total S G & A Expeses 223000 286000 283000 247000 1039000 Cash payment for S G & A expenses 213000 276000 273000 237000 999000 Summer Flowers Company CASH BUDGET for the year ended December 31, 2018 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Beginning Balance 50000 95222 406591 872509 50000 Collections from sales 562600 1009200 1107800 823600 3503200 Totl cash available for disbursements 612600 1104422 1514391 1696109 3553200 Cash disbursements:    For raw material 30938 42071 45763 36828 155599    For direct Labor 99900 174600 160200 113400 548100    For manufacturing overheads 73540 85160 82920 75640 317260    For selling and administrative expenses 223000 286000 283000 247000 1039000    For payment of dividends 10000 10000 10000 10000 40000    For purchase of equipment 80000 100000 60000 20000 260000 Total disbursements 517378 697831 641883 502868 2359959 Ending Cash Balance 95222 406591 872509 1193241 1193241