follow: Please need help using the numbers provided

$($Click the icon to view the balance sheet.$)$

Read the requirements.

Requirement $1.$ Prepare Mata's sales budget for the first quarter of $2025.$

Requirement $2.$ Prepare Mata's production budget for the first quarter of $2025.$

More info

a$.$ Budgeted sales are $1,000$ youth bats and $3,500$ adult bats.

b$.$ Finished Goods Inventory on December $31,2024,$ consists of $400$ youth bats at $$13$

each and $650$ adult bats at $$19$ each.

c$.$ Desired ending Finished Goods Inventory is $300$ youth bats and $550$ adult bats;

FIFO inventory costing method is used.

d$.$ Direct materials requirements are $40$ ounces of wood per youth bat and $58$ ounces

of wood per adult bat. The cost of wood is $$0\mathrm{.}40$ per ounce.

e$.$ Raw Materials Inventory on December $31,2024,$ consists of $29,000$ ounces of wood

at $$0\mathrm{.}40$ per ounce.

f$.$ Desired ending Raw Materials Inventory is $29,000$ ounces $($indirect materials are

insignificant and not considered for budgeting purposes$).$

g$.$ Each bat requires $0\mathrm{.}1$ hours of direct labor; direct labor costs average $$25$ per hour.

h$.$ Variable manufacturing overhead is $$0\mathrm{.}70$ per bat.

i$.$ Fixed manufacturing overhead includes $$700$ per quarter in depreciation and $$590$

per quarter for other costs, such as insurance and property taxes.

j$.$ Fixed selling and administrative expenses include $$5,000$ per quarter for salaries;

$$1,000$ per quarter for rent; $$1,900$ per quarter for insurance; and $$450$ per quarter

for depreciation.

k$.$ Variable selling and administrative expenses include supplies at $1\%$ of sales.

Data table