Section III: Benchmarking

The management of the Hampshire Company would like to implement benchmarking. Standard costs have been established and are presented below. You will want to complete a variance analysis to include efficiency and price variances for materials (cloth and handle assemblies) and labor based on the following data:

Units Produced = 80,000

Units Sold = 60,000

Direct Materials Purchased and Used

Actual square yards of cloth purchased and used: 128,000

Actual price incurred per yard: $1.25

Actual handles purchased and used: 80,808

Actual price per handle/rib/stretcher assembly: $0.99

Direct Manufacturing Labor Used

Actual direct labor hours used: 15,748

Actual price per hour: $7.62

Direct labor costs: $120,000

Standard Rates

Standard labor hours per unit: 0.20

Standard labor price per hour: $7.50

Square yards material per unit: 1.50

Standard price per yard: $1.15

Handle/rib/stretcher assembly per unit: 1

Standard price per handle assembly: $1.05

Companies can use variance analysis and benchmarking to measure performance within their own company and against competitors. This can be done by setting standards/budgets and comparing a completed variance analysis to results from prior periods or comparing them to competitors results. Using the information provided above, complete the following calculations (steps 1 and 2) in the Hampshire Company Spreadsheet. This will assist you in responding to all components of Section III.

Calculate price variances for material and labor and denote whether they are favorable or unfavorable.

Calculate efficiency variances for material and labor and denote whether they are favorable or unfavorable.

Hello based off of this data what numbers would I plug into the following? I think the first part is correct my main question is are the numbers for the "standard" in the second part correct? I dont know where they came from? Also where it says favorable unfavorable could someome please explain why that isnt reversed? I though the cheaper price would be favorable?

Requirement 1
Price Variances:
(Actual Price Standard Price) X Actual Quantity
	actual	minus standard		times actual quanity= variance
	Actual	Standard	Actual Quantity	Variance	Favorable or Unfavorable
Cloth	$1.25	$1.15	128,000	$12,800	Unfav
Handle Assembly	$0.99	$1.05	80,808	-$4,848	Fav
Labor Price Variance	$7.62	$7.50	15,748	$1,890	unfav
Requirement 2
Efficiency Variances:
(Actual Quantity of Input Used Standard Quantity of Input Allowed for Actual Output) X Budgeted Price of Input
	Actual	Standard	Standard Price	Variance	Favorable or Unfavorable
Cloth	128,000	120,000	$1.15	$9,200	Unfav
(1.5 Yards per Unit)
Handle Assembly	80,808	80,000	$1.05	$848	unfav
(1 per Unit)
Labor	15,478	16,000	$7.50	-$3,915 fac