excel 2
mocy20
m2_excel_problems.docxAt the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook.
Complete problems P16A-17B (p. 898), P16A-19B (p. 899), P18-24A (p. 979), P18-26A (p. 980) in your textbook.
Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.
|
Assignment 3 Grading Criteria |
Maximum Points |
|
P16A-17B |
|
|
Drew time line for assembly department |
2 |
|
Computed the equivalent units |
3 |
|
Assigned total costs in the assembling department |
3 |
|
Prepared T-account for WIP inventory |
3 |
|
P16A-19B |
|
|
Drew time line for preparation department |
3 |
|
Computed the equivalent units |
3 |
|
Compute total costs |
3 |
|
Prepared journal entry to record costs of sheets |
3 |
|
Posted journal entries to WIP inventory and calculated ending balance |
3 |
|
P18-24A |
|
|
Computed revenue and VC for each show |
2 |
|
Computed number of shows BP must perform to break even |
3 |
|
Computed number of shows needed to earn $3,825,000 profit |
3 |
|
Prepared BP’s contribution margin income statement |
3 |
|
P18-26A |
|
|
Computed Big Time’s break even revenue in dollars |
3 |
|
Computed dollar revenues needed to earn OI of $11,200 |
3 |
|
Graphed Big Time’s CVP relationships |
4 |
|
Computed new BEP if average revenues increased to $900 per trade |
3 |
|
Total: |
50 |
