URGENT!!

Please prepare schedule of expected cash payments for Direct material purchased

30% of the direct materials is paid for in cash upon purchase. Payment for 50% of the balance is made within 15 days. 30% is paid after the month of purchase and the remainder thereafter.

the total cost of DM purchased is avaliable on the provided photo at first.

A B C D F Direct Material Budget \begin{tabular}{|l|r|r|r|} \hline & \multicolumn{1}{l|}{ January } & \multicolumn{1}{l}{ February } & \multicolumn{1}{l}{ March } \\ \cline { 2 - 4 } & 111,800.00 & 113,820.00 & 114,940.00 \\ Units to be produced (units) & 3.00 & 3.00 & 3.00 \\ \hline Required material per unit (pounds) & 335,400.00 & 341,460.00 & 344,820.00 \\ \hline Total Direct material production rec & & & \\ Add: Desired ending inventory of & & & 18,045.00 \\ \hline material & 17,073.00 & 17,241.00 & 362,865.00 \\ \hline Total required direct material & 352,473.00 & 358,701.00 & 17,241.00 \\ \hline Less: Beginning Inventory of direct n & 16,770.00 & 17,073.00 & 345,624.00 \\ \hline Direct material need to be pruchase & 335,703.00 & 341,628.00 & \end{tabular} Price per pound 3 pounds of direct materials are needed to produce one unit. One pound of direct material costs $2. Sahara likes to keep 5% of the materials needed for the next month's production in its ending inventory. 30% of the direct materials is paid for in cash upon purchase. Payment for 50% of the balance is made within 15 days. 30% is paid after the month of purchase and the remainder thereafter