Archive for May 7th, 2018

Depreciation for the current year includes Office Furniture, $1,000 and Equipment, $2,700. Make a…

  1. Details of Prepaid Insurance are shown in the account:

Prepaid Insurance

Jan. 1

400

Mar. 31

3,600

Callaway prepays insurance on March 31 each year. At December 31, $600 is still prepaid.

b. Callaway pays employees each Friday. The amount of the weekly payroll is $6,000 for a 5-day work week. The current accounting period ends on Wednesday.

c. Callaway has a note receivable. During the current year, Callaway has earned accrued interest revenue of $500 that it will collect next year.

d. The beginning balance of supplies was $2,600. During the year, Callaway purchased supplies costing $6,100, and at December 31 supplies on hand total $2,100.

e. Callaway is providing services for Manatee Investments, and the owner of Manatee paid Callaway $12,000 as the annual service fee. Callaway recorded this amount as Unearned Service Revenue. Callaway estimates that it has earned one-third of the total fee during the current year.

f. Depreciation for the current year includes Office Furniture, $1,000 and Equipment, $2,700. Make a compound entry.

assignment solution

i want the er models and assignment solution

Document Preview:

Assignment 1
Development of an ER Diagram and Database Implementation
Weight 20%
Aim:
To give you practical experience in using Entity-Relationship and Relational Database modelling techniques.
Due Date:
Monday of Week 7 (see Course Description for further dates and times).
Project Specification
The proprietors of WareMart Logistics have approached you and asked if you could design a database to help them manage their business. They would like you to create a conceptual data model of their business information requirements and would like to see how the model could be used to provide the answers to some commonly requested queries and reports.
WareMart has provided the following information that it believes may be relevant to your task:
WareMart Logistics Pty Ltd operates a large warehousing and transportation business. It has a number of warehouses around the country.
Each warehouse is referenced by a warehouse number, and WareMart would also like to record street, city, state and postcode details.
Each warehouse has a number of employees and WareMart references them by use of a Staff ID. In addition they record surname, first name, date of birth, street, city, state, postcode and salary details.
Each warehouse has a single manager and a manager is responsible for only one warehouse.
Employees do not report directly to the manager but to a fellow employee who has been given supervisor status.
Merchandise is stored in warehouse ‘locations’. Each location reference is made up of an aisle, shelf and bin number component. As an example you will find a carton of product number 123 (Printing paper) in location 13,2,1 which refers to aisle 13, shelf 2, and bin 1. WareMart wants to know the capacity of each location, as well as whether hazardous materials can be stored there.
A product can be stored in more than one location within a warehouse and a location can hold more than one product.
Products are assigned a department and each department is…

Attachments:


How much must PepsiCo borrow during 20X4 to keep its cash balance from falling below $330 million?…

Assume the following situation for PepsiCo Inc.: PepsiCo ended 20X3 with cash of $200 million. At December 31, 20X3, Bob Detmer, the CFO of PepsiCo, is preparing the budget for 20X4. During 20X4, Detmer expects PepsiCo to collect $26,400 million from customers and $80 million from interest earned on investments. PepsiCo expects to pay $12,500 million for its inventories and $5,400 million for operating expenses. To remain competitive, PepsiCo plans to spend $2,200 million to upgrade production facilities and an additional $350 million to acquire other companies. PepsiCo also plans to sell older assets for approximately $300 million and to collect $220 million of this amount in cash. PepsiCo is budgeting dividend payments of $550 million during the year. Finally, the company is scheduled to pay off $1,200 million of long-term debt plus the $6,600 million of current liabilities left over from 20X3. Because of the growth planned for 20X4, Detmer budgets the need for a minimum cash balance of $300 million.

Required

  1. How much must PepsiCo borrow during 20X4 to keep its cash balance from falling below $330 million? Prepare the 20X4 cash budget to answer this important question.

Microsoft Corporation”s 2002 annual report included the following income statement information

Interpreting an Income Statement – Microsoft Corporation”s 2002 annual report included the following income statement information.

Microsoft Corporation
Income Statements

(In millions, except earnings per share)

Year Ended June 30

2000

2001

2002

Revenue

$22,956

$25,296

$28,365

Operating expenses:

Cost of revenue

3,002

3,455

5,191

Research and development

3,772

4,379

4,307

Sales and marketing

4,126

4,885

5,407

General and administrative

1,050

857

1,550

Total operating expenses

11,950

13,576

16,455

Operating income

11,006

11,720

11,910

Losses on equity investees and other

57

159

92

Investment income (loss)

3,326

36

305

Income before income taxes

14,275

11,525

11,513

Provision for income taxes

4,854

3,804

3,684

Income before accounting change

9,421

7,721

7,829

Cumulative effect of accounting change

(net of income taxes of $185)

375

Net income

$9,421

$7,346

$7,829

Basic earnings per share:

Before accounting change

$1.81

$1.45

$1.45

Cumulative effect of accounting change

0.07

$1.81

$1.38

$1.45

Diluted earnings per share:

Before accounting change

$1.70

$1.38

$1.41

Cumulative effect of accounting change

0.06

$1.70

$1.32

$1.41

Weighted average shares outstanding:

Basic

5,189

5,341

5,406

Diluted

5,536

5,574

5,553

Required Ratios often are used to assess changes in financial statement information over time. Use Microsoft”s income statements to answer the following questions. Express your answers as percentages.

A. What was the ratio of net income to net revenues each year?

B. What was the ratio of cost of revenues (cost of goods sold) to net revenues each year?

C. What was the ratio of operating expenses to net revenues each year?

D. What was the percentage change in net income between 2000 and 2001, and between 2001 and 2002? (Hint: Divide the increase in net income from 2000 and 2001 by the net income for 2000.)

E. Did Microsoft”s operating results improve between 2000 and 2001? Between 2001 and 2002? Explain your answers.

What were the amounts of total assets, total liabilities, and stockholders” equity at yearend…

Reading and Interpreting a Balance Sheet – A recent balance sheet for Walt Disney Company is provided below.

Walt Disney Company
Consolidated Balance Sheets

(In millions, except per share data)

30-Sep

2001

2000

ASSETS

Current Assets

Cash and cash equivalents

$618

$842

Receivables

3,343

3,599

Inventories

671

702

Television costs (current)

1,175

1,162

Other assets

1,222

1,258

Total current assets

7,029

7,563

Film and television costs

5,235

5,339

Investments

2,061

2,270

Parks, resorts and other property, at cost

Attractions, buildings and equipment

20,635

19,202

Accumulated depreciation

7,728

6,892

12,907

12,310

Intangible assets, net

14,540

16,117

Other assets

1,927

1,428

Total assets

$43,699

$45,027

30-Sep

2001

2000

LIABILITIES AND STOCKHOLDERS” EQUITY

Current Liabilities

Accounts payable and other accrued liabilities

$4,603

$5,161

Current portion of borrowings

829

2,502

Unearned royalties and other advances

787

739

Total current liabilities

6,219

8,402

Borrowings

8,940

6,959

Other noncurrent liabilities

5,486

5,210

Minority interests

382

356

Stockholders” Equity

Common stock

12,096

12,101

Retained earnings

12,171

12,767

Adjustments

1,595

768

Total stockholders” equity

22,672

24,100

Total liabilities and stockholders” equity

$43,699

$45,027

Note: Slight modifications have been made to the format of the statement to simplify the presentation.

Required Respond to the following questions.

A. Do you agree that Disney”s balance sheet is both classified and comparative? Explain why or why not.

B. At year-end 2001, what percentage of total assets was composed of current assets? Had this percentage increased or decreased since year-end 2000?

C. What was Disney”s amount of working capital at year-end 2001? Did it change significantly from year-end 2000?

D. Compute the working capital ratio at year-end 2001 and year-end 2000. Did it improve or deteriorate between 2000 and 2001?

E. Film and television costs is the amount paid to produce movies or television shows.

Explain why it appears in two places on the balance sheet.

F. What were the amounts of total assets, total liabilities, and stockholders” equity at yearend 2001 and year-end 2000?

G. Did Disney”s overall financial position improve between 2000 and 2001? Explain.

What does gross profit represent? Calculate gross profit as a percentage of net operating revenues…

Interpreting an Income Statement – A recent Consolidated Statement of Income for the Coca-Cola Company and Subsidiaries is presented below.

Consolidated Statements of Income
The Coca-Cola Company and Subsidiaries

Year Ended December 31

2001

2000

1999

(In millions except per share data)

NET OPERATING REVENUES

$20,092

$19,889

$19,284

Cost of goods sold

6,044

6,204

6,009

GROSS PROFIT

14,048

13,685

13,275

Selling, administrative and general expenses

8,696

8,551

8,480

Other operating charges

0

1,443

813

OPERATING INCOME

5,352

3,691

3,982

Interest income

325

345

260

Interest expense

289

447

337

Other income (loss)

282

190

-86

INCOME BEFORE INCOME TAXES AND

CUMULATIVE EFFECT OF ACCOUNTING CHANGE

5,670

3,399

3,819

Income taxes

1,691

1,222

1,388

INCOME BEFORE CUMULATIVE EFFECT OF

ACCOUNTING CHANGE

3,979

2,177

2,431

Cumulative effect of accounting change,

net of income taxes

10

0

0

NET INCOME

$3,969

$2,177

$2,431

BASIC NET INCOME PER SHARE

$1.60

$0.88

$0.98

Before accounting change

0

0

0

Cumulative effect of accounting change

$1.60

$0.88

$0.98

DILUTED NET INCOME PER SHARE

Before accounting change

$1.60

$0.88

$0.98

Cumulative effect of accounting change

0

0

0

$1.60

$0.88

$0.98

AVERAGE SHARES OUTSTANDING

2,487

2,477

2,469

Dilutive effect of stock options

0

10

18

AVERAGE SHARES OUTSTANDING ASSUMING DILUTION

2,487

2,487

2,487

Required

A. What is the amount of cost of goods sold for 1999, 2000, and 2001? What kinds of costs are included in cost of goods sold?

B. What does gross profit represent? Calculate gross profit as a percentage of net operating revenues for each year. What do you observe?

C. How does gross profit differ from operating income?

D. Is Coca-Cola more profitable in 2001 than in 1999? Explain.

Leave three lines between each category listed. For each category, write the names of…

Jenny didn”t study very hard when she took accounting because she thought she would never use it on the job at Tech-Noid Company. Yesterday, after preparing all end-of-the-month adjusting entries, the company”s accountant became ill. The company asked Jenny to finish the job by preparing the financial statements. The owner needs the statements tomorrow to present to his banker. Jenny is having trouble getting the balance sheet to balance.

Tech-Noid Company
Balance Sheet
January 31, 2004

Assets

Liabilities and Stockholders” Equity

Current assets:

Current liabilities:

Inventory

$1,121

Accounts payable

$231

Interest payable

100

Accounts receivable

691

Land

2,200

Wages payable

636

Noncurrent assets:

Long-term liabilities:

Buildings and equipment

4,990

7%, 10-year note payable

2,000

Retained earnings

1,398

Accumulated depreciation

531

Stockholders” equity:

Contributed capital4,230

4,230

Cash

124

Total assets

$9,809

Total liabilities and equity

8,443

(a) Help Jenny by making a list of the five account categories that are printed in bold-face type on the balance sheet. Leave three lines between each category listed. For each category, write the names of Tech-Noid”s accounts that should be reported under it on the balance sheet. (b) Determine the correct balance sheet amounts for:

1. total current assets

2. total noncurrent assets

3. total assets

4. total current liabilities

5. total long-term liabilities

6. total stockholders” equity

7. total liabilities and equity

Prepare any summary documents you believe might help management (or interested external parties)…

Evaluating the Results of an Organization’s Transformation Process – SoftwareSolutions.com has been in business for several years and is publicly traded on a major U.S. stock exchange. It is an Internet wholesaler of a variety of commercial software applications. On January 1, 2004, the company’s balance sheet appeared as follows (all amounts are in thousands of dollars):

SoftwareSolutions.com
Balance Sheet
January 1, 2004

Assets

Liabilities & Stockholders’ Equity

Cash

$4,240

Wages payable

$640

Accounts receivable

6,800

Capital stock (owner’s investment)

33,000

Inventory

15,200

Retained earnings

13,600

Buildings & equipment

16,780

Accumulated depreciation

-4,780

Land (for plant expansion)

9,000

Total assets

$47,240

Total liabilities and stockholders’ equity

$47,240

During the first quarter of the current year (January, February, March), the following events occurred.

A. New office furniture costing $500 was purchased on the last day of March. This was to be used in a new sales office that was scheduled to open April 1. The office furniture was paid for in cash.

B. Wages and salaries totaling $3,200 were paid. Of this amount, 20% was to liquidate wages payable that arose in the fourth quarter of the previous year. The company has a policy of not making wage or salary advances to employees.

C. All accounts receivable outstanding at January 1 were collected.

D. The company’s advertising agency billed the firm $1,000 for a campaign that had run during the current quarter. The company is planning to pay the bill during April.

E. Sales totaling $18,000 were made to customers. Of these sales, 60% was collected during the first quarter, and the balance is expected to be collected during the next quarter. The goods that were sold had cost the company $13,000 when they were purchased.

F. Dividends were declared and paid to stockholders in the amount of $1,500.

G. Inventory (software programs) costing $10,500 was purchased, of which 10% was paid for by the end of the quarter.

H. A 3-year, $4,000, 12% loan was obtained from a local bank on the last day of the quarter.

I. New shares of stock were sold by the company for $2,000 in cash.

J. A new 3-year lease agreement was signed and executed. The lease required that a $900 monthly rental be paid in advance for the first 2 quarters of the current year. (Total paid is $5,400 = $900 × 6 months.)

K. The accountants calculated that depreciation totaling $350 should be recorded for the quarter for the firm’s buildings and equipment.

L. The land that had been held for plant expansion was sold for $9,000.

Required:

Prepare any summary documents you believe might help management (or interested external parties) better understand the effectiveness or efficiency of the firm’s first quarter transformation process. Did the company have a satisfactory first quarter?

Industry demand function: Q = 14 – ½P + 0.001(Income). Marginal Cost is fixed and equal to $16….

Industry demand function: Q = 14 – ½P + 0.001(Income). Marginal Cost

is fixed and equal to $16. Fixed costs = $0. You are uncertain about the level of

income. Your statistics department believes that there are 4 reasonable probable

income levels with the following probabilities. 10% chance income is 80,000; 50%

chance income is 60,000; 30% chance income is 50,000; and 10% chance income is

30,000.

a. Calculate the appropriate value to use for income in your analysis. Explain why

you choose to use that level of income.

b. Assume this industry is a monopoly; determine the optimal price, corresponding

level of sales and total profit earned by the monopolist. Show your work.

c. In the unlikely event that the highest possible income ($80,000) is realized how

much profit has the monopoly missed out on by underproducing?

d. If this industry was perfectly competitive, what would be the industry wide price

and output level? How do you know? At this price how much profit would there

be in the industry? (For this part use the income you calculated in part a)

e. What is the dead weight loss associated with monopoly. If you can’t calculate the

exact value, show the area on a graph. (Remember MC is fixed and equal to 16)

Bonus: Repeat parts b and e assuming the industry is a Cournot oligopoly.

How much revenue did it earn from operating activities other than transporting passengers?

An income statement for Delta Air Lines, Inc., for a recent fiscal year is provided below:

Delta Air Lines, Inc.
Consolidated Statements of Operations
For the Year Ended December 31, 2001

(In millions, except per share data)

OPERATING REVENUES:

Passenger

$12,964

Cargo

506

Other, net

409

Total operating revenues

13,879

OPERATING EXPENSES:

Salaries and related costs

6,124

Aircraft fuel1,817

1,817

Depreciation and amortization

1,283

Passenger commissions

540

Contracted services

1,016

Landing fees and other rents

780

Aircraft rent

737

Aircraft maintenance materials and outside repairs

801

Passenger service

466

Other

1,917

Total operating expenses

15,481

OPERATING INCOME (LOSS)

1,602

OTHER INCOME (EXPENSE):

Interest expense, net

410

Other income

148

LOSS BEFORE INCOME TAXES

1,864

INCOME TAX BENEFIT

648

NET LOSS

($1,216)

BASIC EARNINGS (LOSS) PER SHARE

($9.99)

DILUTED EARNINGS (LOSS) PER SHARE

($9.99)

Note: Modifications have been made to the statement to simplify the presentation. Use this income statement to answer the following questions:

a. What was Delta”s primary source of revenue?

b. What percentage of Delta”s revenue came from this source?

c. What were its largest expenses?

d. How much revenue did Delta earn from transporting passengers?

e. How much revenue did it earn from operating activities other than transporting passengers?

f. How much revenue did it earn from nonoperating activities?

g. How much operating income did Delta earn (or lose)?

h. How much expense did it incur for nonoperating activities?

i. Approximately how many shares of stock did Delta have outstanding during the year?

j. How much profit or loss did Delta report during the fiscal year?

error: Content is protected !!