ACTG 2P21 S01 June 14 2010

ACTG 2P21 S01 June 14 2010 - ACTG 2P21 S01 June 14 2010 To...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
ACTG 2P21 S01 June 14 2010 To do the printing for the spreadsheet project, make 3 macros: Print Preparation, Print, then Work Preparation. Then Entry column doesn’t have to be identical, but the rest should be. Problem 8.48 from the textbook: (the second half, we did some last class). A B C D 1 A Q A P (Actual qty, actual price) A Q S P (actual qty, standard price) S Q S P (standard qty standard price) 2 VOH 80000DLH*3.13$/D LH 80000DLH*3$/D LH 76000 DLH* 3$/ DLH 3 $250 000 $240000 $228000 4 Variance 10 000 U 12 000U 5 FOH 100000 DLH* 4$/DLH 76000DLH*4$/D LH 6 $384000 $400000 $304000 7 Variance 16000F 96000U We get $3 in C2 by 1 unit is $6 and we need 2 DLH to make one unit. We get 76000 in D2 by 2$/DLH*38000 units actually produced We get the $4 in C5 by dividing 8$/DLH given by 2 The variances 10000 and 16000 are the buying variances. The 12000 and 96000 are spending variances (volume) Journal Entries: WIP Dept A 228000 WIP Dept A Spend Var 10000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
WIP Dept A Eff Var 12000 WIP MOH VOH
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

ACTG 2P21 S01 June 14 2010 - ACTG 2P21 S01 June 14 2010 To...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online