VJOB Order Costing
cybacatx
job_order_costing.xlsSheet1
| JOB Order Costing and Relative Value Units | ||||
| U2 Reference Lab must calculate the relative value and cost per procedure given that | ||||
| the total lab expense is $943,241: | ||||
| Projected | ||||
| Procedure | Volume | Lab Expense | ||
| A | 3500 | 0.15 | ||
| B | 2200 | 0.20 | ||
| C | 4300 | 0.10 | ||
| D | 2900 | 0.05 | ||
| E | 2700 | 0.15 | ||
| F | 3550 | 0.25 | ||
| G | 2000 | 0.10 | ||
| Part 1: Calculate the Relative Value Units | ||||
| Procedure | ||||
| A | ||||
| B | ||||
| C | ||||
| D | ||||
| E | ||||
| F | ||||
| G | ||||
| Part 2: Calculate total Relative Value Units | ||||
| Procedure | ||||
| A | ||||
| B | ||||
| C | ||||
| D | ||||
| E | ||||
| F | ||||
| G | ||||
| Part 3: Calculate the cost per procedure | ||||
| Procedure | ||||
| A | ||||
| B | ||||
| C | ||||
| D | ||||
| E | ||||
| F | ||||
| G |
