Calculate sale revenue by each salesperson using pivot table

Assignment Help Managerial Accounting

Reference no: EM132640659

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

Required:

Pivot Table and Recommended Charts

Question i. Calculate gross profit for each customer along with product name and payment type

Question ii. Calculate sales revenue by each salesperson using Pivot Table and illustrate it via Clustered

Question iii. Calculate sales revenue and gross profit earned by each product using Pivot Table

Reference no: EM132640659

Questions Cloud

Business plan on family owned barbershop : Design a Cover Page for the business plan that includes relevant information. The Cover Page is the first impression so make it look impressive.

Discuss the performing keyword searches : When you decide to purchase a new car, you first decide what is important to you. If mileage and dependability are the important factors, you will search.

What flat fee for mabel return would the firm be : What flat fee for Mabel's return would the firm be indifferent between the two clients, assuming no time constraints for completing the returns?

Biodiversity is critical topic globally : Explain how the economic situation of a town, city, or country could lead to biodiversity loss. Biodiversity is a critical topic globally.

Calculate sale revenue by each salesperson using pivot table : Yume International is the New Zealand largest food & beverage. Calculate sales revenue by each salesperson using Pivot Table and illustrate it via Clustered

Explain your diagnosis for patient including your rationale : Explain your diagnosis for the patient, including your rationale for the diagnosis. Describe an appropriate drug therapy plan based on the patient's history.

Website articles and peer-reviewed journals : Everyone should discuss how they did their research - whether it be with website articles, peer-reviewed journals, books or other sources.

What is crime theory : This is a criminal justice class. What is crime theory.

Write about why you picked the stressor : Write about why you picked this stressor, and what you would like to change. Describe how you experience this stress physically, psychologically, spiritually.

User Account

All Pages