Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience You are provided with the information related to its customer
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started