Lily Company is preparing its master budget for $2025.$ Relevant data pertaining to its sales, production, and direct materials budgets

are as follows.

Sales. Sales for the year are expected to total $840,000$ units. Quarterly sales are $22\%,23\%,23\%,$ and $32\%,$ respectively. The unit

selling price is expected to be $$38$ for the first three quarters and $$45$ beginning in the fourth quarter. Sales in the first quarter of

$2026$ are expected to be $15\%$ higher than the budgeted sales for the first quarter of $2025.$

Production. Management desires to maintain the ending finished goods inventories at $25\%$ of the next quarter's budgeted sales

volume.

Direct materials. Each unit requires $2$ pounds of raw materials at a cost of $$11$ per pound. Management desires to maintain raw

materials inventories at $10\%$ of the next quarter's production requirements. Assume the production requirements for first quarter

of $2026$ are $378,000$ pounds.

Prepare the sales, production, and direct materials budgets by quarters for $2025.$ LILY COMPANY

Production Budget

For the Year Ending December $31,2025$

Quarter

LILY COMPANY

Direct Materials Budget

For the Year Ending December $31,2025$

Quar

$1$

$2$

$1\sqrt[\phantom{2}]{}$

$1$ LILY COMPANY

Production Budget

For the Year Ending December $31,2025$

LILY COMPANY

Direct Paterials Budget

he Year Ending December $31,2025$ Prepare the sales, production, and direct materials budgets by quarters for $2025.$what would the answer be in chart formLily Company is preparing its master budget for $2025.$ Relevant data pertaining to its sales, production, and direct materials budgets

are as follows.

Sales. Sales for the year are expected to total $840,000$ units. Quarterly sales are $22\%,23\%,23\%,$ and $32\%,$ respectively. The unit

selling price is expected to be $$38$ for the first three quarters and $$45$ beginning in the fourth quarter. Sales in the first quarter of

$2026$ are expected to be $15\%$ higher than the budgeted sales for the first quarter of $2025.$

Production. Management desires to maintain the ending finished goods inventories at $25\%$ of the next quarter's budgeted sales

volume.

Direct materials. Each unit requires $2$ pounds of raw materials at a cost of $$11$ per pound. Management desires to maintain raw

materials inventories at $10\%$ of the next quarter's production requirements. Assume the production requirements for first quarter

of $2026$ are $378,000$ pounds.

Prepare the sales, production, and direct materials budgets by quarters for $2025.$

Can you set this up in a chat so i can follow what you are doing with the answers thank you