SHERIDAN FARM SUPPLY COMPANY Direct Materials Budget$-$Gumm

For the Six Months Ending June $30,2025$

Quarter

$1$

$2$

Total Materials Required

$

$

$

Sheridan Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first $2$ quarters of $2025.$

Sales: quarter $1,28,200$ bags; quarter $2,42,400$ bags. Selling price is $$63$ per bag.

Direct materials: each bag of Snare requires $4$ pounds of Gumm at a cost of $$4$ per pound and $6$ pounds of Tarr at $$1\mathrm{.}75$ per pound.

Desired inventory levels:

$\backslash$table$[[$Type of Inventory,January $1,$April $1,$July $1,],[$Snare $($bags$),,8,200,12,200,18,100],[$Gumm $($pounds$),9,100,10,400,13,300,],[$Tarr $($pounds$),14,500,20,400,25,200,]]$

Direct labor: direct labor time is $15$ minutes per bag at an hourly rate of $$16$ per hour.

Selling and administrative expenses are expected to be $15\%$ of sales plus $$180,000$ per quarter.

Interest expense is $$100,000$ for the $2$ quarters.

Income taxes are expected to be $20\%$ of income before income taxes.

SHERIDAN FARM SUPPLY COMPANY Direct Materials Budget$-$Gumm

For the Six Months Ending June $30,2025$

Quarter

$1$

$2$

Total Materials Required

$

$

$