Question
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
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,200 glare filters in inventory on December 31 of the current year, and has a policy of carrying 30 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,000 | 35,000 | 40,200 | 38,200 |
Sales price per unit | $83 | $83 | $78 | $78 |
Direct labor hours per unit | 2.70 | 2.70 | 2.40 | 2.40 |
Direct labor hourly rate | $18 | $18 | $20 | $20 |
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 | fill in the blank f05c1b00dff3fb5_1 | fill in the blank f05c1b00dff3fb5_2 | fill in the blank f05c1b00dff3fb5_3 | fill in the blank f05c1b00dff3fb5_4 |
Desired ending inventory | fill in the blank f05c1b00dff3fb5_5 | fill in the blank f05c1b00dff3fb5_6 | fill in the blank f05c1b00dff3fb5_7 | fill in the blank f05c1b00dff3fb5_8 |
Total units required | fill in the blank f05c1b00dff3fb5_9 | fill in the blank f05c1b00dff3fb5_10 | fill in the blank f05c1b00dff3fb5_11 | fill in the blank f05c1b00dff3fb5_12 |
Less: Beginning inventory | fill in the blank f05c1b00dff3fb5_13 | fill in the blank f05c1b00dff3fb5_14 | fill in the blank f05c1b00dff3fb5_15 | fill in the blank f05c1b00dff3fb5_16 |
Units produced | fill in the blank f05c1b00dff3fb5_17 | fill in the blank f05c1b00dff3fb5_18 | fill in the blank f05c1b00dff3fb5_19 | fill in the blank f05c1b00dff3fb5_20 |
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 | fill in the blank 0eb079f9a008004_1 | fill in the blank 0eb079f9a008004_2 | fill in the blank 0eb079f9a008004_3 | fill in the blank 0eb079f9a008004_4 |
Direct labor hours per unit | fill in the blank 0eb079f9a008004_5 | fill in the blank 0eb079f9a008004_6 | fill in the blank 0eb079f9a008004_7 | |
Total labor budget (hours) | fill in the blank 0eb079f9a008004_8 | fill in the blank 0eb079f9a008004_9 | fill in the blank 0eb079f9a008004_10 | fill in the blank 0eb079f9a008004_11 |
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 | fill in the blank 987c6e06002102b_1 | fill in the blank 987c6e06002102b_2 | fill in the blank 987c6e06002102b_3 | fill in the blank 987c6e06002102b_4 |
Cost per unit | $fill in the blank 987c6e06002102b_5 | $fill in the blank 987c6e06002102b_6 | $fill in the blank 987c6e06002102b_7 | $fill in the blank 987c6e06002102b_8 |
Total direct materials | $fill in the blank 987c6e06002102b_9 | $fill in the blank 987c6e06002102b_10 | $fill in the blank 987c6e06002102b_11 | $fill in the blank 987c6e06002102b_12 |
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 | fill in the blank fc4895fcf041031_1 | fill in the blank fc4895fcf041031_2 | fill in the blank fc4895fcf041031_3 | fill in the blank fc4895fcf041031_4 |
Unit selling price | $fill in the blank fc4895fcf041031_5 | $fill in the blank fc4895fcf041031_6 | $fill in the blank fc4895fcf041031_7 | $fill in the blank fc4895fcf041031_8 |
Total sales revenue | $fill in the blank fc4895fcf041031_9 | $fill in the blank fc4895fcf041031_10 | $fill in the blank fc4895fcf041031_11 | $fill in the blank fc4895fcf041031_12 |
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 | $fill in the blank 40de4401a040f9d_1 | $fill in the blank 40de4401a040f9d_2 | $fill in the blank 40de4401a040f9d_3 | $fill in the blank 40de4401a040f9d_4 |
Direct labor cost | fill in the blank 40de4401a040f9d_5 | fill in the blank 40de4401a040f9d_6 | fill in the blank 40de4401a040f9d_7 | fill in the blank 40de4401a040f9d_8 |
Materials cost | fill in the blank 40de4401a040f9d_9 | fill in the blank 40de4401a040f9d_10 | fill in the blank 40de4401a040f9d_11 | fill in the blank 40de4401a040f9d_12 |
Contribution margin | $fill in the blank 40de4401a040f9d_13 | $fill in the blank 40de4401a040f9d_14 | $fill in the blank 40de4401a040f9d_15 | $fill in the blank 40de4401a040f9d_16 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started