1. a) Using the financial modelling techniques, complete the information in Table 1. All answer to be provided at 2 (TWO) decimal places.

   (20 marks)

2. b) Based on your answers in a), use any clustered column chart to display your total cost, total revenue and total profit findings.

Table 1 Item Total Cost Cost per Total Profit Multivitamins Collagen Herbal Tea Colostrums Oats Supplements Essence Body Wash Facial Wash Moisturizers Total Average Lowest Highest Units on Average Hand Unit 4,216 58.67 1,798 47.55 1,365 66.89 1,452 96.56 1,543 29.55 3,645 66.89 1,230 26.99 1,138 12.50 989 9.99 785 13.45 Selling Total Price per Revenue Unit 90.90 150.50 95.50 150.50 45.99 95.99 36.99 22.50 19.50 33.90 a) Using the financial modelling techniques, complete the information in Table 1. All answer to be provided at 2 (TWO) decimal places. (20 marks) b) Based on your answers in a), use any clustered column chart to display your total cost, total revenue and total profit findings