#### Details of this Paper

##### Assignment 3: Excel Problems

Description

solution

Question

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

Paper#79418 | Written in 18-Jul-2015

Price : \$22