Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,400, 12,100, 14,200, 17,000. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.70; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,850; depreciation $17,390; and maintenance $14,220. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal places, e.g. 1.25. List variable expenses before fixed expense.) Variable Costs Indirect Materials Indirect Labor Maintenance Total Variable Fixed Costs Depreciation Maintenance Supervisory Salaries Total Fixed Total Manufacturing Overhead Direct labor hours Manufacturing overhead rate per direct labor hour $ $ 1 $ $ ATLANTA COMPANY Manufacturing Overhead Budget For the Year Ending December 31, 2020 2 Quarter $ $ 3

Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,400, 12,100, 14,200, 17,000. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.70; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,850; depreciation $17,390; and maintenance $14,220. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal places, e.g. 1.25. List variable expenses before fixed expense.) Variable Costs Indirect Materials Indirect Labor Maintenance Total Variable Fixed Costs Depreciation Maintenance Supervisory Salaries Total Fixed Total Manufacturing Overhead Direct labor hours Manufacturing overhead rate per direct labor hour $ $ 1 $ $ ATLANTA COMPANY Manufacturing Overhead Budget For the Year Ending December 31, 2020 2 Quarter $ $ 3

Name: Rr.3. Atlanta Company is preparing its manufacturing overhead budget f
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Rr.3. Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following.Units to be produced (by quarters): 10,400, 12,100, 14,200, 17,000.Direct labor: Time is 1.5 hours per unit.Variable overhead costs

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 3PB: TIB makes custom guitars and prepared the following sales budget for the second quarter It also has...

See similar textbooks

Similar questions

Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?
Adam Corporation manufactures computer tables and has the following budgeted indirect manufacturing cost information for the next year: If Adam uses the step-down (sequential) method, beginning with the Maintenance Department, to allocate support department costs to production departments, the total overhead (rounded to the nearest dollar) for the Machining Department to allocate to its products would be: a. 407,500. b. 422,750. c. 442,053. d. 445,000.
The fixed overhead budgeted for Ranier Industries at an expected capacity of 500,000 units is 1,500,000. Variable costing is used internally, and the net income is adjusted to an absorption costing net income at year-end. Data collected over the last three years show the following: Determine the adjustment each year to convert the variable costing income to absorption costing net income. Compute the absorption costing net income for each year.
Judges Gavel uses this information when preparing their flexible budget: direct materials of $3 per unit, direct labor of $2.50 per unit, and manufacturing overhead of $1.25 per unit. Fixed costs are $49,000. What would be the budgeted amounts for 33,000 and 35,000 units?
Flexible budget for factory overhead Presented below are the monthly factory overhead cost budget (at normal capacity of 5,000 units or 20,000 direct labor hours) and the production and cost data for a month. The predetermined overhead rate is based on normal capacity. Required: 1. Assuming that variable costs will vary in direct proportion to the change in volume, prepare a flexible budget for production levels of 80%, 90%, and 110% of normal capacity. Also determine the predetermined factory overhead rate at each level of volume in both units and direct labor hours. 2. Prepare a flexible budget for production levels of 80%, 90%, and 110%, assuming that variable costs will vary in direct proportion to the change in volume, but with the following exceptions. (Hint: Set up a third category for semi-variable expenses.) a. At 110% of capacity, another supervisor will be needed at a salary of 24,000 annually. b. At 80% of capacity, the repairs expense will drop to one-half of the amount at 100% capacity. c. At 80% of capacity, one part-time maintenance worker, earning 10,000 a year, will be laid off. d. At 110% of capacity, a machine not normally in use and on which no depreciation is normally recorded will be used in production. Its cost was 12,000, it has a 10-year life, and straight-line depreciation will be taken.
Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $2 per unit, direct labor of $3 per unit, and manufacturing overhead of $1 per unit. Fixed costs are $35,000. What would be the budgeted amounts for 20,000 and 25,000 units?
At the beginning of the period, the Fabricating Department budgeted direct labor of 72,000 and equipment depreciation of 18,500 for 2,400 hours of production. The department actually completed 2,350 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
Listed below are the budgeted factory overhead costs for 2011 for Moss Industries at a projected level of 2,000 units: Required: Prepare flexible budgets for factory overhead at the 1,000, 2,000, and 4,000 unit levels. (Hint: You must first decide which of the listed costs should be considered variable and which should be fixed.)
Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
Georgia Gasket Co. budgets 8,000 direct labor hours for the year. The total overhead budget is expected to amount to 20,000. The standard cost for a unit of the companys product estimates the variable overhead as follows: The actual data for the period follow: Using the four-variance method, calculate the overhead variances. (Hint: First compute the budgeted fixed overhead rate.)
The Sales Department of Minimus Inc. has forecast sales for May 2016 to be 40,000 units. Additional information follows: Materials used in production: Direct labor hours required in production: Prepare the following: a. A production budget for May. b. A direct materials budget for May. c. A direct labor budget for May.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.