Chapter 11 HW
.docx
keyboard_arrow_up
School
Webster University *
*We aren’t endorsed by this school
Course
513
Subject
Accounting
Date
Jan 9, 2024
Type
docx
Pages
10
Uploaded by Count_Discovery_PolarBear14
Problem 11-36 Standard Hours Allowed; Flexible Budget; Multiple Products; Insurance Company (LO 11-
1, 11-2, 11-4)
Gibralter Insurance Company uses a flexible overhead budget for its application-processing department. The firm offers five types of policies, with the following standard hours allowed for clerical processing.
Automobile 1 hour
Renter's
1 hour
Homeowner's 2 hours
Health
2 hours
Life
5 hours
The following numbers of insurance applications were processed during July.
Automobile 310
Renter's
260
Homeowner's 160
Health
460
Life
260
The controller estimates that the variable-overhead rate in the application-
processing department is $3.00 per clerical hour, and that fixed-overhead costs will amount to $2,600 per month.
Required:
1.
How many standard clerical hours are allowed in July, given actual application activity?
2.
Why would it not be sensible to base the company’s flexible budget on the number of applications processed instead of the number of clerical hours allowed?
3.
Construct a formula flexible overhead budget for the company.
4.
What is the flexible budget for total overhead cost in July?
Explanation
1.
Standard Hours per
Standard
Policy type
Application
Actual ActivityHours Allowed
Automobile
1
310
310
Renter's
1
260
260
Homeowner's
2
160
320
Health
2
460
920
Life
5
260
1,300
Total
3,110
2.
The different types of applications require different amounts of clerical time, and variable overhead cost is related to the use of clerical time. Therefore, basing the flexible budget on the number of applications would give a misleading estimate of overhead costs. For example, processing 160 life insurance applications will entail much more overhead cost than processing 160 automobile insurance applications.
3.
Formula flexible budget:
Total budgeted monthly overhead cost = (budgeted variable overhead cost per clerical hour) × (total clerical hours) + budgeted fixed overhead cost per month
Total budgeted monthly overhead cost = ($3.00 ×
X
) + $2,600
where
X
denotes total clerical time in hours.
4.
Budgeted overhead cost for July
= ($3.00 × 3,110) + $2,600
= $11,930
Problem 11-39 Budgets and Performance Evaluation (LO 11-1, 11-6)
Johnson Electrical produces industrial ventilation fans. The company plans to manufacture 78,000 fans evenly over the next quarter at the following costs: direct material, $1,950,000; direct labor, $546,000; variable production overhead, $581,100; and fixed production overhead, $930,000. The $930,000 amount includes $93,000 of straight-line depreciation and $117,000 of supervisory salaries.
Shortly after the conclusion of the quarter’s first month, Johnson reported the following costs:
Direct material
$
573,500
Direct labor
174,600
Variable production overhead
198,000
Depreciation
31,000
Supervisory salaries
42,500
Other fixed production overhead
239,000
Total
$1,258,600
Dave Kellerman and his crews turned out 22,000 fans during the month—a remarkable feat given that the firm’s manufacturing plant was closed for several days because of storm damage and flooding. Kellerman was especially pleased with the fact that overall financial performance for the period was favorable when compared with the budget. His pleasure, however,
was very short-lived, as Johnson’s general manager issued a stern warning that performance must improve, and improve quickly, if Kellerman had any hopes of keeping his job.
Required:
2.
Which of the two budgets would be more useful when planning the company’s cash needs over a range of activity?
3.
Prepare a performance report that compares static budget and actual costs
for the period just ended (i.e., the report that Kellerman likely used when assessing his performance).
4.
Prepare a performance report that compares flexible budget and actual costs for the period just ended (i.e., the report that the general manager likely used when assessing Kellerman’s performance).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Spiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for
preparing the company's master budget. In compiling the budget data for 20x1, Demarest has learned that new automated
production equipment will be installed on March 1. This will reduce the direct labor per frame from 3.0 hours to 2.75 hours.
Labor-related costs include pension contributions of $1.55 per hour, workers' compensation insurance of $1.25 per hour,
employee medical insurance of $5 per hour, and employer contributions to Social Security equal to 6.00 percent of direct-
labor wages. The cost of employee benefits paid by the company on its employees is treated as a direct-labor cost. Spiffy
Shades Corporation has a labor contract that calls for a wage increase to $21.00 per hour on April 1, 20x1. Management
expects to have 22,000 frames on hand at December 31, 20x0, and has a policy of carrying an end-of-month inventory of
100 percent of the following month's…
arrow_forward
Part IV
Gaurav's Restaurant is analyzing an increase in its labour cost. You
have been given the following information on the average hourly
rate for its front-of-house positions and an excerpt from its
budget and actual results for the month.
Server
Busser
Host
Position
Required
Server
Busser
Host
Position
Actual
Total Cost
$11,963
2,320
1,615
Average Rate
$16.00
$15.00
$18.00
Hours Worked
725
160
95
Budget
Total Cost
$12,000
$2,250
$1,620
Hours Worked
750
150
90
a) Calculate the cost variance for each position.
b) Calculate the quantity variance for each position.
c) Calculate the total variance for each position.
arrow_forward
H
arrow_forward
Saved
antcring overhead s budgeted to be $33,000 plus $6 per unit produced. What Is budgeted manufacturing overhead for AuguUst?
32
Sylerh tas brecast production for the next three months as follows: July 6,500 units, August 8,200 units, September 9,100 units. Monthly
Mutole Choice
S82.200
$I2.000
$9.200
SE7500
arrow_forward
DO not give answer in image formate
arrow_forward
Q.prepare Manufacturing overhead cost budgets for each of the three activities for april.
arrow_forward
Q.Prepare Revenues budget for June
arrow_forward
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
arrow_forward
Vinubhai
arrow_forward
The cheque-clearing office of Pay Loans Company is responsible for processing all cheques that come to the company for payment.
Managers at the company believe that variable overhead costs are essentially proportional to the number of labour-hours worked in
the office, so labour-hours are used as the activity base when preparing variable overhead budgets and performance reports. Data for
October, the most recent month, appear below:
Budgeted labour-hours
Actual labour-hours
Standard labour-hours allowed for the actual number of cheques processed
Variable overhead costs:
Office supplies
Staff coffee lounge.
Indirect labour
Total variable overhead cost
Cost
Formula
(per
labour-
hour)
$ 1.10
0.30
2.70
$4.10
Actual
Costs
Incurred in
October
$ 1,391
463
2,980
$ 4,834
1,380
1,310
1,400
Fixed overhead at Pay Loans Company consists entirely supervisory salaries and is applied at a rate of $6 per direct labour-hour.
Actual fixed overhead costs totalled $6,200 in October, while the flexible…
arrow_forward
Question 1
Green Co. has three production departments Fern, Forest, and Moss and one service
department Shade. Green Co. is preparing its annual budget for the final quarter of
2021. Planned overhead costs for the quarter are as follows:
Overheads
Allocated overheads
40,500
Supervision
Plant Depreciation
14,400
20,000
6,000
46,000
Machine Insurance
Rates and Rent
The following information is available for each department:
Departmental details
Fern
Forest
Moss
Shade
Allocated overhead
11,000
16,500
2,500
9,500
3,500
3,500
1,500
Machine Value (£)
Budgeted Direct Labour hours
Floor Area Occupied (Sq.metres)
Number of employees
Plant at cost (£000)
5,000
1,200
600
1,800
1000
3,000
800
200
700
400
40
80
1,845
852
61
142
Of the total overhead costs allocated to the service department Shade, 20% is
charged to Forest and the remainder is charged equally to the other two
production department.
a)
Prepare an overhead analysis sheet showing the total overhead cost
budgeted for all four…
arrow_forward
6. Question Content Area
Administrative Expense Budget
Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include:
Salaries
$10,000
Insurance
2,100
Depreciation
3,900
Accounting services
800
Required:
Question Content Area
1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period.
Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months
June
July
August
Total
Salaries
$fill in the blank 532c4bfc1f8bfa8_1
$fill in the blank 532c4bfc1f8bfa8_2
$fill in the blank 532c4bfc1f8bfa8_3
$fill in the blank 532c4bfc1f8bfa8_4
Insurance
fill in the blank 532c4bfc1f8bfa8_5
fill in the blank 532c4bfc1f8bfa8_6
fill in…
arrow_forward
Q.prepare Nonmanufacturing costs budget for april.
arrow_forward
Direct Labor Cost Budget
Ace Racket Company manufactures two types of tennis rackets, the Junior and Pro Striker models. The production budget for July for the two rackets is as follows:
Junior
Pro Striker
Production budget
1,500 units
6,200 units
Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are estimated as follows:
Forming Department
Assembly Department
Junior
0.16 hour per unit
0.24 hour per unit
Pro Striker
0.20 hour per unit
0.30 hour per unit
The direct labor rate for each department is as follows:
Forming Department
$18.00 per hour
Assembly Department
$14.00 per hour
Prepare the direct labor cost budget for July.
arrow_forward
Need the what to do from 1-4
arrow_forward
Preparing an Overhead Budget
Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are:
January
13,140
February
12,300
March
15,075
The variable overhead rate is $0.70 per direct labor hour. Fixed overhead is budgeted at $2,850 per month.
Required:
Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your answer. Round total variable overhead and total overhead to the nearest dollar.
Patrick Inc.
Overhead Budget
For the Coming First Quarter
Overhead:
January
February
March
Total
Total direct labor hrs
fill in the blank 1
fill in the blank 2
fill in the blank 3
fill in the blank 4
Variable overhead rate
$fill in the blank 5
$fill in the blank 6
$fill in the blank 7
$fill in the blank 8
Total variable overhead
$fill in the blank 9
$fill in the blank 10
$fill in the blank 11
$fill in the…
arrow_forward
Preparing an Overhead Budget
Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are:
January
13,140
February
12,300
March
15,075
The variable overhead rate is $0.60 per direct labor hour. Fixed overhead is budgeted at $2,580 per month.
Required:
Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of
your answer. Round total variable overhead and total overhead to the nearest dollar.
Patrick Inc.
Overhead Budget
For the Coming First Quarter
Overhead:
January
February
March
Total
Total direct labor hrs
Variable overhead rate
Total variable overhead
$4
Add: Fixed overhead
Total overhead
arrow_forward
Required information
Miami Solar manufactures solar panels for industrial use. The company budgets production of 4,300 units (solar panels) in
July and 5,400 units in August.
Each unit requires 4 hours of direct labor at a rate of $20 per hour. Prepare a direct labor budget for July.
Units to produce
MIAMI SOLAR
Direct Labor Budget
Direct labor hours needed
Cost of direct labor
July
4,300
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Preparing an Accounts Payable Schedule
Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account:
April
$374,400
May
411,100
June
416,700
Wight typically pays 25% on account in the month of billing and 75% the next month.
Required:
1. How much cash is required for payments on account in May?
2. How much cash is expected for payments on account in June?
arrow_forward
Preparing an Overhead Budget
Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are:
January
13,140
February
12,300
March
15,075
The variable overhead rate is $0.70 per direct labor hour. Fixed overhead is budgeted at $2,910 per month.
Required:
Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your answer. Round total variable overhead and total overhead to the nearest dollar.Overhead:JanuaryFebruaryMarchTotalTotal direct labor hrsfill in the blank 1fill in the blank 2fill in the blank 3fill in the blank 4Variable overhead rate$fill in the blank 5$fill in the blank 6$fill in the blank 7$fill in the blank 8Total variable overhead$fill in the blank 9$fill in the blank 10$fill in the blank 11$fill in the blank 12Add: Fixed overheadfill in the blank 13fill in the blank 14fill in the blank 15fill in the…
arrow_forward
Homework problem #5:
Chap
0 moldong rowemoll
Probe Corporation is preparing its manufacturing overhead budget. The company uses directo
labor-hours as its overhead allocation base. The direct labor budget for the upcoming quarter is
as follows:
Budgeted direct labor-hours
April
490
May
770
June
660
The company's variable manufacturing overhead rate is $1.60 per direct labor hour and the
company's fixed manufacturing overhead is $3,000 per month. The only noncash item included
per month.
in fixed manufacturing overhead is depreciation, which is $600
Prepare the company's manufacturing overhead budget for the upcoming fiscal year.
wad ton bib sterol sup
arrow_forward
Q.Prepare Revenues budget for April.
arrow_forward
Don't provide answers in image format
arrow_forward
Preparing an Overhead Budget
Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are:
January
13,140
February
12,300
March
15,075
The variable overhead rate is $0.70 per direct labor hour. Fixed overhead is budgeted at $2,890 per month.
Required:
Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your answer. Round total variable overhead and total overhead to the nearest dollar.
Overhead:
January
February
March
Total
Total direct labor hrs
fill in the blank 1
fill in the blank 2
fill in the blank 3
fill in the blank 4
Variable overhead rate
$fill in the blank 5
$fill in the blank 6
$fill in the blank 7
$fill in the blank 8
Total variable overhead
$fill in the blank 9
$fill in the blank 10
$fill in the blank 11
$fill in the blank 12
Add: Fixed overhead
fill in the blank 13
fill in the…
arrow_forward
Budget performance report for a cost center
GHT Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost
center. The budget for the Consumer Products Division for the month ended July 31 is as follows:
Line Item Description
Customer service salaries
Insurance and property taxes
Distribution salaries
Marketing salaries
Engineer salaries
836,850
586,110
185,120
Total
$4,167,050
During July, the costs incurred in the Consumer Products Division were as follows:
Warehouse wages
Equipment depreciation
Line Item Description
Customer service salaries
Insurance and property taxes
Distribution salaries
Marketing salaries
Engineer salaries
Warehouse wages
Equipment depreciation
Total
Required:
Question Content Area
Line Item Description
Customer service salaries
Insurance and property taxes
Distribution salaries
Amount
$546,840
114,660
872,340
1,025,130
1. Prepare a budget performance report for the director of the Consumer Products Division for the…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Related Questions
- Spiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for preparing the company's master budget. In compiling the budget data for 20x1, Demarest has learned that new automated production equipment will be installed on March 1. This will reduce the direct labor per frame from 3.0 hours to 2.75 hours. Labor-related costs include pension contributions of $1.55 per hour, workers' compensation insurance of $1.25 per hour, employee medical insurance of $5 per hour, and employer contributions to Social Security equal to 6.00 percent of direct- labor wages. The cost of employee benefits paid by the company on its employees is treated as a direct-labor cost. Spiffy Shades Corporation has a labor contract that calls for a wage increase to $21.00 per hour on April 1, 20x1. Management expects to have 22,000 frames on hand at December 31, 20x0, and has a policy of carrying an end-of-month inventory of 100 percent of the following month's…arrow_forwardPart IV Gaurav's Restaurant is analyzing an increase in its labour cost. You have been given the following information on the average hourly rate for its front-of-house positions and an excerpt from its budget and actual results for the month. Server Busser Host Position Required Server Busser Host Position Actual Total Cost $11,963 2,320 1,615 Average Rate $16.00 $15.00 $18.00 Hours Worked 725 160 95 Budget Total Cost $12,000 $2,250 $1,620 Hours Worked 750 150 90 a) Calculate the cost variance for each position. b) Calculate the quantity variance for each position. c) Calculate the total variance for each position.arrow_forwardHarrow_forward
- Saved antcring overhead s budgeted to be $33,000 plus $6 per unit produced. What Is budgeted manufacturing overhead for AuguUst? 32 Sylerh tas brecast production for the next three months as follows: July 6,500 units, August 8,200 units, September 9,100 units. Monthly Mutole Choice S82.200 $I2.000 $9.200 SE7500arrow_forwardDO not give answer in image formatearrow_forwardQ.prepare Manufacturing overhead cost budgets for each of the three activities for april.arrow_forward
- The cheque-clearing office of Pay Loans Company is responsible for processing all cheques that come to the company for payment. Managers at the company believe that variable overhead costs are essentially proportional to the number of labour-hours worked in the office, so labour-hours are used as the activity base when preparing variable overhead budgets and performance reports. Data for October, the most recent month, appear below: Budgeted labour-hours Actual labour-hours Standard labour-hours allowed for the actual number of cheques processed Variable overhead costs: Office supplies Staff coffee lounge. Indirect labour Total variable overhead cost Cost Formula (per labour- hour) $ 1.10 0.30 2.70 $4.10 Actual Costs Incurred in October $ 1,391 463 2,980 $ 4,834 1,380 1,310 1,400 Fixed overhead at Pay Loans Company consists entirely supervisory salaries and is applied at a rate of $6 per direct labour-hour. Actual fixed overhead costs totalled $6,200 in October, while the flexible…arrow_forwardQuestion 1 Green Co. has three production departments Fern, Forest, and Moss and one service department Shade. Green Co. is preparing its annual budget for the final quarter of 2021. Planned overhead costs for the quarter are as follows: Overheads Allocated overheads 40,500 Supervision Plant Depreciation 14,400 20,000 6,000 46,000 Machine Insurance Rates and Rent The following information is available for each department: Departmental details Fern Forest Moss Shade Allocated overhead 11,000 16,500 2,500 9,500 3,500 3,500 1,500 Machine Value (£) Budgeted Direct Labour hours Floor Area Occupied (Sq.metres) Number of employees Plant at cost (£000) 5,000 1,200 600 1,800 1000 3,000 800 200 700 400 40 80 1,845 852 61 142 Of the total overhead costs allocated to the service department Shade, 20% is charged to Forest and the remainder is charged equally to the other two production department. a) Prepare an overhead analysis sheet showing the total overhead cost budgeted for all four…arrow_forward6. Question Content Area Administrative Expense Budget Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include: Salaries $10,000 Insurance 2,100 Depreciation 3,900 Accounting services 800 Required: Question Content Area 1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period. Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months June July August Total Salaries $fill in the blank 532c4bfc1f8bfa8_1 $fill in the blank 532c4bfc1f8bfa8_2 $fill in the blank 532c4bfc1f8bfa8_3 $fill in the blank 532c4bfc1f8bfa8_4 Insurance fill in the blank 532c4bfc1f8bfa8_5 fill in the blank 532c4bfc1f8bfa8_6 fill in…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,