Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please provide the right answers to the red boxes. Problem 13-1 Grouper Company manufactures and sells a pesticide called Snare. The following data are available
please provide the right answers to the red boxes.
Problem 13-1 Grouper Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2017. 1. Sales: quarter 1, 28,200 bags; quarter 2, 12,300 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,200 9,100 14,500 April 1 12,200 10,400 July 1 18,100 13,300 25,200 20,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 $180,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 cost of Tarr purchases to be $301,000 in quarter 1 and $422.500 in quarter 2. Prepare the sales budget GROUPER COMPANY Sales Budget For the six months Ending June 30, 2017 Quarter Six Months 1 2 Expected unit sales 128200 242300 370500 Unit selling price 63 63 63 $0 Total sales 8076600 15264900 2334150 Prepare the production budget. GROUPER COMPANY Production Budget For the Six Months Ending June 30, 2017 Quarter 1 2 Six Months Expected Unit Sales 128200 242300 1 Add Desired Ending Finished Goods Units 12200 18100 Total Required Units 240400 260400 LES Beginning Finished Goods Units 8200 12200 Roured Production Units 132200 2.46200 380400 GROUPER COMPANY Direct Materials Budget-Gumm TEHNI For the St Months Ending June 10, 2017 ANTTI Quarter Six Months 1 2 Units to be produced 793200 1489200 Direct Materials per Unit Total Pounds Needed for production Add- Desired Ending Direct Materials Total Materials Required Less Beginning Direct Materials Direct Materials Purchases 530100 995700 Cost period 1.75 1.75 Total cost of Direct Material Purchase Tch + Prepare the direct labor budget. (Enter Direct lahor time per unit in proportion to hours, e.g. for 45 minutes the prope GROUPER COMPANY Direct Labor Budget For the six months Ending June 30, 2017 Quarter Six Months 1 2 Units to be produced 132200 248200 Direct Labor Time per Unit 15 15 Total Required Direct Labor Hours 33050 62050 Direct labor cost per Hour 16 16 x Total Direce Labor COSE 528800 992800 1521600 Prepare the selling and administrative ayn Prepare the selling and administrative expense budget GROUPER COMPANY Selling and Administrative Expense Budget For the Six Months Ending June 30, 2017 M Quarter 2 Six Months Budgeted sales in units Variable cost DDD DOO s Prepare the budgeted multiple-step income statement for the first 6 months. (Round intermed 1,255.) GROUPER COMPANY Budgeted Income Statement For the six months Ending June 30, 2017 X Sales 23341500 GA Cost of Goods Sold > Gross Profit X Selling and Administrative Expenses M Income from Operations Interest Expense 100000 EX Income Before Income Tax 9390485 X Income Tax Expense 2817145 Net Income (Loss) N 6573640 dStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started