Problem 23-1A (Part Level Submission)
Cook Farm Supply Company manufactures and sells a pesticidecalled Snare. The following data are available for preparingbudgets for Snare for the first 2 quarters of 2017.
1. Sales: quarter 1, 28,300 bags;quarter 2, 43,800 bags. Selling price is $61 per bag.
2. Direct materials: each bag ofSnare requires 4 pounds of Gumm at a cost of $3.8 per pound and 6pounds 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 labortime is 15 minutes per bag at an hourly rate of $16 per hour.
5. Selling and administrativeexpenses are expected to be 15% of sales plus $177,000 perquarter.
6. Interest expense is$100,000.
7. Income taxes are expected tobe 30% of income before income taxes.
Your assistant has prepared two budgets: (1) the manufacturingoverhead budget shows expected costs to be 125% of direct laborcost, and (2) the direct materials budget for Tarr shows the costof Tarr purchases to be $301,000 in quarter 1 and $427,500 inquarter 2.
(a)
Your answer is correct.
Prepare the sales budget.
COOK FARM SUPPLY COMPANY
Sales Budget
Quarter
Six
Months
1
2
Expected unit sales
Unit selling price
$
$
$
Total sales
$
$
$
Prepare the production budget.
COOK FARM SUPPLY COMPANY
Production Budget
Quarter
Six
Months
1
2
:
:
LINK TO TEXT
LINK TO TEXT
By accessing this Question Assistance, you will learn while youearn points based on the Point Potential Policy set by yourinstructor.
Attempts: 5 of 5 used
(b)
Prepare the direct materials budget. (Round Cost per poundanswers to 2 decimal places, e.g. 52.70.)
COOK FARM SUPPLY COMPANY
Direct Materials Budget—Gumm
Quarter
Six
Months
1
2
:
:
$ $
$ $ $
Prepare the direct labor budget. (Enter Direct labor time perunit in proportion to hours, e.g. for 45 minutes the proportionwill be 0.75.)
COOK FARM SUPPLY COMPANY
Direct Labor Budget
Quarter
Six
Months
1
2
$ $
$ $ $
Prepare the selling and administrative expense budget.
COOK FARM SUPPLY COMPANY
Selling and Administrative Expense Budget
Quarter
Six
Months
1
2
$
$
$
$ $ $