Questions
The yearly salary (in thousands of dollars) for a small company are listed below. Find the...

The yearly salary (in thousands of dollars) for a small company are listed below. Find the mode, mean, median and population standard deviation and use the Empirical Rule to find a 95% confidence interval. 74 67 39 75 98 67 460 96

In: Statistics and Probability

Prepare entries, in general journal form, to record the following transactions in the proper fund(s) and/or...

Prepare entries, in general journal form, to record the following transactions in the proper fund(s) and/or account group(s). Designate the fund or account group in which each entry is recorded.

1.   Bond proceeds of $2,000,000 were received to be used in constructing a new City Jail. An equal amount is contributed from general revenues.

2.   Serial bonds in the amount of $300,000 matured. Interest of $75,000 was paid on these and other serial bonds outstanding.

3.   Insurance proceeds amounting to $19,000 were received as a result of the accidental destruction of a garbage truck costing $33,000. Accumulated depreciation on the truck was $21,000.

4.   The City Parks Endowment Fund transferred $160,000 in expendable funds to the City Parks Special Revenue Fund.

5.   Proceeds of $21,000 were received from the sale of equipment which had been purchased from general revenues at a cost of $100,000. Accumulated depreciation on the equipment was $75,000.

6.   The City Power Company (an enterprise fund) issued a bill for $400,000 for electricity provided to municipal government buildings.

7.   The City Power Company transferred excess funds of $90,000 to the General Fund.

8.   A central data processing center was established by a contribution of $400,000 from the General Fund, a long-term loan of $130,000 from the City Parks Special Revenue Fund, and general obligation bond proceeds of $180,000.

9.   The Data Processing Fund billed the General Fund $20,000 and the City Parks Special Revenue Fund $8,500 for data processing services.

            10. The City Power Company received $7,000 as customer deposits during the year. The monies are to be held in     trust until customers request that their services be discontinued and final bills are collected.

11. In order to retire general obligation term bonds when they become due, it is determined that the Debt Service Fund will require annual contributions of $40,000 and earnings in the current year of $3,000.

In: Accounting

General, Inc. leases equipment to different types of businesses. The company generally acquires the equipment and...

General, Inc. leases equipment to different types of businesses. The company generally acquires the equipment and leases the equipment to its customers under long-term sales-type leases. General’s implicit interest in the lease arrangements is 10% annual rate.

General leased its machine that it purchased for $30,900 to a lessee, Oscar Company on January 1, 2018. The lease contract specified annual payments of $8,000 beginning January 1, 2018, the beginning of the lease, and each January 1 through 2020 (three-year lease term). Oscar Company has the option to purchase the machine at the end of the lease term, December 31, 2020, for $12,000 when it is expected to have a residual value of $16,000, considered a bargain purchase amount. The Company’s year-end is 12/31.

Required:

1. Show how General calculated the $8,000 annual lease payments for this sales-type lease.

2. Prepare an amortization schedule that describes the pattern of interest revenue for General, Inc. over the lease term.

3. Prepare the appropriate entries for General, Inc. from the beginning of the lease through the end of the lease term.

In: Accounting

Problem #1 Professor Quark opens his own company, Electronic Tutorial Services, and completes the following transactions...

  1. Problem #1 Professor Quark opens his own company, Electronic Tutorial Services, and completes the following transactions in June:
  • 6/1 Quark invests $12,000 into the business.
  • 6/3 Purchased $1,800 of equipment on account.
  • 6/4 Paid $360 for a two-year insurance policy.
  • 6/6 Purchased office supplies for cash, $300.
  • 6/9 Purchased a new computer for $7,500. Paid $1,500 cash agreed to pay the remainder in 30 days.
  • 6/10 Billed student Fiona Smith $40 for tutorial services that were performed.
  • 6/14 Paid for the equipment purchased on June 3rd.
  • 6/25 Received $35 cash from student Bert Bantrum for tutorial services performed.
  • 6/30 Student billed on June 10 pays the amount due to Quark.
  • 6/30 Quark withdraws $500 for personal use.

Required: Prepare the journal entries to record these transactions. How much cash did Professor Quark have at the end of June?

  1. Problem #2 Maria Sanchez started the Merry Mowers lawncare business. She began operations on May 1st and completed the following transactions, which included her initial investment of $8,000 cash. After these transactions, the ledger included the following accounts with normal balances.
  • Cash $ 9,440     
  • Office Supplies 500        
  • Equipment 3,000     
  • Accounts Payable 500        
  • Notes Payable 2,000     
  • Maria Sanchez, Capital 8,000     
  • Lawncare Revenue 3,200     
  • Gas and Oil Expense 210        

Required: Prepare a balance sheet and income statement for this business at the end of May.

  1. Problem #3 Below are accounts listed for September for PC Partners, a company that installs/repairs home computers for customers. The business is owned by Ed Connor. The accounts are listed in alphabetical order. For the month of September, prepare an income statement and a balance sheet.

ACCOUNT BALANCE

Accounts Payable 4,200

Accounts Receivable 8,480

Advertising expense 420

Capital (Ed Connor) at 08/31/04 56,000

Cash 35,460

Entertainment Expense 600

Equipment 15,700

Installation Revenue 15,600

Miscellaneous Revenue 800

Photocopying Expense 150

Rent Expense 1,300

Repair Revenue 8,650

Supplies 8,400

Truck 8,500

Unearned Revenue 760

In: Accounting

. Kurbe Marketing Research Kurbe Marketing Research (KMR), located in Boston, specializes in marketing research in...

. Kurbe Marketing Research

Kurbe Marketing Research (KMR), located in Boston, specializes in marketing research in the consumer goods industry. Each year KMR conducts hundreds of research studies for a variety of clients utilizing focus groups, internet surveys and telephone surveys. KMR is currently studying the resources it dedicates to telephone surveys.

Demand for KMR’s telephone research varies throughout the year. KMR conducts the vast majority of its research in-house, but if it cannot handle all of the work at peak demand times, it is forced to subcontract some of the phone interviewing, which results in a lower profit margin. Also, outsourcing the phone interviews means that KMR loses some control of the process. This can result in problems such as missed deadlines and a decrease in quality. However, dedicating enough resources to ensure no outsourcing would not be very efficient, since it would result in more costs and decreased productivity due to idle time during slower periods. Nonetheless, based on the recent amount of outsourcing, KMR management feels that the company has too few operators conducting telephone survey research. You have been assigned the task of studying this problem and making a recommendation.

The annual fixed costs (management, facilities and other overhead charges) associated with the telephone survey group are $320,000. Every operator needs a computer-assisted telephone interviewing station (known as a CATI). Currently KMR has 48 CATIs and they are considering purchasing additional ones this year. Of the 48 CATIs currently on hand, 16 per year will be replaced each year for the next 3 years. New CATIs will not need replacement over this time period.

The purchase cost of a CATI is $36,000 and is likely to remain stable for the next 3 years. The cost of an operator (one per CATI) per month is $2,200. Assume that only additional CATIs (beyond the current number of 48) require training (replacement CATIs do not since they already have operators).

The time frame for the study is the next three years. Demand varies by month and forecasted demand for the coming year is shown in the table below (demand is expressed in dollars of revenue). A CATI can handle approximately $12,000 of work per month. Demand is expected to grow by 10% per year (the forecasted amounts in the table have already factored this in for next year). Assume that each month’s demand will grow by this amount in years 2006 and 2007. This increase in revenue will come from increased volume of work rather than increases in pricing (the forecast assumes stable pricing).

Month             Demand ($000)

January                        $890

February                      $820

March                          $575

April                            $860

May                             $695

June                             $330

July                              $740

August                        $700

September                   $255

October                       $750

November                   $170

December                    $160

Forecasted demand (in dollars of revenue) for 2005

Management is looking for the best level of in-house operation (number of CATIs). KMR receives 15% of the revenue for the work that is outsourced to an outside vendor. Finally, for studies such as this, KMR uses an annual discount rate of 10% and their tax rate is 34%.

a. Build a spreadsheet to help KMR analyze this situation. In your base case, evaluate the NPV of net income after taxes assuming KMR maintains 48 CATIs in all years.

You may use the following page to sketch your spreadsheet (although your sketch will not be graded). Your spreadsheet will be graded both for its technical correctness and for its adherence to the principles of spreadsheet engineering. Note, however, that documentation is not required, nor is extensive formatting for appearance.

b. Construct a graph on a separate sheet in your workbook to show the sensitivity of the NPV of net income after taxes to the number of CATIs. Sketch your results here, showing numerical scales for the horizontal and vertical axes, and clearly identify the optimal number of CATIs.

c. In the base case (with 48 CATIs) how much lower does KMR’s tax rate have to be to increase the NPV of net income after taxes by 10%?

In: Accounting

In May 2004, a Gallup Poll of adults’ attitudes toward Health Maintenance Organization (HMOs) found that...

In May 2004, a Gallup Poll of adults’ attitudes toward Health Maintenance Organization (HMOs) found that 41% of adults had little or no confidence in HMOs, 38% had some confidence, 17% had a great deal or quite a lot of confidence, and 4% had no opinion (USA TODAY, June 22, 2004). Let us denote these outcomes as L, S, G, and N, respectively. A recent random sample of 500 adults yielded the frequency distribution given in the following table.   Response L S G N Frequency 212 198 82 8

a. Determine the rejection region.

b. Using the 2.5% significance level, can you conclude that the current distribution of opinions differs from the distribution of May 2004?

In: Statistics and Probability

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows:

Debit Credit
Cash $6,380
Accounts receivable 1,460
Supplies 840
Accounts payable $490
Unearned service revenue 1,370
Common stock 4,400
Retained earnings 2,420
$8,680 $8,680


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $4,400 cash and signing a 2-year note payable for $24,400. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 24,400 shares of common stock for $61,000 cash.
3 Paid $4,200 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $4,900 per month.
6 Paid $4,600 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Blue will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $1,460 cash on account from Milani Brothers. This client was billed in June when Blue performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $1,370 in advance last month. All services relating to this payment are now completed.
14 Paid $490 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $14,600 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $13,400.
20 Performed services worth $34,200 on account and billed customers.
20 Received a bill for $2,700 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $12,200 of revenue from the cash advance received July 16.
27 Received $18,300 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,550.
4. Equipment depreciation, $600 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $13,400, to be paid on August 1.
7. Estimated utilities expense for July, $980 (invoice will be received in August).
8. Income tax for July, $1,460, will be paid in August.


The chart of accounts for Blue Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

Journalize and post adjusting entries for the month ending July 31. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. Record journal entries in the order presented in the problem. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

In: Accounting

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows:

Debit Credit
Cash $6,380
Accounts receivable 1,460
Supplies 840
Accounts payable $490
Unearned service revenue 1,370
Common stock 4,400
Retained earnings 2,420
$8,680 $8,680


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $4,400 cash and signing a 2-year note payable for $24,400. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 24,400 shares of common stock for $61,000 cash.
3 Paid $4,200 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $4,900 per month.
6 Paid $4,600 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Blue will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $1,460 cash on account from Milani Brothers. This client was billed in June when Blue performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $1,370 in advance last month. All services relating to this payment are now completed.
14 Paid $490 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $14,600 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $13,400.
20 Performed services worth $34,200 on account and billed customers.
20 Received a bill for $2,700 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $12,200 of revenue from the cash advance received July 16.
27 Received $18,300 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,550.
4. Equipment depreciation, $600 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $13,400, to be paid on August 1.
7. Estimated utilities expense for July, $980 (invoice will be received in August).
8. Income tax for July, $1,460, will be paid in August.


The chart of accounts for Blue Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

Journalize the July transactions. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. Record journal entries in the order presented in the problem. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

In: Accounting

Carolyn Shaw is 27. - She works as an accountant for an oil company. - Her...

Carolyn Shaw is 27. - She works as an accountant for an oil company. - Her salary next year will be $80,000. - She expects to receive a 5 percent raise each year until she retires at age of 65. - Carolyn is considering a return to school to pursue an MBA degree. - She expects the cost of books, tuition, and fees to be $70,000 the first year and $72,000 the second. - These costs are paid at the beginning of the year (as you surely know). - She will not work while in school. - Graduates of the school Carolyn is considering receive starting salaries that average $130,000. - Raises average 7 percent per year. - Carolyn considers the opportunity costs to be 12 percent. a)Determine the present value of Carolyn’s lifetime earnings if she does not return to school. b)Determine the present value of Carolyn’s lifetime earnings with an MBA degree. Remember, she won’t start her job for two years. c) What is the NPV of an MBA degree given Carolyn Shaw's assumptions?

In: Finance

List Customer and Product Without Sale In one list return, all customers who do not have...

List Customer and Product Without Sale

In one list return, all customers who do not have an invoice and all products that were not sold. Use the UNION operator in this query. Return 3 values:
- category - Is this line related to "customer" or "product"? Print "customer" or "product" without quotes.

- id - customer.id (category="customer") or product.id (category="product")

- name - customer.customer_name (category="customer") or product.product_name (category="product")

Table definitions and a data sample are given below.

Schema

Table: customer

column name column type key / NULL
id int PK
customer_name varchar(255)
city_id int FK
customer_address varchar(255)
contact_person varchar(255) N
email varchar(128)
phone varchar(128)

Table: product

column name column type key / NULL
id int PK
sku varchar(32)
product_name varchar(128)
product_description text
current_price decimal(8,2)
quantity_in_stock int

Table: invoice

column name column type key / NULL
id int PK
invoice_number varchar(255)
customer_id int FK
user_account_id int
total_price decimal(8,2)
time_issued varchar N
time_due varchar N
time_paid varchar N
time_canceled varchar N
time_refunded varchar N

invoice.customer_id references customer.id

Table: invoice_item

column name column type key / NULL
id int PK
invoice_id int FK
product_id int FK
quantity int
price decimal(8,2)
line_total_price decimal(8,2)

invoice_item.invoice_id references invoice.id

invoice_item.product_id references product.id

Sample Data Tables

Table: customer

id customer_name city_id customer_address contact_person email phone
1 Drogerie Wien 1 Deckergasse 15A Emil Steinbach [email protected] 094234234
2 Cosmetics Store 4 Watling Street 347 Jeremy Corbyn [email protected] 093923923
3 Kosmetikstudio 3 Rothenbaumchaussee 53 Willy Brandt [email protected] 0941562222
4 Neue Kosmetik 1 Karlsplatz 2 NULL [email protected] 094109253
5 Bio Kosmetik 2 Motzstraße 23 Clara Zetkin [email protected] 093825825
6 K-Wien 1 Kärntner Straße 204 Maria Rauch-Kallat [email protected] 093427002
7 Natural Cosmetics 4 Clerkenwell Road 14B Glenda Jackson [email protected] 093555123
8 Kosmetik Plus 2 Unter den Linden 1 Angela Merkel [email protected] 094727727
9 New Line Cosmetics 4 Devonshire Street 92 Oliver Cromwell [email protected] 093202404

Table: product

id sku product_name product_description current_price quantity_in_stock
1 330120 Game Of Thrones - URBAN DECAY Game Of Thrones Eyeshadow Palette 65 122
2 330121 Advanced Night Repair - ESTEE LAUDER Advanced Night Repair Synchronized Recovery Complex II 98 51
3 330122 Rose Deep Hydration - FRESH Rose Deep Hydration Facial Toner 45 34
4 330123 Pore-Perfecting Moisturizer - TATCHA Pore-Perfecting Moisturizer & Cleanser Duo 25 393
5 330124 Capture Youth - DIOR Capture Youth Serum Collection 95 74
6 330125 Slice of Glow - GLOW RECIPE Slice of Glow Set 45 40
7 330126 Healthy Skin - KIEHL S SINCE 1851 Healthy Skin Squad 68 154
8 330127 Power Pair! - IT COSMETICS IT is Your Skincare Power Pair! Best-Selling Moisturizer & Eye Cream Duo 80 0
9 330128 Dewy Skin Mist - TATCHA Limited Edition Dewy Skin Mist Mini 20 281
10 330129 Silk Pillowcase - SLIP Silk Pillowcase Duo + Scrunchies Kit 170 0

Table: invoice

id invoice_number customer_id user_account_id total_price time_issued time_due time_paid time_canceled time_refunded
1 in_25181b07ba800c8d2fc967fe991807d9 7 4 1436 7/20/2019 3:05:07 PM 7/27/2019 3:05:07 PM 7/25/2019 9:24:12 AM NULL NULL
2 8fba0000fd456b27502b9f81e9d52481 9 2 1000 7/20/2019 3:07:11 PM 7/27/2019 3:07:11 PM 7/20/2019 3:10:32 PM NULL NULL
3 3b6638118246b6bcfd3dfcd9be487599 3 2 360 7/20/2019 3:06:15 PM 7/27/2019 3:06:15 PM 7/31/2019 9:22:11 PM NULL NULL
4 dfe7f0a01a682196cac0120a9adbb550 5 2 1675 7/20/2019 3:06:34 PM 7/27/2019 3:06:34 PM NULL NULL NULL
5 2a24cc2ad4440d698878a0a1a71f70fa 6 2 9500 7/20/2019 3:06:42 PM 7/27/2019 3:06:42 PM NULL 7/22/2019 11:17:02 AM NULL
6 cbd304872ca6257716bcab8fc43204d7 4 2 150 7/20/2019 3:08:15 PM 7/27/2019 3:08:15 PM 7/27/2019 1:42:45 PM NULL 7/27/2019 2:11:20 PM

Table: invoice_item

id invoice_id product_id quantity price line_total_price
1 1 1 20 65 1300
2 1 7 2 68 136
3 1 5 10 100 1000
4 3 10 2 180 360
5 4 1 5 65 325
6 4 2 10 95 950
7 4 5 4 100 400
8 5 10 100 95 9500
9 6 4 6 25 150

The first 2 lines of the result should be:

category ("customer" or "product") id (customer.id or product.id) name (customer_name or product_name)

-> customer 2 Cosmetics Store
-> product 9 Dewy Skin Mist - TATCHA

In: Computer Science