Activity$-$based costing for a service company

$\backslash$table$[[$Activity$,$Activity Rate$],[$Room and meals,$$177$ per day$],[$Radiology$,$$$250$ per image$],[$Pharmacy$,$$$48$ per physician order$],[$Chemistry lab,$$87$ per test$],[$Operating room,$$860$ per operating room hour$]]$

The activity usage information associated with the two patients is as follows:

$\backslash$table$[[,$Abel Putin,Cheryl Umit$],[$Number of days,$4$ days,$10$ days$],[$Number of images,$4$ images,$8$ images$],[$Number of physician orders,$5$ orders,$7$ orders$],[$Number of tests,$4$ tests,$7$ tests$],[$Number of operating room hours,$2\mathrm{.}5$ hours,$7$ hours$]]$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

a$.$ Determine the activity cost associated with each patient.

Abel Putin :

Cheryl Umit &

b$.$ Why is the total activity cost different for the two patients?

apparently had a different condition that required more extensive treatment. Thus, the activity cost to is more than the activity cost of the other patient.