Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Order Date Region Rep Item Units Unit cost Total sales 06/01/2018 East Jones Pencil 95 1.99 189.05 23/01/2018 Central Kivell Binder 50 19.99 999.5 09/02/2018
Order Date | Region | Rep | Item | Units | Unit cost | Total sales |
06/01/2018 | East | Jones | Pencil | 95 | 1.99 | 189.05 |
23/01/2018 | Central | Kivell | Binder | 50 | 19.99 | 999.5 |
09/02/2018 | Central | Jardine | Penil | 36 | 4.99 | 179.64 |
26/02/2018 | Central | Gill | Pen | 27 | 19.99 | 539.73 |
15/03/2018 | West | Sorvino | Pencil | 56 | 2.99 | 167.44 |
01/04/2018 | East | Jones | Binder | 60 | 4.99 | 299.4 |
18/04/2018 | Central | Andrews | Pencil | 75 | 1.99 | 149.25 |
05/05/2018 | Central | Jardine | Pencil | 90 | 4.99 | 449.1 |
22/05/2018 | West | Thompson | Pencil | 32 | 1.99 | 63.68 |
08/06/2018 | East | Jones | Binder | 60 | 8.99 | 539.4 |
25/06/2018 | Central | Morgan | Pencil | 90 | 4.99 | 449.1 |
12/07/2018 | East | Howard | Binder | 29 | 1.99 | 57.71 |
29/07/2018 | East | Parent | Binder | 81 | 19.99 | 1,619.19 |
15/08/2018 | East | Jones | Pencil | 35 | 4.99 | 174.65 |
01/09/2018 | Central | Smith | Desk | 2 | 125.00 | 250.00 |
18/09/2018 | East | Jones | Pen Set | 16 | 15.99 | 255.84 |
5/10/2018 | Central | Morgan | Binder | 28 | 8.99 | 251.72 |
22/10/2018 | East | Jones | Pencil | 64 | 8.99 | 575.36 |
8/11/2018 | East | Parent | Pencil | 15 | 19.99 | 299.85 |
25/11/2018 | Central | Kivell | Pen Set | 96 | 4.99 | 479.04 |
12/12/2018 | Central | Smith | Pencil | 67 | 1.29 | 86.43 |
29/12/2018 | East | Parent | Pen Set | 74 | 15.99 | 1,183.26 |
15/01/2019 | Central | Gill | Binder | 46 | 8.99 | 413.54 |
01/02/2019 | Central | Smith | Binder | 87 | 15.00 | 1,305.00 |
18/02/2019 | East | Jones | Binder | 4 | 4.99 | 19.96 |
07/03/2019 | west | Sorvino | Binder | 7 | 19.99 | 139.93 |
24/03/2019 | Central | Jardine | Pen Set | 50 | 4.99 | 249.5 |
how to calculate >
Average Unit Cost for the period June 2018 to end March 2019
Total Units sold between June 2018 and March 2019
Total Sales for the period June 2018 to end March 2019
Students must also present the following information visually (in a suitable chart):
Total number of each item sold, by month from June 2018 to end March 2019
Percentage of monthly sales by month from June 2018 to end March 2019
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started