Question

In: Accounting

Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable...

Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2020 contained the following data.

Variable Costs

Fixed Costs

Indirect materials $11,100 Supervisory salaries $36,700
Indirect labor 11,000 Depreciation 6,100
Utilities 7,700 Property taxes and insurance 7,400
Maintenance 5,500 Maintenance 4,900


Actual variable costs were indirect materials $14,800, indirect labor $9,200, utilities $9,300, and maintenance $5,200. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,400. The actual activity level equaled the budgeted level.

All costs are considered controllable by the production department manager except for depreciation, and property taxes and insurance.

(a) Prepare a manufacturing overhead flexible budget report for the first quarter. (List variable costs before fixed costs.)

(b) Prepare a responsibility report for the first quarter.

Solutions

Expert Solution

As the Actual activity is same as budgeted

Master budget= flexible budget

a)Manufacturing Overhead Flexible Budget for the first quarter

Particulars Flexible Budget Actual Variance
Variable Cost
Indirect Materials $11,100 $14,800

$3,700 U

[$14,800-$11,100]

Indirect Labor $11,000 $9,200

$1,800 F

[$11,000-9,200]

Utilities $7,700 $9,300

$1,600 U

[$7,700-$9,300]

Maintenance $5,500 $5,200

$300 F

[$5,500-5,200]

Total Variable Cost $35,300 [$11,100+11,000+7,700+5,500] $38,500

3,200 U

[$35,300-38,500]

Fixed Cost
Supervisory Salaries $36,700 $36,700 ''N''
Depreciation $6,100 $6,100 ''N''
Property taxes and insurance $7,400 $8,400 $300 U
Maintenance $4,900 $4,900 ''N''
Total Fixed Cost $55,100 [$36,700+$6,100+$7,400+$4,900] $56,100 1,000 U[$55,100-$56,100]
Total Cost $90,400 [$55,100+$35,300] $94,600 $4,200 U [$90,400-94,600]

b) Manufacturing Overhead Responsibility Report

Particulars Flexi Budget Actual Variance
Controllable Cost
Indirect Materials $11,100 $14,800 $3,700 U
Indirect Labor $11,000 $9,200 $1,800 F
Utilities $7,700 $9,300 $1,600 U
Maintenance $10,400[$5,500+$4,900] $10,100[$5,200+$4,900] $300 F
Supervisory Salaries $36,700 $36,700 N
Total Cost $76,900 $80,100

$3,200 U

[3,700+1,600-1,800-300]


Related Solutions

Strickland Crop's manufacturing overhead budget for the first quarter of 2013 contained the following data: Variable...
Strickland Crop's manufacturing overhead budget for the first quarter of 2013 contained the following data: Variable Costs    Indirect materials $40,000 Indirect labor $24,000 Utilities $20,000 Maintenance   $12,000 Fixed Cost Supervisor's salary $80,000 Depreciation $16,000 Property taxes $8000 Actual variable cost for the first quarter were: indirect materials $37200 indirect labor $26400 utilities $21000 maintenance $10600 Actual fixed costs were as expected except for the property taxes which were $9000. All cost are considered controllable by the department manger except...
Your job is to create the following: Overhead budget (for each quarter): Variable Overhead Rate ($/hr)...
Your job is to create the following: Overhead budget (for each quarter): Variable Overhead Rate ($/hr) Budgeted Variable Overhead Budgeted fixed overhead without depreciation Depreciation Total Overhead Selling & Administrative Budget (for each quarter) Planned sales in dollars Variable S & A rate (per unit sold) Variable S & A Expense Fixed S & A Expense without depreciation Depreciation Total S & A Expense Diesel Dynamo Company Budget Project Fall 2017 INPUT SECTION SALES 4th 1st 2nd 3rd 4th Quarter...
Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following....
Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,500, 12,400, 14,700, 16,700. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.30; and maintenance $0.60. Fixed overhead costs per quarter: supervisory salaries $36,820; depreciation $18,270; and maintenance $14,100. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020 are November...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020 are November...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step...
Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Prepare schedules for cash receipts and cash payments, and determine ending balances for balance sheet. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after...
The following information relates to Tallman comma Inc.?'s overhead costs for the? month: Static budget variable...
The following information relates to Tallman comma Inc.?'s overhead costs for the? month: Static budget variable overhead - $8,000 Static budget fixed overhead - $3,000 Static budget direct labor hours - 1,000 hours Static budget number of units - 5,000 units Tallman allocates manufacturing overhead to production based on standard direct labor hours. Last? month, Tallman reported the following actual? results: actual variable? overhead, $ 10600?; actual fixed? overhead, $ 2780?; actual production of 7400 units at 0.25 direct labor...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 180 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 150 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:...
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:    January February March Sales budget $142,000 $159,000 $174,000    Credit sales are collected as follows:    70 percent in the month of the sale 25 percent in the month after the sale 5 percent in the second month after the sale    The accounts receivable balance at the end of the previous quarter was $70,150 ($61,200 of which was uncollected December sales).   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT