Question 3 (18 marks) Assume you own a cake house and have 100 cakes in storage. During the seasonal period, you sell certain % for the highest price of RM50 and a certain % for the lower price of RM20. For instance, if you sell 60% for the highest price and 40% for the lowest price, what will be the total profit? By using Excel spreadsheet, show step-by-step formula and the final answer.

Question 4 (22 marks) Sometimes during the peak seasons or special events, your percentage of the cake price fluctuates. In this situation, you may need to use Scenario Manager to create the various percentages. Create FIVE (5) scenario values starting from 60%, and your change cell will be C4 (use the Question 3 design) for your cakes. Provide each step (starts from selecting Scenario Manager) by screen shots and proof the changes in cell C4.