ONLY FOR MAESTRO

profiledhriase
Week4Data.xlsx
Home>Business & Finance homework help>Accounting homework help>ONLY FOR MAESTRO

inventory record

Item Number Type Materials Labor Package Unit_Cost Sales_Price
A-122 Blood Pressure 0.1200 0.1800 0.0100 0.3100 0.5580
A-123 Blood Pressure 0.1320 0.1980 0.0100 0.3400 0.6120
A-124 Blood Pressure 0.0840 0.1260 0.0100 0.2200 0.3960
A-125 Blood Pressure 0.1200 0.1800 0.0100 0.3100 0.5580
A-126 Blood Pressure 0.1760 0.2640 0.0100 0.4500 0.8100
A-127 Blood Pressure 0.1200 0.1800 0.0100 0.3100 0.5580
A-128 Blood Pressure 12.3960 18.5940 0.0100 31.0000 55.8000
A-129 Blood Pressure 13.1960 19.7940 0.0100 33.0000 59.4000
A-130 Blood Pressure 0.1200 0.1800 0.0100 0.3100 0.5580
A-131 Blood Pressure 0.1200 0.1800 0.0100 0.3100 0.5580
A-132 Blood Pressure 0.0800 0.1200 0.0100 0.2100 0.3780
A-133 Blood Pressure 0.2120 0.3180 0.0100 0.5400 0.9720
A-134 Blood Pressure 0.1200 0.1800 0.0100 0.3100 0.5580
B-334 Blood Pressure 0.2200 0.3300 0.0100 0.5600 1.0080
B-335 Blood Pressure 0.2200 0.3300 0.0100 0.5600 1.0080
B-336 Blood Pressure 0.2280 0.3420 0.0100 0.5800 1.0440
B-337 Blood Pressure 0.2200 0.3300 0.0100 0.5600 1.0080
B-338 Blood Pressure 0.2200 0.3300 0.0100 0.5600 1.0080
B-339 Blood Pressure 0.2320 0.3480 0.0100 0.5900 1.0620
B-340 Blood Pressure 0.2200 0.3300 0.0100 0.5600 1.0080
B-341 Blood Pressure 0.2200 0.3300 0.0100 0.5600 1.0080
C-447 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
C-448 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
C-449 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
C-450 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
C-451 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
C-452 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
C-453 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
C-454 Diabetic 0.5440 0.8160 0.0100 1.3700 2.7400
D-887 Diabetic 7.2360 10.8540 0.0100 18.1000 36.2000
D-888 Diabetic 5.9160 8.8740 0.0100 14.8000 29.6000
D-889 Diabetic 3.5960 5.3940 0.0100 9.0000 18.0000
D-890 Diabetic 4.9560 7.4340 0.0100 12.4000 24.8000
D-891 Diabetic 4.9560 7.4340 0.0100 12.4000 24.8000
D-892 Diabetic 4.9960 7.4940 0.0100 12.5000 25.0000
D-893 Diabetic 5.6360 8.4540 0.0100 14.1000 28.2000
D-894 Diabetic 5.6360 8.4540 0.0100 14.1000 28.2000
D-895 Diabetic 5.9160 8.8740 0.0100 14.8000 29.6000
D-896 Diabetic 5.6440 8.4660 0.0100 14.1200 28.2400
D-897 Diabetic 5.6440 8.4660 0.0100 14.1200 28.2400
D-898 Diabetic 6.2360 9.3540 0.0100 15.6000 31.2000
D-899 Diabetic 5.6520 8.4780 0.0100 14.1400 28.2800
D-900 Diabetic 5.6520 8.4780 0.0100 14.1400 28.2800
D-901 Diabetic 5.6360 8.4540 0.0100 14.1000 28.2000
D-902 Diabetic 49.3560 74.0340 0.0100 123.4000 246.8000
D-903 Diabetic 56.8760 85.3140 0.0100 142.2000 284.4000
D-904 Diabetic 55.1160 82.6740 0.0100 137.8000 275.6000
D-905 Diabetic 54.5960 81.8940 0.0100 136.5000 273.0000
E-224 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-225 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-226 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-227 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-228 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-229 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-230 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-231 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-232 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-233 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-234 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-235 Depression 1.0680 1.6020 0.0100 2.6800 8.0400
E-236 Depression 1.1920 1.7880 0.0100 2.9900 8.9700
E-237 Depression 1.3760 2.0640 0.0100 3.4500 10.3500
E-238 Depression 0.0760 0.1140 0.0100 0.2000 0.6000
E-239 Depression 0.0800 0.1200 0.0100 0.2100 0.6300
E-240 Depression 0.0840 0.1260 0.0100 0.2200 0.6600
E-241 Depression 1.1920 1.7880 0.0100 2.9900 8.9700
E-242 Depression 1.2000 1.8000 0.0100 3.0100 9.0300
E-243 Depression 1.2120 1.8180 0.0100 3.0400 9.1200
E-244 Depression 0.9880 1.4820 0.0100 2.4800 7.4400
E-245 Depression 0.9920 1.4880 0.0100 2.4900 7.4700
E-246 Depression 0.9960 1.4940 0.0100 2.5000 7.5000
E-247 Depression 7.4760 11.2140 0.0100 18.7000 56.1000
F-119 Pain Relief 0.0000 0.0000 0.0100 0.0100 0.0150
F-120 Pain Relief 0.0000 0.0000 0.0100 0.0100 0.0150
F-121 Pain Relief 0.0000 0.0000 0.0100 0.0100 0.0150
F-122 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-123 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-124 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-125 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-126 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-127 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-128 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-129 Pain Relief 0.0080 0.0120 0.0100 0.0300 0.0450
F-130 Pain Relief 0.0120 0.0180 0.0100 0.0400 0.0600
F-131 Pain Relief 0.0120 0.0180 0.0100 0.0400 0.0600
F-132 Pain Relief 0.0120 0.0180 0.0100 0.0400 0.0600
F-133 Pain Relief 0.0120 0.0180 0.0100 0.0400 0.0600
F-134 Pain Relief 0.0120 0.0180 0.0100 0.0400 0.0600
F-135 Pain Relief 0.0120 0.0180 0.0100 0.0400 0.0600
F-136 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-137 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-138 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-139 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-140 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-141 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-142 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-143 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-144 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-145 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-146 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-147 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-148 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-149 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
F-150 Pain Relief 0.0160 0.0240 0.0100 0.0500 0.0750
G-008 Pain Relief 8.4760 12.7140 0.0100 21.2000 84.8000
G-009 Pain Relief 8.7960 13.1940 0.0100 22.0000 88.0000
G-010 Pain Relief 14.4680 21.7020 0.0100 36.1800 144.7200
G-011 Pain Relief 13.6760 20.5140 0.0100 34.2000 136.8000
G-012 Pain Relief 14.5960 21.8940 0.0100 36.5000 146.0000
G-013 Pain Relief 16.5160 24.7740 0.0100 41.3000 165.2000
G-014 Pain Relief 16.3960 24.5940 0.0100 41.0000 164.0000
G-015 Pain Relief 17.5960 26.3940 0.0100 44.0000 176.0000
G-016 Pain Relief 21.5960 32.3940 0.0100 54.0000 216.0000
G-017 Pain Relief 22.3960 33.5940 0.0100 56.0000 224.0000
G-018 Pain Relief 23.1960 34.7940 0.0100 58.0000 232.0000
H-445 Allergy 1.6440 2.4660 0.0100 4.1200 4.9440
H-446 Allergy 0.0720 0.1080 0.0100 0.1900 0.2280
H-447 Allergy 1.1480 1.7220 0.0100 2.8800 3.4560
H-448 Allergy 0.0920 0.1380 0.0100 0.2400 0.2880
H-449 Allergy 1.9480 2.9220 0.0100 4.8800 5.8560
H-450 Allergy 1.2840 1.9260 0.0100 3.2200 3.8640
H-451 Allergy 1.1960 1.7940 0.0100 3.0000 3.6000
H-452 Allergy 1.6520 2.4780 0.0100 4.1400 4.9680
H-453 Allergy 2.6200 3.9300 0.0100 6.5600 7.8720
H-454 Allergy 2.0680 3.1020 0.0100 5.1800 6.2160
H-455 Allergy 2.0760 3.1140 0.0100 5.2000 6.2400
H-456 Allergy 1.9960 2.9940 0.0100 5.0000 6.0000
H-457 Allergy 2.0240 3.0360 0.0100 5.0700 6.0840
H-458 Allergy 1.2800 1.9200 0.0100 3.2100 3.8520
H-459 Allergy 2.0360 3.0540 0.0100 5.1000 6.1200
H-460 Allergy 2.1160 3.1740 0.0100 5.3000 6.3600
H-461 Allergy 1.9880 2.9820 0.0100 4.9800 5.9760
H-462 Allergy 2.3720 3.5580 0.0100 5.9400 7.1280
I-1000 Allergy 15.9960 23.9940 0.0100 40.0000 48.0000
I-1001 Allergy 17.9960 26.9940 0.0100 45.0000 54.0000
I-1002 Allergy 9.9960 14.9940 0.0100 25.0000 30.0000
I-1003 Allergy 45.9960 68.9940 0.0100 115.0000 138.0000
I-1004 Allergy 15.9960 23.9940 0.0100 40.0000 48.0000
I-1005 Allergy 16.7960 25.1940 0.0100 42.0000 50.4000
I-1006 Allergy 9.9960 14.9940 0.0100 25.0000 30.0000
I-1007 Allergy 18.3960 27.5940 0.0100 46.0000 55.2000
I-1008 Cholesterol 2.3960 3.5940 0.0100 6.0000 18.0000
I-1009 Cholesterol 2.3960 3.5940 0.0100 6.0000 18.0000
J-665 Cholesterol 2.0440 3.0660 0.0100 5.1200 15.3600
J-666 Cholesterol 2.7440 4.1160 0.0100 6.8700 20.6100
J-667 Cholesterol 2.7440 4.1160 0.0100 6.8700 20.6100
J-668 Cholesterol 4.4760 6.7140 0.0100 11.2000 33.6000
J-669 Cholesterol 2.7440 4.1160 0.0100 6.8700 20.6100
J-670 Cholesterol 2.7440 4.1160 0.0100 6.8700 20.6100
J-671 Cholesterol 6.5960 9.8940 0.0100 16.5000 49.5000
J-672 Cholesterol 21.5960 32.3940 0.0100 54.0000 162.0000
J-673 Cholesterol 8.9560 13.4340 0.0100 22.4000 67.2000
J-674 Cholesterol 8.5560 12.8340 0.0100 21.4000 64.2000
K-764 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-765 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-766 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-767 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-768 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-769 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-770 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-771 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-772 Antibiotic 0.0080 0.0120 0.0100 0.0300 0.0360
K-773 Antibiotic 14.4680 21.7020 0.0100 36.1800 43.4160
K-774 Antibiotic 14.4680 21.7020 0.0100 36.1800 43.4160
K-775 Antibiotic 14.4680 21.7020 0.0100 36.1800 43.4160
K-776 Antibiotic 14.4680 21.7020 0.0100 36.1800 43.4160
K-777 Antibiotic 14.4680 21.7020 0.0100 36.1800 43.4160
K-778 Antibiotic 3.4760 5.2140 0.0100 8.7000 10.4400
K-779 Antibiotic 3.4760 5.2140 0.0100 8.7000 10.4400
K-780 Antibiotic 4.1960 6.2940 0.0100 10.5000 12.6000
K-781 Antibiotic 3.4760 5.2140 0.0100 8.7000 10.4400
K-782 Antibiotic 4.4960 6.7440 0.0100 11.2500 13.5000
K-783 Antibiotic 3.4760 5.2140 0.0100 8.7000 10.4400
L-333 Chemotherapy 2.1200 3.1800 10.0000 15.3000 91.8000
L-334 Chemotherapy 3.6800 5.5200 10.0000 19.2000 115.2000
L-335 Chemotherapy 3.5320 5.2980 10.0000 18.8300 112.9800
L-336 Chemotherapy 3.5320 5.2980 10.0000 18.8300 112.9800
L-337 Chemotherapy 6.1200 9.1800 10.0000 25.3000 151.8000
L-338 Chemotherapy 3.8000 5.7000 10.0000 19.5000 117.0000
L-339 Chemotherapy 3.8600 5.7900 10.0000 19.6500 117.9000
L-340 Chemotherapy 0.8400 1.2600 10.0000 12.1000 72.6000
L-341 Chemotherapy 0.9000 1.3500 10.0000 12.2500 73.5000
L-342 Chemotherapy 5.4000 8.1000 10.0000 23.5000 141.0000
L-343 Chemotherapy 4.5600 6.8400 10.0000 21.4000 128.4000
L-344 Chemotherapy 7.4000 11.1000 10.0000 28.5000 171.0000
L-345 Chemotherapy 0.8400 1.2600 10.0000 12.1000 72.6000
L-346 Chemotherapy 0.5000 0.7500 10.0000 11.2500 67.5000
L-347 Chemotherapy 0.2400 0.3600 10.0000 10.6000 63.6000
L-348 Chemotherapy 0.2400 0.3600 10.0000 10.6000 63.6000
M-221 Chemotherapy 3.2800 4.9200 10.0000 18.2000 109.2000
M-222 Chemotherapy 17.1200 25.6800 10.0000 52.8000 316.8000
M-223 Chemotherapy 15.2800 22.9200 10.0000 48.2000 289.2000
M-224 Chemotherapy 18.3200 27.4800 10.0000 55.8000 334.8000
M-225 Chemotherapy 3.8520 5.7780 10.0000 19.6300 117.7800
M-226 Chemotherapy 20.8000 31.2000 10.0000 62.0000 372.0000
M-227 Chemotherapy 0.2920 0.4380 10.0000 10.7300 64.3800
M-228 Chemotherapy 19.8400 29.7600 10.0000 59.6000 357.6000
M-229 Chemotherapy 0.2920 0.4380 10.0000 10.7300 64.3800
M-230 Chemotherapy 30.9600 46.4400 10.0000 87.4000 524.4000