90.2K

Verified Solution

Link Copied!

Complete all parts of A, B, and C

Part A - 1. Prepare the sales budget

2. Prepare the production budget

Part B - 1. Prepare the direct materials budget

2. Prepare the direct labor budget

3. Prepare the selling and the administative expense budget

Part C - 1. Prepare the budgeted multiple step income statement for the 6 months

Please Make sure you read all the boxes and fill everything out.

MAKE SURE TO DO ALL PARTS OF A, B, AND C

Cook 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. Sales: quarter 1,40,000 bags; quarter 2,56,000 bags. Selling price is $60 per bag. 2. Direct materials: each bag of Snare requires 4 pounds of Gumm at a cost of $3.8 per pound and 6 pounds of Tarr at $1.50 per pound. 3. Desired inventory levels: 4. Direct labor: direct labor time is 15 minutes per bag at an hourly rate of $16 per hour. 5. Selling and administrative expenses are expected to be 15% of sales plus $175,000 per quarter. 6. Interest expense is $100,000. 7. Income taxes are expected to be 20% of income before income taxes. 2. Direct materials: each bag of Snare requires 4 pounds of Gumm at a cost of $3.8 per pound and 6 pounds of Tarr at $1.50 per pound. 3. Desired inventory levels: 4. Direct labor: direct labor time is 15 minutes per bag at an hourly rate of $16 per hour. 5. Selling and administrative expenses are expected to be 15% of sales plus $175,000 per quarter. 6. Interest expense is $100,000. 7. Income taxes are expected to be 20% of income before income taxes. 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 $297,000 in quarter 1 and $439,500 in quarter 2. (Note: Do not prepare the manufacturing overhead budget or the direct materials budget for Tarr.) Prepare the sales budget. Prepare the production budget. Prepare the sales budget. Prepare the production budget. Prepare the sales budget. Prepare the production budget. F Prepare the production budget. What Deginning Direct Materials Beginning Finished Goods Units Cost per Pound Desired Ending Direct Materials Desired Ending Finished Goods Units Direct Labor Cost per Hour Direct Labor Time per Unit Direct Materials per Unit Direct Materials Purchases Expected Unit Sales Required Production Units Total Cost of Direct Materials Purchases Total Direct Labor Cost Total Materials Required Total Pounds Needed for Production Total Required Direct Labor Hours Total Required Units Prepare the direct materials budget. (Round Cost per pound answers to 2 decimal places, e.g. 52.70.) Prepare the production budget. What Deginning Direct Materials Beginning Finished Goods Units Cost per Pound Desired Ending Direct Materials Desired Ending Finished Goods Units Direct Labor Cost per Hour Direct Labor Time per Unit Direct Materials per Unit Direct Materials Purchases Expected Unit Sales Required Production Units Total Cost of Direct Materials Purchases Total Direct Labor Cost Total Materials Required Total Pounds Needed for Production Total Required Direct Labor Hours Total Required Units Prepare the direct labor budget. (Enter Direct labor time per unit in proportion to hours, e.g. for 45 minutes the proportion will be 0.75.) Prepare the selling and administrative expense budget. Prepare the selling and administrative expense budget. Prepare the direct labor budget. (Enter Direct labor time per unit in proportion to hours, e.g. for 45 minutes the proportion will he 751 Prepare the selling and administrative expense budget. Prepare the budgeted multiple-step income statement for the first 6 months. (Round intermediate calculations to 2 decimal places and final answer to 0 decimal places, e.g. 1,255.) Prepare the budgeted multiple-step income statement for the first 6 months. (Round intermediate calculations to 2 decimal places and final answer to 0 decimal places, e.g. 1,255.)