PLZZ INCLUDE EXCEL FORMULAS

Warner Company, a manufacturer, predicts sales of 4,800 units in January, 4,400 units in February, 6,400 units in March, and 7,000 units in April. The company wants each month's ending finished goods inventory to equal 60% of next month's predicted unit sales. Beginning finished goods inventory for January is 2,880 units. Each unit of finished goods requires 0.30 pounds of direct materials at a cost of $8.00 per pound, and 4.0 hours of direct labor at a cost of $16 per hour. Additionally, the company wants each month's ending raw materials inventory to equal 40% of next month's budgeted production. Prepare a sales budget, a production budget, a direct materials and a direct labor budget. Warner Company Budget Assumptions For the months of January, February, and March 2023 \begin{tabular}{lrrc} \hline \multicolumn{2}{c}{ January } & February & March \\ \hline Selling price per unit & $580 & $580 & $580 \\ Budgeted sales (units) & 4,800 & 4,400 & 6,400 \\ Budgeted sales (units) April & & 7,000 \\ Budgeted production (units) April & & 7,400 \\ Ratio of ending finished goods inventory to next month's sales & & 60% \\ Ratio of ending raw materials inventory to next month's requirements & & 40% \\ Number of units in finished goods inventory, January 1 & & 2,880 \\ Number of pounds in raw materials inventory, January 1 & & 547 \\ Number of pounds of raw materials required per unit & & 0.30 \\ Cost per pound of raw materials & & $8.00 \\ Number of direct labor hours required per unit & & 4.0 \\ Rate per direct labor hour & & $16.00 \end{tabular} Your formula is incorrect Your formula is incorrect Direct labor rate (per hour) Total budgeted direct labor cost \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline \end{tabular}