In: Accounting
Scooter Ltd manufactures scooters for the domestic market using a highly automated process. The company uses a standard costing system for planning and control purposes and has prepared a standard cost sheet based on a practical capacity (denominator level) of 20,000 scooters (200,000 machine hours).
Standard Cost Sheet
Direct Materials (10 kg @$9.00 per kg)........................................................ $90.00
Direct Labour (3 hours @ $20.00 per hour).................................................. $60.00
Variable Overhead (10 machine hours @ $4.00 per machine hour) ............ $40.00
Fixed Overhead (10 machine hours @ $5.00 per machine hour)................. $50.00
Standard cost per barbecue ......................................................................... $240.00
The Manufacturing Department Budget was prepared based on the forecast need to manufacture 18,000 scooters. During the year, 20,000 scooters were actually made.
At year end, the manufacturing department (cost) performance report is as below:
........................................Actual Master Budget ..........@ Std Cost ................Variance
Number of units ......................20,000 .............................18,000 .....................2,000
Direct Materials ..................$2,576,500 .........................$1,620,000 ................$956,500 U
Direct Labour .....................$1,516,000............................ $1,080,000................ $436,000 U
Variable Overhead ...............$861,000 .........................$720,000 .....................$141,000 U
Fixed Overhead ..................$970,000 ............................$900,000 ...................$70,000 U
Total ..................................$5,923,500 .........................$4,320,000 ................$1,603,500 U
After viewing the report, the company CEO was concerned. He wants to know what is going on in the Manufacturing Department. The accountant has directed you to investigate the variances further. As part of your investigations, you have discovered the following:
335,000 kg of raw materials were purchased and used during the year;
72,000 direct labour hours were worked during the year;
210,000 machine hours were worked during the year;
During the year a factory supervisor retired and was not replaced;
Defective materials delivered by a supplier had gone undetected before use in production. This defective material caused the additional use of 30,000 kg of raw materials; 1,000 labour hours, and 2,500 machine hours to meet the required production.
REQUIRED: Calculate the following manufacturing variances for:
Direct materials price variance based on usage
Direct materials efficiency variance
Direct manufacturing labour price variance
Direct manufacturing labour efficiency variance
Variable manufacturing overhead spending variance
Variable manufacturing overhead efficiency variance
Fixed overhead spending variance
Production volume variance Indicate whether each variance is favourable or unfavourable.
b. Provide a short statement to the CEO regarding the potential causes of the following variance and a practical recommendation to address each variance: direct materials efficiency variance labour efficiency variance variable overhead efficiency variance
Budgeted units of production | 20000 | |||||||||||
Actual Units of Production | 18000 | |||||||||||
SQ | Standard Quantity(Kg) for actual output | 180,000 | (10Kg*18000) | |||||||||
AQ | Actual Quantity (Kg)of materials used | 335,000 | ||||||||||
SP | Standard Price per Kg | $9.00 | ||||||||||
AP | Actual Price per Kg | $7.69 | (2576500/335000) | |||||||||
AQ*(AP-SP) | Direct Materials Price Variance | $438,500 | Favorable | (Actual Price is LESS than Standard Price) | ||||||||
SP*(AQ-SQ) | Direct Materials Efficiency Variance | $1,395,000 | Unfavorable | (Actual quantity is MORE than Standard quantity) | ||||||||
Total Material cost variance | $956,500 | Unfavorable | ||||||||||
DIRECT LABOR VARIANCES | ||||||||||||
SH | Standard Labor hour for actual output | 54000 | (3*18000) | |||||||||
SR | Standard Labor rate per hour | $20.00 | ||||||||||
AH | Actual labor hour used | 72000 | ||||||||||
AR | Actual Labor rate per hour | $21.06 | (1516000/72000) | |||||||||
AH*(AR-SR) | Direct labor Price Variance | $76,000 | Unfavorable | (Actual Rate is HIGHER than Standard Rate) | ||||||||
SR*(AH-SH) | Direct Labor Efficiency Variance | $360,000 | Unfavorable | (Actual hour is MORE than Standard hour) | ||||||||
Total Direct labor variance | $436,000 | Unfavorable | ||||||||||
VARIABLE OVERHEAD VARIANCES | ||||||||||||
SH | Standard Machine hour for actual output | 180000 | (10*18000) | |||||||||
SR | Standard Overhead rate per hour | $4.00 | ||||||||||
AH | Actual Machine hour used | 210000 | ||||||||||
AR | Actual Overhead rate per hour | $4.10 | (861000/210000) | |||||||||
5 | AH*(AR-SR) | Variable Overhead Spending (Price) Variance | $21,000 | Unfavorable | (Actual Rate is More than Standard Rate) | |||||||
6 | SR*(AH-SH) | Varable Overhead Efficiency Variance | $120,000 | Unfavorable | (Actual hour is More than Standard hour) | |||||||
FIXED OVERHEAD VARIANCES | ||||||||||||
A | Budgeted Fixed Overhead | $14,000 | ||||||||||
B | Budgeted labor hour | 2000 | (2*1000) | |||||||||
C=A/B | Budgeted fixed overhead rate | $7 | ||||||||||
D | Standard Labor hour for actual output | 2600 | (2*1300) | |||||||||
E=C*D | Fixed overhead applied | $18,200 | ||||||||||
A-E | Fixed Overhead Volume Variance | $4,200 | Unfavorable | |||||||||
F | Budgeted Fixed Overhead | $900,000 | (20000*50) | |||||||||
G | Actual Fixed Overhead | $970,000 | ||||||||||
H=F-G | Fixed OverheadSpending Variance | $70,000 | Unfavorable |
Related SolutionsScooter Ltd manufactures scooters for the domestic market using a highly automated process. The company uses...Scooter Ltd manufactures scooters for the domestic market using
a highly automated process. The company uses a standard costing
system for planning and control purposes and has prepared a
standard cost sheet based on a practical capacity (denominator
level) of 20,000 scooters (200,000 machine hours). Standard Cost
Sheet Direct Materials (10 kg @$9.00 per
kg)..................................... $90.00 Direct Labour (3
hours @ $20.00 per hour).................................. $60.00
Variable Overhead (10 machine hours @ $4.00 per machine hour)
............ $40.00 Fixed Overhead (10...
The Scooter Company uses a process cost system for making scooter wheels. Materials are added at...The Scooter Company uses a process cost system for making
scooter wheels. Materials are added at the beginning of the process
and conversion costs are uniformly incurred. At the beginning of
October the work-in-process is 40 percent complete and at the end
of the month it is 60 percent complete. Spoilage is detected at the
end of the process. Other data for the month include:
Beginning work-in-process inventory
1600
units
Units
started
20000
units
Units
placed in finished goods
12000...
Gordon Company is highly automated and uses computerized controllers in manufacturing operations. The company uses a...Gordon Company is highly automated and uses computerized
controllers in manufacturing operations. The company uses a
job-order costing system and applies manufacturing overhead cost to
products on the basis of the time recorded to complete each job by
the computerized controllers attached to each machine. The
following estimates were used in preparing the predetermined
overhead rate at the beginning of the year:
Machine time in hours
4,000
Manufacturing overhead cost
$
230,000
A severe economic recession resulted in cutting...
Jackson Ltd. uses an automated process in its manufacturing operations. On September 1, the company had...Jackson Ltd. uses an automated process in its manufacturing
operations. On September 1, the company had 15,000 units in
beginning work in process which were 60% complete with respect to
conversion. During the month of September, it started 100,000 into
production. On September 30, there were 20,000 units in process,
which were 30% complete with respect to conversion.
Direct materials are added at the beginning of the process, and
no units are spoiled in production. The beginning inventory had
direct...
Timekeeper Inc. manufactures clocks on a highly automated assembly line. Its costing system uses two cost...Timekeeper Inc. manufactures clocks on a highly automated
assembly line. Its costing system uses two cost categories, direct
materials and conversion costs. Each product must pass through the
Assembly Department and the Testing Department. Direct materials
are added at the beginning of the production process. Conversion
costs are allocated evenly throughout production. Timekeeper Inc.
uses weighted-average costing.
Data for the Assembly Department for June are:
Work in process, beginning
inventory 300
units
Direct
materials (100% complete)
Conversion
costs (50% complete)...
Timekeeper Inc. manufactures clocks on a highly automated assembly line. Its costing system uses two cost...Timekeeper Inc. manufactures clocks on a highly automated
assembly line. Its costing system uses two cost categories, direct
materials and conversion costs. Each product must pass through the
Assembly Department and the Testing Department. Direct materials
are added at the beginning of the production process. Conversion
costs are allocated evenly throughout production. Timekeeper Inc.
uses weighted-average costing. Data for the Assembly Department for
June 2017 are: Work in process, beginning inventory 340 units
Direct materials (100% complete) Conversion costs (50%...
Sheffield Wings, Inc. manufactures airplanes for use in stunt shows. Sheffield’s factory is highly automated, using...Sheffield Wings, Inc. manufactures airplanes for use in stunt
shows. Sheffield’s factory is highly automated, using the latest in
robotic technology. To keep costs low, the company employs as few
factory workers as possible. Since each plane has different
features (such as its shape, weight, and color), Sheffield uses a
job order costing system to accumulate product costs.
At the end of 2016, Sheffield’s accountants developed the following
expectations for 2017 based on the marketing department’s sales
forecast:
Budgeted overhead...
Sierra Company manufactures woven blankets and accounts for product costs using process costing. The company uses...Sierra Company manufactures woven blankets and accounts for product costs using process costing. The company uses a single processing department. The following Information is available regarding its May Inventories Raw materials inventory Work in process inventory Finished goods inventory Beginning Ending Inventory Inventory $ 55,000 $ 68,500 439,000 613,000 605,000 564,000 The following additional Information describes the company's production activities for May. $ 280,000 1,582,000 5,000 $ Raw materials purchases (on credit) Factory wages cost (paid in cash) Other overhead cost (Other Accounts...
Sierra Company manufactures woven blankets and accounts for product costs using process costing. The company uses...
Sierra Company manufactures woven blankets and accounts for
product costs using process costing. The company uses a single
processing department. The following information is available
regarding its May inventories.
Beginning
Inventory
Ending
Inventory
Raw
materials inventory
$
60,000
$
92,500
Work in process
inventory
435,000
515,000
Finished goods
inventory
633,000
605,000
The following additional information describes the company's
production activities for May.
Raw
materials purchases (on credit)
$
250,000
Factory wages
cost (paid in cash)
1,530,000
Other overhead
cost (Other...
Wheels Inc. manufactures kick scooters. The company offers a one-year warranty on all scooters. During 2019,...Wheels Inc. manufactures kick scooters. The company
offers a one-year warranty on all scooters. During 2019, the
company recorded net sales of $2,800 million. Historically, about
3% of all sales are returned under warranty and the cost of
repairing and or replacing goods under warranty is about 30% of
retail value. Assume that at the start of the year Wheels’ balance
sheet included an accrued warranty liability of $15.4 million and
at the end of the year, the accrued warranty...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|