MGMT-3220 - Mgmt Information System
dhyaa22
export.xlsx_mis.xlsxSheet2
| Sum of Value | Column Labels | |||||||||||
| Row Labels | 1kg Blueberry Muesli | 1kg Mixed Fruit Muesli | 1kg Nut Muesli | 1kg Original Muesli | 1kg Raisin Muesli | 1kg Strawberry Muesli | 500g Blueberry Muesli | 500g Mixed Fruit Muesli | 500g Nut Muesli | 500g Raisin Muesli | 500g Strawberry Muesli | Grand Total |
| 1 | 139143.3 | 125576.1 | 96000 | 139284.77 | 96199.2 | 75000 | 75000 | 103956 | 850159.37 | |||
| 2 | 161685.48 | 77351.4 | 136967.7 | 54666.5 | 42400 | 67988.8 | 53378.85 | 594438.73 | ||||
| 3 | 158439 | 72800 | 64000 | 84786 | 89594.4 | 51384.3 | 65411.8 | 83425.95 | 669841.45 | |||
| 4 | 79272 | 168000 | 69645.6 | 60000 | 67766.7 | 98226 | 54526.5 | 54215.7 | 108230.3 | 126578.85 | 886461.65 | |
| Grand Total | 538539.78 | 168000 | 345373.1 | 60000 | 227766.7 | 361038.47 | 338686.1 | 54526.5 | 223000 | 316630.9 | 367339.65 | 3000901.2 |
Revenue per product, per quarter
1kg Blueberry Muesli 1 2 3 4 139143.29999999999 161685.48000000001 158439 79272 1kg Mixed Fruit Muesli 1 2 3 4 168000 1kg Nut Muesli 1 2 3 4 125576.1 77351.399999999994 72800 69645.600000000006 1kg Original Muesli 1 2 3 4 60000 1kg Raisin Muesli 1 2 3 4 96000 64000 67766.700000000012 1kg Strawberry Muesli 1 2 3 4 139284.76999999999 136967.70000000001 84786 500g Blueberry Muesli 1 2 3 4 96199.2 54666.5 89594.4 98226 500g Mixed Fruit Muesli 1 2 3 4 54526.5 500g Nut Muesli 1 2 3 4 75000 42400 51384.3 54215.7 500g Raisin Muesli 1 2 3 4 75000 67988.800000000003 65411.8 108230.3 500g Strawberry Muesli 1 2 3 4 103956 53378.850000000006 83425.95 126578.85
Sheet1
| Rnd | Simulation Day | Area | Distribution Channel | Material | Material description | Price | Qty | Value | Cost |
| 4 | 19 | NO | 12 | II-F01 | 500g Nut Muesli | 3.30 | 7,132 | 23,535.60 | 6,418.80 |
| 4 | 19 | NO | 12 | II-F14 | 1kg Raisin Muesli | 4.35 | 3,778 | 16,434.30 | 5,213.64 |
| 4 | 19 | NO | 12 | II-F01 | 500g Nut Muesli | 3.30 | 7,310 | 24,123.00 | 6,579.00 |
| 4 | 19 | NO | 12 | II-F01 | 500g Nut Muesli | 3.30 | 1,987 | 6,557.10 | 1,788.30 |
| 4 | 17 | WE | 12 | II-F14 | 1kg Raisin Muesli | 4.20 | 6,645 | 27,909.00 | 9,170.10 |
| 4 | 17 | WE | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.50 | 4,138 | 22,759.00 | 8,524.28 |
| 4 | 17 | WE | 12 | II-F14 | 1kg Raisin Muesli | 4.20 | 5,577 | 23,423.40 | 7,696.26 |
| 4 | 17 | WE | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.50 | 2,951 | 16,230.50 | 6,079.06 |
| 4 | 16 | SO | 12 | II-F12 | 1kg Blueberry Muesli | 5.40 | 5,239 | 28,290.60 | 11,840.14 |
| 4 | 16 | SO | 12 | II-F02 | 500g Blueberry Muesli | 4.65 | 5,579 | 25,942.35 | 6,862.17 |
| 4 | 16 | SO | 12 | II-F02 | 500g Blueberry Muesli | 4.65 | 5,221 | 24,277.65 | 6,421.83 |
| 4 | 16 | SO | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.50 | 4,313 | 23,721.50 | 8,884.78 |
| 4 | 16 | WE | 12 | II-F04 | 500g Raisin Muesli | 3.45 | 6,564 | 22,645.80 | 5,185.56 |
| 4 | 16 | WE | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.50 | 4,598 | 25,289.00 | 9,471.88 |
| 4 | 16 | WE | 12 | II-F04 | 500g Raisin Muesli | 3.45 | 3,739 | 12,899.55 | 2,953.81 |
| 4 | 12 | NO | 12 | II-F04 | 500g Raisin Muesli | 3.35 | 7,557 | 25,315.95 | 5,970.03 |
| 4 | 12 | NO | 12 | II-F04 | 500g Raisin Muesli | 3.35 | 7,058 | 23,644.30 | 5,575.82 |
| 4 | 12 | NO | 12 | II-F11 | 1kg Nut Muesli | 5.10 | 4,624 | 23,582.40 | 7,444.64 |
| 4 | 12 | NO | 12 | II-F12 | 1kg Blueberry Muesli | 5.40 | 5,312 | 28,684.80 | 12,005.12 |
| 4 | 12 | WE | 12 | II-F11 | 1kg Nut Muesli | 5.10 | 4,772 | 24,337.20 | 7,682.92 |
| 4 | 12 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 5.40 | 4,129 | 22,296.60 | 9,331.54 |
| 4 | 12 | WE | 12 | II-F11 | 1kg Nut Muesli | 5.10 | 4,260 | 21,726.00 | 6,858.60 |
| 4 | 12 | WE | 12 | II-F04 | 500g Raisin Muesli | 3.35 | 7,082 | 23,724.70 | 5,594.78 |
| 4 | 9 | WE | 12 | II-F03 | 500g Strawberry Muesli | 4.10 | 5,788 | 23,730.80 | 7,119.24 |
| 4 | 9 | WE | 12 | II-F15 | 1kg Original Muesli | 3.75 | 7,025 | 26,343.75 | 9,483.75 |
| 4 | 9 | WE | 12 | II-F15 | 1kg Original Muesli | 3.75 | 2,984 | 11,190.00 | 4,028.40 |
| 4 | 9 | WE | 12 | II-F03 | 500g Strawberry Muesli | 4.10 | 6,715 | 27,531.50 | 8,259.45 |
| 4 | 8 | SO | 12 | II-F06 | 500g Mixed Fruit Muesli | 3.50 | 7,457 | 26,099.50 | 8,426.41 |
| 4 | 8 | SO | 12 | II-F15 | 1kg Original Muesli | 3.75 | 5,991 | 22,466.25 | 8,087.85 |
| 4 | 8 | SO | 12 | II-F06 | 500g Mixed Fruit Muesli | 3.50 | 8,122 | 28,427.00 | 9,177.86 |
| 4 | 8 | SO | 12 | II-F03 | 500g Strawberry Muesli | 4.10 | 6,859 | 28,121.90 | 8,436.57 |
| 4 | 4 | SO | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.00 | 4,642 | 23,210.00 | 9,562.52 |
| 4 | 4 | SO | 12 | II-F03 | 500g Strawberry Muesli | 4.05 | 6,108 | 24,737.40 | 7,512.84 |
| 4 | 4 | SO | 12 | II-F03 | 500g Strawberry Muesli | 4.05 | 5,545 | 22,457.25 | 6,820.35 |
| 4 | 4 | SO | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.00 | 928 | 4,640.00 | 1,911.68 |
| 4 | 3 | SO | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.00 | 4,874 | 24,370.00 | 10,040.44 |
| 4 | 3 | SO | 12 | II-F02 | 500g Blueberry Muesli | 4.50 | 5,581 | 25,114.50 | 6,864.63 |
| 4 | 3 | SO | 12 | II-F02 | 500g Blueberry Muesli | 4.50 | 5,087 | 22,891.50 | 6,257.01 |
| 4 | 3 | SO | 12 | II-F16 | 1kg Mixed Fruit Muesli | 5.00 | 5,556 | 27,780.00 | 11,445.36 |
| 3 | 20 | SO | 12 | II-F02 | 500g Blueberry Muesli | 4.20 | 5,332 | 22,394.40 | 6,558.36 |
| 3 | 20 | SO | 12 | II-F12 | 1kg Blueberry Muesli | 5.40 | 4,216 | 22,766.40 | 9,528.16 |
| 3 | 20 | SO | 12 | II-F12 | 1kg Blueberry Muesli | 5.40 | 4,842 | 26,146.80 | 10,942.92 |
| 3 | 19 | SO | 12 | II-F04 | 500g Raisin Muesli | 3.20 | 5,334 | 17,068.80 | 4,213.86 |
| 3 | 19 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 5.20 | 4,378 | 22,765.60 | 9,938.06 |
| 3 | 19 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 5.20 | 2,543 | 13,223.60 | 5,772.61 |
| 3 | 19 | SO | 12 | II-F12 | 1kg Blueberry Muesli | 5.40 | 4,727 | 25,525.80 | 10,683.02 |
| 3 | 13 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.90 | 7,500 | 21,750.00 | 5,925.00 |
| 3 | 13 | NO | 12 | II-F13 | 1kg Strawberry Muesli | 5.20 | 4,986 | 25,927.20 | 11,318.22 |
| 3 | 13 | NO | 12 | II-F13 | 1kg Strawberry Muesli | 5.20 | 4,398 | 22,869.60 | 9,983.46 |
| 3 | 13 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.90 | 3,166 | 9,181.40 | 2,501.14 |
| 3 | 7 | NO | 12 | II-F14 | 1kg Raisin Muesli | 4.00 | 3,408 | 13,632.00 | 4,703.04 |
| 3 | 7 | NO | 12 | II-F03 | 500g Strawberry Muesli | 4.05 | 6,274 | 25,409.70 | 7,717.02 |
| 3 | 7 | NO | 12 | II-F03 | 500g Strawberry Muesli | 4.05 | 4,394 | 17,795.70 | 5,404.62 |
| 3 | 6 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 5.25 | 4,981 | 26,150.25 | 11,257.06 |
| 3 | 6 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 5.25 | 353 | 1,853.25 | 797.78 |
| 3 | 6 | WE | 12 | II-F03 | 500g Strawberry Muesli | 4.05 | 5,332 | 21,594.60 | 6,558.36 |
| 3 | 5 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.90 | 6,004 | 17,411.60 | 4,743.16 |
| 3 | 5 | NO | 12 | II-F12 | 1kg Blueberry Muesli | 5.25 | 5,083 | 26,685.75 | 11,487.58 |
| 3 | 5 | NO | 12 | II-F12 | 1kg Blueberry Muesli | 5.25 | 5,011 | 26,307.75 | 11,324.86 |
| 3 | 5 | NO | 12 | II-F12 | 1kg Blueberry Muesli | 5.25 | 572 | 3,003.00 | 1,292.72 |
| 3 | 3 | WE | 12 | II-F01 | 500g Nut Muesli | 3.30 | 7,860 | 25,938.00 | 7,074.00 |
| 3 | 3 | WE | 12 | II-F11 | 1kg Nut Muesli | 4.55 | 4,492 | 20,438.60 | 7,232.12 |
| 3 | 3 | WE | 12 | II-F01 | 500g Nut Muesli | 3.30 | 7,711 | 25,446.30 | 6,939.90 |
| 3 | 2 | SO | 12 | II-F02 | 500g Blueberry Muesli | 4.20 | 6,509 | 27,337.80 | 8,006.07 |
| 3 | 2 | SO | 12 | II-F03 | 500g Strawberry Muesli | 4.05 | 4,599 | 18,625.95 | 5,656.77 |
| 3 | 2 | SO | 12 | II-F02 | 500g Blueberry Muesli | 4.20 | 3,589 | 15,073.80 | 4,414.47 |
| 3 | 2 | SO | 12 | II-F14 | 1kg Raisin Muesli | 4.00 | 6,172 | 24,688.00 | 8,517.36 |
| 3 | 1 | NO | 12 | II-F02 | 500g Blueberry Muesli | 4.20 | 5,902 | 24,788.40 | 7,259.46 |
| 3 | 1 | NO | 12 | II-F11 | 1kg Nut Muesli | 4.55 | 6,147 | 27,968.85 | 9,896.67 |
| 3 | 1 | NO | 12 | II-F14 | 1kg Raisin Muesli | 4.00 | 6,420 | 25,680.00 | 8,859.60 |
| 3 | 1 | NO | 12 | II-F11 | 1kg Nut Muesli | 4.55 | 5,361 | 24,392.55 | 8,631.21 |
| 2 | 15 | NO | 12 | II-F12 | 1kg Blueberry Muesli | 5.00 | 4,658 | 23,290.00 | 10,527.08 |
| 2 | 15 | NO | 12 | II-F12 | 1kg Blueberry Muesli | 5.00 | 1,508 | 7,540.00 | 3,408.08 |
| 2 | 15 | NO | 12 | II-F11 | 1kg Nut Muesli | 4.20 | 5,260 | 22,092.00 | 8,468.60 |
| 2 | 15 | NO | 12 | II-F01 | 500g Nut Muesli | 2.65 | 5,640 | 14,946.00 | 5,076.00 |
| 2 | 15 | WE | 12 | II-F11 | 1kg Nut Muesli | 4.20 | 6,731 | 28,270.20 | 10,836.91 |
| 2 | 15 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 5.00 | 5,098 | 25,490.00 | 11,521.48 |
| 2 | 15 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 5.00 | 4,736 | 23,680.00 | 10,703.36 |
| 2 | 15 | WE | 12 | II-F02 | 500g Blueberry Muesli | 3.25 | 5,334 | 17,335.50 | 6,560.82 |
| 2 | 14 | NO | 12 | II-F11 | 1kg Nut Muesli | 4.20 | 6,426 | 26,989.20 | 10,345.86 |
| 2 | 14 | NO | 12 | II-F13 | 1kg Strawberry Muesli | 4.70 | 5,031 | 23,645.70 | 11,420.37 |
| 2 | 14 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.80 | 9,996 | 27,988.80 | 7,896.84 |
| 2 | 14 | NO | 12 | II-F01 | 500g Nut Muesli | 2.65 | 10,360 | 27,454.00 | 9,324.00 |
| 2 | 9 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.50 | 10,978 | 27,445.00 | 8,672.62 |
| 2 | 9 | NO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 6,323 | 26,872.75 | 14,353.21 |
| 2 | 9 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.50 | 5,022 | 12,555.00 | 3,967.38 |
| 2 | 9 | NO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 4,341 | 18,449.25 | 9,854.07 |
| 2 | 7 | WE | 12 | II-F03 | 500g Strawberry Muesli | 3.99 | 5,641 | 22,507.59 | 6,938.43 |
| 2 | 7 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 5.25 | 4,213 | 22,118.25 | 9,521.38 |
| 2 | 7 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 5.25 | 2,885 | 15,146.25 | 6,520.10 |
| 2 | 7 | WE | 12 | II-F03 | 500g Strawberry Muesli | 3.99 | 5,760 | 22,982.40 | 7,084.80 |
| 2 | 5 | SO | 12 | II-F12 | 1kg Blueberry Muesli | 4.99 | 4,517 | 22,539.83 | 10,208.42 |
| 2 | 5 | SO | 12 | II-F02 | 500g Blueberry Muesli | 3.50 | 7,781 | 27,233.50 | 9,570.63 |
| 2 | 5 | SO | 12 | II-F02 | 500g Blueberry Muesli | 3.50 | 2,885 | 10,097.50 | 3,548.55 |
| 2 | 5 | SO | 12 | II-F12 | 1kg Blueberry Muesli | 4.99 | 4,385 | 21,881.15 | 9,910.10 |
| 2 | 2 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 5,131 | 21,806.75 | 11,647.37 |
| 2 | 2 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 5,539 | 23,540.75 | 12,573.53 |
| 2 | 2 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 5,330 | 22,652.50 | 12,099.10 |
| 2 | 2 | SO | 12 | II-F03 | 500g Strawberry Muesli | 3.78 | 2,087 | 7,888.86 | 2,567.01 |
| 1 | 19 | SO | 12 | II-F04 | 500g Raisin Muesli | 2.50 | 9,235 | 23,087.50 | 7,295.65 |
| 1 | 19 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 6,727 | 28,589.75 | 15,270.29 |
| 1 | 19 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 6,113 | 25,980.25 | 13,876.51 |
| 1 | 19 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 2,194 | 9,324.50 | 4,980.38 |
| 1 | 18 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.50 | 9,605 | 24,012.50 | 7,587.95 |
| 1 | 18 | NO | 12 | II-F13 | 1kg Strawberry Muesli | 4.25 | 6,313 | 26,830.25 | 14,330.51 |
| 1 | 18 | NO | 12 | II-F12 | 1kg Blueberry Muesli | 4.80 | 2,573 | 12,350.40 | 5,814.98 |
| 1 | 18 | NO | 12 | II-F04 | 500g Raisin Muesli | 2.50 | 11,160 | 27,900.00 | 8,816.40 |
| 1 | 13 | NO | 12 | II-F01 | 500g Nut Muesli | 2.50 | 11,307 | 28,267.50 | 10,176.30 |
| 1 | 13 | NO | 12 | II-F14 | 1kg Raisin Muesli | 3.20 | 7,751 | 24,803.20 | 10,696.38 |
| 1 | 13 | NO | 12 | II-F01 | 500g Nut Muesli | 2.50 | 9,900 | 24,750.00 | 8,910.00 |
| 1 | 13 | WE | 12 | II-F14 | 1kg Raisin Muesli | 3.20 | 7,095 | 22,704.00 | 9,791.10 |
| 1 | 13 | WE | 12 | II-F01 | 500g Nut Muesli | 2.50 | 8,793 | 21,982.50 | 7,913.70 |
| 1 | 13 | WE | 12 | II-F03 | 500g Strawberry Muesli | 4.00 | 6,683 | 26,732.00 | 8,220.09 |
| 1 | 13 | WE | 12 | II-F14 | 1kg Raisin Muesli | 3.20 | 7,421 | 23,747.20 | 10,240.98 |
| 1 | 12 | WE | 12 | II-F11 | 1kg Nut Muesli | 4.80 | 4,842 | 23,241.60 | 7,795.62 |
| 1 | 12 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 4.80 | 5,891 | 28,276.80 | 13,313.66 |
| 1 | 12 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 4.80 | 5,347 | 25,665.60 | 12,084.22 |
| 1 | 12 | WE | 12 | II-F14 | 1kg Raisin Muesli | 3.20 | 7,733 | 24,745.60 | 10,671.54 |
| 1 | 9 | WE | 12 | II-F11 | 1kg Nut Muesli | 4.50 | 5,395 | 24,277.50 | 8,685.95 |
| 1 | 9 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 4.50 | 5,115 | 23,017.50 | 11,559.90 |
| 1 | 9 | WE | 12 | II-F12 | 1kg Blueberry Muesli | 4.50 | 5,805 | 26,122.50 | 13,119.30 |
| 1 | 9 | WE | 12 | II-F02 | 500g Blueberry Muesli | 3.10 | 6,188 | 19,182.80 | 7,611.24 |
| 1 | 8 | SO | 12 | II-F11 | 1kg Nut Muesli | 4.50 | 6,076 | 27,342.00 | 9,782.36 |
| 1 | 8 | SO | 12 | II-F11 | 1kg Nut Muesli | 4.50 | 5,763 | 25,933.50 | 9,278.43 |
| 1 | 8 | SO | 12 | II-F12 | 1kg Blueberry Muesli | 4.50 | 5,269 | 23,710.50 | 11,907.94 |
| 1 | 8 | SO | 12 | II-F13 | 1kg Strawberry Muesli | 4.80 | 5,370 | 25,776.00 | 12,189.90 |
| 1 | 8 | WE | 12 | II-F02 | 500g Blueberry Muesli | 3.10 | 7,854 | 24,347.40 | 9,660.42 |
| 1 | 8 | WE | 12 | II-F02 | 500g Blueberry Muesli | 3.10 | 7,960 | 24,676.00 | 9,790.80 |
| 1 | 8 | WE | 12 | II-F11 | 1kg Nut Muesli | 4.50 | 5,507 | 24,781.50 | 8,866.27 |
| 1 | 8 | WE | 12 | II-F03 | 500g Strawberry Muesli | 4.00 | 5,838 | 23,352.00 | 7,180.74 |
| 1 | 6 | WE | 12 | II-F13 | 1kg Strawberry Muesli | 6.94 | 3,283 | 22,784.02 | 7,452.41 |
| 1 | 6 | WE | 12 | II-F03 | 500g Strawberry Muesli | 3.50 | 8,023 | 28,080.50 | 9,868.29 |
| 1 | 6 | WE | 12 | II-F02 | 500g Blueberry Muesli | 3.50 | 7,998 | 27,993.00 | 9,837.54 |
| 1 | 6 | WE | 12 | II-F03 | 500g Strawberry Muesli | 3.50 | 7,369 | 25,791.50 | 9,063.87 |
