MS Excel The spreadsheet
jonathan06
excel_assessment_data.xlsxInventory
| Common Name | Scientific Name | Waters of Origin | Cost per Unit | Amount on Hand | Value of Inventory | Sales Tax | Tariff | Total Value of Inventory |
| Alphabet Cone | Conus bullatus | Southern Mexico | $55.00 | 27 | $1,485.00 | $89.10 | 0.08 | $3,148.28 |
| Angular Volute | Volute angulata | Brazil | $55.00 | 33 | $1,815.00 | $108.90 | 0.08 | $3,847.88 |
| Aulicus Cone | Conus aulicus | Indo-Pacific | $20.00 | 6 | $120.00 | $7.20 | 0.08 | $254.48 |
| Bat Volute | Volute vespertilio | Australia | $85.00 | 10 | $850.00 | $51.00 | 0.05 | $1,802.05 |
| Brown Paper Nautilius | Argonauta hians | World wide in warm seas | $85.00 | 16 | $1,360.00 | $81.60 | 0.07 | $2,883.27 |
| Cabrit's Murex | Murex cabriti | Florida and the Caribbean | $250.00 | 5 | $1,250.00 | $75.00 | 0.05 | $2,650.05 |
| Chambered Nautilus | Nautilius pompilius | Western Pacific | $25.00 | 44 | $1,100.00 | $66.00 | 0.08 | $2,332.08 |
| Comb of Venus | Murex pecten | Indo-Pacific | $25.00 | 25 | $625.00 | $37.50 | 0.08 | $1,325.08 |
| Court Volute | Aulicia aulicia | Phillipines | $35.00 | 84 | $2,940.00 | $176.40 | 0.05 | $6,232.85 |
| Decipiens Cowrie | Cypraea decipiens | Australia | $75.00 | 18 | $1,350.00 | $81.00 | 0.05 | $2,862.05 |
| Emperor's Slit Shell | Pleurotomaria hirasei | Japan | $15.00 | 10 | $150.00 | $9.00 | 0.09 | $318.09 |
| Endive Murex | Murex territus | Australia | $125.00 | 3 | $375.00 | $22.50 | 0.05 | $795.05 |
| Eyed Cowrie | Cypraea argus | Indo-Pacific | $15.00 | 47 | $705.00 | $42.30 | 0.08 | $1,494.68 |
| Fulton's Cowrie | Cypraea fultoni | South Africa | $23.00 | 7 | $161.00 | $9.66 | 0.08 | $341.40 |
| Golden Cowrie | Cypraea aurantium | Solomon Islands | $275.00 | 3 | $825.00 | $49.50 | 0.08 | $1,749.08 |
| Green Abalone | Haliotis fulgens | California | $13.00 | 19 | $247.00 | $14.82 | 0.09 | $523.73 |
| Heart Cockle | Corculum cardissa | Indo-Pacific | $25.00 | 19 | $475.00 | $28.50 | 0.08 | $1,007.08 |
| Imperial Delphinula | Angaria melanacantha | Phillipines | $25.00 | 22 | $550.00 | $33.00 | 0.05 | $1,166.05 |
| Japanese Carrier Shell | Xenophora palliduls | Japan | $35.00 | 44 | $1,540.00 | $92.40 | 0.09 | $3,264.89 |
| Lazarus Jewel Box | Chamas lazarus | Indo-Pacific | $100.00 | 6 | $600.00 | $36.00 | 0.08 | $1,272.08 |
| Leafy Purpura | Pterorytis foliata | West Coast of North America | $68.00 | 23 | $1,564.00 | $93.84 | 0.09 | $3,315.77 |
| Lightning Volute | Ericusa fulgetrum | Australia | $40.00 | 84 | $3,360.00 | $201.60 | 0.05 | $7,123.25 |
| Lobeck's Murex | Murex lobeckii | Japan | $23.00 | 5 | $115.00 | $6.90 | 0.09 | $243.89 |
| Marble Cone | Conus marmoreus | Phillipines | $15.00 | 44 | $660.00 | $39.60 | 0.05 | $1,399.25 |
| Paper Nautilius | Argonauta nodosa | World wide in warm seas | $75.00 | 74 | $5,550.00 | $333.00 | 0.07 | $11,766.07 |
| Queen Tegula | Tegula regina | California | $90.00 | 6 | $540.00 | $32.40 | 0.09 | $1,144.89 |
| Red Abalone | Haliotis rufescens | California | $17.00 | 15 | $255.00 | $15.30 | 0.09 | $540.69 |
| Rose-branch Murex | Murex palmarosae | Indo-Pacific | $18.00 | 55 | $990.00 | $59.40 | 0.08 | $2,098.88 |
| Rosy Cardita | Cardita crassicostata | Western Pacific | $125.00 | 8 | $1,000.00 | $60.00 | 0.08 | $2,120.08 |
| Tapestry Turban | Turbo petholatus | South Pacific | $55.00 | 18 | $990.00 | $59.40 | 0.08 | $2,098.88 |
| Sales tax | 6% | |||||||
| Largest amount in Hand | 84 | |||||||
| Smallest amount on Hand | 3 | |||||||
| Average Cost per Unit | $62 |
Value Graph
Inventory Value
US Dollars Alphabet Cone Angular Volute Aulicus Cone Bat Volute Brown Paper Nautilius Cabrit's Murex Chambered Nautilus Comb of Venus Court Volute Decipiens Cowrie Emperor's Slit Shell Endive Murex Eyed Cowrie Fulton's Cowrie Golden Cowrie Green Abalone Heart Cockle Imperial Delphinula Japanese Carrier Shell Lazarus Jewel Box Leafy Purpura Lightning Volute Lobeck's Murex Marble Cone Paper Nautilius Queen Tegula Red Abalone Rose-branch Murex Rosy Cardita Tapestry Turban 1485 1815 120 850 1360 1250 1100 625 2940 1350 150 375 705 161 825 247 475 550 1540 600 1564 3360 115 660 5550 540 255 990 1000 990Common Names
Value in US Dollars
