Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 2020.

1. Sales: quarter 1, 28,400 bags; quarter 2, 43,800 bags. Selling price is $61 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.50 per pound.
3. Desired inventory levels:

Type of Inventory

January 1

April 1

July 1

Snare (bags) 8,500 12,100 18,100
Gumm (pounds) 9,300 10,500 13,100
Tarr (pounds) 14,200 20,100 25,100

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 $177,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 $427,500 in quarter 2. (Note: Do not prepare the manufacturing overhead budget or the direct materials budget for Tarr.)

Prepare the sales budget.

COOK FARM SUPPLY COMPANY Sales Budget choose the accounting period June 30, 2020For the Six Months Ending June 30, 2020For the Quarter Ending June 30, 2020

Quarter

Six Months

1

2

Expected unit sales

enter a number of units

enter a number of units

enter a number of units

Unit selling price

$enter a dollar amount

$enter a dollar amount

$enter a dollar amount

Total sales

$enter a total dollar amount

$enter a total dollar amount

$enter a total dollar amount

Prepare the production budget.

COOK FARM SUPPLY COMPANY Production Budget choose the accounting periodJune 30, 2020For the Quarter Ending June 30, 2020For the Six Months Ending June 30, 2020 For the Six Months Ending June 30, 2020June 30, 2020For the Quarter Ending June 30, 2020

Quarter

Six Months

1

2

select an opening production budget itemRequired Production UnitsDesired Ending Finished Goods UnitsDirect Materials per UnitBeginning Direct MaterialsTotal Pounds Needed for ProductionTotal Cost of Direct Materials PurchasesDesired Ending Direct MaterialsTotal Required UnitsTotal Materials RequiredExpected Unit SalesDirect Materials PurchasesCost per PoundDirect Labor Time per UnitTotal Direct Labor CostTotal Required Direct Labor HoursBeginning Finished Goods UnitsDirect Labor Cost per Hour Beginning Direct MaterialsBeginning Finished Goods UnitsCost per PoundDesired Ending Direct MaterialsDesired Ending Finished Goods UnitsDirect Labor Cost per HourDirect Labor Time per UnitDirect Materials per UnitDirect Materials PurchasesExpected Unit SalesRequired Production UnitsTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Materials RequiredTotal Pounds Needed for ProductionTotal Required Direct Labor HoursTotal Required Units

enter a number of units

enter a number of units

enter a number of units enter a number of units

enter a total number of units for the first part

enter a total number of units for the first part

enter a number of units enter a number of units
enter a total number of units enter a total number of units enter a total number of units

Prepare the direct materials budget

COOK FARM SUPPLY COMPANY Direct Materials BudgetGumm choose the accounting periodFor the Six Months Ending June 30, 2020For the Quarter Ending June 30, 2020June 30, 2020 For the Six Months Ending June 30, 2020June 30, 2020For the Quarter Ending June 30, 2020

Quarter

Six Months

enter a number of units

enter a number of units

select an itemDirect Materials PurchasesExpected Unit SalesTotal Required UnitsDirect Materials per UnitTotal Materials RequiredBeginning Finished Goods UnitsTotal Pounds Needed for ProductionDesired Ending Direct Materials (Pounds)Total Required Direct Labor HoursBeginning Direct Materials (Pounds)Total Cost of Direct Materials PurchasesDesired Ending Finished Goods UnitsDirect Labor Time (Hours) per UnitTotal Direct Labor CostCost per PoundDirect Labor Cost per HourUnits to be Produced Beginning Direct Materials (Pounds)Beginning Finished Goods UnitsCost per PoundDesired Ending Direct Materials (Pounds)Desired Ending Finished Goods UnitsDirect Labor Cost per HourDirect Labor Time (Hours) per UnitDirect Materials per UnitDirect Materials PurchasesExpected Unit SalesTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Materials RequiredTotal Pounds Needed for ProductionTotal Required Direct Labor HoursTotal Required UnitsUnits to be Produced

enter the amount of pounds enter the amount of pounds

enter a total amount of pounds for the first part enter a total amount of pounds for the first part
enter the amount of pounds enter the amount of pounds
enter a total amount of pounds for the second part enter a total amount of pounds for the second part
enter the amount of pounds enter the amount of pounds
enter a total amount of pounds for the third part enter a total amount of pounds for the third part

$enter a total dollar amount $enter a total dollar amount $enter a total dollar amount

Prepare the direct labor budget

Prepare the selling and administrative expense budget.

Prepare the budgeted multiple-step income statement for the first 6 months

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

Recommended Textbook for

The Brain Audit Why Customers Buy And Why They Dont

Authors: Sean D'Souza, John Forde

1st Edition

0473175045, 978-0473175047

More Books

Students also viewed these Accounting questions

Question

What are some of the possible scenes from our future?

Answered: 1 week ago