In: Accounting
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 Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 6,700 glare filters in inventory on December 31 of the current year, and has a policy of carrying 25 percent of the following month’s 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,800 | 34,600 | 39,200 | 38,200 |
Sales price per unit | $81 | $81 | $76 | $76 |
Direct labor hours per unit | 2.80 | 2.80 | 2.50 | 2.50 |
Direct labor hourly rate | $17 | $17 | $19 | $19 |
Direct materials cost per unit | $10 | $10 | $10 | $10 |
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 | ||||
Desired ending inventory | ||||
Total units required | ||||
Less: Beginning inventory | ||||
Units produced |
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 | ||||
Direct labor hours per unit | ||||
Total labor budget (hours) |
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 | ||||
Cost per unit | $ | $ | $ | $ |
Total direct materials | $ | $ | $ | $ |
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 | ||||
Unit selling price | $ | $ | $ | $ |
Total sales revenue | $ | $ | $ | $ |
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 | $ | $ | $ | $ |
1 | ||||||||
a. | Production budget in units: | |||||||
Greiner Company | ||||||||
Production Budget (units) | ||||||||
For the First Quarter of the Coming Year | ||||||||
January | February | March | Total | April | ||||
Unit sales | 36800 | 34600 | 39200 | 110600 | 38200 | |||
Desired ending inventory | 8650 | 9800 | 9550 | |||||
(Next month sales*25%) | (34600*25%) | (39200*25%) | (38200*25%) | |||||
Total units required | 45450 | 44400 | 48750 | 138600 | ||||
Less: Beginning inventory | 6700 | 8650 | 9800 | |||||
Units produced | 38750 | 35750 | 38950 | 113450 | ||||
b. | Greiner Company | |||||||
Direct Labor Budget (hours) | ||||||||
For the First Quarter of the Coming Year | ||||||||
January | February | March | Total | |||||
Units produced | a | 38750 | 35750 | 38950 | 113450 | |||
Direct labor hours per unit | b | 2.8 | 2.8 | 2.5 | ||||
Total labor budget (hours) | a*b | 108500 | 100100 | 97375 | 305975 | |||
c. | Greiner Company | |||||||
Direct Materials Cost Budget | ||||||||
For the First Quarter of the Coming Year | ||||||||
January | February | March | Total | |||||
Units produced | a | 38750 | 35750 | 38950 | 113450 | |||
Cost per unit | b | 10 | 10 | 10 | ||||
Total direct materials | a*b | 387500 | 357500 | 389500 | 1134500 | |||
d. | Greiner Company | |||||||
Sales Budget (dollars) | ||||||||
For the First Quarter of the Coming Year | ||||||||
January | February | March | Total | |||||
Unit sales | a | 36800 | 34600 | 39200 | 110600 | |||
Unit selling price | b | 81 | 81 | 76 | ||||
Total sales revenue | a*b | 2980800 | 2802600 | 2979200 | 8762600 | |||
2 | Greiner Company | |||||||
Budgeted Contribution Margin | ||||||||
For the First Quarter of the Coming Year | ||||||||
January | February | March | Total | |||||
Sales revenue | a | 2980800 | 2802600 | 2979200 | 8762600 | |||
Direct labor cost | (Note:1) | b | 1844500 | 1701700 | 1850125 | 5396325 | ||
Materials cost | c | 387500 | 357500 | 389500 | 1134500 | |||
Contribution margin |
Related SolutionsProduction, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality...
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 Greiner’s master budget and has assembled the following
data for the coming year. The direct labor rate includes wages, all
employee-related benefits, and the employer’s share of FICA. Labor
saving machinery will be fully operational by March. Also, as of
March 1, the company’s union contract calls for an increase in
direct...
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality...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 Greiner’s master budget and has assembled the following
data for the coming year. The direct labor rate includes wages, all
employee-related benefits, and the employer’s share of FICA. Labor
saving machinery will be fully operational by March. Also, as of
March 1, the company’s union contract calls for an increase in
direct...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for March is summarized as follows:
a. Estimated sales for March by sales territory:
Maine:
Backyard Chef
350 units at $800 per unit
Master Chef
200 units at $1,400 per unit
Vermont:
Backyard Chef
400 units at $825 per unit
Master...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for March is summarized as follows:
a. Estimated sales for March by sales territory:
Maine:
Backyard Chef
350 units at $800 per unit
Master Chef
200 units at $1,400 per unit
Vermont:
Backyard Chef
400 units at $825 per unit
Master...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for March is summarized as follows:
a. Estimated sales for March by sales territory:
Maine:
Backyard Chef
350 units at $800 per unit
Master Chef
200 units at $1,400 per unit
Vermont:
Backyard Chef
400 units at $825 per unit
Master...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...
Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for July is summarized as follows:
a. Estimated sales for July by sales territory:
Maine:
Backyard Chef
310 units at $700 per unit
Master Chef
150 units at $1,200 per unit
Vermont:
Backyard Chef
240 units at $750 per unit
Master...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...
Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for July is summarized as follows:
a. Estimated sales for July by sales territory:
Maine:
Backyard Chef
310 units at $700 per unit
Master Chef
150 units at $1,200 per unit
Vermont:
Backyard Chef
240 units at $750 per unit
Master...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for July is summarized as follows:
a. Estimated sales for July by sales territory:
Maine:
Backyard Chef
310 units at $700 per unit
Master Chef
150 units at $1,200 per unit
Vermont:
Backyard Chef
240 units at $750 per unit
Master...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for July is summarized as follows:
a. Estimated sales for July by sales territory:
Maine:
Backyard Chef
310 units at $700 per unit
Master Chef
150 units at $1,200 per unit
Vermont:
Backyard Chef
240 units at $750 per unit
Master...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Royal Furniture...Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Royal Furniture Company requests
estimates of sales, production, and other operating data from the
various administrative units every month. Selected information
concerning sales and production for February is summarized as
follows:
a. Estimated sales of King and Prince chairs for February by
sales territory:
Northern Domestic:
King
610 units at $780 per unit
Prince
750 units at $550 per unit
Southern Domestic:
King
340 units at...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|