Assignment 3: excel problems | Business & Finance homework help

Reading – http://vizedhtmlcontent.next.ecollege.com/(NEXT(ea3dfc0c7f))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=733626339&courseItemType=CourseContentItem&#

 

Don't use plagiarized sources. Get Your Custom Essay on
Assignment 3: excel problems | Business & Finance homework help
Just from $13/Page
Order Essay

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, October 14, 2015 deliver your assignment to the M2: Assignment 3 Dropbox.

 

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

 

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper