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 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 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
Required: Prepare the journal entries to record these transactions. How much cash did Professor Quark have at the end of June?
Required: Prepare a balance sheet and income statement for this business at the end of May.
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 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 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 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 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 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
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.
SchemaTable: 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 |
| 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
Table: customer
| id | customer_name | city_id | customer_address | contact_person | 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