MGAC01H3 Study Guide - Midterm Guide: John Wiley & Sons, Debt Service Coverage Ratio, Cash Flow Statement

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.

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:

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.

Hint(s)

Hi I need help in financial accounting please..