Cost Variance Analysis for Mark Tristan Tuazon's BSA-III Project, Study notes of English

An analysis of the cost variances for Mark Tristan Tuazon's BSA-III project, including material quantity and price variances, labor rate and hours variances, and variable overhead variances. The document also includes a four-way variance analysis.

Typology: Study notes

2022/2023

Uploaded on 09/18/2022

mark-tristan
mark-tristan 🇦🇺

4 documents

1 / 12

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Tuazon, Mark Tristan
BSA - III
Number of Chopping Boards ₱ 4,000.00
Number of board feet per Chopping Board 2.5
Standard Board feet Allowed ₱ 10,000.00
did not exceed the limit
Standard cost per board foot 1.8
Total Standard Cost ₱ 18,000.00
Actual Cost incurred ₱ 18,700.00
Standard Cost ₱ 18,000.00
Spending Variance ₱ 700.00 Unfavorable
Standard Quantity Allowed for Actual Quantity of Input,
Actual Quantity of Input,
Actual Output, at Stadard Price at Standard Price
at Actual Price
(SQ*SP) (AQ*SP)
(AQ*AP)
10,000 board feet*1.80 per board foot 11,000 board feet*1.80 per board foot
18000 19,800
18,700
Materials Quantity Variance 1,800
Materials Price Variance 1,100 (19,800 - 18,700)
Spending Variance 700 UF
pf3
pf4
pf5
pf8
pf9
pfa

Partial preview of the text

Download Cost Variance Analysis for Mark Tristan Tuazon's BSA-III Project and more Study notes English in PDF only on Docsity!

Tuazon, Mark Tristan BSA - III Number of Chopping Boards ₱ 4,000. Number of board feet per Chopping Board 2. Standard Board feet Allowed ₱ 10,000.00 did not exceed the limit Standard cost per board foot 1. Total Standard Cost ₱ 18,000. Actual Cost incurred ₱ 18,700. Standard Cost ₱ 18,000. Spending Variance ₱ 700.00 Unfavorable Standard Quantity Allowed for Actual Quantity of Input, Actual Quantity of Input, Actual Output, at Stadard Price at Standard Price at Actual Price (SQSP) (AQSP) (AQAP) 10,000 board feet1.80 per board foot 11,000 board feet*1.80 per board foot 18000 19,800 18, Materials Quantity Variance 1, Materials Price Variance 1,100 (19,800 - 18,700) Spending Variance 700 UF

d not exceed the limit Actual Quantity of Input, at Actual Price (AQ*AP) 18,

Tuazon, Mark Tristan BSA - III Standard Direct Labor Cost: 4,400 units/4 = 1,100 units/hr 1,10012 = 13, Quantity Hrs. Price/Hr Amount Actual 1,190 11.9 14, Less: Standard 1,100 12 13, Variance: 90 UF -0.1 F 961 UF DL Variance: 1,19012 = 14, DL rate and efficiency variance: 1,19011.9 = 14, Labor Rate Variance (.101190 = 119 F) Labor Hours Variance (90*12 = 1080UF) 961 UF

Tuazon, Mark Tristan BSA - III Number of Discs prepared 20, Standard Direct Labor Hours per discs 0. Total Direct Labor Hours allowed 8, Standard Direct Labor cost per hour 6 Total Standard Direct Labor Cost 48, Actual Cost incurred 49, Total Standard Direct Labor Cost 48, Spending Variance 1,300 UF Standard Hours Allowed for Actual Hours of Input, Actual Hours of Input, Actual Output, at Stadard Rate at Standard Rate at Actual Rate (SHSR) (AHSR) (AHAR) 8000 hours6 per hour 8,500 hours6 per hour 8,500 hours5.8 per hour 48,000 51,000 49, Labor Hours Variance 3,000 500 UF * 6 = 3,000 UF Labor Rate Variance 1,700 .20F*8,500 = 1,700 F Spending Variance 1,300 UF Variable overhead efficiency variance = 4(8000-8,500) = -2, Actual variable overhead rate = 39,100/8,500 = 4. Variable overhead rate variance = 8,500(4-4.6) = -5,

Tuazon, Mark Tristan BSA - III Two-Way Variance Controllable Variance Actual Factory Overhead (39,000+29,000) Less: Budgeted Allowance based on STD. Hours Fixed OH (at normal capacity) (24,00015/60=6,0005) 30, Variable OH (Std. Hrs. * VOH Rate) (25,00015/60=6,2506) 37, Volume Variance Budgeted Allowance based on Std. Hrs. Less: Standard Factory Overhead (Std. Hrs.Std. Rate) (6,25011) Total Overhead Variance Three-Way Variance Spending Variance Actual Factory Overhead (39,000+29,000) Less: Budgeted Allowance on Actual Hours Fixed OH (at normal capacity) (24,00015/60=6,0005) 30, Variable OH (Actual Hrs.* VOH Rate) (6,4006) 38, Variable Efficiency Variance Budgeted Allowance on Actual Hours Less: Budgeted Allowance based on STD. Hours Fixed OH (at normal capacity) (24,00015/60=6,0005) 30, Variable OH (Std. Hrs. * VOH Rate) (25,00015/60=6,2506) 37, Volume Variance Budgeted Allowance based on STD. Hours Less: Standard Factory Overhead (Std. Hrs.Std. Rate) (6,25011) Total Overhead Variance Four-Way Variance (AGAMATA) Variable Spending Variance Actual Variable OH Less: Actual HoursVariable OH (6,400*6)

Fixed Spending Variance Actual Fixed OH Less: Budgeted Fixed OH (Normal CapacityFOH rate) (24,0001.25) Variable Efficiency Variance Budgeted Allowance on Actual Hours Less: Budgeted Allowance based on STD. Hours Fixed OH (at normal capacity) (24,00015/60=6,0005) 30, Variable OH (Std. Hrs. * VOH Rate) (25,00015/60=6,2506) 37, Volume Variance Budgeted Allowance based on STD. Hours Less: Standard Factory Overhead (Std. Hrs.Std. Rate) (6,25011) Total Overhead Variance

Variable OH (Actual Hrs.* VOH Rate) (6, ₱ 29,000. 30,000.00 Variable Efficiency Variance (1,000.00) F Budgeted Allowance on Actual Hours Less: Budgeted Allowance based on STD. Hours Fixed OH (at normal capacity) (24,00015/ 68,400.00 Variable OH (Std. Hrs. * VOH Rate) (25,000 67,500.00 Fixed Efficeincy Variance 900.00 UF Actual HoursFOH Rate (6,4005) Less: Standard HoursFOH Rate (6,2505) 67,500. 68,750.00 Idle Capacity Variance (1,250.00) F Normal Capacity Hrs.Fixed OR Rate (6,0005) (₱750.00) F Less: Actual HoursFOH Rate (6,4005) Total Overhead Variance

Actual Hours l capacity) (24,00015/60=6,0005) 30,