(1) retrieve the names of employees in department 5 who work more than 10 hours per week on the 'productx' project. (2) list the names of employees who have a dependent with the same first name as themselves. (3) find the names of employees that are directly supervised by 'franklin wong'. (4) for each project, list the project name and the total hours per week (by all employees) spent on that project. (5) retrieve the names of employees who work on every project of jpl. (6) retrieve the names of employees who do not work on any project of jpl. (7) for each department, retrieve the department name, and the average salary of employees working in that department. (8) retrieve the average (total) working hour (on all projects) of all female employees. (9) find the names and addresses of employees who work on at least one project located in houston but whose department has no location in houston. (10) list the last names of department managers who have no dependents.

What is "staffing level"? a) the practice of assigning the same number of workers to each department b) the average educational level attained by employees of a business c) the rank above cashier d) the number of workers assigned to jobs at a particular time

Barbara jones opened barb’s book business on february 1, 2010. the company specilizes in editing accounting textbooks. you have been hired as manager. your duties include maintaining the company’s financial records. the following transactions occurred in february , the first month of operations. a. received shareholders' cash contributions on february 1 totaling $16,000 to form the corporation; issued 1,000 shares of common stock. b. paid $2,400 cash on february 2 for three months' rent for office space. tip: for convenience, simply record the full amount of the payment as an asset (prepaid rent). at the end of the month, this account will be adjusted to its proper balance. c. purchased and received supplies on february 3 for $300 cash. d. signed a promissory note on february 4, payable in two years; deposited $10,000 in the company's bank account. e. on february 5, paid cash to buy equipment for $2,500 and land for $7,500. f. placed an advertisement in the local paper on february 6 for $425 cash. g. recorded sales on february 7 totaling $1,800; $1,525 was in cash and the rest on accounts receivable. h. collected accounts receivable of $50 from customers on february 8. i. on february 9, repaired one of the computers for $120 cash. tip: most repairs involve costs that do not provide additional future economic benefits. j. incurred and paid employee wages on february 28 of $420.required: set up appropriate t-accounts for cash, accounts receivable, supplies, prepaid rent, equipment, furniture and fixtures, notes payable, contributed capital, service revenue, advertising expense, wages expense, and repair expense. all accounts begin with zero balances. tip: when preparing the t-accounts, you might find it useful to group them by type: assets, liabilities, stockholders’ equity, revenues, and expenses.2. record in t-accounts the effects of each transaction in february, referencing each transaction in the accounts with the transaction letter. show the unadjusted ending balances in the t-accounts. 3. prepare an unadjusted trial balance at the end of february.4. refer to the revenues and expenses shown on the unadjusted trial balance. based on this information, write a short memo offering your opinion on the results of operations during the first month of business.

Depreciation on the company's equipment for 2017 is computed to be $18,000.the prepaid insurance account had a $6,000 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of the company's insurance policies showed that $1,100 of unexpired insurance coverage remains. the office supplies account had a $700 debit balance on december 31, 2016; and $3,480 of office supplies were purchased during the year. the december 31, 2017, physical count showed $300 of supplies available. two-thirds of the work related to $15,000 of cash received in advance was performed this period. the prepaid insurance account had a $6,800 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of insurance policies showed that $5,800 of coverage had expired. wage expenses of $3,200 have been incurred but are not paid as of december 31, 2017.