MGAC01H3 Study Guide - Midterm Guide: John Wiley & Sons, Debt Service Coverage Ratio, Cash Flow Statement
Get access
Related Documents
Related Questions
Week One: Hands-on MIS Application Software ExerciseSolution
Store & Region Sales Database
This exercise helps students understand how a raw file of salestransactions can be analyzed to produce valuable information formanagers. Your challenge is to ask the right questionsabout the data and then present your case!
Import the data into Excel or Access (or compatiblespreadsheet/database). Use the data to perform the belowanalyses:
Analyze ALL THREE of the below items:
1.Best Performing Regions by TotalRevenue
2.Best Performing Stores by TotalRevenue
3.Best Selling Products by TotalRevenue
Select ONLY ONE of the below items:
A.Strongest Selling Period for eachProduct by Total Revenue
B.Strongest Selling Period for eachRegion by Total Revenue
C.Strongest Selling Period for eachStore by Total Revenue
Provide a business case – in the form of ONE descriptiveparagraph and ONE data table-- for eachanalysis. Each paragraph must refer to the informationpresented in the table using the labeled Table #. UseAPA format to label your tables.
SUBMIT– your final report with one WORDdocument and one EXCEL/ACCESS file.
Store & Region Sales Database | |||||||
ID | StoreNo | SalesRegion | ItemNo | ItemDescription | UnitPrice | UnitsSold | WeekEnding |
1 | 1 | South | 2005 | 17"Monitor | $229.00 | 28 | 10/27/10 |
2 | 1 | South | 2005 | 17"Monitor | $229.00 | 30 | 11/24/10 |
3 | 1 | South | 2005 | 17"Monitor | $229.00 | 9 | 12/29/10 |
4 | 1 | South | 3006 | 101Keyboard | $19.95 | 30 | 10/27/10 |
5 | 1 | South | 3006 | 101Keyboard | $19.95 | 35 | 11/24/10 |
6 | 1 | South | 3006 | 101Keyboard | $19.95 | 39 | 12/29/10 |
7 | 1 | South | 6050 | PC Mouse | $8.95 | 28 | 10/27/10 |
8 | 1 | South | 6050 | PC Mouse | $8.95 | 3 | 11/24/10 |
9 | 1 | South | 6050 | PC Mouse | $8.95 | 38 | 12/29/10 |
10 | 1 | South | 8500 | DesktopCPU | $849.95 | 25 | 10/27/10 |
11 | 1 | South | 8500 | DesktopCPU | $849.95 | 27 | 11/24/10 |
12 | 1 | South | 8500 | DesktopCPU | $849.95 | 33 | 12/29/10 |
13 | 2 | South | 2005 | 17"Monitor | $229.00 | 8 | 10/27/10 |
14 | 2 | South | 2005 | 17"Monitor | $229.00 | 8 | 11/24/10 |
15 | 2 | South | 2005 | 17"Monitor | $229.00 | 10 | 12/29/10 |
16 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 10/27/10 |
17 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 11/24/10 |
18 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 12/29/10 |
19 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 10/27/10 |
20 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 11/24/10 |
21 | 2 | South | 6050 | PC Mouse | $8.95 | 8 | 12/29/10 |
22 | 2 | South | 8500 | DesktopCPU | $849.95 | 18 | 10/27/10 |
23 | 2 | South | 8500 | DesktopCPU | $849.95 | 18 | 11/24/10 |
24 | 2 | South | 8500 | DesktopCPU | $849.95 | 20 | 12/29/10 |
25 | 3 | South | 2005 | 17"Monitor | $229.00 | 38 | 10/27/10 |
26 | 3 | South | 2005 | 17"Monitor | $229.00 | 30 | 11/24/10 |
27 | 3 | South | 2005 | 17"Monitor | $229.00 | 3 | 12/29/10 |
28 | 3 | South | 3006 | 101Keyboard | $19.95 | 30 | 10/27/10 |
29 | 3 | South | 3006 | 101Keyboard | $19.95 | 32 | 11/24/10 |
30 | 3 | South | 3006 | 101Keyboard | $19.95 | 33 | 12/29/10 |
31 | 3 | South | 6050 | PC Mouse | $8.95 | 25 | 10/27/10 |
32 | 3 | South | 6050 | PC Mouse | $8.95 | 5 | 11/24/10 |
33 | 3 | South | 6050 | PC Mouse | $8.95 | 26 | 12/29/10 |
34 | 3 | South | 8500 | DesktopCPU | $849.95 | 28 | 10/27/10 |
35 | 3 | South | 8500 | DesktopCPU | $849.95 | 27 | 11/24/10 |
36 | 3 | South | 8500 | DesktopCPU | $849.95 | 29 | 12/29/10 |
37 | 4 | North | 2005 | 17"Monitor | $229.00 | 18 | 10/27/10 |
38 | 4 | North | 2005 | 17"Monitor | $229.00 | 20 | 11/24/10 |
39 | 4 | North | 2005 | 17"Monitor | $229.00 | 4 | 12/29/10 |
40 | 4 | North | 3006 | 101Keyboard | $19.95 | 12 | 10/27/10 |
41 | 4 | North | 3006 | 101Keyboard | $19.95 | 24 | 11/24/10 |
42 | 4 | North | 3006 | 101Keyboard | $19.95 | 36 | 12/29/10 |
43 | 4 | North | 6050 | PC Mouse | $8.95 | 29 | 10/27/10 |
44 | 4 | North | 6050 | PC Mouse | $8.95 | 11 | 11/24/10 |
45 | 4 | North | 6050 | PC Mouse | $8.95 | 38 | 12/29/10 |
46 | 4 | North | 8500 | DesktopCPU | $849.95 | 21 | 10/27/10 |
47 | 4 | North | 8500 | DesktopCPU | $849.95 | 24 | 11/24/10 |
48 | 4 | North | 8500 | DesktopCPU | $849.95 | 30 | 12/29/10 |
49 | 5 | North | 2005 | 17"Monitor | $229.00 | 27 | 10/27/10 |
50 | 5 | North | 2005 | 17"Monitor | $229.00 | 25 | 11/24/10 |
51 | 5 | North | 2005 | 17"Monitor | $229.00 | 23 | 12/29/10 |
52 | 5 | North | 3006 | 101Keyboard | $19.95 | 80 | 10/27/10 |
53 | 5 | North | 3006 | 101Keyboard | $19.95 | 82 | 11/24/10 |
54 | 5 | North | 3006 | 101Keyboard | $19.95 | 75 | 12/29/10 |
55 | 5 | North | 6050 | PC Mouse | $8.95 | 65 | 10/27/10 |
56 | 5 | North | 6050 | PC Mouse | $8.95 | 24 | 11/24/10 |
57 | 5 | North | 6050 | PC Mouse | $8.95 | 55 | 12/29/10 |
58 | 5 | North | 8500 | DesktopCPU | $849.95 | 55 | 10/27/10 |
59 | 5 | North | 8500 | DesktopCPU | $849.95 | 57 | 11/24/10 |
60 | 5 | North | 8500 | DesktopCPU | $849.95 | 47 | 12/29/10 |
61 | 6 | East | 2005 | 17"Monitor | $229.00 | 24 | 10/27/10 |
62 | 6 | East | 2005 | 17"Monitor | $229.00 | 85 | 11/24/10 |
63 | 6 | East | 2005 | 17"Monitor | $229.00 | 56 | 12/29/10 |
64 | 6 | East | 3006 | 101Keyboard | $19.95 | 52 | 10/27/10 |
65 | 6 | East | 3006 | 101Keyboard | $19.95 | 58 | 11/24/10 |
66 | 6 | East | 3006 | 101Keyboard | $19.95 | 69 | 12/29/10 |
67 | 6 | East | 6050 | PC Mouse | $8.95 | 35 | 10/27/10 |
68 | 6 | East | 6050 | PC Mouse | $8.95 | 39 | 11/24/10 |
69 | 6 | East | 6050 | PC Mouse | $8.95 | 44 | 12/29/10 |
70 | 6 | East | 8500 | DesktopCPU | $849.95 | 78 | 10/27/10 |
71 | 6 | East | 8500 | DesktopCPU | $849.95 | 88 | 11/24/10 |
72 | 6 | East | 8500 | DesktopCPU | $849.95 | 99 | 12/29/10 |
73 | 7 | East | 2005 | 17"Monitor | $229.00 | 34 | 10/27/10 |
74 | 7 | East | 2005 | 17"Monitor | $229.00 | 36 | 11/24/10 |
75 | 7 | East | 2005 | 17"Monitor | $229.00 | 35 | 12/29/10 |
76 | 7 | East | 3006 | 101Keyboard | $19.95 | 49 | 10/27/10 |
77 | 7 | East | 3006 | 101Keyboard | $19.95 | 47 | 11/24/10 |
78 | 7 | East | 3006 | 101Keyboard | $19.95 | 48 | 12/29/10 |
79 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 10/27/10 |
80 | 7 | East | 6050 | PC Mouse | $8.95 | 42 | 11/24/10 |
81 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 12/29/10 |
82 | 7 | East | 8500 | DesktopCPU | $849.95 | 55 | 10/27/10 |
83 | 7 | East | 8500 | DesktopCPU | $849.95 | 57 | 11/24/10 |
84 | 7 | East | 8500 | DesktopCPU | $849.95 | 55 | 12/29/10 |
85 | 8 | East | 2005 | 17"Monitor | $229.00 | 18 | 10/27/10 |
86 | 8 | East | 2005 | 17"Monitor | $229.00 | 17 | 11/24/10 |
87 | 8 | East | 2005 | 17"Monitor | $229.00 | 23 | 12/29/10 |
88 | 8 | East | 3006 | 101Keyboard | $19.95 | 22 | 10/27/10 |
89 | 8 | East | 3006 | 101Keyboard | $19.95 | 18 | 11/24/10 |
90 | 8 | East | 3006 | 101Keyboard | $19.95 | 22 | 12/29/10 |
91 | 8 | East | 6050 | PC Mouse | $8.95 | 14 | 10/27/10 |
92 | 8 | East | 6050 | PC Mouse | $8.95 | 16 | 11/24/10 |
93 | 8 | East | 6050 | PC Mouse | $8.95 | 17 | 12/29/10 |
94 | 8 | East | 8500 | DesktopCPU | $849.95 | 32 | 10/27/10 |
95 | 8 | East | 8500 | DesktopCPU | $849.95 | 28 | 11/24/10 |
96 | 8 | East | 8500 | DesktopCPU | $849.95 | 30 | 12/29/10 |
Jennifer Lopez opened a school for administrative skills called Lopez Office Training and completed the following transactions:
a. Contributed the following assets to the business:
Cash | $5,700 |
Computers | 4,300 |
Office Equipment | 3,600 |
b. Found a location for her business and paid the first month’s rent, $260.
c. Paid for an advertisement announcing the opening of the school, $190.
d. Received applications from three students for a four-week administrative program and two students for a ten-day keyboarding course. The students will be billed a total of $1,300.
e. Purchased supplies on credit, $330.
f. Billed the enrolled students, $1,740.
g. Purchased a second-hand computer, $480, and office equipment, $380, on credit.
h. Paid for the supplies purchased on credit in e, $330.
i. Paid cash to repair a broken computer, $40.
j. Received partial payment from students previously billed, $1,080.
k. Paid the utility bill for the current month, $90.
l. Paid an assistant one week’s salary, $440.
m. Made a cash withdrawal of $300.
Hint(s)
1. Record the transactions directly in the T accounts, using the transaction letter to identify each debit and credit. Enter in the order presented above.
Cash | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 1 of Item 1 | Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 3 of Item 1 | ||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 5 of Item 1 | Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 7 of Item 1 | ||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 9 of Item 1 | |||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 11 of Item 1 | |||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 13 of Item 1 | |||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 15 of Item 1 | |||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 17 of Item 1 | |||
Bal. |
Accounts Receivable | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 22 of Item 1 | Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 24 of Item 1 | ||
Bal. |
Supplies | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 27 of Item 1 |
Computers | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 29 of Item 1 | |||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 31 of Item 1 | |||
Bal. |
Office Equipment | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 34 of Item 1 | |||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 36 of Item 1 | |||
Bal. |
Accounts Payable | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 39 of Item 1 | Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 41 of Item 1 | ||
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 43 of Item 1 | |||
Bal. |
J. Lopez, Capital | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 48 of Item 1 |
J. Lopez, Withdrawals | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 50 of Item 1 |
Tuition Revenue | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 52 of Item 1 |
Salaries Expense | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 54 of Item 1 |
Utilities Expense | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 56 of Item 1 |
Rent Expense | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 58 of Item 1 |
Repair Expense | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 60 of Item 1 |
Advertising Expense | |||
---|---|---|---|
Selecta.b.c.d.e.f.g.h.i.j.k.l.m.Correct 62 of Item 1 |
Hint(s)
2. Prepare a trial balance using today's date. List all the accounts, in the order the T accounts are given. If an amount box does not require an entry, enter "0".
|
Hi I need help in financial accounting please..
Listed below are selected accounts.In the dropdowns provided for each account, indicate what type ofaccount it is, its normal balance, and the debit/credit rules forincreasing and decreasing it. Use the following abbreviations foryour answer:
|