Prepare a manufacturing overhead budget for the year. de E21-11 Atlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the following. Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000. Direct labor: time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.20; and maintenance $0.50. Fixed overhead costs per quarter: supervisory salaries $35,000; depreciation $15,000; and maintenance $12,000. Instructions Prepare the manufacturing overhead budget for the year, showing quarterly data.

Prepare a manufacturing overhead budget for the year. de E21-11 Atlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the following. Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000. Direct labor: time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.20; and maintenance $0.50. Fixed overhead costs per quarter: supervisory salaries $35,000; depreciation $15,000; and maintenance $12,000. Instructions Prepare the manufacturing overhead budget for the year, showing quarterly data.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter4: Job Order Costing

Section: Chapter Questions

Problem 7EB: A company estimates its manufacturing overhead will be $840,000 for the next year. What is the...

See similar textbooks

Related questions

Q: What does CAPM allow you to calculate?

A: CAPM model is basically the capital asset pricing model which helps us in determining the expected…

Q: I need to see the equation used to calculate this for it to make sense to me. Can you please show…

A: A mortgage is a loan for a specific amount of money, and mortgage payments are the repayments of…

Q: 1. Compute the accrued interest payable on December 31. 2. & 3. Prepare the journal entry to record…

A: The problem pertains to interest calculation and recognition of year-end adjustment entries as well…

Q: how do you calculate the answers for question a

A: On reading the 4th line of the question, we came across a statement "The company currently absorbs…

Q: Could you show me to solve this problem step by step. Please

A: The equation we have to solve is as shown on the white board. We will take the following approach.As…

Q: PLEASE EXPLAIN EACH POINT STEP BY STEP

A: Auditor refers to the person or individual who is involved in conducting the auditing of the…

Q: Requirement Show your working

A: The calculations represented below shows the schedule of payment:

Q: HOW DO YOU FIND NET CURRENT RECIEVABLES

A: The total amount of money owing to a corporation by its clients minus the money owing that will most…

Q: me how to calculate this without using excel? Thanks

A: A mortgage payment is a regular commitment that a borrower makes to a lender in order to pay back a…

Q: Fill out the missing columns and show the calculation and formulas

A: Net revenue = Gross profit + Cost of goods sold Operating expense = Net revenue x 15%

Concept explainers

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.

Question

Please help me with show all calculation thanku

Prepare a manufacturing
overhead budget for the year.
over
E21-11 Atlanta Company is preparing its manufacturing overhead budget for 2017.
Relevant data consist of the following.
Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000.
Direct labor: time is 1.5 hours per unit.
Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor
$1.20; and maintenance $0.50.
Fixed overhead costs per quarter: supervisory salaries $35,000; depreciation $15,000;
and maintenance $12,000.
Instructions
Prepare the manufacturing overhead budget for the year, showing quarterly data.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Manufacturing Overhead Budget:

VIEW

Step 2: Working notes for the calculation of the manufacturing overhead budget

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

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.
Calculating factory overhead The standard capacity of a factory is 8,000 units per month. Cost and production data follow: Calculate the amount of factory overhead allowed for the actual volume of production each month and the variance between budgeted and actual overhead for each month.
A company estimates its manufacturing overhead will be $750,000 for the next year. What is the predetermined overhead rate given the following independent allocation bases? Budgeted direct labor hours: 60,000 Budgeted direct labor expense: $1,500,000 Estimated machine hours: 100,000
Direct labor hours are estimated as 2,000 in Quarter 1; 2,100 in Quarter 2; 1,900 in Quarter 3; and 2,300 in Quarter 4. Prepare a manufacturing overhead 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.)
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?
Calculating factory overhead The normal capacity of a factory is 10,000 units per month. Cost and production data follow: Calculate the amount of factory overhead allowed for the actual volume of production each month and the variance between budgeted and actual overhead for each month.
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.
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.
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.
Business Specialty, Inc., manufactures two staplers: small and regular. The standard quantities of direct labor and direct materials per unit for the year are as follows: The standard price paid per pound of direct materials is 1.60. The standard rate for labor is 8.00. Overhead is applied on the basis of direct labor hours. A plantwide rate is used. Budgeted overhead for the year is as follows: The company expects to work 12,000 direct labor hours during the year; standard overhead rates are computed using this activity level. For every small stapler produced, the company produces two regular staplers. Actual operating data for the year are as follows: a. Units produced: small staplers, 35,000; regular staplers, 70,000. b. Direct materials purchased and used: 56,000 pounds at 1.5513,000 for the small stapler and 43,000 for the regular stapler. There were no beginning or ending direct materials inventories. c. Direct labor: 14,800 hours3,600 hours for the small stapler and 11,200 hours for the regular stapler. Total cost of direct labor: 114,700. d. Variable overhead: 607,500. e. Fixed overhead: 350,000. Required: 1. Prepare a standard cost sheet showing the unit cost for each product. 2. Compute the direct materials price and usage variances for each product. Prepare journal entries to record direct materials activity. 3. Compute the direct labor rate and efficiency variances for each product. Prepare journal entries to record direct labor activity. 4. Compute the variances for fixed and variable overhead. Prepare journal entries to record overhead activity. All variances are closed to Cost of Goods Sold. 5. Assume that you know only the total direct materials used for both products and the total direct labor hours used for both products. Can you compute the total direct materials and direct labor usage variances? Explain.
Professional labor cost budget Based on the data in Exercise 13-5 and assuming that the average compensation per hour for staff is $36 and for partners is $300. prepare a professional labor cost budget for Day & Spieth, CPAs, for the year ending March 31. 20Y6. Use the following column headings: