Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i have all of this already complete and correct. i just need help with part c, the budgeted multi-step income statement Question 9 Cook Farm

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
i have all of this already complete and correct. i just need help with part c, the budgeted multi-step income statement
Question 9 Cook Farm Supply Company manufactures and sells a pesticide called Share. The following data are available for preparing budgets for Snare for the first 2 quarters of 2020. 1. Sales: quarter 1, 29,400 bags; quarter 2, 42,600 bags. Selling price is $63 per bag 2. Direct materials: each bag of Snare requires 4 pounds of Gumm at a cost of $3.80 per pound and 6 pounds of Tarr at $1.75 per pound. 3. Desired Inventory levels: Type of Inventory Snare (bags) Gumm (pounds) Tarr (pounds) January 1 8,100 9,500 14,200 April 1 12,200 10,100 20,500 July 1 18,100 13,200 25,400 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 $179,000 per quarter. 6. Interest expense is $100,000 7. Income taxes are expected to be 30% 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 cos Tarr purchases to be $301,000 in quarter i and $426,500 in quarter 2. (Note: Do not prepare the manufacturing overhead budget or the direct materials budget for Torr) (c) Prepare the budgeted multiple-step income statement for the first 6 months. (Round Intermediate calculations to 2 decimal places and final answer to o decimal places, e.g. 1,255.) COOK FARM SUPPLY COMPANY Budgeted Income Statement . . Prepare the sales budget. COOK FARM SUPPLY COMPANY Sales Budget For the Six Months Ending June 30, 2020 4 Quarter Six Months 1 2 29,400 Expected Unit Sales 4 42,600 72,000 63 63 63 Unit Selling Price $1 $ 1,852,200 2,683,800 4,536,000 Total Sales Prepare the production budget. COOK FARM SUPPLY COMPANY Production Budget For the Six Months Ending June 30, 2020 Quarter Six Months 1 2 Expected Unit Sales 29,400 42,600 Add Desired Ending Finished Goods Units 12,200 18,100 Total Required Units 41,6001 60,700 Less Beginning Finished Goods Units 8,100 12,200 Required Production Units 33,500 48,500 82,000 Your answer is correct. Prepare the direct materials budget. (Round Cost per pound answers to 2 decimal places, e.g. 52.70.) COOK FARM SUPPLY COMPANY Direct Materials Budget-Gumm For the Six Months Ending June 30, 2020 Quarter Six Months 1 2 Units to be produced 33,500 48,500 4 Direct Materials per Unit Total Pounds Needed for Production 134,000 194,000 Add Desired Ending Direct Materials (Pounds) 4 10,100 13,200 Total Materials Required 144,100 207,200 Less Beginning Direct Materials (Pounds) 9,500 10,100 Direct Materials Purchases 134,600 197,100 Cost per Pound 3.8 3.8 $1 Total Cost of Direct Materials Purchases 511,480 748,980 1,260,460 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.) COOK FARM SUPPLY COMPANY Direct Labor Budget For the Six Months Ending June 30, 2020 4 Quarter Six 1 2 Months Units to be produced 33,500 48,500 Direct Labor Time (Hours) per Unit 0.25 0.25 Total Required Direct Labor Hours 8,375 12,125 Direct Labor Cost per Hour 16 16 $ Total Direct Labor Cost 134,000 194,000 328,000 Prepare the selling and administrative expense budget. COOK FARM SUPPLY COMPANY Selling and Administrative Expense Budget For the Six Months Ending June 30, 2020 # Quarter Six Months 1 2. Sales 1,852,200 2,683,800 4,536,000 Variable Expenses 277,830 402.570 680,400 DS Fixed Expenses 179,000 179,000 358,000 Total Selling and Administrative Expenses. 456,830 581,570 1,038,400

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions