Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACC202 Accounting Information Systems Missing Answer for Part C (Part A and B done!!) Yume International is the New Zealand largest food & beverage wholesaler

ACC202

Accounting Information Systems

Missing Answer for Part C (Part A and B done!!)

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles Volume I

Authors: Kermit Larson, Tilly Jensen, Heidi Dieckmann

16th Canadian edition

978-1260305821

More Books

Students also viewed these Accounting questions

Question

What does SMART stand for? (p. 86)

Answered: 1 week ago

Question

Annoyance about a statement that has been made by somebody

Answered: 1 week ago