*NEED FORMULAS ONLY FOR THE YELLOW BOXES!!*

I WILL LEAVE A THUMBS UP

Phol Company, a manufacturer, predicts sales of 7,800 units in January, 7,200 units in February, 10,200 units in March, and 11, 200 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,340 units. Each unit of finished goods requires 0.35 pounds of direct materials at a cost of $13.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. Phol Company Sales Budget For the months of January, February, and March 2023 Direct Materials Budget For the months of January, February, and March 2023 \begin{tabular}{l|l|l|l|} \hline \multicolumn{3}{|c|}{ Jadgeted units to produce } & \multicolumn{1}{|c|}{ March } \\ Buary \\ Materials requirements per unit \\ Materials needed for production (pounds) \\ Add: Budgeted ending inventory (pounds) \\ Total materials requirements (pounds) \\ Deduct: Beginning inventory (pounds) \\ Materials to be purchased (pounds) \end{tabular} Material price per pound Total budgeted cost of direct materials purchases Phol Company Direct Labor Budget For the months of January, February, and March 2023 Budgeted units to produce Direct labor requirements (hours) per unit Total direct labor hours needed \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ January } & February & March \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Direct labor rate (per hour) Total budgeted direct labor cost \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline \end{tabular}