A B D H M N 43 FRT-LON Longan 1.85 1.1 6.716 15.320 2.78 44 FRT-LYE 45 FRT-MAG 46 FRT-MAR 47 FRT-MEO 48 FRT-MII Lychee 2.01 1.25 12.424 59.724 8.12 Mango 2.31 1.47 27.489 271.317 7.76 Marionberry 0.95 0.61 6.960 60.085 Melon 1.94 1.2 46.597 597.573 1.74 45.63 Miracle fruit 2.05 1.2 6.787 26.463 4.66 49 FRT-MUR Mulberry 0.66 0.44 5.064 14.294 3.41 50 FRT-NAC 51 FRT-NEN 52 FRT-OLV 53 FRT-ORG 54 FRT-PAI 55 FRT-PAY 56 FRT-PEA 57 FRT-PEC 58 FRT-PEO 59 FRT-PHI 60 FRT-PIL 61 FRT-PLI 62 FRT-PLM Nance Nectarine Pear Peach Persimmon Physalis Pineapple Plantain 1.18 0.72 6.567 21.162 5.56 1.47 0.96 41.793 333.323 2.8 Olive 1.54 0.95 31.347 167.586 25.15 Orange 0.75 0.49 101.049 1728.040 7.85 Passionfruit 0.94 0.61 16.507 79.661 16.28 Papaya 1.06 0.63 51.929 558.626 33.89 1.83 1.07 35.954 270.328 15.69 1.15 0.71 30.369 254.474 3.3 1.99 1.23 6.875 23.112 5.83 1.82 1.12 6.992 34.613 2.68 0.77 0.46 50.292 601.002 5.63 2.06 1.24 16.516 127.713 12.45 PlumPrune (dried plum) 1.31 0.77 12.836 57.883 3.68 63 FRT-PLT 64 FRT-POL 65 FRT-POT Plumcot (or Pluot) 2.1 1.24 6.232 14.238 2.94 Pomelo 2.37 1.54 6.185 22.121 3.09 Pomegranate 0.65 0.42 6.999 21.163 2.63 66 FRT-PUE Purple mangosteen 1.01 0.59 7.530 22.256 5.35 0.75 40.54054 37.94665 0.76 37.81095 37.88015 0.84 36.36364 37.88197 0.34 35.78947 37.923 0.74 38.14433 37.98227 0.85 41.46341 37.97764 0.22 33.33333 37.87511 0.46 38.98305 38.01274 0.51 34.69388 37.98242 0.59 38.31169 38.0885 0.26 34.66667 38.08106 0.33 35.10638 38.1988 0.43 40.56604 38.30924 0.76 41.53005 38.22566 0.44 38.26087 38.09857 0.76 38.19095 38.09208 0.7 38.46154 38.08796 0.31 40.25974 38.07171 0.82 39.80583 37.97226 0.54 41.22137 37.88494 0.86 40.95238 37.71812 0.83 35.0211 37.5479 0.23 35.38462 37.68828 0.42 41.58416 37.82379 67 FRT-QUC 68 FRT-RAA 69 FRT-RAR 70 FRT-REN 71 FRT-SAA 72 FRT-SAM 73 FRT-SAR 74 FRT-SOO 75 FRT-SOS 76 FRT-STI 77 FRT-STR 78 FRT-SUL 79 FRT-TAL 80 FRT-TAN Quince Rambutan Raspberry Redcurrant Salak Satsuma Star fruit Strawberry Sugar apple Tamarillo 1.03 0.63 8.650 16.356 5.83 2.3 1.52 5.062 16.727 1.78 1.14 0.7 15.175 93.100 11.05 1.42 0.85 5.194 14.770 1.19 0.81 0.5 6.517 8.345 4.78 0.4 38.83495 37.58876 0.78 33.91304 37.50568 0.44 38.59649 37.7623 0.57 40.14085 37.69813 0.31 38.2716 37.49457 0.69 0.44 6.154 15.031 3.85 Salal berry 1.12 0.66 6.208 15.252 1.78 Soursop 2.4 1.46 6.764 12.871 3.33 Solanum quitoense 0.94 0.59 6.711 23.330 1.88 2.5 1.57 9.163 25.534 4.45 0.93 0.8 0.52 23.011 200.498 12.26 0.28 1.01 0.62 5.537 27.262 4.03 0.77 0.51 10.796 48.262 1.45 Tamarind 2.19 1.38 10.833 53.939 0.72 81 FRT-UGI Ugli fruit 1.12 0.69 7.669 27.868 2.86 82 FRT-YUZ Yuzu 1.5 0.93 6.326 24.018 0.05 0.25 36.23188 37.42393 0.46 41.07143 37.54314 0.94 39.16667 37.15111 0.35 37.23404 36.89916 37.2 36.85132 35 36.79321 0.39 38.61386 37.15185 0.26 33.76623 36.78635 0.81 36.9863 37.79305 0.43 38.39286 38.19643 0.57 38 38 83 L SKU A 2 FRT-APL B C Description E Sales Price per Pound Cost per pound Average Inventory D F G H | J K L Cost of Goods Sold Waste/Loss Apple FRT-APO FRT-AVD Apricot Avocado نہ نے 1.7 1.09 51.067 908.792 42.91 2.8 1.76 30.631 298.030 10.15 0.61 35.88235 37.95282 1.04 37.14286 37.9787 1 0.59 20.054 288.724 5.74 0.41 41 37.98928 FRT-BAN Banana 0.5 0.31 100.417 2216.854 77.6 0.19 38 37.95068 FRT-BIT Bilberty 2 1.17 6.856 46.849 3.46 0.83 41.5 37.95004 FRT-BLB 0 FRT-BOR 3 FRT-BLN FRT-BLR Blackberry Blackcurrent Blueberry Boysenberry 2 1.29 5.105 34.771 4.49 0.71 35.5 37.90333 2 1.18 6.640 37.004 5.13 0.82 41 37.93537 1.75 1.07 16.523 94.967 12.06 1 0.62 5.157 23.038 3.09 0.68 38.85714 37.89396 0.38 38 37.88076 1 FRT-CHI Chico fruit 1.75 1.03 6.123 15.144 4.73 2 FRT-CHR Cherry 2.5 1.56 15.259 124.159 11.96 3 FRT-CHY Cherimoya 1.75 1.11 5.686 21.470 1.62 4 FRT-CLR Cloudberry 1.75 1.09 5.628 31.837 1.64 5 FRT-COU Coconut 2.41 1.54 10.734 52.737 2.38 6 FRT-CRR Cranberry 1.01 0.61 11.120 56.754 8.67 7 FRT-CUE Cucumber 1.82 1.09 30.120 476.298 27 8 FRT-CUN 9 FRT-DAO Currant 1.75 1.04 6.168 20.296 2.15 Damson 2.04 1.34 6.563 25.455 4.98 0 FRT-DAT 1 FRT-DRI Date 0.83 0.54 6.953 15.223 6.78 Dragonfruit 1.63 0.98 6.393 37.169 5.59 2 FRT-DUA Durian 2.17 1.32 5.314 20.014 2.74 3 FRT-ELR Elderberry 2.41 1.52 5.202 10.614 4.61 4 FRT-FEO Feijoa 1.98 1.3 6.073 14.156 2.53 5 FRT-FII Fig 2.41 1.55 6.387 20.202 2.25 6 FRT-GOR Goji berry 1.18 0.74 6.170 17.065 3.39 7 FRT-GOR Gooseberry 1.82 1.19 6.962 15.223 6.01 8 FRT-GRI GrapeRaisin 1.25 0.74 6.041 13.193 3.48 9 FRT-GRI Grapefruit 0.98 0.65 41.012 419.601 5.31 0 FRT-GUV 1 FRT-HOR Guava 0.94 0.56 18.152 146.384 0.81 Honeyberry 0.94 0.59 7.947 56.265 3.28 0.72 41.14286 37.87911 0.94 37.6 37.83314 0.64 36.57143 37.83647 0.66 37.71429 37.8548 0.87 36.09959 37.85687 0.4 39.60396 37.8831 0.73 40.10989 37.85702 0.71 40.57143 37.82236 0.7 34.31373 37.77941 0.29 34.93976 37.83442 0.65 39.8773 37.88111 0.85 39.17051 37.84838 0.89 36.92946 37.82635 0.68 34.34343 37.84155 0.86 35.68465 37.90186 0.44 37.28814 37.94076 0.63 34.61538 37.95242 0.51 40.8 38.01309 0.33 33.67347 37.96148 0.38 40.42553 38.04239 0.35 37.23404 37.99656 2 FRT-HUR Huckleberry 0.96 0.63 6.831 20.691 1.71 3 FRT-JAB 4 FRT-JAI 5 FRT-JAU Jabuticaba 0.89 0.52 7.347 16.049 2.62 Jackfruit 0.63 0.37 5.018 6.515 1.01 Jambul 1.95 1.13 7.600 16.238 1.7 6 FRT-JUB Jujube 1.49 0.95 5.235 13.739 4.19 7 FRT-JUR Juniper berry 1.3 0.86 6.191 17.549 3.12 8 FRT-KII Kiwifruit 2.32 1.37 6.884 51.539 3.82 9 FRT-KUA Kumquat 0.71 0.45 6.082 14.461 2.2 0 FRT-LEO 1 FRT-LIM 2 FRT-LOA Lemon Lime 2.46 1.48 30.278 298.064 27.69 0.96 0.57 35.645 320.716 15.24 0.39 Loquat 0.57 0.38 21.992 83.550 10.97 0.33 34.375 38.01151 0.37 41.57303 38.08424 0.26 41.26984 38.01304 0.82 42.05128 37.94519 0.54 36.24161 37.85782 0.44 33.84615 37.89296 0.95 40.94828 37.98289 0.26 36.61972 37.91549 0.98 39.8374 37.94563 40.625 37.90058 0.19 33.33333 37.83413

A B D H M N 43 FRT-LON Longan 1.85 1.1 6.716 15.320 2.78 44 FRT-LYE 45 FRT-MAG 46 FRT-MAR 47 FRT-MEO 48 FRT-MII Lychee 2.01 1.25 12.424 59.724 8.12 Mango 2.31 1.47 27.489 271.317 7.76 Marionberry 0.95 0.61 6.960 60.085 Melon 1.94 1.2 46.597 597.573 1.74 45.63 Miracle fruit 2.05 1.2 6.787 26.463 4.66 49 FRT-MUR Mulberry 0.66 0.44 5.064 14.294 3.41 50 FRT-NAC 51 FRT-NEN 52 FRT-OLV 53 FRT-ORG 54 FRT-PAI 55 FRT-PAY 56 FRT-PEA 57 FRT-PEC 58 FRT-PEO 59 FRT-PHI 60 FRT-PIL 61 FRT-PLI 62 FRT-PLM Nance Nectarine Pear Peach Persimmon Physalis Pineapple Plantain 1.18 0.72 6.567 21.162 5.56 1.47 0.96 41.793 333.323 2.8 Olive 1.54 0.95 31.347 167.586 25.15 Orange 0.75 0.49 101.049 1728.040 7.85 Passionfruit 0.94 0.61 16.507 79.661 16.28 Papaya 1.06 0.63 51.929 558.626 33.89 1.83 1.07 35.954 270.328 15.69 1.15 0.71 30.369 254.474 3.3 1.99 1.23 6.875 23.112 5.83 1.82 1.12 6.992 34.613 2.68 0.77 0.46 50.292 601.002 5.63 2.06 1.24 16.516 127.713 12.45 PlumPrune (dried plum) 1.31 0.77 12.836 57.883 3.68 63 FRT-PLT 64 FRT-POL 65 FRT-POT Plumcot (or Pluot) 2.1 1.24 6.232 14.238 2.94 Pomelo 2.37 1.54 6.185 22.121 3.09 Pomegranate 0.65 0.42 6.999 21.163 2.63 66 FRT-PUE Purple mangosteen 1.01 0.59 7.530 22.256 5.35 0.75 40.54054 37.94665 0.76 37.81095 37.88015 0.84 36.36364 37.88197 0.34 35.78947 37.923 0.74 38.14433 37.98227 0.85 41.46341 37.97764 0.22 33.33333 37.87511 0.46 38.98305 38.01274 0.51 34.69388 37.98242 0.59 38.31169 38.0885 0.26 34.66667 38.08106 0.33 35.10638 38.1988 0.43 40.56604 38.30924 0.76 41.53005 38.22566 0.44 38.26087 38.09857 0.76 38.19095 38.09208 0.7 38.46154 38.08796 0.31 40.25974 38.07171 0.82 39.80583 37.97226 0.54 41.22137 37.88494 0.86 40.95238 37.71812 0.83 35.0211 37.5479 0.23 35.38462 37.68828 0.42 41.58416 37.82379 67 FRT-QUC 68 FRT-RAA 69 FRT-RAR 70 FRT-REN 71 FRT-SAA 72 FRT-SAM 73 FRT-SAR 74 FRT-SOO 75 FRT-SOS 76 FRT-STI 77 FRT-STR 78 FRT-SUL 79 FRT-TAL 80 FRT-TAN Quince Rambutan Raspberry Redcurrant Salak Satsuma Star fruit Strawberry Sugar apple Tamarillo 1.03 0.63 8.650 16.356 5.83 2.3 1.52 5.062 16.727 1.78 1.14 0.7 15.175 93.100 11.05 1.42 0.85 5.194 14.770 1.19 0.81 0.5 6.517 8.345 4.78 0.4 38.83495 37.58876 0.78 33.91304 37.50568 0.44 38.59649 37.7623 0.57 40.14085 37.69813 0.31 38.2716 37.49457 0.69 0.44 6.154 15.031 3.85 Salal berry 1.12 0.66 6.208 15.252 1.78 Soursop 2.4 1.46 6.764 12.871 3.33 Solanum quitoense 0.94 0.59 6.711 23.330 1.88 2.5 1.57 9.163 25.534 4.45 0.93 0.8 0.52 23.011 200.498 12.26 0.28 1.01 0.62 5.537 27.262 4.03 0.77 0.51 10.796 48.262 1.45 Tamarind 2.19 1.38 10.833 53.939 0.72 81 FRT-UGI Ugli fruit 1.12 0.69 7.669 27.868 2.86 82 FRT-YUZ Yuzu 1.5 0.93 6.326 24.018 0.05 0.25 36.23188 37.42393 0.46 41.07143 37.54314 0.94 39.16667 37.15111 0.35 37.23404 36.89916 37.2 36.85132 35 36.79321 0.39 38.61386 37.15185 0.26 33.76623 36.78635 0.81 36.9863 37.79305 0.43 38.39286 38.19643 0.57 38 38 83 L SKU A 2 FRT-APL B C Description E Sales Price per Pound Cost per pound Average Inventory D F G H | J K L Cost of Goods Sold Waste/Loss Apple FRT-APO FRT-AVD Apricot Avocado نہ نے 1.7 1.09 51.067 908.792 42.91 2.8 1.76 30.631 298.030 10.15 0.61 35.88235 37.95282 1.04 37.14286 37.9787 1 0.59 20.054 288.724 5.74 0.41 41 37.98928 FRT-BAN Banana 0.5 0.31 100.417 2216.854 77.6 0.19 38 37.95068 FRT-BIT Bilberty 2 1.17 6.856 46.849 3.46 0.83 41.5 37.95004 FRT-BLB 0 FRT-BOR 3 FRT-BLN FRT-BLR Blackberry Blackcurrent Blueberry Boysenberry 2 1.29 5.105 34.771 4.49 0.71 35.5 37.90333 2 1.18 6.640 37.004 5.13 0.82 41 37.93537 1.75 1.07 16.523 94.967 12.06 1 0.62 5.157 23.038 3.09 0.68 38.85714 37.89396 0.38 38 37.88076 1 FRT-CHI Chico fruit 1.75 1.03 6.123 15.144 4.73 2 FRT-CHR Cherry 2.5 1.56 15.259 124.159 11.96 3 FRT-CHY Cherimoya 1.75 1.11 5.686 21.470 1.62 4 FRT-CLR Cloudberry 1.75 1.09 5.628 31.837 1.64 5 FRT-COU Coconut 2.41 1.54 10.734 52.737 2.38 6 FRT-CRR Cranberry 1.01 0.61 11.120 56.754 8.67 7 FRT-CUE Cucumber 1.82 1.09 30.120 476.298 27 8 FRT-CUN 9 FRT-DAO Currant 1.75 1.04 6.168 20.296 2.15 Damson 2.04 1.34 6.563 25.455 4.98 0 FRT-DAT 1 FRT-DRI Date 0.83 0.54 6.953 15.223 6.78 Dragonfruit 1.63 0.98 6.393 37.169 5.59 2 FRT-DUA Durian 2.17 1.32 5.314 20.014 2.74 3 FRT-ELR Elderberry 2.41 1.52 5.202 10.614 4.61 4 FRT-FEO Feijoa 1.98 1.3 6.073 14.156 2.53 5 FRT-FII Fig 2.41 1.55 6.387 20.202 2.25 6 FRT-GOR Goji berry 1.18 0.74 6.170 17.065 3.39 7 FRT-GOR Gooseberry 1.82 1.19 6.962 15.223 6.01 8 FRT-GRI GrapeRaisin 1.25 0.74 6.041 13.193 3.48 9 FRT-GRI Grapefruit 0.98 0.65 41.012 419.601 5.31 0 FRT-GUV 1 FRT-HOR Guava 0.94 0.56 18.152 146.384 0.81 Honeyberry 0.94 0.59 7.947 56.265 3.28 0.72 41.14286 37.87911 0.94 37.6 37.83314 0.64 36.57143 37.83647 0.66 37.71429 37.8548 0.87 36.09959 37.85687 0.4 39.60396 37.8831 0.73 40.10989 37.85702 0.71 40.57143 37.82236 0.7 34.31373 37.77941 0.29 34.93976 37.83442 0.65 39.8773 37.88111 0.85 39.17051 37.84838 0.89 36.92946 37.82635 0.68 34.34343 37.84155 0.86 35.68465 37.90186 0.44 37.28814 37.94076 0.63 34.61538 37.95242 0.51 40.8 38.01309 0.33 33.67347 37.96148 0.38 40.42553 38.04239 0.35 37.23404 37.99656 2 FRT-HUR Huckleberry 0.96 0.63 6.831 20.691 1.71 3 FRT-JAB 4 FRT-JAI 5 FRT-JAU Jabuticaba 0.89 0.52 7.347 16.049 2.62 Jackfruit 0.63 0.37 5.018 6.515 1.01 Jambul 1.95 1.13 7.600 16.238 1.7 6 FRT-JUB Jujube 1.49 0.95 5.235 13.739 4.19 7 FRT-JUR Juniper berry 1.3 0.86 6.191 17.549 3.12 8 FRT-KII Kiwifruit 2.32 1.37 6.884 51.539 3.82 9 FRT-KUA Kumquat 0.71 0.45 6.082 14.461 2.2 0 FRT-LEO 1 FRT-LIM 2 FRT-LOA Lemon Lime 2.46 1.48 30.278 298.064 27.69 0.96 0.57 35.645 320.716 15.24 0.39 Loquat 0.57 0.38 21.992 83.550 10.97 0.33 34.375 38.01151 0.37 41.57303 38.08424 0.26 41.26984 38.01304 0.82 42.05128 37.94519 0.54 36.24161 37.85782 0.44 33.84615 37.89296 0.95 40.94828 37.98289 0.26 36.61972 37.91549 0.98 39.8374 37.94563 40.625 37.90058 0.19 33.33333 37.83413

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter5: Operating Activities: Purchases And Cash Payments

Section: Chapter Questions

Problem 2.1C

See similar textbooks