Question
Perky Packers is a medium-sized shipping company that contracts it packing services to Un-Sun, an organic sunscreen company in which its products are warehoused in
Perky Packers is a medium-sized shipping company that contracts it packing services to Un-Sun, an organic sunscreen company in which its products are warehoused in a suburb of Orange, Florida. The shipping boxes are pre-filled with one to six containers of sunscreen. Perky's five employees seal each box, affix tape, and stick the shipping label on the face of the shipping box. Data from the company's payroll records and the number of boxes packed by employee are presented here.
| Total costs of jobs for January through June | ||||
| Job No. | Direct Materials | Direct Labor | Job Overhead Assigned | Number of Rooms Painted |
| 215 | $ 51,501 | $ 35,077 | $ 16,837 | 252 |
| 216 | 70,889 | 48,624 | 23,340 | 356 |
| 217 | 60,677 | 40,744 | 19,557 | 314 |
| 218 | 52,537 | 37,132 | 17,823 | 265 |
| 219 | 79,917 | 45,979 | 22,070 | 356 |
| 220 | 64,777 | 39,085 | 18,761 | 299 |
| 221 | 49,789 | 35,939 | 17,251 | 245 |
| 222 | 77,401 | 52,791 | 25,340 | 379 |
| 223 | 35,093 | 22,914 | 10,999 | 174 |
| 224 | 26,397 | 27,724 | 13,308 | 201 |
| 225 | 48,665 | 30,843 | 14,805 | 214 |
| 226 | 51,867 | 38,810 | 18,629 | 286 |
| 227 | 43,571 | 26,944 | 12,933 | 214 |
| 228 | 56,299 | 37,632 | 18,063 | 280 |
| 229 | 33,211 | 22,923 | 11,003 | 172 |
| 230 | 22,851 | 13,343 | 6,405 | 100 |
| 231 | 70,803 | 50,624 | 24,300 | 350 |
| 232 | 81,311 | 55,845 | 26,806 | 421 |
| 233 | 78,055 | 47,726 | 22,908 | 380 |
| 234 | 89,303 | 59,568 | 28,593 | 416 |
| 235 | 23,887 | 14,464 | 6,943 | 98 |
| 236 | 54,720 | 38,849 | 18,648 | 270 |
| 237 | 46,728 | 34,397 | 16,511 | 235 |
| 238 | 21,420 | 14,674 | 7,044 | 106 |
| 239 | 22,456 | 15,190 | 7,291 | 102 |
| 240 | 73,516 | 47,158 | 22,636 | 350 |
| 241 | 72,036 | 47,905 | 22,994 | 342 |
| 242 | 26,748 | 13,434 | 6,448 | 105 |
| 243 | 76,476 | 57,737 | 27,714 | 425 |
| 244 | 29,353 | 21,021 | 10,090 | 150 |
| 245 | 63,393 | 43,242 | 20,756 | 300 |
| 246 | 43,561 | 29,253 | 14,041 | 225 |
| 247 | 58,657 | 41,788 | 20,058 | 290 |
| 248 | 22,545 | 14,445 | 6,934 | 105 |
| 249 | 59,101 | 38,030 | 18,254 | 300 |
| 250 | 28,909 | 20,663 | 9,918 | 150 |
| 251 | 37,641 | 26,819 | 12,873 | 190 |
| 252 | 37,296 | 26,618 | 12,777 | 185 |
Complete the packing cost per box and the number of boxes packed per hour for each employee by week. (Round packing cost per box to 3 decimal places, e.g. 15.258 and boxes packed per hour to 1 decimal place, e.g. 15.2.)
| Week Ending | Employee | Packing Cost per Box | Boxes Packed Per Hour | |||
|---|---|---|---|---|---|---|
| 4/4 | 201 | |||||
| 4/11 | 201 | |||||
| 4/18 | 201 | |||||
| 4/25 | 201 | |||||
| 5/2 | 201 | |||||
| 5/9 | 201 | |||||
| 5/16 | 201 | |||||
| 5/23 | 201 | |||||
| 5/30 | 201 | |||||
| 4/4 | 202 | |||||
| 4/11 | 202 | |||||
| 4/18 | 202 | |||||
| 4/25 | 202 | |||||
| 5/2 | 202 | |||||
| 5/9 | 202 | |||||
| 5/16 | 202 | |||||
| 5/23 | 202 | |||||
| 5/30 | 202 | |||||
| 4/4 | 204 | |||||
| 4/11 | 204 | |||||
| 4/18 | 204 | |||||
| 4/25 | 204 | |||||
| 5/2 | 204 | |||||
| 5/9 | 204 | |||||
| 5/16 | 204 | |||||
| 5/23 | 204 | |||||
| 5/30 | 204 | |||||
| 4/4 | 205 | |||||
| 4/11 | 205 | |||||
| 4/18 | 205 | |||||
| 4/25 | 205 | |||||
| 5/2 | 205 | |||||
| 5/9 | 205 | |||||
| 5/16 | 205 | |||||
| 5/23 | 205 | |||||
| 5/30 | 205 | |||||
| 4/4 | 206 | |||||
| 4/11 | 206 | |||||
| 4/18 | 206 | |||||
| 4/25 | 206 | |||||
| 5/2 | 206 | |||||
| 5/9 | 206 |
|
| |||
| 5/16 | 206 |
|
| |||
| 5/23 | 206 | |||||
| 5/30 | 206 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started