Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

Ais - When Should You Use Gl System - Assignment 2 - Very Beginning Step Essay

Open Document

Below is an essay on "Ais - When Should You Use Gl System - Assignment 2 - Very Beginning Step" from Anti Essays, your source for research papers, essays, and term paper examples.

Task 1
1. The list is useful when we would like to figure out which item is popular, unpopular in the market, how much a particular item is sold, and how many quantities of an item are sold. By listing by invoice number, we could get the information about how much a particular invoice costs and how many items and quantities the invoice has.
2.
Query2 |
InvoiceNumber | CustomerName | ItemNumber | SumOfPriceEach |
V-3 | D. Lund, Inc. | I-1 | $2,000.00 |
V-3 | D. Lund, Inc. | I-3 | $1,000.00 |
V-3 | D. Lund, Inc. | I-5 | $4,000.00 |
| | | $7,000.00 |

3.
Query4 |
CustomerName | SalespersonNumber | InvoiceNumber | AmountP |
J. P. Carpenter | S-10 | V-4 | $10,000.00 |
J. P. Carpenter | S-10 | V-2 | $1,666.00 |
J. P. Carpenter | S-10 | V-2 | $1,666.00 |

So, J.P uses (3) option.
4.
Query3 |
SalespersonNumber | SumOfAmountI |
S-10 | $87,600.00 |
S-11 | $23,000.00 |
S-12 | $7,200.00 |

5.
C-1 | V-1 | $7,200 | V-1 | $7,200 | $0 |
C-2 | V-2 | $10,000 | V-2 | $3,332 | $6,668 |
C-2 | V-4 | $10,000 | V-4 | $10,000 | $0 |
C-3 | V-6 | $35,000 |   |   | $35,000 |
C-4 | V-7 | $23,000 |   |   | $23,000 |
C-5 | V-3 | $16,000 | V-3 | $16,000 | $0 |
C-5 | V-5 | $16,600 | V-5 | $16,600 | $0 |

6.
Query2 |
InvoiceNumber | Quantity | PriceEach | Expr1 |
V-1 | 1 | $2,000.00 | $2,000.00 |
V-1 | 2 | $600.00 | $1,200.00 |
V-2 | 2 | $5,000.00 | $10,000.00 |
V-3 | 1 | $2,000.00 | $2,000.00 |
V-3 | 2 | $4,000.00 | $8,000.00 |
V-3 | 6 | $1,000.00 | $6,000.00 |
V-4 | 2 | $5,000.00 | $10,000.00 |
V-5 | 2 | $300.00 | $600.00 |
V-5 | 2 | $3,000.00 | $6,000.00 |
V-5 | 2 | $5,000.00 | $10,000.00 |
V-6 | 3 | $1,575.00 | $4,725.00 |
V-6 | 10 | $3,500.00 | $35,000.00 |
V-7 | 2 | $7,000.00 | $14,000.00 |
V-7 | 3 | $3,000.00 | $9,000.00 |
V-1 and V-6 were wrong.
Based on V-1, S-12’s sales decreases by 3,200. Carl Beers should refund to C-1 by 3,200.
Based on V-6, S-10’s sales increases by 4,725. But, Carl Beers...

Show More


Citations

MLA Citation

"Ais - When Should You Use Gl System - Assignment 2 - Very Beginning Step". Anti Essays. 10 Dec. 2018

<http://parimatchstavki7.com/free-essays/Ais-When-Should-You-Use-507476.html>

APA Citation

Ais - When Should You Use Gl System - Assignment 2 - Very Beginning Step. Anti Essays. Retrieved December 10, 2018, from the World Wide Web: http://parimatchstavki7.com/free-essays/Ais-When-Should-You-Use-507476.html