Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin

Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiners master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employers share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the companys union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 6,400 glare filters in inventory on December 31 of the current year, and has a policy of carrying 35 percent of the following months projected sales in inventory. Information on the first four months of the coming year is as follows:

	January	February	March	April
Estimated unit sales	36,200	34,400	40,200	39,600
Sales price per unit	$81	$81	$75	$75
Direct labor hours per unit	2.90	2.90	2.50	2.50
Direct labor hourly rate	$16	$16	$17	$17
Direct materials cost per unit	$7	$7	$7	$7

Required: Unless otherwise indicated, round all calculated amounts to the nearest dollar or unit.

1. Prepare the following monthly budgets for Greiner Company for the first quarter of the coming year.

a. Production budget in units:

Greiner Company
Production Budget (units)
For the First Quarter of the Coming Year
	January	February	March	Total
Unit sales	36200	34400	40200	110800
Desired ending inventory	12040	14070	13860
Total units required	48240	48470	54060
Less: Beginning inventory	6400
Units produced	41840

Feedback

b. Direct labor budget in hours: Round your answers to two decimal places, if required.

Greiner Company
Direct Labor Budget (hours)
For the First Quarter of the Coming Year
	January	February	March	Total
Units produced	41840
Direct labor hours per unit
Total labor budget (hours)

Feedback

c. Direct materials cost budget:

Greiner Company
Direct Materials Cost Budget
For the First Quarter of the Coming Year
	January	February	March	Total
Units Produced	41840
Cost per unit
Total direct materials

Feedback

d. Sales budget: Round unit selling price amounts to the nearest cent and use the same for subsequent requirements.

Greiner Company
Sales Budget (dollars)
For the First Quarter of the Coming Year
	January	February	March	Total
Unit sales	36200	34400	40200	110800
Unit selling price
Total sales revenue

Feedback

2. Calculate the total budgeted contribution margin for Greiner Company by month and in total for the first quarter of the coming year. (CMA adapted)

Greiner Company
Budgeted Contribution Margin
For the First Quarter of the Coming Year
	January	February	March	Total
Sales revenue
Direct labor cost
Materials cost
Contribution margin