this is my acct 203 needs help!

OAKBROOK FARM SUPPLY Oakbrook farm Supply manufactures a pesticide called Snare. The company is preparing its budget for the first two quarters of 2020. Sales in quarter 1 are budgeted at 35,000 bags, for quarter 2, sales are expected to be 50,000 bags. The selling price is $60 per bag. Create a sales budget. Check Figs: Q1 Q1 SALES BUDGET Sales, in bags Price Per Bag Sales Revenue SO Desired Inventory Levels: Snare Gumm (pounds) Tarr (pounds) 1-Jan 8,000 9,000 14,000 1-Apr 12,000 10,000 20,000 1- Jul 18,000 13,000 25,000 01 Q2 PRODUCTION BUDGET Sales of Snare Budgeted + Desired Ending Inventory Subtotal - Beginning Inventory Units of Snare to Produce 0 100 Tarr and Gumm Details Each bag of Snare requires 5 pounds of Gumm at a price of $3.00 per pound and 8 pounds of Tarr at $1.50 per pound. 01 FORMULAS See Gumm Details =C2930 See Gumm Details DIRECT MATERIALS BUDGET--GUMM Bags of Snare to be produced Pounds of Gumm Required per Bag Total Pounds Needed + Desired Ending Inventory of Gumm Subtotal - Beginning Inventory of Gumm Pounds of Gumm to Purchase Gumm Cost Per Pound Cost of Gumm Purchases =C31+C32 See Gumm Details C33-C34 SO =C36+C35 DIRECT MATERIALS BUDGET--TARR Bags of Snare to be produced Pounds of Tarr Required per Bag See Tarr Details 38 39 See Tarr Details See Tarr Details 38 39 DIRECT MATERIALS BUDGET--TARR 40 Bags of Snare to be produced 41 Pounds of Tarr Required per Bag 42 Total Pounds Needed 43 + Desired Ending Inventory of Tarr 44 Subtotal 45 - Beginning Inventory of Tarr 46 Pounds of Tarr to Purchase 47 Tarr Cost Per Pound 48 Cost of Tarr Purchases 49 50 Check Figures for Tarr 41 42 43 44 45 46 47 48 49 50 See Tarr Details 0 $0 SO SO $477,000 $679,500 $1,156,500 51