| Job Cost Assignment |
| Group Variables |
| Group # | A | B | C | D | E | F | G | COGM with Adjustment | Net Income | Group Members |
| 1 | $2.40 | $1.60 | $7.90 | $13.00 | $12.00 | 70,330 | $172,000 | $ 108,181.20 | $ 63,448.32 | Sarah Edmonds, Melissa Smith, Mitchell Hart, Brittany Pehlke |
| 2 | $2.50 | $1.60 | $7.90 | $13.10 | $12.10 | 70,430 | $172,200 | $ 108,854.05 | $ 62,897.95 | Brandon Arnold, Christian Escobar. Alex Labonte-Miller |
| 3 | $2.60 | $1.60 | $7.90 | $13.20 | $12.20 | 70,530 | $172,400 | $ 109,578.40 | $ 62,371.81 | Firas Baidas, Khanna Betros |
| 4 | $2.40 | $1.40 | $8.00 | $13.40 | $12.40 | 70,630 | $171,000 | $ 108,659.78 | $ 63,328.44 | Jennifer Darling, Tareq Al-Shamali, Alicia Wideman |
| 5 | $2.50 | $1.40 | $8.00 | $13.50 | $12.50 | 70,730 | $171,200 | $ 109,401.84 | $ 62,804.50 | Yutian He, Yuwen Chen, Xinyue Zhang |
| 6 | $2.60 | $1.40 | $8.00 | $13.60 | $12.60 | 70,830 | $171,400 | $ 110,074.69 | $ 62,254.13 | Doowon Jung, Ao Leng, Manqi Zhang |
| 7 | $2.40 | $1.50 | $8.00 | $13.70 | $12.70 | 70,930 | $170,000 | $ 110,378.01 | $ 62,286.43 | Uyen Nguyen, Gahai Kim, Qianting He |
| 8 | $2.50 | $1.50 | $8.00 | $13.80 | $12.80 | 71,030 | $170,200 | $ 111,050.86 | $ 61,736.06 | Dylan Aubin, Emily Beharrell, Kyra MacLean |
| 9 | $2.60 | $1.50 | $8.00 | $13.90 | $12.90 | 71,130 | $170,400 | $ 111,775.21 | $ 61,209.92 | Eunyong Lee, Eunyong Jeong |
| 10 | $2.40 | $1.60 | $8.00 | $14.00 | $13.00 | 71,230 | $173,000 | $ 111,708.25 | $ 61,178.47 | Ricardo Barillas, Mahoud El Shawa, Zac McPhee |
| 11 | $2.50 | $1.60 | $8.00 | $13.00 | $12.00 | 71,330 | $173,200 | $ 108,416.15 | $ 62,765.88 | Yu Xin, Xiaoxin Jiang |
| 12 | $2.60 | $1.60 | $8.00 | $13.00 | $12.00 | 71,430 | $173,400 | $ 108,778.44 | $ 62,433.89 | Onaopemipo Yahya, Jyoti Sachdova |
| | | | | | | | | | |
| 13 | $2.40 | $1.40 | $7.90 | $13.00 | $12.00 | 71,480 | $171,800 | $ 106,699.91 | $ 64,197.79 | Theodoros Dejene, Jacob Heimpel, Harshkumar Mehta |
| 14 | $2.50 | $1.40 | $7.90 | $13.10 | $12.10 | 71,530 | $171,600 | $ 107,408.18 | $ 63,651.81 | Aneeta Habeeb, Danita Radlovic, Gayathri Kumar |
| 15 | $2.60 | $1.40 | $7.90 | $13.20 | $12.20 | 71,580 | $171,400 | $ 108,167.95 | $ 63,130.06 | Lori Prentice |
| 16 | $2.40 | $1.50 | $7.90 | $13.40 | $12.40 | 71,630 | $171,200 | $ 108,727.07 | $ 62,955.04 | |
| 17 | $2.50 | $1.50 | $7.90 | $13.50 | $12.50 | 71,680 | $171,000 | $ 109,486.84 | $ 62,433.29 |
| 18 | $2.60 | $1.50 | $7.90 | $13.60 | $12.60 | 71,730 | $170,800 | $ 110,195.11 | $ 61,887.31 |
profkents
ACCT3022-CostAssignVariablesS18.xlsx
