ACC202

Accounting Information Systems

Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience stores in Australia. You are provided with the information related to its customer details, product details, and costs and revenue information sheet. Yume International has partnered with three shipping companies who ships the products to its Australian customers on time. You are a junior accountant and your Senior Accounts Manager wants you to summarise this data in a meaningful way. Required: PART- A: Complete missing information in costs and revenue information sheet (highlighted in yellow colour) (5 marks) PART B: Pivot Table and Recommended Charts (5 marks) i. Calculate gross profit for each customer along with product name and payment type using Pivot Table; categorising the columns by salesperson ii. Calculate sales revenue by each salesperson using Pivot Table and illustrate it via Clustered Bar Chart iii. Calculate sales revenue and gross profit earned by each product using Pivot Table and illustrate it via 100%% stacked line graph For Pivot Tables and charts, please use a new worksheet and label it as (Pivot and Charts). You must use relevant Excel functions for the tasks assigned. Do not calculate it manually. PART C. Discuss, justify and illustrate the following features that can be included, to help with strategic decision making. (10 marks) 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 question / other sources. Professional presentation is expected all through