Please use excel
Question 2 [20 marks During the COVID-19 pandemic. A cake factory sells 6 types of cake for the whole Malaysia through online orders (hence assuming that the supply will never exceed the demand - all cakes made will be sold out). The price list is as shown in Table 4 Table 4 Type of cake Chocolate Cake Vanilla Cake Strawberry Cake Caramel Cake White Cake Red Velvet Cake Selling price per whole cake RM 103.00 RM 91.00 RM 144.00 RM 116.00 RM 83.00 RM 83.00 All the ingredients to make each one of the six types of cakes are as shown in Table 5 Table 5 Ingredients to make one whole Chocolate Vanilla Strawberry Caramel cake Cake Cake Cake Cake White Cake Red Velvet Cake 540 360 0 30 0 5 All-purpose flour (ml) 480 White sugar (ml) 480 Confectioner's sugar sifted (ml) 1200 Unsweetened cocoa powder (ml) 420 Baking powder (ml) 10 Baking soda (ml) 7.5 Salt (ml) 5 Coffee powder (ml) 7.5 Milk (ml) 360 Vegetable oil (ml) 120 Egg (qty) 2 Raw strawberries (qly) 0 Strawberry jam (ml) 0 Vanilla extract (ml) 20 Unsalted Butter (ml) 360 Shortening (ml) 0 White Vinegar (ml) 0 Food Coloring (ml) 0 0 *data sourced from a recipe website: httpsdadidapincha 765 720 0 0 10 5 5 0.3 0 0 480 0 4 0 0 17.5 240 240 0 0 720 720 960 0 0 10 0 1.55 0 270 0 5 12 60 25 480 120 0 1 720 960 0 0 0 0 10 5 0 0 480 0 4 0 0 10 360 120 0 0 0 360 360 960 0 10 0 0 1.55 0 0 285 0 5 0 0 20 480 120 0 0 0 240 0 2 0 0 s 0 0 120 15 60 The cost and the maximum monthly supply of each ingredient is as shown in Table 6. Table 6 Ingredients Cost maximum monthly supply All-purpose flour RM 4.30 per kg. 1kg is 1970ml. 203 kg White sugar RM 3.60 per kg. Ikg is 1220ml. 323 kg Icing sugar RM 4.50 per kg. Ikg is 1970ml. 178 kg Unsweetened cocoa powder RM 34.50 per kg. Ikg is 2460ml. 20.3 kg Baking powder RM 15.10 per kg. Ikg is 2960ml. 2.1 kg Baking soda RM 4.20 per kg. 1kg is 1030ml. 2.4 ky Salt RM 31.76 per kg. 1kg is 820 ml. 2.0 kg Coffee powder RM 32.00 per kg. Ikg is 4930ml. 182 grams Milk RM 5.61 per liter 240 liters Vegetable oil RM 9.25 per kg. Ikg is 1060ml. 13.2 kg RM 24.80 per tray. I tray has 36 ty 117 trays Raw strawberries RM 33.50 per tray. I tray has 50 aty 50 trays Strawberry jam RM 8.00 per liter 8 liters Vanilla extract RM 2.90 per 25ml 10 liters Unsalted Butter RM 11.80 per kg. 1kg is 1060ml. 198 kg Shortening RM 9.90 per kg. 1kg is 1230ml 65 kg White vinegar RM 17.86 per liter 2 liters Food coloring RM 2.80 per 30ml 7 liters *data sourced from various online shopping websides like httpshttps: /pee.com.my, and various txakety unit conversion websites such as https://www.traditionalovcu.com a [8] Write down the profit (selling price - cost) generated per one whole cake for each 6 type of cakes. Attach one(1) screenshot from Microsoft Excel/LibreOffice Calc alongside with your answers. The raw answers with plenty of decimals may be kept for part 3 b. Egg b. [12] By using [Solver), determine the monthly production rate for each of the 6 types of cake (thus non-integer answers are allowed) to generate the maximum profit. Attach one(1) screenshot from Microsoft Excel LibreOffice Calc alongside with your answers, Question 2 [20 marks During the COVID-19 pandemic. A cake factory sells 6 types of cake for the whole Malaysia through online orders (hence assuming that the supply will never exceed the demand - all cakes made will be sold out). The price list is as shown in Table 4 Table 4 Type of cake Chocolate Cake Vanilla Cake Strawberry Cake Caramel Cake White Cake Red Velvet Cake Selling price per whole cake RM 103.00 RM 91.00 RM 144.00 RM 116.00 RM 83.00 RM 83.00 All the ingredients to make each one of the six types of cakes are as shown in Table 5 Table 5 Ingredients to make one whole Chocolate Vanilla Strawberry Caramel cake Cake Cake Cake Cake White Cake Red Velvet Cake 540 360 0 30 0 5 All-purpose flour (ml) 480 White sugar (ml) 480 Confectioner's sugar sifted (ml) 1200 Unsweetened cocoa powder (ml) 420 Baking powder (ml) 10 Baking soda (ml) 7.5 Salt (ml) 5 Coffee powder (ml) 7.5 Milk (ml) 360 Vegetable oil (ml) 120 Egg (qty) 2 Raw strawberries (qly) 0 Strawberry jam (ml) 0 Vanilla extract (ml) 20 Unsalted Butter (ml) 360 Shortening (ml) 0 White Vinegar (ml) 0 Food Coloring (ml) 0 0 *data sourced from a recipe website: httpsdadidapincha 765 720 0 0 10 5 5 0.3 0 0 480 0 4 0 0 17.5 240 240 0 0 720 720 960 0 0 10 0 1.55 0 270 0 5 12 60 25 480 120 0 1 720 960 0 0 0 0 10 5 0 0 480 0 4 0 0 10 360 120 0 0 0 360 360 960 0 10 0 0 1.55 0 0 285 0 5 0 0 20 480 120 0 0 0 240 0 2 0 0 s 0 0 120 15 60 The cost and the maximum monthly supply of each ingredient is as shown in Table 6. Table 6 Ingredients Cost maximum monthly supply All-purpose flour RM 4.30 per kg. 1kg is 1970ml. 203 kg White sugar RM 3.60 per kg. Ikg is 1220ml. 323 kg Icing sugar RM 4.50 per kg. Ikg is 1970ml. 178 kg Unsweetened cocoa powder RM 34.50 per kg. Ikg is 2460ml. 20.3 kg Baking powder RM 15.10 per kg. Ikg is 2960ml. 2.1 kg Baking soda RM 4.20 per kg. 1kg is 1030ml. 2.4 ky Salt RM 31.76 per kg. 1kg is 820 ml. 2.0 kg Coffee powder RM 32.00 per kg. Ikg is 4930ml. 182 grams Milk RM 5.61 per liter 240 liters Vegetable oil RM 9.25 per kg. Ikg is 1060ml. 13.2 kg RM 24.80 per tray. I tray has 36 ty 117 trays Raw strawberries RM 33.50 per tray. I tray has 50 aty 50 trays Strawberry jam RM 8.00 per liter 8 liters Vanilla extract RM 2.90 per 25ml 10 liters Unsalted Butter RM 11.80 per kg. 1kg is 1060ml. 198 kg Shortening RM 9.90 per kg. 1kg is 1230ml 65 kg White vinegar RM 17.86 per liter 2 liters Food coloring RM 2.80 per 30ml 7 liters *data sourced from various online shopping websides like httpshttps: /pee.com.my, and various txakety unit conversion websites such as https://www.traditionalovcu.com a [8] Write down the profit (selling price - cost) generated per one whole cake for each 6 type of cakes. Attach one(1) screenshot from Microsoft Excel/LibreOffice Calc alongside with your answers. The raw answers with plenty of decimals may be kept for part 3 b. Egg b. [12] By using [Solver), determine the monthly production rate for each of the 6 types of cake (thus non-integer answers are allowed) to generate the maximum profit. Attach one(1) screenshot from Microsoft Excel LibreOffice Calc alongside with your answers
