# assignment 3 excel problems 5

Assignment 3: 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.

By Wednesday, September 3, 2014 deliver your assignment to the M2: Assignment 3 Dropbox.

Create the file with the following name: LastnameFirstInitial_M2A3.Excel.xls.

 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