XT108 XT109 XT110 16 14 11 10 18 21 21 20 16 22 16 13 22 22 14 11 22 11 XT101 XT102 XT103 XT104 XT105 XT106 XT107 Month 1 50 29 43 34 30 51 20 Month 2 39 25 54 53 25 41 25 Month 3 30 37 38 37 52 26 23 Month 4 27 50 32 55 29 54 11 Month 5 53 52 28 33 55 54 13 Month 6 42 53 32 40 53 45 13 Month 7 47 31 40 45 49 47 17 Month 8 25 38 42 38 41 41 13 Month 9 52 29 54 53 50 55 18 Month 10 53 26 35 36 55 54 11 Month 11 38 53 45 26 25 48 14 Month 12 40 37 33 54 24 Month 13 49 26 49 35 29 10 Month 14 47 52 35 46 53 21 Month 15 26 37 33 31 31 25 Month 16 39 39 26 34 34 24 Month 17 31 36 39 13 Month 18 25 26 32 39 10 Month 19 39 28 42 41 50 18 Month 20 43 43 34 54 52 20 22 20 13 S 4 4 4 4 Total Sales (RM) 34,670.00 35,185.00 37,330.00 39,315.00 41,115.00 39,425.00 42,245.00 34,870.00 43,030.00 39,205.00 35,225.00 39,295.00 30,095.00 41,580.00 30,315.00 34,745.00 38,495.00 31,880.00 37,110.00 41,375.00 24 15 30 53 15 16 31 11 17 19 51 14 29 16 35 20 11 51 53 41 11 11 21 20 12 42 38 38 39 13 12 19 Question 2 The manager decides to give discounts as below: For items XT101 to XT105: Between 35 to 45 volumes, 3% discount More than above mentioned volumes, 5% discount For items XT106 to XT110 Between 15 to 20 volumes, 3% discount More than above mentioned volumes, 5% discount ii. What is total sales for each month? (5 marks) XT108 XT109 XT110 16 14 11 10 18 21 21 20 16 22 16 13 22 22 14 11 22 11 XT101 XT102 XT103 XT104 XT105 XT106 XT107 Month 1 50 29 43 34 30 51 20 Month 2 39 25 54 53 25 41 25 Month 3 30 37 38 37 52 26 23 Month 4 27 50 32 55 29 54 11 Month 5 53 52 28 33 55 54 13 Month 6 42 53 32 40 53 45 13 Month 7 47 31 40 45 49 47 17 Month 8 25 38 42 38 41 41 13 Month 9 52 29 54 53 50 55 18 Month 10 53 26 35 36 55 54 11 Month 11 38 53 45 26 25 48 14 Month 12 40 37 33 54 24 Month 13 49 26 49 35 29 10 Month 14 47 52 35 46 53 21 Month 15 26 37 33 31 31 25 Month 16 39 39 26 34 34 24 Month 17 31 36 39 13 Month 18 25 26 32 39 10 Month 19 39 28 42 41 50 18 Month 20 43 43 34 54 52 20 22 20 13 S 4 4 4 4 Total Sales (RM) 34,670.00 35,185.00 37,330.00 39,315.00 41,115.00 39,425.00 42,245.00 34,870.00 43,030.00 39,205.00 35,225.00 39,295.00 30,095.00 41,580.00 30,315.00 34,745.00 38,495.00 31,880.00 37,110.00 41,375.00 24 15 30 53 15 16 31 11 17 19 51 14 29 16 35 20 11 51 53 41 11 11 21 20 12 42 38 38 39 13 12 19 Question 2 The manager decides to give discounts as below: For items XT101 to XT105: Between 35 to 45 volumes, 3% discount More than above mentioned volumes, 5% discount For items XT106 to XT110 Between 15 to 20 volumes, 3% discount More than above mentioned volumes, 5% discount ii. What is total sales for each month
