In Java Please!!!

6.22 LAB: Python and sqlite basics Write a Python program that connects to a sqlite database. Create a table called Horses with the following fields: id (integer): a primary key and not null name (text) breed (text) height (real) birthday (text) Next, insert the following data row into the Horses table: id: 1 name: 'Babe' breed: 'Quarter Horse' height: 15.3 birthday: '2015-02-10' Output all records from the Horses table. Ex: With the above row inserted, the output should be: All Horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')

Consider the following time series data.

1. Graph this data series (use the X-Y scatter/chart tool in Excel for this plot). What type of pattern(s) exists in the data? Does the graph suggest that these data exhibit seasonality? What is the length of the season in this particular case?
2. Determine the seasonal factors for each quarter using METHOD 1 (multiplicative seasonal model).
3. Compute the quarterly forecasts for next year (Year 4)?

Consider the following time series data.

1. Graph this data series (use the X-Y scatter/chart tool in Excel for this plot). What type of pattern(s) exists in the data? Does the graph suggest that these data exhibit seasonality? What is the length of the season in this particular case?
2. Determine the seasonal factors for each quarter using METHOD 1 (multiplicative seasonal model).
3. Compute the quarterly forecasts for next year (Year 4)?

You have recently been hired by Middleton Manufacturing to work in the newly established treasury department. Middleton Manufacturing is a small company with disorganized systems and the finance area needs work.

The company currently has a beginning cash balance of $100,000 and plans to buy new machinery during the fourth quarter for $500,000, paying cash. The company maintains a minimum cash balance of $100,000 and invests any excess cash in a money market account. The company borrows short-term from CIBC, paying 1.5 percent interest per quarter on all short-term borrowing, and receives 1% per quarter from any balances in its money market account. The company pays $110,000 of interest each quarter for its long-term debt.

All sales and purchases are made on credit. Credit sales for each of the next four quarters:

Gross sales Q1 1,360,000 Q2 1,440,000 Q3 1,500,000 Q4 1,600,000

The forecasted credit sales for Q1 of next year is $1,420,000. Middleton currently has an average collection period of 45 days and beginning accounts receivable of $500,000. Twenty percent of the beginning balance of accounts receivable balance is from a company that has just entered bankruptcy. This account receivable will not be collected.

Purchases are done one quarter in advance and represent 50% of the next quarter’s sales (cost of inventory sold is 50% of sales). Suppliers are paid after 30 days. Wages, taxes, and other costs average 30 percent of gross sales and are paid in cash in the same quarter when they occur.

Required: You have been asked to prepare a cash budget and short-term financial plan for the company under the current policies.

QUESTIONS

1. For each of the following accounts, signify which part of the accounting equation

    would include the account balance.

1.1 Merchandise inventory

a) Liabilities            b) Owner's equity            c) Assets      

1.2 Freight out expense

   a) Liabilities           b) Owner's equity            c) Assets      

1.3 Sales revenue

     a) Liabilities            b) Owner’s equity           c) Assets      

1.4 Cost of goods sold

     a) Liabilities            b) Owner's equity            c) Assets      

1.5 Sales returns and allowances

      a) Liabilities            b) Owner’s equity            c) Assets      

1.6 Sales discounts

      a) Liabilities            b) Owner's equity           c) Assets      

1.7 Accounts receivable

      a) Liabilities            b) Owner's equity            c) Assets      

1.8 Owner's capital

     a) Liabilities            b) Owner’s equity            c) Assets      

1.9 Owner's withdrawals

      a) Liabilities            b) Owner's equity            c) Assets      

1.10 Accounts payable

   a) Liabilities            b) Owner's equity            c) Assets      

2. For each of the following accounts, signify DEBIT or CREDIT to indicate the normal balance

    of the account.

2.1 Merchandise inventory

  a) Debit            b) Credit      

2.2 Freight out expense

  a) Debit            b) Credit      

2.3 Sales revenue

   a) Debit            b) Credit      

2.4 Cost of goods sold

   a) Debit            b) Credit      

2.5 Sales returns and allowances

   a) Debit            b) Credit      

2.6 Sales discounts

     a) Debit            b) Credit      

2.7 Accounts receivable

     a) Debit            b) Credit      

2.8 Owner's capital

     a) Debit            Credit      

2.9 Owner's withdrawals

      a) Debit            b) Credit      

2.10 Accounts payable

      a) Debit            b) Credit      

3. For each of the following items, signify the effect the item will ultimately have on the TOTAL

    COST of merchandise inventory on the books of the business recording the item.

3.1 Purchase returns

  a) No effect            b) Decrease           c) Increase      

3.2 Purchase allowances

   a) No effect            b) Decrease            c) Increase      

3.3 Purchase discounts

   a) No effect            b) Decrease            c) Increase      

3.4 Incoming freight costs

  a) No effect            b) Decrease            c) Increase      

3.5 Sales returns

a) No effect            b) Decrease            c) Increase      

3.6 Sales allowances

  a) No effect            b) Decrease            c) Increase      

3.7 Sales discounts

  a) No effect            b) Decrease            c) Increase      

3.8 Outgoing freight costs

  a) No effect            b) Decrease            c) Increase   

Question 214 pts

If the world price is above the domestic “no-trade” equilibrium price, then with international trade, the shortage caused in the domestic market can be met by foreign imports.

Flag this Question

Question 224 pts

Firms in industrial countries find a larger market for their goods in other industrial countries than in developing countries because:

Flag this Question

Question 234 pts

A country benefits from trade if it is able to obtain a good from a foreign country:

Flag this Question

Question 244 pts

We know that industrial countries tend to trade with other industrial countries. This pattern counters the:

Flag this Question

Question 254 pts

It seems evident that countries would have an advantage in producing those goods that use relatively large amounts of their most abundant factor of production.

There is a positive relationship between two variables if

they move in the same direction.

they move in opposite directions.

neither variable moves.

one variable changes and the other does not.

One of the most obvious clues to the relative scarcity of a product is

its current market price.

the variations in available sizes.

the quality of the product.

the limited selection of colors.

Recall the Application about the harmattan and how it affects the price of cocoa to answer the following question(s).

According to this Application, the longer than usual harmattan has impacted the supply curve for cocoa pods, shifting the supply curve to the ________ due to a(n) ________ in cocoa yields.

left; decrease

right; decrease

left; increase

right; increase

If the number of automobile manufacturers decreases,

the supply of automobiles increases.

the demand for automobiles decreases.

the supply of automobiles decreases.

the demand for automobiles increases.

If the price elasticity of demand is 2, this means that a ________ increase in price causes a ________ decrease in quantity demanded.

15%; 100%

20%; 40%

15%; 10%

30%; 20%

Claudia spends her income on two goods, DVD rentals and chewing gum. She considers both goods to be normal goods. If Claudia's income increases and the prices of the two goods remain constant, she will:

rent fewer DVDs and purchase less chewing gum.

rent more DVDs and purchase less chewing gum.

rent fewer DVDs and purchase more chewing gum.

rent more DVDs and purchase more chewing gum.

Recall the Application about finding estimates of elasticities of demand to answer the following question(s).

According to the Application, the regular price elasticities of demand found at www.ers.usda.gov are reported as

positive numbers.

negative numbers.

dollars per unit of foreign currency.

foreign currency units per dollar.

34) Tall Trees Gear uses the periodic inventory method and recorded the following inventory and purchase transactions for the month of August, 20X3.

Date         Transaction             Units     Unit Cost

Aug 1 Beginning inventory 2,800 units @ $1.10

Aug 3 Purchases 500 units@ $1.20

Aug 10 Purchases 300 units@ $1.30

Aug 17 Purchases 400 units@ $1.40

Aug 24 Purchases 700 units@ $1.55

Determine the ending inventory balance at August 31 and the cost of goods sold for the month of August, 20X3 for Tall Trees Gear. Tall Trees Gear sold 3,200 units during August, 20X3. On August 31, a physical inventory count was conducted, and 1,500 units were on hand. Assume the company uses the first-in-first-out (FIFO) cost flow assumption.

FIFO ending inventory

Aug. 24 Purchase 700 units @ $1.55 $ 1,085

Aug. 17 Purchase 400 units @ $1.40 560

Aug. 10 Purchase 300 units @ $1.30390

Aug. 3 Purchase 100 units @ $1.20120

1,500 $2,155

FIFO periodic cost of goods sold

Aug. 3 Purchase 400 units @ $1.20 $ 480

Aug. 1 B.I. 2,800 units @ $1.10 3,080

3,200$3,560

35) Tall Trees Gear uses the periodic inventory method and recorded the following inventory and purchase transactions for the month of August, 20X3.

Date         Transaction             Units     Unit Cost

Aug 1 Beginning inventory 2,800 units@ $1.10

Aug 3 Purchases 500 units@ $1.20

Aug 10 Purchases 300 units@ $1.30

Aug 17 Purchases 400 units@ $1.40

Aug 24 Purchases 700 units @ $1.55

Determine the ending inventory balance at August 31 and the cost of goods sold for the month of August, 20X3 for Tall Trees Gear. Tall Trees Gear sold 3,200 units during August, 20X3. On August 31, a physical inventory count was conducted, and 1,500 units were on hand. Assume the company uses the last-in-first-out (LIFO) cost flow assumption.

LIFO ending inventory

Aug. 1 B.I. 1,500 units @ $1.10 $1,650

LIFO periodic cost of goods sold

Aug. 24 Pur. 700 units @ $1.55 $ 1,085

Aug. 17 Pur. 400 units @ $1.40 560

Aug. 10 Pur. 300 units @ $1.30 390

Aug. 3 Pur. 500 units @ $1.20 600

Aug. 1 B.I. 1,300 units @ $1.10 1,430

3,200 $4,065

For all the baseball fans out there: Assuming that two teams are evenly matched in the World Series (a championship series of at most 7 games; the first team to win 4 games wins the Series) so that the probability of each team winning each game is 50%, and assuming each game is independent of each other game, what is the probability that the Series will be won in exactly 4 games? 5? 6? that the Series goes to game 7?

Compared with Canada, Germany, and the U.K., the U.S. ranks first in the stock of medical technologies such as magnetic resonance imaging (MRI), radiation therapy, and cardiac catheterization. Typically, technological advancement is thought to reduce costs and thus leading to lower prices in most markets. However, in U.S. health care markets, technological improvements are cited as one of the reasons for price increases. Briefly explain this seemingly contradictory phenomena using supply and demand analysis.