PLZ INCLUDE EXCEL FORMULAS!

Company, a manufacturer, predicts sales of 9,750 units in January, 9,000 units in February, 12,750 units in March, and 14,000 units in April. The company wants each month's ending finished goods inventory to equal 30% of next month's predicted unit sales. Beginning finished goods inventory for January is 2,925 units. Each unit of finished goods requires 0.35 pounds of direct materials at a cost of $11.00 per pound, and 4.5 hours of direct labor at a cost of $18 per hour. Additionally, the company wants each month's ending raw materials inventory to equal 50% of next month's budgeted production. Prepare a sales budget, a production budget, a direct materials and a direct labor budget. \begin{tabular}{l} 24 \\ 25 \\ \hline 26 \\ 27 \\ 28 \\ 29 \\ 30 \\ 31 \\ \hline 32 \\ 33 \\ 34 \\ 35 \\ 36 \\ \hline 37 \\ 38 \\ 39 \\ 40 \\ \hline 41 \\ \hline 42 \\ 43 \\ \hline 44 \\ 45 \\ 46 \\ \hline 47 \\ \hline 48 \\ 49 \\ 50 \\ 51 \\ 52 \\ 53 \\ 54 \\ 55 \\ 56 \\ 57 \\ 58 \\ 59 \\ 60 \\ 61 \\ 62 \\ 63 \end{tabular} A B C D F Material price per pound Total budgeted cost of direct materials purchases \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|} \hline Company \\ For the months of January, February, and March 2023 \\ \hline \end{tabular} Direct labor rate (per hour) Total budgeted direct labor cost \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline \end{tabular} Company, a manufacturer, predicts sales of 9,750 units in January, 9,000 units in February, 12,750 units in March, and 14,000 units in April. The company wants each month's ending finished goods inventory to equal 30% of next month's predicted unit sales. Beginning finished goods inventory for January is 2,925 units. Each unit of finished goods requires 0.35 pounds of direct materials at a cost of $11.00 per pound, and 4.5 hours of direct labor at a cost of $18 per hour. Additionally, the company wants each month's ending raw materials inventory to equal 50% of next month's budgeted production. Prepare a sales budget, a production budget, a direct materials and a direct labor budget. \begin{tabular}{l} 24 \\ 25 \\ \hline 26 \\ 27 \\ 28 \\ 29 \\ 30 \\ 31 \\ \hline 32 \\ 33 \\ 34 \\ 35 \\ 36 \\ \hline 37 \\ 38 \\ 39 \\ 40 \\ \hline 41 \\ \hline 42 \\ 43 \\ \hline 44 \\ 45 \\ 46 \\ \hline 47 \\ \hline 48 \\ 49 \\ 50 \\ 51 \\ 52 \\ 53 \\ 54 \\ 55 \\ 56 \\ 57 \\ 58 \\ 59 \\ 60 \\ 61 \\ 62 \\ 63 \end{tabular} A B C D F Material price per pound Total budgeted cost of direct materials purchases \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|} \hline Company \\ For the months of January, February, and March 2023 \\ \hline \end{tabular} Direct labor rate (per hour) Total budgeted direct labor cost \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline \end{tabular}