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
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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question
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
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education