ERD Lucid chart with Crow's foot notation for the following. include all entities, attributes, and correct carnality in relationships between entities. primary and foreign keys.

You have been asked to build a database for a sportswear company called Ath Fleet.

The company owner needs to keep track of the customers that buy their products, the employees that work at Ath Fleet, the vendors that provide them with products, and the products themselves.

Each vendor has contact with one employee representative and needs this support.

Employees in their first year usually don't have vendors to support, as they are learning the ropes, but as they work there longer and more vendors are reached, they may be assigned their only vendor.

The owner wants to track employee names and email addresses, as well as vendor names and locations.Vendors provide products to Ath Fleet, like shoes, apparel, and equipment.

Each product they sell comes from only one vendor. Some products are made in house, but if a vendor is in the system they must have provided a product.

The owner wants to track product names and each product's unique SKU.

Finally, customers purchase products from Ath Fleet and that transaction data needs to be recorded. Each product is often purchased by lots of customers, especially if it is popular.

Customers are only put in the system if they have made a purchase, but a product does not need to have been purchased to be stored.

The owner wants to keep track of customer names and email addresses.

Step 3 of 5 :

A fast-food restaurant owner believes that when a customer orders a drink, 50% will order a regular soda, 30% will order a diet soda, and 20% will order water. To test this belief, over the course of a day she tracks how many customers order each drink. During the day 119 customers order drinks, and the breakdown by type is given in the table below:

Using a 0.10 level of significance, is there sufficient evidence to conclude that the restaurant owner's belief is incorrect?

Step 3: With the observed frequencies from the table above, and the expected frequencies from the previous step, use Microsoft Excel to find the p-value of the chi-squared test for goodness of fit.

Flint Corporation uses a perpetual inventory system. Data for product E2-D2 include the purchases shown below.

On June 1, Flint Corporation sold 26 units, and on August 27, 37 more units.

1) Calculate the average cost for June 1 sale and August 27 sale. (Round answers to 3 decimal places, e.g. 5.125.)

2) Compute the cost of goods sold using FIFO, LIFO, and average-cost. (Round answers to 0 decimal places, e.g. 125.)

One hundred product labels are inspected every day for surface nonconformities. Results for the
past 25 days are: 22, 29, 25, 17, 20, 16, 34, 11, 31, 29, 15, 10, 33, 23, 27, 15, 17, 17, 19, 22, 23, 27,
29, 33, and 21.
1. Determine the CL, UCL, and LCL for the appropriate control chart.
2. Plot the control chart and interpret he results.
3. If the rst 10 days only 80 packages are inspected. Calculate the appropriate CL, UCL, and
LCL, as well as an appropriate control chart. Interpret the results.

A fishing line manufacturer claims that the new X-25 series has a mean tensile strength ( ) of 25 psi and a standard deviation ( ) of 3 psi. To verify the claim, a ??sample of 25 specimens was tested and yielded the following results:

32 19 27 24 28 29 38 30 25 33 18 25 37 28 20 32 23 21 25 19 23 27 32 26 30

A. Compute the sample median, sample mode, sample mean, sample range, sample variance, average deviation and sample standard deviation. What do you think about the Manufacturer’s claim?

Income Statement and Balance Sheet Green Bay Corporation began business in July 2017 as a commercial fishing operation and a passenger service between islands. Shares of stock were issued to the owners in exchange for cash. Boats were purchased by making a down payment in cash and signing a note payable for the balance. Fish are sold to local restaurants on open account, and customers are given 15 days to pay their account. Cash fares are collected for all passenger traffic. Rent for the dock facilities is paid at the beginning of each month. Salaries and wages are paid at the end of the month. The following amounts are from the records of Green Bay Corporation at the end of its first month of operations: Accounts receivable $18,300 Notes payable $57,000 Boats 74,100 Passenger service revenue 11,910 Capital stock 38,200 Rent expense 3,800 Cash 7,650 Retained earnings ? Dividends 6,200 Salary and wage expense 17,300 Fishing revenue 20,240

1. Using the data given, prepare an income statement for the month ended July 31, 2017.

   Green Bay Corporation
   Income Statement
   For the Month Ended July 31, 2017
   Revenues:
   Total revenues
   Expenses:
   Total expenses

   2. Using the data given, prepare a balance sheet at July 31, 2017.

   Green Bay Corporation
   Balance Sheet
   July 31, 2017
   Assets
   Total assets
   Liabilities and stockholders' equity
   Total liabilities and stockholders' equity

   3. While assessing the long-term viability of the Notes Payable, which of the following would you least consider?

   1.	The due date.
   2.	The interest rate.
   3.	The amount of the note.
   4.	Any assets been offered as collateral for the loan.

Answer all questions. Showing your work may earn you partial credit.

Proposal #1 would extend trade credit to some customers that previously have been denied credit because they were considered poor risks.   Sales are projected to increase by $200,000 per year if credit is extended to these new customers. Of the new accounts receivable generated, 6% are projected to be uncollectible. Additional collection costs are projected to be 5% of incremental sales, and production and selling costs are projected to be 78% of sales. Your firm expects to pay a total of 30% of its income after expenses in taxes.

1. Compute the incremental income after taxes that would result from these projections:

2. Compute the incremental Return on Sales if these new credit customers are accepted:If the receivable turnover ratio is expected to be 5 to 1 and no other asset buildup is needed to serve the new customers…
3. Compute the additional investment in Accounts Receivable
4. Compute the incremental Return on New Investment
5. If your company requires a 20% Rate of Return on Investment for all proposals, do the numbers suggest that trade credit should be extended to these new customers? Explain.