Question

1 Approved Answer

Posted on Jul 24, 2024

Individual presentation based on the original case study The Mystery of the Missing Oil which was distributed to students at commencement of semester. Requirements: You

Individual presentation based on the original case study The Mystery of the Missing Oil which was distributed to students at commencement of semester.

Requirements: You have been appointed as consultant to Jon Enterprise to address the following issues:

Assuming 3 tanks of petrol are unaccounted for in the month of July, estimate the value based on the prices controlled by the Government.

image text in transcribed

2 January to August 2020 3 Stock Balance Report (Unleaded Petrol), July 2019 July Daily Pump Sales (Litres Receipts (RM) Physical Stock Balance Missing Petrol (Litres) Physical Stock Balance (Audited) RM 1 Petrol Diesel RM 1.92 RM 1.58 1.92 RM 1.58 RM 1.92 RM 1.58 RM 1.92 RM 1.58 RM 1.92 RM 1.58 RM 2.70 RM 2.58 RM 2.55 RM 2.50 RM 2.45 RM 2.40 4 Month 5 January 6 February 7 March 8 April 9 May 10 June 11 July 12 August 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 TOTAL 13,647 14,701 7,542 6.199 7,973 5,420 3,647 8,701 5,542 2.525 1,973 1,420 8,647 4,701 7,542 6,199 4.973 5,420 3,647 8,701 5.542 2,525 4,973 611 3,647 5,701 5,302 2.525 1.973 1,420 3,651 166,990 32,760 0 0 32,760 0 0 0 32,760 0 0 0 32.760 0 0 0 32.760 0 0 0 0 32.760 0 0 0 32.760 0 0 0 32.760 0 32,760 294,840 25,131 10.461 4,919 28.480 23,507 18,087 14,440 34,499 32.957 30,432 23,459 49,799 50.152 46,451 38,909 32,710 27.737 22.317 18,670 9.969 37,187 34,662 29,689 29,078 58, 191 52.490 47,188 40.663 55.450 50,404 38,960 1,017,048 2,031 2.000 0 3,000 0 0 0 4,000 0 0 5,000 10,000 1,000 0 0 32.760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32.760 36,760 52.760 56,386 96,939 662,996 27,162 12,461 4,919 31,480 23,507 18,087 14,440 38,499 32,957 30,432 28.459 59,799 51,152 46,451 38,909 65,470 60,497 55,077 51,430 42,729 69,947 67.422 62,449 61,838 90.951 85,250 79.948 77,423 108,210 106,790 135,899 1,680,044 1 Bank Statement, July 2019 2 3 Date Transaction Debit Credit 4 30 Jun 5 1 Jul Cash deposit 7,563.78 6 2 Jul Cash deposit 19,754.28 7 2 Jul Cheque 175553 57,002.40 8 2 Jul TT 5,504.18 9 3 Jul Cash deposit 18,070.56 10 4 Jul Cash deposit 12,923.55 11 5 Jul Cash deposit 9,629.10 12 5 Jul TT 24,821.01 13 5 Jul Cheque 175552 57,002.40 14 6 Jul Cash deposit 15,305,36 15 7 Jul Cash deposit 9,388.26 16 8 Jul Cash deposit 6,132.24 17 8 Jul TT 11,909.39 18 9 Jul Cheque 175551 57,002.40 19 9 Jul Cash deposit 14,488.20 20 10 Jul Cash deposit 8,860.41 21 10 Jul TT 13,688.55 22 11 Jul Cash deposit 6.970.68 23 12 Jul Cash deposit 5,404.73 24 13 Jul Cash deposit 4,037.67 13 Jul Cheque 175555 57,002.40 26 14 Jul Cash deposit 15,337.34 27 14 Jul TT 5,205.83 28 15 Jul Cash deposit 8,482.32 29 16 Jul Cash deposit 10,338.84 30 16 Jul Cheque 17554 57,002.40 31 16 Jul TT 13,410.90 32 17 Jul Cash deposit 8,888.40 33 18 Jul Cash deposit 9,454.73 34 19 Jul Cash deposit 8,717.67 35 20 Jul Cash deposit 7,687.34 36 20 Jul TT 13,771.31 37 21 Jul Cash deposit 14,488.20 38 22 Jul Cheque 175557 57,002.40 39 22 Jul Cash deposit 11,586.69 40 22 Jul Cash deposit 8,407.17 41 23 Jul Cash deposit 5,740.56 42 24 Jul Cash deposit 7,563.78 43 25 Jul Cash deposit 1653.48 44 26 Jul Cash deposit 7,665.30 45 26 Jul Cheque 175556 57,002.40 46 26 Jul TT 8,605.08 47 27 Jul Cash deposit 10.216.44 48 28 Jul Cash deposit 11,586.69 49 29 Jul Cash deposit 6,150.60 50 29 Jul TT 10,100.97 51 30 Jul Cash deposit 4,584.10 52 30 Jul Cheque 175559 57,002.40 53 31 Jul Cash deposit 5,280.03 Balance 25,624.10 33,187.88 52,942.16 -4,060.24 1,443.94 19,514.50 32,438.05 42,067.15 66.888.16 9,885.76 25,191.12 34,579.38 40,711.62 52,621.01 -4,381.39 10,106.81 18,967.22 32,655.77 39,626.45 45,031.18 49,068.85 -7,933.55 7,403.79 12,609.62 21.091.94 31,430.78 -25,571.62 -12,160.72 -3,272.32 6,182.41 14,900.08 22,587.42 36,358.73 50,846.93 -6,155.47 5,431.22 13,838.39 19,578.95 27.142.73 28,796.21 36,461.51 -20,540.89 -11,935.81 -1,719.37 9,867.32 16,017.92 26,118.89 30,702.99 -26,299.41 -21,019.38 0 WN coro- 7 13 WN 600 1 Station Collections, July 2019 2 3 Date Sales Cash Sales 4 1 32,220.40 21,754.28 5 2 34,117.60 20,070.56 6 3 21,231.40 14,923.55 7 4 18,814.00 11,629.10 8 5 22,006.31 17,305.36 9 17,411.80 11,388.26 10 7 14,220.40 8,132.24 11 8 23,317.60 16,488.20 12 9 17,631.40 10,860.41 10 12,200.80 8,970.68 14 11 11,206.31 7,404.73 15 10,211.80 6,037.67 16 23,220.40 18,337.34 17 14 16,117.60 10,482.32 18 15 21,231.40 12,338.84 19 16 18,814.00 10,888.40 20 17 16,697.31 11,545.73 21 18 17,411.80 10,717.67 22 19 14,220.40 10,687.34 23 20 23,317.60 16,488.20 24 21 17,631.40 13,586.69 25 22 12,200.80 7,740.56 26 23 16,606.30 9,563.78 27 24 6,755.80 3,653.48 28 25 14,220.40 9,665.30 29 26 19,917.60 12,216.44 30 27 17,631.40 13,586.69 31 28 12,200.80 8,150.60 32 29 11,206.31 6,684.10 33 30 10,211.80 7,280.03 34 31 14,227.60 9,159.32 Credit Card 10,466.12 14,047.04 6,307.85 7,184.90 4,700.95 6,023.54 6,088.16 6,829.40 6,770.99 3,230.12 3,801.58 4,174.13 4,883.06 5,635.28 8,892.56 7,925.60 5,151.58 6,694.13 3,533.06 6,829.40 4,044.71 4,460.24 7,042.52 3,102.32 4,555.10 7,701.16 4,044.71 4,050.20 4,522.21 2,931.77 5,068.28 2 January to August 2020 3 Stock Balance Report (Unleaded Petrol), July 2019 July Daily Pump Sales (Litres Receipts (RM) Physical Stock Balance Missing Petrol (Litres) Physical Stock Balance (Audited) RM 1 Petrol Diesel RM 1.92 RM 1.58 1.92 RM 1.58 RM 1.92 RM 1.58 RM 1.92 RM 1.58 RM 1.92 RM 1.58 RM 2.70 RM 2.58 RM 2.55 RM 2.50 RM 2.45 RM 2.40 4 Month 5 January 6 February 7 March 8 April 9 May 10 June 11 July 12 August 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 TOTAL 13,647 14,701 7,542 6.199 7,973 5,420 3,647 8,701 5,542 2.525 1,973 1,420 8,647 4,701 7,542 6,199 4.973 5,420 3,647 8,701 5.542 2,525 4,973 611 3,647 5,701 5,302 2.525 1.973 1,420 3,651 166,990 32,760 0 0 32,760 0 0 0 32,760 0 0 0 32.760 0 0 0 32.760 0 0 0 0 32.760 0 0 0 32.760 0 0 0 32.760 0 32,760 294,840 25,131 10.461 4,919 28.480 23,507 18,087 14,440 34,499 32.957 30,432 23,459 49,799 50.152 46,451 38,909 32,710 27.737 22.317 18,670 9.969 37,187 34,662 29,689 29,078 58, 191 52.490 47,188 40.663 55.450 50,404 38,960 1,017,048 2,031 2.000 0 3,000 0 0 0 4,000 0 0 5,000 10,000 1,000 0 0 32.760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32,760 32.760 36,760 52.760 56,386 96,939 662,996 27,162 12,461 4,919 31,480 23,507 18,087 14,440 38,499 32,957 30,432 28.459 59,799 51,152 46,451 38,909 65,470 60,497 55,077 51,430 42,729 69,947 67.422 62,449 61,838 90.951 85,250 79.948 77,423 108,210 106,790 135,899 1,680,044 1 Bank Statement, July 2019 2 3 Date Transaction Debit Credit 4 30 Jun 5 1 Jul Cash deposit 7,563.78 6 2 Jul Cash deposit 19,754.28 7 2 Jul Cheque 175553 57,002.40 8 2 Jul TT 5,504.18 9 3 Jul Cash deposit 18,070.56 10 4 Jul Cash deposit 12,923.55 11 5 Jul Cash deposit 9,629.10 12 5 Jul TT 24,821.01 13 5 Jul Cheque 175552 57,002.40 14 6 Jul Cash deposit 15,305,36 15 7 Jul Cash deposit 9,388.26 16 8 Jul Cash deposit 6,132.24 17 8 Jul TT 11,909.39 18 9 Jul Cheque 175551 57,002.40 19 9 Jul Cash deposit 14,488.20 20 10 Jul Cash deposit 8,860.41 21 10 Jul TT 13,688.55 22 11 Jul Cash deposit 6.970.68 23 12 Jul Cash deposit 5,404.73 24 13 Jul Cash deposit 4,037.67 13 Jul Cheque 175555 57,002.40 26 14 Jul Cash deposit 15,337.34 27 14 Jul TT 5,205.83 28 15 Jul Cash deposit 8,482.32 29 16 Jul Cash deposit 10,338.84 30 16 Jul Cheque 17554 57,002.40 31 16 Jul TT 13,410.90 32 17 Jul Cash deposit 8,888.40 33 18 Jul Cash deposit 9,454.73 34 19 Jul Cash deposit 8,717.67 35 20 Jul Cash deposit 7,687.34 36 20 Jul TT 13,771.31 37 21 Jul Cash deposit 14,488.20 38 22 Jul Cheque 175557 57,002.40 39 22 Jul Cash deposit 11,586.69 40 22 Jul Cash deposit 8,407.17 41 23 Jul Cash deposit 5,740.56 42 24 Jul Cash deposit 7,563.78 43 25 Jul Cash deposit 1653.48 44 26 Jul Cash deposit 7,665.30 45 26 Jul Cheque 175556 57,002.40 46 26 Jul TT 8,605.08 47 27 Jul Cash deposit 10.216.44 48 28 Jul Cash deposit 11,586.69 49 29 Jul Cash deposit 6,150.60 50 29 Jul TT 10,100.97 51 30 Jul Cash deposit 4,584.10 52 30 Jul Cheque 175559 57,002.40 53 31 Jul Cash deposit 5,280.03 Balance 25,624.10 33,187.88 52,942.16 -4,060.24 1,443.94 19,514.50 32,438.05 42,067.15 66.888.16 9,885.76 25,191.12 34,579.38 40,711.62 52,621.01 -4,381.39 10,106.81 18,967.22 32,655.77 39,626.45 45,031.18 49,068.85 -7,933.55 7,403.79 12,609.62 21.091.94 31,430.78 -25,571.62 -12,160.72 -3,272.32 6,182.41 14,900.08 22,587.42 36,358.73 50,846.93 -6,155.47 5,431.22 13,838.39 19,578.95 27.142.73 28,796.21 36,461.51 -20,540.89 -11,935.81 -1,719.37 9,867.32 16,017.92 26,118.89 30,702.99 -26,299.41 -21,019.38 0 WN coro- 7 13 WN 600 1 Station Collections, July 2019 2 3 Date Sales Cash Sales 4 1 32,220.40 21,754.28 5 2 34,117.60 20,070.56 6 3 21,231.40 14,923.55 7 4 18,814.00 11,629.10 8 5 22,006.31 17,305.36 9 17,411.80 11,388.26 10 7 14,220.40 8,132.24 11 8 23,317.60 16,488.20 12 9 17,631.40 10,860.41 10 12,200.80 8,970.68 14 11 11,206.31 7,404.73 15 10,211.80 6,037.67 16 23,220.40 18,337.34 17 14 16,117.60 10,482.32 18 15 21,231.40 12,338.84 19 16 18,814.00 10,888.40 20 17 16,697.31 11,545.73 21 18 17,411.80 10,717.67 22 19 14,220.40 10,687.34 23 20 23,317.60 16,488.20 24 21 17,631.40 13,586.69 25 22 12,200.80 7,740.56 26 23 16,606.30 9,563.78 27 24 6,755.80 3,653.48 28 25 14,220.40 9,665.30 29 26 19,917.60 12,216.44 30 27 17,631.40 13,586.69 31 28 12,200.80 8,150.60 32 29 11,206.31 6,684.10 33 30 10,211.80 7,280.03 34 31 14,227.60 9,159.32 Credit Card 10,466.12 14,047.04 6,307.85 7,184.90 4,700.95 6,023.54 6,088.16 6,829.40 6,770.99 3,230.12 3,801.58 4,174.13 4,883.06 5,635.28 8,892.56 7,925.60 5,151.58 6,694.13 3,533.06 6,829.40 4,044.71 4,460.24 7,042.52 3,102.32 4,555.10 7,701.16 4,044.71 4,050.20 4,522.21 2,931.77 5,068.28