can you please show all the steps to complete the following tables.

c. Construct the production budget. (1) Required: Note: All amounts should be entered as positive values. a. Construct the sales budget for the current year: Dowson Company is creating components of its mastr budget for the year. Below is some information from the budget commintee. \begin{tabular}{|l|c|c|c|c|c|c|} \hline & \multicolumn{3}{|c|}{ Current Year Quarters } & \multicolumn{2}{|c|}{ Next Year Quarters } \\ \cline { 2 - 7 } & 1 & 2 & 3 & 4 & 1 \\ \hline 8udgeted unit sales & 39,000 & 62,400 & 101,580 & 56,680 & 70,250 & 81,270 \\ \hline \end{tabular} Selling price per unit $36.84 Accounts receivable, beginning balance $75,424 Sales collected in the quarter sales are made 70% Sales collected in the quarter after sales are made 30% Devired ending finished goods inventory is 30Os of the budgeted unit sales of the next quarter? Finished goods inventory, beginaing 12,685 units Raw materials required to produce one unit 10 pounds Desired ending inventory of raw materials is 10% of the next quarter's production needs Row materials inveotory, be ginning 23,286 pounds raw material costs $0.83 per pound Haw materiah purchases are paid 65% in the quarter the purchases are made and 35% in the quarter following purchase \begin{tabular}{|rr|} \hline 5 & 36.84 \\ $ & 75,424 \\ & 70% \\ 30% \\ & 3056 \\ & 12,685 \\ & 10 \\ & 10s5 \\ & 23,286 \\ 5 & 0.83 \\ & 65 \end{tabular} 35N All other expenses are paid the quarter they ace incurred Accoumts payabte for raw riaterfals, beginning balanen Direct Labor Hours per unit Direct Labor Rate per Hour Varisbe Owerthead per Unit: Fued Over head per duater Vartable Selling Expense ber unit sold \( \left[\begin{tabular}{rr} 5 ight. \) & 84,000 \\ 5 & 0.80 \\ 5 & 22.55 \\ 2.15 \\ 5 & 17,000 \\ 2.28 \end{tabular} \mid e. Construct the direct labor budget. c. Construct the production budget. (1) Required: Note: All amounts should be entered as positive values. a. Construct the sales budget for the current year: Dowson Company is creating components of its mastr budget for the year. Below is some information from the budget commintee. \begin{tabular}{|l|c|c|c|c|c|c|} \hline & \multicolumn{3}{|c|}{ Current Year Quarters } & \multicolumn{2}{|c|}{ Next Year Quarters } \\ \cline { 2 - 7 } & 1 & 2 & 3 & 4 & 1 \\ \hline 8udgeted unit sales & 39,000 & 62,400 & 101,580 & 56,680 & 70,250 & 81,270 \\ \hline \end{tabular} Selling price per unit $36.84 Accounts receivable, beginning balance $75,424 Sales collected in the quarter sales are made 70% Sales collected in the quarter after sales are made 30% Devired ending finished goods inventory is 30Os of the budgeted unit sales of the next quarter? Finished goods inventory, beginaing 12,685 units Raw materials required to produce one unit 10 pounds Desired ending inventory of raw materials is 10% of the next quarter's production needs Row materials inveotory, be ginning 23,286 pounds raw material costs $0.83 per pound Haw materiah purchases are paid 65% in the quarter the purchases are made and 35% in the quarter following purchase \begin{tabular}{|rr|} \hline 5 & 36.84 \\ $ & 75,424 \\ & 70% \\ 30% \\ & 3056 \\ & 12,685 \\ & 10 \\ & 10s5 \\ & 23,286 \\ 5 & 0.83 \\ & 65 \end{tabular} 35N All other expenses are paid the quarter they ace incurred Accoumts payabte for raw riaterfals, beginning balanen Direct Labor Hours per unit Direct Labor Rate per Hour Varisbe Owerthead per Unit: Fued Over head per duater Vartable Selling Expense ber unit sold \( \left[\begin{tabular}{rr} 5 ight. \) & 84,000 \\ 5 & 0.80 \\ 5 & 22.55 \\ 2.15 \\ 5 & 17,000 \\ 2.28 \end{tabular} \mid e. Construct the direct labor budget