please help solving this tamplet

please help solving this tamplet

ATTACHMENT PREVIEW

Download attachment

AP = Actual Price
SP=Standard Price
AQ=Actual Quantity
SQ=Standard Quantity
Granite
Standard
Granite per Square Foot
$50.00 SP
Average Number of Sq Ft Installed
32.00
Number of Jobs Completed
50.00
Total for Jobs Completed Number of Sq Ft at Standard
SQ
Actual Sq Ft Granite Purchased and Used
1,640.00 AQ
Actual Amount Paid for the Granite Purchased and Used
79,048.00
Actual Price Paid per Sq ft
(AP-SP)*AQ
(AQ-SQ)*SP
Material
Actual
Flexible
Standard
AP
AQ
SP
AQ
SP
SQ
Material Price Variance
Material Quantity Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable
Total Material Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable
Glue
Standard
Glue per oz
$0.15 SP
Number of oz per Sq ft
10.00
Standard Cost per unit
Average Number of Sq Ft Installed
32.00
Number of Jobs Completed
50.00
Total for Jobs Completed Standard
SQ
Actual oz Purchased and Used
16,000.00 AQ
Actual Amount Paid for the Glue Purchased and Used
Actual Price Paid per Sq ft
(AP-SP)*AQ
(AQ-SQ)*SP
Material
Actual
Flexible
Standard
AP
AQ
SP
AQ
SP
SQ
Material Price Variance
Material Quantity Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable
Total Material Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable
Cutting
Standard
Cutting Labor per Hr
$15.00 SR
Number of Hrs per Sq ft
0.10
Standard Cost per unit
Average Number of Sq Ft Installed
32.00
Number of Jobs Completed
50.00
Total for Jobs Completed Standard
SH
Actual Cutting Hours
180.00 AH
Actual Labor Rate
$15.00 AR
Total Actual Labor Costs
(AR-SR)*AH
(AH-SH)*SR
Labor
Actual
Flexible
Standard
AR
AH
SR
AH
SR
SH
Labor Rate Variance
Labor Efficiency Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable
Total Labor Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable
Installation
Standard
Installation Labor per Hr
$25.00 SR
Number of Hrs per Sq ft
0.25
Standard Cost per unit
Average Number of Sq Ft Installed
32.00
Number of Jobs Completed
50.00
Total for Jobs Completed Standard
SH
Actual Installation Hours
390.00 AH
Actual Labor Rate
$25.00 AR
Total Actual Labor Costs
(AR-SR)*AH
(AH-SH)*SR
Labor
Actual
Flexible
Standard
AR
AH
SR
AH
SR
SH
Labor Rate Variance
Labor Efficiency Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable
Total Labor Variance
Indicate in the Green Cell either F for Favorable or U for Unfavorable

Leave a Comment