ACC 331 Module 4 Spreadsheet Exam Chapters 10-11

ACC 331 Module 4 Spreadsheet Exam Chapters 10-11 - 1....

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

View Full Document Right Arrow Icon
Color Key: Given information = Added information = Actual Activity level (in units)  290  Variable costs:    Indirect materials  $3,625     Power  $2,648  Total variable costs  $6,273  Fixed costs:    Supervision  $9,670     Depreciation  $4,210  Total Fixed costs  $13,880  TOTAL COSTS  $20,153  Static Budgeted   Activity Variance = Budget per unit (Flexible) - (Static) Activity level (in units)  280   10  F Variable costs:    Indirect materials  $3,780   $13.50   $135.00  U    Power  $2,576   $9.20   $92.00  U Total variable costs  $6,356   $22.70   $227.00  Fixed costs:    Supervision  $9,700   $34.64   $-    0    Depreciation  $4,200   $15.00   $-    0 Total Fixed costs  $13,900   $49.64   $-    0 TOTAL COSTS  $20,256   $72.34   $227.00  U 1. The following overhead data are for a department in a large company. Required: Prepare a report that would be useful in assessing how well costs were controlled
Background image of page 1

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

View Full Document Right Arrow Icon
Static Budget  280   $3,780   $2,576   $6,356   $9,700   $4,200   $13,900   $20,256  Flexible Unit Budget Variance* Variance Actual Actual per unit 290  290  $3,915  $(290) $(1.00) F  $3,625   $12.50  $2,668  $(20) $(0.07) F  $2,648   $9.13  $6,583  $(310) $(1.07) F  $6,273   $21.63  $9,700  $(30) $(0.10) F  $9,670   $33.34  $4,200  $10  $0.03 U  $4,210   $14.52 
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.

{[ snackBarMessage ]}

Page1 / 9

ACC 331 Module 4 Spreadsheet Exam Chapters 10-11 - 1....

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