978-0078025273 Chapter 29 Excel

subject Type Homework Help
subject Pages 6
subject Words 487
subject Authors John Price, M. David Haddock, Michael Farina

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
2,250 2,500 2,750
90% 100% 110%
2,250.00 2,500.00 2,750.00
562.50 625.00 687.50
337.50 375.00 412.50
900.00 1,000.00 1,100.00
562.50 625.00 687.50
4,612.50 5,125.00 5,637.50
1,800.00 1,800.00 1,800.00
100.00 100.00 100.00
100.00 100.00 100.00
200.00 200.00 200.00
1,200.00 1,200.00 1,200.00
500.00 500.00 500.00
200.00 200.00 200.00
McGraw-Hill/Irwin
Instructor
Depreciation
Utilities
Indirect Materials
Payroll Taxes
Maintenance
Taxes and Insurance
Utilities ($0.40/hr)
Indirect Materials ($0.15/unit)
Payroll Taxes ($0.25/hr)
Indirect labor ($1.00/hr)
Indirect labor
Fixed costs
Total variable costs
Repairs ($.25/hr)
Variable costs
Percent of expected capacity
Number of direct hours
Problem 29.02A
Flexible Budget for Manufacturing Overhead
For Month of May, 2013
BIBEE PRODUCTS, INC.
page-pf2
Variable Cost Monthly
Element Fixed
per Hour Cost Element
1.00$ 1,800$
0.25 100
0.15 100
0.40 200
1,200
500
0.25 200
2,500
1,900
3,650$
375
400
1,000
1,200
475
650
Depreciation
Utilities
Assembly Department Manufacturing Overhead Costs
BIBEE PRODUCTS, INC.
Indirect materials
Payroll taxes
Indirect labor
Maintenance
Taxes and insurance
Actual production for May in direct labor hours
Expected production for May in direct labor hours
Additional Information:
Indirect materials
Payroll taxes
Indirect labor
Actual Costs for May:
Maintenance
Taxes and insurance
Depreciation
Utilities
page-pf3
Student Name:
Class:
Standard Actual Quantity Price
Gallons Price
7,000 0.40$ 2,800.00
7,050 0.38$ 2,679.00
(20.00)
141.00
Gallons Price
2,500 1.20$ 3,000.00
2,550 1.22$ 3,111.00
(60.00)
(51.00)
Gallons Price
500 12.00$ 6,000.00
490 12.20$ 5,978.00
120.00
(98.00)
11,800.00 11,768.00 40.00 (8.00)
Correct! Correct! Correct! Correct!
Standard Actual Variance
2,800.00$ 2,679.00$ 121.00$
3,000.00$ 3,111.00$ (111.00)$
6,000.00$ 5,978.00$ 22.00$
Totals 11,800.00$ 11,768.00$ 32.00$
Correct! Correct! Correct!
Activator
Acid
Starter
Variances for Each Type of Material
CAL CHEMICAL COMPANY
Standard
Totals
Price Variance
Quantity Variance
Actual
Cost Element
Month of June, 2013
Actual
Activator
Standard
Acid
Price Variance
Quantity Variance
Price Variance
Quantity Variance
Problem 29.03A
McGraw-Hill/Irwin
Instructor
Actual
Standard
Starter
Analysis of Materials Variance
Cost
CAL CHEMICAL COMPANY
Variance
page-pf4
Quantity Standard Standard
in Cost Cost
Material Gallons per Gallon per Batch
700 0.40$ 280$
250 1.20 300
50 12.00 600
13.60$ 1,180$
1,000
50
200
Quantity
in Cost per
Gallons Gallon
7,050 0.38$
2,550 1.22
490 12.20
Activator
Given Data P29.03A
Starter
Starter
Acid
Acid
Activator
Total standard cost
Standard Costs per Batch of Licon
Material
CAL CHEMICAL COMPANY
Materials Actually Used In June
Additional Information:
Production batches in gallons
Number of drums of Licon produced in June, 2013
Number of gallons per drum of output
page-pf5
Student Name:
Class:
Standard Actual Quantity Price
Sq. Ft. Price
50,000 0.250$ 12,500.00
49,650 0.255$ 12,660.75
87.50
(248.25)
Pounds Price
75,000 0.050$ 3,750.00
75,100 0.045$ 3,379.50
(5.00)
375.50
16,250.00 16,040.25 82.50 127.25
Correct! Correct! Correct! Correct!
Standard Actual Quantity Price
Hours Rate
5,000 14.00$ 70,000.00
4,980 14.05$ 69,969.00
280.00
(249.00)
Hours Rate
2,500 15.00$ 37,500.00
2,550 14.98$ 38,199.00
(750.00)
51.00
107,500.00 108,168.00 (470.00) (198.00)
Correct! Correct! Correct! Correct!
Analysis of Labor Variance
Totals
Price Variance
EVAD MANUFACTURING COMPANY
Actual
Standard
Analysis of Materials Variance
Quantity Variance
Actual
Standard
Costs
Month of March, 2013
Month of March, 2013
Cost Element
Costs
Variances
EVAD MANUFACTURING COMPANY
Variances
Totals
Rate Variance
Quantity Variance
Actual
Standard
Final Dept.
Rate Variance
Quantity Variance
Cost Element
McGraw-Hill
Instructor
Actual
Standard
Cutting Dept.
Problem 29.04A
Filler
Framing
Price Variance
Quantity Variance
page-pf6
Cost per Standard
Quantity Unit Cost
10 0.25$ 2.50$
15 0.05 0.75
3.25$
114.00 14.00$
0.5 15.00 7.50
21.50$
Cost per Actual
Quantity Unit Cost
49,650.00 0.255$ 12,660.75$
75,100.00 0.045 3,379.50
16,040.25$
4,980 14.05 69,969.00$
2,550 14.98 38,199.00
108,168.00$
5,000
Given Data P29.04A
Framing
Raw materials
Standard Costs
EVAD MANUFACTURING COMPANY
Additional Information
Units of product made during March, 2013
Filler
Raw materials
Final Dept.
Cutting Dept.
Standard materials cost per unit
Total actual materials cost
Cutting Dept.
Final Dept.
Direct Labor
Direct Labor
Total actual direct labor cost
Standard direct labor cost per unit
Actual Costs
Framing
Filler

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.