Metal Holdings Inc.

You have been assigned the task of creating a simple relational database using SQLite database by the owner of “Metal Holdings” who is in the business of selling industrial metals to customers (mostly wholesale suppliers) who buy from the company.

Your goal is to design and build a database that would be responsible for:

• Managing a product table containing all metals which at a minimum should provide information such as name, description and price of each metal sold by the company.

• Manage a list of customers who would be purchasing metals from the company. The owner is interested in name, location, contact as well as whether the customer is a retail or wholesale buyer.

• Manage and maintain a complete inventory of all orders shipped by the company to customers.
  
• The owner wants to maintain the following information about each order at a minimum, but not limited to:
  • Date of the OrderShipping information such as date and status.
  • Product purchased and Quantity ordered.
  • Customer Information.
  • Each customer can purchase 1-to-many products (metals) in a single order.

The following is a list of metals sold by the company (these below metals should be available in your uploaded SQLite database):

• Copper
• Aluminium
• Silver
• Steel
• Bronze
• Brass
• Lead
• Nickel
• Titanium
• Magnesium

Consider the automobile insurance company database we use for examples in class. For each problem, write an SQL statement to retrieve the specified data.

1. For each accident that occurred in 2005, the names of drivers involved and the make and year of the auto they were driving.
2. The name and ssn of automobile owners who have never been the driver in any accident.
3. The name and ssn of people involved in accidents while driving a car they do not own. (Remember that cars may have multiple owners.)

Database Schema:
• People (ssn, fname, lname, city, state)

• Agents (ssn, salary, photo)

• Autos (vin, make, year, agent_ssn)

• Owns (ssn, vin)

• Accidents (aid, accident_date, city, state)

• Involvements(aid, vin, damages, driver_ssn)

Curly Ramen Pte Ltd is a factory that manufactures instant noodles. The company has completed a research exercise amounting to $5,200 to improve its production process. Due to the outcome of the research, it is now considering purchasing new machines to replace its older machines. The new machines will cost $290,000 altogether, and incur an additional installation expense of $10,000. The old machines can be sold now for a proceed of $51,000, but required a disposal fee of $1,000. The table below shows the cash revenue and expenses for the existing machines:

The cost of capital for the company is 4%.

Required:
a. Calculate the initial investment for the proposed machines.

b. It is estimated that the new machines are expected to increase cash revenue by 35% and expenses by 10% respectively. Calculate the following:
i. Operating cash inflows for the existing machines.
ii. Operating cash inflows for the proposed new machines.
iii. Incremental cash flows for the project.

c. i. Calculate the Net Present Value for the proposed project.
ii. Should the company continue to operate the old machine or purchase the new machine? State your reason.

d. i. Explain what is sunk cost and it’s relevance to investment decisions.
ii. Identify a sunk cost from the case above.

e. If the Internal Rate of Return (IRR) for the project is 9%, should the company accept or reject the project solely based on the IRR technique? State your reason.

You are auditing Osakis Electronics Ltd, a subsidiary of a Japanese company, and will issue an audit report covering the balance sheets as of 31 December 2008 and 2007, and the income statements and cash flow statements for the two years then ended. The company's ordinary shares are traded on the Fiji and Tokyo stock exchanges. Each of the following is an independent audit reporting situation. Required: 1 Osakis does not disclose segment information, because Japanese accounting standards do not require it. Indicate the effect on your audit report, which will be widely used in Fiji. 2 Osakis reports its inventory, non-current assets, depreciation, and cost of goods sold on a current -value basis. Such accounting violates the accounting standards of both Japan and Australia. There is disclosure of the pertinent facts, including the effect on key financial statement amounts, in Note 13. 3. a What factors should you consider in deciding whether to issue a qualified or an adverse opinion? b Draft the explanatory and opinion paragraphs for: 1 a qualified opinion 2 an adverse opinion

You are auditing Osakis Electronics Ltd, a subsidiary of a Japanese company, and will issue an audit report covering the balance sheets as of 31 December 2008 and 2007, and the income statements and cash flow statements for the two years then ended. The company's ordinary shares are traded on the Fiji and Tokyo stock exchanges. Each of the following is an independent audit reporting situation. Required: 1 Osakis does not disclose segment information, because Japanese accounting standards do not require it. Indicate the effect on your audit report, which will be widely used in Fiji. 2 Osakis reports its inventory, non-current assets, depreciation, and cost of goods sold on a current -value basis. Such accounting violates the accounting standards of both Japan and Australia. There is disclosure of the pertinent facts, including the effect on key financial statement amounts, in Note 13. 3. a What factors should you consider in deciding whether to issue a qualified or an adverse opinion? b Draft the explanatory and opinion paragraphs for: 1 a qualified opinion 2 an adverse opinion

1. Under which President's administration were there multiple years of the federal budget running a surplus?

Richard Nixon (1969-74)

Ronald Reagan (1981-89)

Bill Clinton (1993-2001)

George W. Bush (2001-09)

2. In the March/April 2013 issue of Dollars and Sense, Gerald Friedman shows that the increases in the federal deficit during the G. W. Bush (Bush 2) and B. Obama administrations was primarily due to:

the Wall Street bailout.

decreases in federal revenue.

increased federal spending on the stimulus.

A and C.

3. Which of the following is NOT part of Gerald Friedman's Progressive Tax-Reform Agenda?

Elimination of Federal Income Tax on income below the Poverty Line.

Elimination of the exemption from the Social Security payroll tax of income above $118,500.

Taxing capital gains at the same rate as earned income

. Restoration of a tax on financial transactions.

4. Which is not part of the "Golden Straightjacket?"

Privatize pensions

Increase research and development

funding Reduce corruption

Privatize state-owned enterprises

5. Ha-Joon Chang argues that modern developed countries usually achieved their high level of development by practicing:

Most of the prescriptions in the Golden Straightjacket.

Most of the policy prescriptions known as the Washington Consensus.

Protectionism.

All of the above.

A club professional at a major golf course claims that the course is so tough that even professional golfers rarely break par of 73. The scores from a random sample of 20 professional golfers are listed below. Find the test statistic x to test the club professional's claim. 72 70 73 73 76 75 67 79 73 78 70 72 74 74 81 79 73 75 76 66

Answer choices: 6, 10, 4, 14

A test of abstract reasoning is given to a random sample of students before and after they completed a formal logic course. The results are given below. Construct a 95% confidence interval for the mean difference in tests scores. Research has shown that the distribution of such differences is approximately normal. Interpret your result.

Manufacturing company has 3 products: skatebords, snowboards, and kick-scooters.

They only produce boards for intermediate level riders.

They sell product in their own retail stores and offer customization to customers who are willing to pay a price premium.

1. Business Strategy? Why?

2.Appropriate production process? Why?

3. Identify all planning activities components of MPC framework and explain how the organization would plan, schedule, and control flow of material?

4. Thoroughly explain the MPC framework and how the comapsny's apporach and techniques support the business stratefy and prodcution process?

A manufacturer of plastic products spent $2,400,000 during the course of 2004 on research and development. $800,000 of this was spent on an unsuccessful attempt to design new and cheaper moulds which would have lasted twice as long as the moulds currently in use; this proved impossible because the moulds would not sustain the temperature of the molten plastic. $1,200,000 was spent on a very successful project to enable the gnomes to be cast in a cheaper form of plastic, and the remaining $400,000 was spent in the rental, heating and lighting costs of the research and development office.

Required: Advise the manufacturer how the expenditure of $2,400,000 should be treated in the income statement (Statement of Profit & Loss) and balance sheet (Statement of Financial Position). Explain your reasoning carefully and indicate any assumptions you make.