Please help me solve this problem.

The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by reducing the selling price from $8 to $7. The marketing manager wants to use the following projections in the budget

Based on the above information, use Excel to prepare the revised sales, cash collections, production, raw materials purchases, cash payments, direct labor, manufacturing overhead, and selling and administrative budgets.

However, some of the information has been filled out please solve the remainig information.

1) Construct the raw materials purchases budget

2) Construct the schedule of expected cash payments

3) Construct the direct labor budget

4) Construct the manufacturing overhead budget

5) Construct the selling and administrative budget

Examples of how its suppose to look.

66 Construct the schedule of expected cash payments 68 Accounts payable, beginning balance 70 First-quarter purchases 71 Second-quarter purchases 72 Third-quarter purchases 73 Fourth-quarter purchases 74 Total cash disbursements \begin{tabular}{|r|r|r|r|r|} \hline 1 & \multicolumn{2}{|c|}{ Year 2 Quarter } & & \\ \hline? & 2 & 3 & 4 & Year \\ \hline? & ? & & & ? \\ \hline & ? & ? & ? \\ \hline \end{tabular} 76 Construct the direct labor budget 77 Units of production 79 Direct labor hour per unit 80 Labor hours required 81 Direct labor rate 82 Total direct labor cost \begin{tabular}{|rrr|r|r|r|r|} \hline 1 & \multicolumn{7}{|c|}{ Year 2 Quarter } & & & & \\ \hline? & 2 & 3 & 4 & Year \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \hline \end{tabular} 84 Construct the manufacuring overhead budget 85 86 Budgeted direct labor hours 87 Manufacturing overhead rate 88 Total manufacturing overhead cost 89 90 Construct the selling and adminstrative budget 91 92 Budgeted sales 93 Variable selling and adminstrative cost rate 94 Variable selling and adminstrative cost 95 Fixed selling and adminstrative cost 96 Total selling and adminstrative cost 97 66 Construct the schedule of expected cash payments 68 Accounts payable, beginning balance 70 First-quarter purchases 71 Second-quarter purchases 72 Third-quarter purchases 73 Fourth-quarter purchases 74 Total cash disbursements \begin{tabular}{|r|r|r|r|r|} \hline 1 & \multicolumn{2}{|c|}{ Year 2 Quarter } & & \\ \hline? & 2 & 3 & 4 & Year \\ \hline? & ? & & & ? \\ \hline & ? & ? & ? \\ \hline \end{tabular} 76 Construct the direct labor budget 77 Units of production 79 Direct labor hour per unit 80 Labor hours required 81 Direct labor rate 82 Total direct labor cost \begin{tabular}{|rrr|r|r|r|r|} \hline 1 & \multicolumn{7}{|c|}{ Year 2 Quarter } & & & & \\ \hline? & 2 & 3 & 4 & Year \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \hline \end{tabular} 84 Construct the manufacuring overhead budget 85 86 Budgeted direct labor hours 87 Manufacturing overhead rate 88 Total manufacturing overhead cost 89 90 Construct the selling and adminstrative budget 91 92 Budgeted sales 93 Variable selling and adminstrative cost rate 94 Variable selling and adminstrative cost 95 Fixed selling and adminstrative cost 96 Total selling and adminstrative cost 97