Exercise 1 -  Crede and Rensing, CPAs, are preparing their service revenue (sales) budget for the coming year (2011). 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.

Instructions - Prepare the service revenue (sales) budget for 2011 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.

Exercise 2 - Pletcher Company produces and sell automobile batteries, the heavy-duty HD-24. The 2011 sales forecast is as follows.

Quarter HD-240

1 5,000

2 7,000

3 8,000

4 10,000

The January 1, 2011, inventory of DH-240is 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 2012 are expected to be 30% higher than sales in the same quarter in 2011.

Instructions - Prepare quarterly production budgets for each quarter and in total for 2011.

Exercise 3 - Dewitt Industries has adopted the following production budget for the first 4 months of 2012.

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, 2011, 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.

Instructions - Prepare a direct materials purchases budget by month for the first quarter.

Exercise 4 - Ortiz Company's sales budget projects unit sales of part 198Z of 10,000 units in January, 12,000 units in February, and 13,000 units in March. Each unit of part 198Z requires 2 pounds of materials, which cost $3 per pound. Ortiz Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 25% of the next month's expected unit sales. These goals were met at December 31, 2010.

Instructions

(a) Prepare a production budget for January and February 2011.

(b) Prepare a direct materials budget for January 2011.