Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience You are provided with the information related to its customer details, product details, and costs and Yume International has partnered with three shipping companies who ships the products to its Austr You are a junior accountant and your Senior Accounts Manager wants you to summarise this data in Required: PART- A: Complete missing information in costs and revenue information sheet (highlighted in y PART B: Pivot Table and Recommended Charts (5 marks) i. Calculate gross profit for each customer along with product name and payment type using ii. Calculate sales revenue by each salesperson using Pivot Table and illustrate it via Clustered iii. Calculate sales revenue and gross profit earned by each product using Pivot Table and illu: For Pivot Tables and charts, please use a new worksheet and label it as (Pivot and Charts). You must PART C. Discuss, justify and illustrate the following features that can be included, to help with stri SUMIF COUNTIF Forecasting Index Match Function IF with And/OR Use suitable data for the purpose of illustration, on separate sheets. Feel free to use data from this q Professional presentation is expected all through