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,400 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 37,400 35,200 40,200 38,200 Sales price per unit $82 $82 $77 $77 Direct labor hours per unit 2.70 2.70 2.30 2.30 Direct labor hourly rate $19 $19 $20 $20 Direct materials cost per unit $9 $9 $9 $9 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. Question Content Area a. Production budget in units: Greiner CompanyProduction Budget (units)For the First Quarter of the Coming Year January February March Total Unit sales fill in the blank fill in the blank fill in the blank fill in the blank Desired ending inventory fill in the blank fill in the blank fill in the blank fill in the blank Total units required fill in the blank f2aff202bfbafb4_9 fill in the blank f2aff202bfbafb4_10 fill in the blank f2aff202bfbafb4_11 fill in the blank f2aff202bfbafb4_12 Less: Beginning inventory fill in the blank f2aff202bfbafb4_13 fill in the blank f2aff202bfbafb4_14 fill in the blank f2aff202bfbafb4_15 fill in the blank f2aff202bfbafb4_16 Units produced fill in the blank f2aff202bfbafb4_17 fill in the blank f2aff202bfbafb4_18 fill in the blank f2aff202bfbafb4_19 fill in the blank f2aff202bfbafb4_20 Question Content Area
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s
January | February | March | April | |
Estimated unit sales | 37,400 | 35,200 | 40,200 | 38,200 |
Sales price per unit | $82 | $82 | $77 | $77 |
Direct labor hours per unit | 2.70 | 2.70 | 2.30 | 2.30 |
Direct labor hourly rate | $19 | $19 | $20 | $20 |
Direct materials cost per unit | $9 | $9 | $9 | $9 |
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.
Question Content Area
a. Production budget in units:
January | February | March | Total | |
---|---|---|---|---|
Unit sales | fill in the blank | fill in the blank | fill in the blank | fill in the blank |
Desired ending inventory | fill in the blank | fill in the blank | fill in the blank | fill in the blank |
Total units required | fill in the blank f2aff202bfbafb4_9 | fill in the blank f2aff202bfbafb4_10 | fill in the blank f2aff202bfbafb4_11 | fill in the blank f2aff202bfbafb4_12 |
Less: Beginning inventory | fill in the blank f2aff202bfbafb4_13 | fill in the blank f2aff202bfbafb4_14 | fill in the blank f2aff202bfbafb4_15 | fill in the blank f2aff202bfbafb4_16 |
Units produced | fill in the blank f2aff202bfbafb4_17 | fill in the blank f2aff202bfbafb4_18 | fill in the blank f2aff202bfbafb4_19 | fill in the blank f2aff202bfbafb4_20 |
Question Content Area
b. Direct labor budget in hours: Round your answers to two decimal places, if required.
January | February | March | Total | |
---|---|---|---|---|
Units produced | fill in the blank 968767f2403ffc5_1 | fill in the blank 968767f2403ffc5_2 | fill in the blank 968767f2403ffc5_3 | fill in the blank 968767f2403ffc5_4 |
Direct labor hours per unit | fill in the blank 968767f2403ffc5_5 | fill in the blank 968767f2403ffc5_6 | fill in the blank 968767f2403ffc5_7 | |
Total labor budget (hours) | fill in the blank 968767f2403ffc5_8 | fill in the blank 968767f2403ffc5_9 | fill in the blank 968767f2403ffc5_10 | fill in the blank 968767f2403ffc5_11 |
Question Content Area
c. Direct materials cost budget:
January | February | March | Total | |
---|---|---|---|---|
Units produced | fill in the blank 779812fa6030fc1_1 | fill in the blank 779812fa6030fc1_2 | fill in the blank 779812fa6030fc1_3 | fill in the blank 779812fa6030fc1_4 |
Cost per unit | $fill in the blank 779812fa6030fc1_5 | $fill in the blank 779812fa6030fc1_6 | $fill in the blank 779812fa6030fc1_7 | $fill in the blank 779812fa6030fc1_8 |
Total direct materials | $fill in the blank 779812fa6030fc1_9 | $fill in the blank 779812fa6030fc1_10 | $fill in the blank 779812fa6030fc1_11 | $fill in the blank 779812fa6030fc1_12 |
Question Content Area
d. Sales budget: Round unit selling price amounts to the nearest cent and use the same for subsequent requirements.
January | February | March | Total | |
---|---|---|---|---|
Unit sales | fill in the blank 03a8ac004fd8fd1_1 | fill in the blank 03a8ac004fd8fd1_2 | fill in the blank 03a8ac004fd8fd1_3 | fill in the blank 03a8ac004fd8fd1_4 |
Unit selling price | $fill in the blank 03a8ac004fd8fd1_5 | $fill in the blank 03a8ac004fd8fd1_6 | $fill in the blank 03a8ac004fd8fd1_7 | $fill in the blank 03a8ac004fd8fd1_8 |
Total sales revenue | $fill in the blank 03a8ac004fd8fd1_9 | $fill in the blank 03a8ac004fd8fd1_10 | $fill in the blank 03a8ac004fd8fd1_11 | $fill in the blank 03a8ac004fd8fd1_12 |
Question Content Area
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)
January | February | March | Total | |
---|---|---|---|---|
Sales revenue | $fill in the blank 4d411cfa2020fb0_1 | $fill in the blank 4d411cfa2020fb0_2 | $fill in the blank 4d411cfa2020fb0_3 | $fill in the blank 4d411cfa2020fb0_4 |
Direct labor cost | fill in the blank 4d411cfa2020fb0_5 | fill in the blank 4d411cfa2020fb0_6 | fill in the blank 4d411cfa2020fb0_7 | fill in the blank 4d411cfa2020fb0_8 |
Materials cost | fill in the blank 4d411cfa2020fb0_9 | fill in the blank 4d411cfa2020fb0_10 | fill in the blank 4d411cfa2020fb0_11 | fill in the blank 4d411cfa2020fb0_12 |
Contribution margin | $fill in the blank 4d411cfa2020fb0_13 | $fill in the blank 4d411cfa2020fb0_14 | $fill in the blank 4d411cfa2020fb0_15 | $fill in the blank 4d411cfa2020fb0_16 |

Step by step
Solved in 6 steps









