Question: Order # Sales Rep. Customer # Order date Product # Quantity Unit price Total cost Revenue 101 Prabnith 101219/23/2019 product 223$8184 $14,765.00 102 Faith 101227/24/2019

Order # Sales Rep. Customer # Order date Product # Quantity Unit price Total cost Revenue 101 Prabnith 101219/23/2019 product 223$8184 $14,765.00 102 Faith 101227/24/2019 product 86$18108 $14,978.00 103 Parneet 101235/15/2019 product 1067$13247 $9,851.00 104 Sam 101241/30/2019 product 113$14301 $20,198.00 105 Putin 101252/17/2019 product 524$495 $30,921.00 106 Damian 101264/18/2019 product 734$16231 $42,761.00 107 Jesse 101279/25/2019 product 365$1787 $45,126.00 108 Singh 101286/3/2019 product 414$2256 $8,126.00 109 Izzy 101296/17/2019 product 633$3068 $71,264.00 110 Mercy 1013010/22/2019 product 925$1179 $11,900.00 Required: 1. Enter the above data in an excel sheet 2. Create a bar chart to depict the sales representative and total cost revenue 3. Label each bar against the name of sales representative

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 General Management Questions!

1. Increasing the promotional budget for a product in order to increase awareness is not advisable in the short run under which of the following circumstances? Select: 1 Demand in the segment is...

Please help with assignment 2 MAC2601. assignment attched MAC2601/103/1/2016 Tutorial letter 103/1/2016 Principles of Management Accounting MAC2601 Semester 1 Department of Management Accounting...

Hi there I need help answering ASSIGNMENT 1 ONLY by Friday afternoon. I have attached the study pack to help answer the question. Thanks! FIN4802 ASSIGNMENTS ASSIGNMENT 01 Due date: 13 May 2016...

Refer to Figure, the level 0 DFD of Suprinas order entry system. Use Microsoft Visio or other diagraming software. a. Construct a diagram 1 that explodes process 1.0, Capture customer order, down to...

[3 View 125% Zoom v 'll (9+in lnsert Table Chart Text Shape Media Collaborate AdVva ntage Process Management Class Project Case Study Deliverable 2 Scope Overview Wholesale Large Format Printing....

Based on the interview conducted with a sales representative (see transcript below), complete the following three deliverables: 1.A3/Charter:Using the template posted on Canvas, complete the...

Accounting information system please prepare a table of entities and activities for Narrative 1. An example of the table of entities and activities can be found in Table 4.2 there is no extra...

7) Data Design: In a Context Diagram, an external entity is an external person or anything that interacts with an information system. In data design, however, the definition is slightly different. In...

AG22 A B C EFGHIJK In the green cells calculate Shipping Expense using the data on the "Region" and "Customer" data tables in columns 1 and J. If "Warehouse" and "Location" comprise the same letter...

You need to write an Outline for starting a new business

Propose a mechanism for the following reaction: H,NCCH CH CHCO ADP O-P-O OCCH CH2CHCO NH3 ATP NH3 +NH3 OH

The commonly accepted method for valuing inventory that produces an inventory of newer items is referred to as: Question 3 4 Select one: a . FIFO, or "first - in , first - out" b . LIFO, or "last -...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...