Perfect Pizza is a pizza delivery and pick up shop. They are hiring you to create a database designed to track their customers, employees, products, and orders. Their needs are outlined below. They want to use the customer’s telephone number to identify the customer. They are interested in households, not individuals. They need the street address and zip code for delivery. They only deliver to the following zip codes: 29572, 29575, 29577, 29578, 29579, and 29588. Since all zip codes are in the Myrtle Beach area, they would like that information auto filled for the city and state, but want the option to enter other cities and states due to pick up orders from tourists. They also need an order detail table to store the price charged. They need to be able to change the price charged for two reasons: it may be different than product price due to a discount or special allowance and it will keep a historic record of the price. That way, when they are updating a product in the product table, it doesn’t affect the prices charged in past sales. 1) Make a list of Entities you feel this database needs and give an explanation for your reasoning behind each one. 2) For each of the entities you listed above, list the attributes you feel need to be included in each of those entities. 3) Identify the attribute that would be designated as the primary key in each entity. 4) Make a list of questions you would ask to help you better design the database. (Must be at least 5 questions) 5) Make a list of suggestions for the pizza shop owners to improve the database. (Must be at least 3 suggestions)

A local credit union offers car loans to customers on a regular basis. Unfortunately, the credit union ends up repossessing an average of 20 cars per month. Once the cars are repossessed, the credit union sells them to individual buyers to recoup some of their losses.

The cars are placed in a secure parking lot; where potential buyers are invited to inspect the cars. To find out which cars are available each month, potential buyers subscribe to a mailing list. If the car looks good, the buyer puts in a bid to the credit union via email. The highest bid wins the car.

The credit union has been doing the paperwork for these transactions by hand, but now want a computerized system. Because you have knowledge in database development and Microsoft Access, you have been hired to create a database for the monthly auction.

Using the database design rules covered in class, list each rule. Then provide specific details when appropriate as you develop the auction database. When you are finished, I should be able to see the tables, fields, datatypes, primary keys, foreign keys, and relationships.

Consider the following.

- When the bank repossesses a car, an employee records the year, make and model of the car, the mileage, color and VIN number

- Potential customer information is also recorded; name, address, gender, phone number and email address.

- Finally, the bank needs to have some way of recording the bids that come in. Customers send in their bids on specific cars. The bids are recorded and the date is noted.

Please Provide the answers and Solution for this question.

Question One

The financial records of Manchester Corporation were destroyed by fire at the end of 2017. Fortunately, the controller had kept the following statistical data related to the income statement and the balance sheet in addition to the published balance sheet of the year 2017:

• The beginning merchandise inventory was $92,000 and decreased 20% during the current year.
• Sales discounts amount to $17,000.
• Interest expense was $20,000.
• The income tax is $106,000.
• Cost of goods sold amounts to $500,000.
• Administrative expenses are 18% of cost of goods sold but only 8% of gross sales.
• 4/5 of the operating expenses relate to sales activities.

During the year 2018, the company had the following transactions.                                                                                             

1. Manchester Corporation sold part of its investment portfolio for $15,000 and this transaction resulted in a gain of $3,400 for the firm. The company classifies its investments as non-trading equity.
2. A tract of land was purchased for $18,000 cash.
3. Long-term notes payable in the amount of $16,000 were retired before maturity by paying $16,000 cash.
4. An additional $20,000 in ordinary shares were issued at par.
5. Dividends totaling $8,200 were declared and paid to shareholders.
6. Depreciation expense of year 2018 is $11,000.
7. Land was purchased through the issuance of $30,000 in bonds.
8. At December 31, 2018, Cash was $32,000, Accounts Receivable (net) was $41,600, and Accounts Payable remained at $30,000.

The financial position statement of the year 2017.

Instructions:                                                                                  

1. Prepare an Income statement for 2018 and EPS.
2. Prepare a retained earnings statement for 2018.
3. Prepare a statement of financial position as it would appear at December 31, 2018.
4. Prepare a statement of cash flows for 2018.
5. Critically evaluate the rationale for the statement of financial position; income statement; and statement of cash flow.
6. What is the indication for EPS?

The financial records of Manchester Corporation were destroyed by fire at the end of 2017. Fortunately, the controller had kept the following statistical data related to the income statement and the balance sheet in addition to the published balance sheet of the year 2017:

• The beginning merchandise inventory was $92,000 and decreased 20% during the current year.
• Sales discounts amount to $17,000.
• Interest expense was $20,000.
• The income tax is $106,000.
• Cost of goods sold amounts to $500,000.
• Administrative expenses are 18% of cost of goods sold but only 8% of gross sales.
• 4/5 of the operating expenses relate to sales activities.

During the year 2018, the company had the following transactions.                                            

1. Manchester Corporation sold part of its investment portfolio for $15,000 and this transaction resulted in a gain of $3,400 for the firm. The company classifies its investments as non-trading equity.
2. A tract of land was purchased for $18,000 cash.
3. Long-term notes payable in the amount of $16,000 were retired before maturity by paying $16,000 cash.
4. An additional $20,000 in ordinary shares were issued at par.
5. Dividends totaling $8,200 were declared and paid to shareholders.
6. Depreciation expense of year 2018 is $11,000.
7. Land was purchased through the issuance of $30,000 in bonds.
8. At December 31, 2018, Cash was $32,000, Accounts Receivable (net) was $41,600, and Accounts Payable remained at $30,000.

The financial position statement of the year 2017.

Instructions:                                                                                                                                    

1. Prepare an Income statement for 2018 and EPS.
2. Prepare a retained earnings statement for 2018.
3. Prepare a statement of financial position as it would appear at December 31, 2018.
4. Prepare a statement of cash flows for 2018.
5. Critically evaluate the rationale for the statement of financial position; income statement; and statement of cash flow.
6. What is the indication for EPS?

Garda World Security Corporation has the following shares, taken from the equity section of its balance sheet dated December 31, 2020.

*All shares were issued during 2018.

During its first three years of operations, Garda World Security Corporation declared and paid total dividends as shown in the last column of the following schedule.

Required:
Part A
1. Calculate the total dividends paid in each year to the preferred and to the common shareholders.

Total Dividend 2018$ 170,000

2019 $410,000

2020 $570,000

2. Calculate the dividends paid per share to both the preferred and the common shares in 2020. (Round the final answers to 2 decimal places.)

Part B
1. Calculate the total dividends paid in each year to the preferred shares and to the common shareholders assuming preferred shares are cumulative.

Total for three years$1,150,000

Total Dividend 2018$ 170,000

2019 $410,000

2020 $570,000

2. Calculate the dividends paid per share to both the preferred and the common shares in 2020 assuming preferred shares are cumulative. (Round the final answers to 2 decimal places.)

On January 1, 2017, Bonduris Company leases warehouse space in Oakland, CA. The lease is for six years with payments to be made at the beginning of each year. The lease calls for Bonduris to pay $15,000 on January 1, 2017. The lease calls for subsequent rent payments to increase 10% per year. For example, the January 1, 2018 payment will be $16,500, and the January 1, 2019 payment will be $18,150. Bonduris has adopted early ASC 842 and has appropriately classified the lease as an operating lease. Bonduris has a calendar reporting year and an incremental borrowing rate of 7%. Bonduris uses straight-line amortization for its long-lived assets. Ignore current and non currrent classification for this exercise. Use tables (PV of 1, PVAD of 1, and PVOA of 1) (Use the appropriate factor(s) from the tables provided.)

Required:

1-What journal entries should Bonduris make at January 1, 2017, to record the effects of the lease?

2-Prepare Bonduris’s amortization table for the leased warehouse.

3-What is the balance of the lease liability on January 1, 2018, after Bonduris makes the rent payment?

4-What is the balance of the right-of-use asset on January 1, 2018, after Bonduris makes the rent payment?

A 0.1156g of an unknown compound C, H, and N compnd is analyzed by comubustion analysis and produces a 0.1638g CO2 and 0.1676g of water. In a separate experiment, the molar mass was determined to be 31 g/mol. What is its empirical formula and molecular formula?

The empirical formula of styrene is CH; the molar mass of styrene is 104.14 g/mol.
How many H atoms are present in a 4.825g sample of styrene?
___ H atoms
(Give your answer in e format. For example 12014 = 1.2014e+05)

(a) Discuss the procedure in carrying out the Johannes Cointegration.

(b) Discuss how one can undertake the Eagle Granger error regression model.

(c) In empirical research heteroskedacity is not a nusance because it offers a research to re-estimate the model. Discuss