Hardin Company is preparing its manufacturing overhead budget for 2012

Hardin Company is preparing its manufacturing overhead budget for 2012. Relevant data consist of the following.

Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000.

Direct labor: Time is 1.5 hours per unit.

Variable overhead costs per direct labor hour: Indirect materials $0.70; indirect labor $1.20; and maintenance $0.50.

Fixed overhead costs per quarter: Supervisory salaries $35,000; depreciation $16,000; and maintenance $12,000.



Complete the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal places, i.e. 4.25.)



HARDIN COMPANY

Manufacturing Overhead Budget

For the Year Ending December 31, 2012





Quarter







1



2



3



4



Year



Variable costs

Indirect materials $ $ $ $ $

Indirect labor

Maintenance





Total variable

Fixed costs

Supervisory salaries

Depreciation

Maintenance


Total fixed


Total manufacturing overhead

$



$



$



$



$

Direct labor hours


Manufacturing overhead rate per direct labor hour

$



2. Neely, Inc., is preparing its direct labor budget for 2012 from the following production budget based on a calendar year.

Quarter Units Quarter Units

1 20,000 3 35,000

2 25,000 4 30,000

Each unit requires 1.6 hours of direct labor.



Complete the direct labor budget for 2012. Wage rates are expected to be $15 for the first 2 quarters and $16 for quarters 3 and 4.



NEELY, INC.

Direct Labor Budget

For the Year Ending December 31, 2012





Quarter







1



2



3



4



Year



Units to be produced

Direct labor time (hours) per unit

×



×



×



×





Total required direct labor hours

Direct labor cost per hour

× $



× $



× $



× $





Total direct labor cost

$



$



$



$



$



3. On January 1, 2013 the Batista Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2013.

Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000

Ending raw materials inventory: 50% of the next quarter's production requirements

Ending finished goods inventory: 30% of the next quarter's expected sales units

Third-quarter production: 7,250 units

The ending raw materials and finished goods inventories at December 31, 2012, follow the same percentage relationships to production and sales that occur in 2013. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound.









Complete the production budget by quarters for the 6-month period ended June 30, 2013.

BATISTA COMPANY

Production Budget

For the Six Months Ending June 30, 2013





Quarter



Six





1



2



Months





Add:











Total required units

Less:











Required production units











4. Moreno Industries has adopted the following production budget for the first 4 months of 2013.

Month Units Month Units

January 10,000 March 5,000

February 8,000 April 4,000

Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2012, the ending raw materials inventory was 9,000 pounds. Management wants to have a raw materials inventory at the end of the month equal to 30% of next month's production requirements.



Complete the direct materials purchases budget by month for the first quarter.



MORENO INDUSTRIES

Direct Materials Purchases Budget

For the Quarter Ending March 31, 2013



January February March





×



×



×



Total pounds needed for production

Add:













Total materials required

Less:













Direct materials purchases



× $



× $



× $



Total cost of direct materials purchases

$



$



$



5. Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2012 sales budget is as follows.

Quarter HD-240

1 5,000

2 7,000

3 8,000

4 10,000

The January 1, 2012, inventory of HD-240 is 2,500 units. Management desires an ending inventory each quarter equal to 50% of the next quarter's sales. Sales in the first quarter of 2013 are expected to be 30% higher than sales in the same quarter in 2012.



Complete quarterly production budgets for each quarter and in total for 2012.



TURNEY COMPANY

Production Budget

For the Year Ending December 31, 2012



Product HD-240



Quarter







1



2



3



4



Year





Add:



















Total required units

Less:



















Required production units



















6. Roche and Young, CPAs, are preparing their service revenue (sales) budget for the coming year (2012). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided below.

Department Quarter 1 Quarter 2 Quarter 3 Quarter 4

Auditing 2,200 1,600 2,000 2,400

Tax 3,000 2,400 2,000 2,500

Consulting 1,500 1,500 1,500 1,500

Average hourly billing rates are: auditing $80, tax $90, and consulting $100.



Complete the service revenue (sales) budget for 2012 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.



ROCHE AND YOUNG, CPA's

Sales Revenue Budget

For the Year Ending December 31, 2012





Quarter 1



Dept Billable Hours Billable Rate Total Rev.

Auditing $ $

Tax

Consulting











Totals

$







Quarter 2



Auditing $ $

Tax

Consulting











Totals

$







Quarter 3



Auditing $ $

Tax

Consulting











Totals

$







Quarter 4



Auditing $ $

Tax

Consulting











Totals

$







Totals



Auditing $ $

Tax

Consulting











Totals

$