Principles of Management Accounting Excel Problems

At 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

P16A-17B

Drew time line for assembly department

Computed the equivalent units

Assigned total costs in the assembling department

Prepared T-account for WIP inventory

P16A-19B

Drew time line for preparation department

Computed the equivalent units

Compute total costs

Prepared journal entry to record costs of sheets

Posted journal entries to WIP inventory and calculated ending balance

P18-24A

Computed revenue and VC for each show

Computed number of shows BP must perform to break even

Computed number of shows needed to earn $3,825,000 profit

Prepared BP’s contribution margin income statement

P18-26A

Computed Big Time’s break even revenue in dollars

Computed dollar revenues needed to earn OI of $11,200

Graphed Big Time’s CVP relationships

Computed new BEP if average revenues increased to $900 per trade

Total: