Question: fPART B: Pivot Table and Recommended Charts (5 marks) i. Calculate gross profit for each customer along with product name and payment type using Pivot

$\fPART B: Pivot Table and Recommended Charts (5 marks) i. Calculate$ gross profit for each customer along with product name and payment type

\fPART 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

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...

please answer instructions 1-9 for a like! please and thank you! Y019_Excel_Ch06_Prepare_PartB_Sales_Analysis Project Description: Aleeta Herriott manager of the Red Blut Pro Shop, would like to...

N5 fx G H - K F 1 Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience stores in Australia. 2 You are provided with the information related to its...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

NEED STEP BY STEP PROCESS Exp19_Excel_Ch06_Cap_High_West Fashions_Instructions - Protected View - Saved to this PC References Mailings Review View Help Tell me what you want to do et can contain...

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...

Learning Objectives When you have finished this assignment, you should be able to: 1. Create pivot tables to analyze data. 2. Format numbers in pivot tables. 3. Calculate gross profit for a...

Suppose a firm produces its output in two different plants. Production costs at plant 1 are given by C1 = 4(Q1)2, where Q1 is the amount of production at plant 1. The production costs at plant 2 are...

What is a cognitive bias? What are examples of cognitive biases? What is a black swan phenomenon? How do cognitive biases and black swan phenomena affect strategic planning for information systems?

Find the rate of change of total revenue cost, profit with respect to time. Assume that k ( x ) and ( x ) are in dollars R ( x ) = 5 5 x - 0 . 5 x 2 ( 6 x ) = 6 x 5 when x = 2 5 and d x a t = 2 0

Tidwell Company experienced the following during 2015: a. Sold preferred stock for $480,000. b. Declared dividends of $150,000 payable on March 1, 2016. c. Borrowed $575,000 from bank on a 2-year...

What are the types of reports that an auditor can issue for an audit of ICFR? Briefly identify the circumstances justifying each type of report.

Does the difficulty in determining the current value of an asset create a problem in determining the depreciation expense that should be charged for a year?

Corporate debt has been expanding very dramatically in the last three decades. What has been the impact on interest coverage, particularly since 1977?

For many years businesses have struggled with the rising cost of health care. But recently, the increases have slowed due to less inflation in health care prices and employees paying for a larger...

Consider the economy of Hicksonia. a. C=300+0.50[Y-T) The investment function is l=100-20t Government purchases and taxes are both 150.For this economy, use a graph to illustrate the IS curve for r...

1. Discuss the following statements: a) What we seek to achieve is different from why we seek to achieve it. b) Thoughts are different from what we are thinking about. c) Writing to find out what one...

2. Provide new information and before 20 seconds have elapsed, add more infor-mation. The initial information will then be lost from memory for most people.

7. What is the extent (percentage) of errors detected in the information collected?