only need the last question answered, the rest is just additional information. thank you!

Carla Vista 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 2022. 1. 2. Sales: quarter 1, 29,400 bags: quarter 2,44,000 bags. Selling price is $61 per bag. Direct materials: each bag of Snare requires 5 pounds of Gumm at a cost of $4 per pound and 6 pounds of Tarr at $1.8 per pound. Desired inventory levels: 3. January 1 April 1 July 1 8.500 12,300 18,500 Type of Inventory Snare (bags) Gumm (pounds) Tarr (pounds) 9,400 10,200 13,100 14.400 20,500 25,500 4. 5. 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. Income taxes are expected to be 20% of income before income taxes. 6. 7. Your assistant has prepared two budgets: (1) the manufacturing overhead budget shows expected costs to be 125% of direct labor cost, and (2) the direct materials budget for Tarr shows the cost of Tarr purchases to be $299,000 in quarter 1 and $426,500 in quarter (a) Your answer is correct. Prepare the sales budget. CARLA VISTA FARM SUPPLY COMPANY Sales Budget For the Six Months Ending June 30, 2022 Quarter Six Months 1 2 Expected Unit Sales 29400 44000 73400 $ 61.00 $ Unit Selling Price 61,00 $ 61.00 Total Sales $ 1793400 $ 2684000 $ 4,477,400 Prepare the production budget. CARLA VISTA FARM SUPPLY COMPANY Production Budget For the Six Months Ending June 30, 2022 Quarter 1 2 Six Months 29400 44000 Hing Finished Goods Units 12300 18500 41700 62500 Finished Goods Units 8500 12300 33200 50200 83400 Prepare the direct materials budget. (Round Cost per pound answers to 2 decimal places, e.g. 52.70.) CARLA VISTA FARM SUPPLY COMPANY Direct Materials Budget-Gumm For the Six Months Ending June 30, 2022 Quarter 1 2 Units to be Produced 33200 50200 Direct Materials per Unit 5 5 Total Pounds Needed for Production 166000 251000 Add : Desired Ending Direct Materials (Pounds) 10200 13100 Total Materials Required 176200 264100 Less vi Beginning Direct Materials (Pounds) 9400 10200 Direct Materials Purchases 166800 253900 Cost per Pound 4 4 Total Cost of Direct Materials Purchases $ 667 200 $ 1,015,600 Prepare the direct labor budget. (Enter Direct labor time per unit in proportion to hours, eg. for 45 minutes the proportion will be 0.75.) CARLA VISTA FARM SUPPLY COMPANY Direct Labor Budget For the Six Months Ending June 30, 2022 Quarter Six Months 1 2 3 be Produced 33200 50200 Labor Time (Hours) per Unit 25 25 quired Direct Labor Hours 8300 12550 abor Cost por Hour SA 16 16 irect Labor Cost $ 132,800 200,800 $ 333,600 Prepare the selling and administrative expense budget CARLA VISTA FARM SUPPLY COMPANY Selling and Administrative Expense Budget For the Six Months Ending June 30, 2022 Quarter Six Months 1 2 29400 $ 44000 d Sales in Units $ 73400 Expenses 269.010 402,600 671,610 penses 180,000 180,000 360,000 $ ling and Administrative Expenses 449,010 582,600 1.031,610 Prepare the budgeted multiple-step income statement for the first 6 months. (Round intermediate calculations to 2 decimal places and final answer to decimal places, eg. 1,255.) CARLA VISTA FARM SUPPLY COMPANY Budgeted Income Statement For the Six Months Ending June 30, 2022 Sales $ 4.477,400 Cost of Goods Sold Gross Profit Selling and Administrative Expenses 1,031.610 Income from Operations Interest Expense 100,000 i Income Before Income Tax Income Tax Expense Net Income /(Loss)