This paper circulates around the core theme of Thome Company uses a flexible budget for manufacturing overhead based on direct labor hours. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Name: Date: Instructor: Course: Accounting, Fourth Edition by Kimmel, Weygandt, and Kieso Primer on. 1 answer below » Name: Date: Instructor: Course: Accounting, Fourth Edition by Kimmel, Weygandt, and Kieso Primer on Using Excel in Accounting by Rex A Schildhouse E21-4 – Prepare flexible budget reports for manufacturing overhead costs, and comment on findings. Thome Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.00 Indirect materials 0.50 Utilities 0.40 $4,000 Fixed overhead costs per month are: Supervision Depreciation 1,500 Property Taxes 800 In July 2012, Thome Company View complete question » Name: Date: Instructor: Course: Accounting, Fourth Edition by Kimmel, Weygandt, and Kieso Primer on Using Excel in Accounting by Rex A Schildhouse E21-4 – Prepare flexible budget reports for manufacturing overhead costs, and comment on findings. Thome Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.00 Indirect materials 0.50 Utilities 0.40 $4,000 Fixed overhead costs per month are: Supervision Depreciation 1,500 Property Taxes 800 In July 2012, Thome Company incurs the following manufacturing overhead costs: Variable Costs: Fixed Costs: Indirect labor $8,700 Supervision $4,000 Indirect materials 4,300 Depreciation 1,500 Utilities 3,200 Property Taxes 800 (b) Prepare a flexible budget performance report, assuming that the company worked 8,500 direct labor hours during the month. #NAME? #NAME? #NAME? Direct labor hours (DLH) Budget: Actual Costs Favorable – Fav Variable costs 8,500 DLH 8,500 DLH Unfavorable – Unf Title Amount Amount Amount Fav/Unf Title Amount Amount Amount Fav/Unf Title Amount Amount Amount Fav/Unf Total variable Formula Formula Formula Fav/Unf Fixed costs Title Amount Amount Amount Fav/Unf Title Amount Amount Amount Fav/Unf Title Amount Amount Amount Fav/Unf Total fixed Formula Formula Formula Fav/Unf Total costs Formula Formula Formula Fav/Unf (c) Comment on your findings. Enter text answer here. qattachments_1b5b9ae219fc0bdcbb6d6e035822bec7a9c9bebd.xlsx , Exercise E21-4, Page 1 of 1 Page(s), 04/10/201300:19:31 Document Preview: 1
0.5
0.4
4000
1500
800
8700
4000
4300
1500
3200
800
8500
, , Page of Page(s),
Instructions for the Microsoft Excel Templates by Rex A Schildhouse
Be advised, the template workbooks and worksheets are not protected.
Overtyping any data may remove it.
Extensive detail and information is contained within the help function of Microsoft Excel and in the provided text.
You should enter your name, date, instructor’s name, and course into the cells at the top of the page. This information will be printed on the top of each page if the template requires more than one page.
If more than one page is required by the template, manual page breaks have been set to provide consistent presentation.
All of the cells have been correctly formatted for presentation and should not require any adjustment. For example, if the text requires one, two, or three significant digits in a presentation, the template has been set for that presentation in the appropriate cells.
In general, the yellow highlighted cells are the cells which work and effort should be presented. These entries may include date(s), account title(s), values, memorandum appropriate to the entry, or text answers to questions.
And information or data which may be required by the solution will be entered in cells with borders to help identify them.
Where a yellow highlighted cell shows “Date” enter the appropriate date for that step of the challenge. This may be any date format that Microsoft Excel accepts. Some of these formats include “1/1/12”, “01/01/12”, and “01/01/2012.” All of these will return January 01, 2010, in the format set in the template.
Wh…
