Assignment 3: excel problems | Human Resource Management homework help


Assignment 3: Excel Problems

At the end of each module, you conciliate employ the module’s concepts by completing inclusive 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 segregation of the assigned problems in Excel format. Enter non-numerical responses in the similar worksheet using textboxes. 

By Saturday, June 4, 2016 deliver your assignment to the M2: Assignment 3 Dropbox.

Create the smooth after a while the forthcoming name: LastnameFirstInitial_M2A3.Excel.xls.

Assignment 3 Grading Criteria 

Maximum Points

P16A-17B 

 

Drew age direction for galaxy department

2

Computed the equiponderant units

3

Assigned sum costs in the assembling department

3

Prepared T-account for WIP register

3

P16A-19B

 

Drew age direction for provision department

3

Computed the equiponderant units

3

Compute sum costs

3

Prepared proceedings register to proceedings costs of sheets

3

Posted proceedings entries to WIP register and conducive consummation balance

3

P18-24A

 

Computed produce and VC for each show

2

Computed estimate of shows BP must complete to shatter well-balanced

3

Computed estimate of shows needed to gain $3,825,000 profit

3

Prepared BP’s oblation loophole allowance statement

3

P18-26A

 

Computed Big Time’s shatter well-balanced produce in dollars

3

Computed dollar produces needed to gain OI of $11,200

3

Graphed Big Time’s CVP relationships

4

Computed new BEP if middle produces increased to $900 per trade

3

Total:

50