Concept explainers
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
January | February | March | April | |
Estimated unit sales | 35,800 | 35,600 | 39,800 | 40,800 |
Sales price per unit | $83 | $83 | $75 | $75 |
Direct labor hours per unit | 2.80 | 2.80 | 2.50 | 2.50 |
Direct labor hourly rate | $17 | $17 | $18 | $18 |
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.
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 b2252d05000afe5_1 | fill in the blank b2252d05000afe5_2 | fill in the blank b2252d05000afe5_3 | fill in the blank b2252d05000afe5_4 |
Desired ending inventory | fill in the blank b2252d05000afe5_5 | fill in the blank b2252d05000afe5_6 | fill in the blank b2252d05000afe5_7 | fill in the blank b2252d05000afe5_8 |
Total units required | fill in the blank b2252d05000afe5_9 | fill in the blank b2252d05000afe5_10 | fill in the blank b2252d05000afe5_11 | fill in the blank b2252d05000afe5_12 |
Less: Beginning inventory | fill in the blank b2252d05000afe5_13 | fill in the blank b2252d05000afe5_14 | fill in the blank b2252d05000afe5_15 | fill in the blank b2252d05000afe5_16 |
Units produced | fill in the blank b2252d05000afe5_17 | fill in the blank b2252d05000afe5_18 | fill in the blank b2252d05000afe5_19 | fill in the blank b2252d05000afe5_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 7b399ffab07506a_1 | fill in the blank 7b399ffab07506a_2 | fill in the blank 7b399ffab07506a_3 | fill in the blank 7b399ffab07506a_4 |
Direct labor hours per unit | fill in the blank 7b399ffab07506a_5 | fill in the blank 7b399ffab07506a_6 | fill in the blank 7b399ffab07506a_7 | |
Total labor budget (hours) | fill in the blank 7b399ffab07506a_8 | fill in the blank 7b399ffab07506a_9 | fill in the blank 7b399ffab07506a_10 | fill in the blank 7b399ffab07506a_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 0d7ec5f4c005fb4_1 | fill in the blank 0d7ec5f4c005fb4_2 | fill in the blank 0d7ec5f4c005fb4_3 | fill in the blank 0d7ec5f4c005fb4_4 |
Cost per unit | $fill in the blank 0d7ec5f4c005fb4_5 | $fill in the blank 0d7ec5f4c005fb4_6 | $fill in the blank 0d7ec5f4c005fb4_7 | $fill in the blank 0d7ec5f4c005fb4_8 |
Total direct materials | $fill in the blank 0d7ec5f4c005fb4_9 | $fill in the blank 0d7ec5f4c005fb4_10 | $fill in the blank 0d7ec5f4c005fb4_11 | $fill in the blank 0d7ec5f4c005fb4_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 356a67fc9f8cf9e_1 | fill in the blank 356a67fc9f8cf9e_2 | fill in the blank 356a67fc9f8cf9e_3 | fill in the blank 356a67fc9f8cf9e_4 |
Unit selling price | $fill in the blank 356a67fc9f8cf9e_5 | $fill in the blank 356a67fc9f8cf9e_6 | $fill in the blank 356a67fc9f8cf9e_7 | $fill in the blank 356a67fc9f8cf9e_8 |
Total sales revenue | $fill in the blank 356a67fc9f8cf9e_9 | $fill in the blank 356a67fc9f8cf9e_10 | $fill in the blank 356a67fc9f8cf9e_11 | $fill in the blank 356a67fc9f8cf9e_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 | $fill in the blank | $fill in the blank | $fill in the blank |
Direct labor cost | fill in the blank | fill in the blank | fill in the blank | fill in the blank |
Materials cost | fill in the blank | fill in the blank | fill in the blank | fill in the blank |
Contribution margin | $fill in the blank | $fill in the blank | $fill in the blank | $fill in the blank |
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 5 images
- Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 18,700 nozzles in stock, although the latest estimate for August production indicates a requirement for only 18,800 nozzles. Total uses of the nozzle are expected to be 18,500 in September and 19,340 in October. Nozzles are purchased at a wholesale price of $27. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 40,000 parts in July. Required: Estimate purchases of the nozzle (in units) for August and September. Estimate the cash disbursements for nozzles in August and September.arrow_forward! Required information Miami Solar manufactures solar panels for industrial use. The company budgets production of 5,000 units (solar panels) in July and 5,300 units in August. Each unit requires 4 hours of direct labor at a rate of $16 per hour. The company applies variable overhead at the rate of $12 per direct labor hour. Budgeted fixed factory overhead is $180,000 per month. Prepare a factory overhead budget for August. MIAMI SOLAR Factory Overhead Budget Direct labor hours needed Variable overhead rate per direct labor hour Budgeted variable overhead Budgeted fixed overhead Budgeted total factory overhead August $ 0arrow_forwardSingha Ltd produces and sells two products, X and Y, using the same type of materials and labour but in different quantities. Budgeted sales units for the next six months (July to December 2022) are as follows: July August September October November December Sales units of X 5,000 4,800 4,200 5,600 7,200 8,000 Sales units of Y 2,400 2,500 2,500 4,000 4,400 5,000 The standard selling prices and variable costs of production of each product is provided in the table below. Product X Product Y £ per unit £ per unit Selling Price £60 £100 Variable Costs of production Material A (£2 per kg) £6 £10 Material B (£3 per kg) £12 £24 Direct labour (£10 per hour) £15 £20 Variable production overhead (£4 per direct labour hour) £6 £8 The management accountant of the company has provided the following additional information. All sales are on account and the collection pattern are…arrow_forward
- Sthilaire Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.48 direct labor-hours. The direct labor rate is $9.00 per direct labor-hour. The production budget calls for producing 1,800 units in April and 1,700 units in May. The company guarantees its direct labor workers a 40-hour paid work week. With the number of workers currently employed, that means that the company is committed to paying its direct labor work force for at least 960 hours in total each month even if there is not enough work to keep them busy. Required: Prepare the direct labor budget for the next two months. (Round "labor-hours per unit" & "labor cost per hour" answers to 2 decimal places.)arrow_forwardPackaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.40q Indirect labor $4,000 + $1.40q Utilities $5,300 + $0.30q Supplies $1,600 + $0.10q Equipment depreciation $18,500 + $3.00q Factory rent $8,200 Property taxes $2,500 Factory administration $13,600 + $0.60q The Production Department planned to work 4,400 labor-hours in March; however, it actually worked 4,200 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor $ 70,480 Indirect labor $ 9,340 Utilities $ 7,010 Supplies $ 2,250 Equipment depreciation $ 31,100 Factory rent $ 8,600 Property taxes $ 2,500 Factory…arrow_forwardGrouper Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2022. The following data were used in developing the master manufacturing overhead budget for the Ironing Department, which is based on an activity index of direct labor hours. Variable costs Rate per DirectLabor Hour Annual Fixed Costs Indirect labor $0.43 Supervision $44,880 Indirect materials 0.52 Depreciation 18,000 Factory utilities 0.30 Insurance 17,880 Factory repairs 0.20 Rent 28,680 The master overhead budget was prepared in the expectation that 482,900 direct labor hours will be worked during the year. In June, 44,800 direct labor hours were worked. At that level of activity, actual costs were as shown below.Variable—per direct labor hour: indirect labor $0.45, indirect materials $0.50, factory utilities $0.33, and factory repairs $0.24.Fixed: same as…arrow_forward
- Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.30q $4,300 +$1.50g $5,300 +$0.40g $1.400+ $0.30q $18,200+ $2.70g $8,400 $13,800+ $0.60g $2,600 The Production Department planned to work 4,200 labor-hours in March; however, it actually worked 4,000 labor-hours during the month. Its actual costs incurred in March are listed below: Direct labor Actual Cost Incurred in March $ 66,780 Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Required: $ 9,780 $ 7,370 $ 2,870 $ 29,000 $ 8.800 $ 2,600 $ 15,550 1. Prepare the Production…arrow_forwardSunland Corporation manufactures safes-large mobile safes, and large walk-in stationary bank safes. As part of its annual budgeting process, Sunland is analyzing the profitability of its two products. Part of this analysis involves estimating the amount of overhead to be assigned to each product line. The information shown below relates to overhead, Units planned for production Material moves per product line Purchase orders per product line Direct labor hours per product line (1) One mobile safe (2) Mobile Safes One walk-in safe 200 300 450 800 Walk-in Safes 435.2 50 The total estimated manufacturing overhead was $272,000. Under traditional costing (which assigns overhead on the basis of direct labor hours), what amount of manufacturing overhead costs are assigned to: (Round answers to 2 decimal places, e.g. 12.25.) 200 350 1.700 per unit per unitarrow_forward← Oliver, Inc. manufactures model airplane kits and projects production at 300, 680, 500, and 800 kits for the next four quarters. (Click the icon to view the manufacturing information.) Prepare Oliver's direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number. Direct materials (ounces) per kit Direct materials needed for production Plus: Total direct materials needed Less: Budgeted purchases of direct materials Direct materials cost per ounce Budgeted cost of direct materials purchases For the Year Ended December 31 First Second Third Fourth Quarter Quarter Quarter Quarter Totalarrow_forward
- Question: Asy Clean operates a chain of dry cleaners. It is experimenting with a continuous-improvement (i.e., kaizen) budget for operating expenses. Currently, a typical location has operating expenses of $14,000 per month. Plans are in place to achieve labor and utility savings. The associated operational changes are estimated to reduce monthly operating costs by a factor of 0.99 beginning in January. What is the estimated operating cost for: i) January? ii) For June? iii) For December?arrow_forwardMk. 226.arrow_forwardRose Company uses a flexible budget for manufacturing overhead based on direct labor hours. The following information are from the yearly static overhead budget for the Production Department for 2023. It is based on 300,000 direct labor hours. Variable Costs Fixed Costs Indirect labor ($1.2 per DL hour) $30,000 Supervision $ 5,000 Supplies and lubricants ($0.5 per DL hour) 12,500 Depreciation 2,000 Maintenance ($0,7 per DL hour) 17,500 Property taxes 1,500 Utilities ($0,4 per DL hour) 10,000 Insurance 1,000 During July, 24,500 direct labor hours were worked. The company incurred the following variable costs in July: indirect labor $30,200, supplies and lubricants $11,600, maintenance $17,500, and utilities $9,200. Actual fixed overhead costs were the same as monthly budgeted fixed costs. a.) Prepare a flexible monthly budget for the Production Department for the relevant range between 24,000 and 26,000 DL hours with increments of 1000 DL hours. b.) Prepare a flexible budget…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education