Hey everyone

I'm working through my homework which involves creating a ER diagram based of certain business rules and I am stuck on this part:

Updated info

• Customers have a name, phone number, a credit card no, and a unique customer number.

• Customers can attend many performances, and each performance can have many customers attending. • Each performance of a show is on at a specific date and time, at a venue.

• Each performance has many actors and the actors in each performance can vary.

• Actors have a staff id, first name, last name, and a date of birth.

• A show has a title, year and duration in minutes. While two shows could have the same title, no two shows in the same year have the same title.

• Shows can have many producers, each with a staff id, first name, last name, date of birth.

1. Whenever customers want to attend a performance they must purchase a ticket, which records the purchase date. They can use different credit cards for different purchases. The customer account must be created prior to purchasing a ticket, and tickets are not transferable.

2. Tickets are for a specific performance of a show and identify the seat number, and a status (to indicate if the ticket has been redeemed).

3. There may be cases where performances of a show run concurrently.

4. Actors have a specific role that they play in each performance of the show which must be recorded in the system.

5. Actors must have one understudy, who will perform their role in cases where the primary actor is unavailable (eg due to illness). An understudy can study under many primary actors.

6. Producers may have a single production company which has a unique name and has an address. Each production company belongs to a single producer.

I can see that credit cards would be an attribute of customer entity but i'm not sure how this would relate to a ticket entity, an example diagram would really help me (UML must be used)

Thanks in advance!

Chart of Accounts for Techno Engineering Supplies Company

Assets:

101       Cash

105       Accounts Receivable

110       Note Receivable

115       Inventory

120       Prepaid Insurance

125       Warehouse Building

130       Equipment

Liabilities:

201       Account Payable

205       Note Payable

210       Wages Payable

215       Loan Payable

220       Interest Payable

Owners’ Equity:

301       Capital Stock

310       Dividends

Revenues:

401       Sales Revenue

405       Interest Revenue

Expenses:

501       Cost of Goods Sold

505       Wages Expense

510       Utilities Expense

515       Insurance Expense

520       Income Tax Expense

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Assume the following: Revolution Store had the following transactions:

Jan-01          Issued capital stock for $980,000.

Jan-01          Purchased a Packaging Equipment for $25,000 with a useful life of 10 years and a Salvage value of $1,500.

Jan-01          Purchased an Insurance Policy (1 year) for $35,000.

Jan-03          Purchased a Truck, paying $10,000 in cash and issuing a note of $20,000.

Jan-05          Purchased $20,000 of inventory on account.

Jan-07          Sold inventory costing $5,000 for $50,000 on account.

Jan-11          Paid $1,000 for inventory purchased on account (from Jan-05).

Jan-15          Collect $15,550 of accounts receivable from customers (from Jan-07).

Jan-17          Paid utility bills totaling $500.

Jan-23          Paid wages for $9,000.

Jan-25          Collect $300 in bank interest.

Jan-30          Paid $2,500 due to income taxes.

Jan-31          Adjust the Insurance account and depreciation expense at the end of the month.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

***Required:

-Record the above transactions in General Journal (Journal Entries).

-Record the transactions in General Ledger format (T-Accounts).

-Prepare a Trial Balance for Techno Engineering Company.

-Prepare Income Statement.

-Prepare Retained Earnings Statement.

-Prepare Balance Sheet.

-Prepare a Cash Flow Statement

1/ Arizona Desert Homes (ADH) constructed a new subdivision during 2017 and 2018 under contract with Cactus Development Co. Relevant data are summarized below:

ADH recognizes revenue upon completion of the contract.

What is the journal entry in 2018 to record revenue?

Multiple Choice

• Construction in progress	460,000
  Cost of construction	660,000
  Revenue from long-term contracts		1,120,000

• Accounts receivable	1,635,000
  Revenue from long-term contracts		1,635,000

• Construction in progress	1,350,000
  Cost of construction	1,920,000
  Revenue from long-term contracts		3,270,000

• Cost of construction	2,150,000
  Gross profit	1,120,000
  Revenue from long-term contracts		3,270,000

2/ On December 15, 2018, Rigsby Sales Co. sold a tract of land that cost $3,300,000 for $5,000,000. Rigsby appropriately uses the installment sales method of accounting for this transaction. Terms called for a down payment of $440,000 with the balance in two equal annual installments payable on December 15, 2019, and December 15, 2020. Ignore interest charges. Rigsby has a December 31 year-end.

In its December 31, 2018, balance sheet, Rigsby would report:

Multiple Choice

• Installment receivables (net) of $4,560,000.

• Installment receivables (net) of $3,009,600.

• Realized gross profit of $149,600.

• Deferred gross profit of $149,600

3/ Lake Power Sports sells jet skis and other powered recreational equipment. Customers pay one-third of the sales price of a jet ski when they initially purchase the ski, and then pay another one-third each year for the next two years. Because Lake has little information about the ability to collect these receivables, it uses the cost recovery method to recognize revenue on these installment sales. In 2017, Lake began operations and sold jet skis with a total price of $750,000 that cost Lake $375,000. Lake collected $250,000 in 2017, $250,000 in 2018, and $250,000 in 2019 associated with those sales. In 2018, Lake sold jet skis with a total price of $1,200,000 that cost Lake $720,000. Lake collected $400,000 in 2018, $270,000 in 2019, and $270,000 in 2020 associated with those sales. In 2020, Lake also repossessed $260,000 of jet skis that were sold in 2018. Those jet skis had a fair value of $97,500 at the time they were repossessed.

In 2017, Lake would recognize realized gross profit of:

Multiple Choice

• $0.

• $250,000.

• $375,000.

• $125,000.

4/ Indiana Co. began a construction project in 2018 with a contract price of $161 million to be received when the project is completed in 2020. During 2018, Indiana incurred $36 million of costs and estimates an additional $89 million of costs to complete the project. Indiana recognizes revenue over time and for this project recognizes revenue over time according to the percentage of the project that has been completed.

Indiana:

Multiple Choice

• Recognized $72.00 million loss on the project in 2018.

• Recognized $36.00 million loss on the project in 2018.

• Recognized $10.37 million gross profit on the project in 2018.

• Recognized no gross profit or loss on the project in 2018.

Question 12 pts

(CO 1) A survey of 1272 pre-owned vehicle shoppers found that 8% bought the extended warranties. What is the population and what is the sample?

Group of answer choices

Population: pre-owned vehicle shoppers; Sample: the 8% that bought extended warranties

Population: 1272 pre-owned vehicle shoppers; Sample: the 8% that bought extended warranties

Population: pre-owned vehicle shoppers; Sample: 1272 pre-owned vehicle shoppers

Population: 1272 pre-owned vehicle shoppers; Sample: pre-owned vehicle shoppers

Question 22 pts

(CO 1) A survey of 481 of your customers shows that 79% of them like the recent changes to the product. Is this percentage a parameter or a statistic and why?

Group of answer choices

Parameter as it represents the population

Statistic as it represents the sample

Parameter as it represents the sample

Statistic as it represents the population

Question 32 pts

(CO 1) Classify the data of the number of customers at a restaurant.

Group of answer choices

Quantitative

Qualitative

Statistics

Classical

Question 42 pts

(CO 1) The data set that lists the temperatures in Albany, NY each day in the month of February would be classified as what type of data?

Group of answer choices

Ratio

Interval

Nominal

Ordinal

Question 52 pts

(CO 1) A data set that includes the number of products that were produced within each hour by a company would be classified as what type of data?

Group of answer choices

Ratio

Ordinal

Interval

Nominal

Question 62 pts

(CO 1) What type of data collection might be best to estimate the impact of exercise on longevity?

Group of answer choices

Observational

Experiment

Simulation

Survey

Question 72 pts

(CO 1) What type of data collection might be best to study how voters might decide an upcoming ballot issue?

Group of answer choices

Observational

Simulation

Survey

Experiment

Question 82 pts

(CO 1) You need to study the satisfaction of customers of a specific restaurant. You decide to randomly select a few tables and talk to everyone at those selected tables. This would most closely describe which type of sampling technique?

Group of answer choices

Stratified

Random

Systematic

Cluster

Question 92 pts

(CO 2) Which of the following graphs would be a line graph?

Group of answer choices

a

b

c

d

Question 102 pts

(CO 1) In a normally distributed data set of how long customers stay in your store, the mean is 44.8 minutes and the standard deviation is 2.6 minutes. Within what range would you expect 95% of your customers to stay in your store?

Group of answer choices

37.0-52.6

2.6-44.8

39.6-50.0

42.2-47.4

Question 112 pts

(CO 1) Which of the following graphs would be considered a uniform distribution?

Group of answer choices

a

b

c

d

Question 122 pts

(CO 1) In a normally distributed data set with a mean of 19 and a standard deviation of 2.6, what percentage of the data would be between 13.8 and 24.2?

Group of answer choices

68% based on the Empirical Rule

95% based on the Empirical Rule

68% based on the histogram

95% based on the histogram

Question 132 pts

(CO 1) Which of the following would be the standard deviation for this sample data set: 5, 7, 6, 9, 6, 4, 4, 6, 5, 9, 3?

Group of answer choices

1.94

2.91

1.85

5.82

Question 142 pts

(CO 1) What would be the mean of this data set: 8, 9, 7, 508, 7, 1, 5, 8, 1?

Group of answer choices

61.6

50.8

33.8

5.8

Question 152 pts

(CO 1) A researcher wants to study the effects of playing video games 24-7 for a week. What type of study would be best suited to make this determination?

Group of answer choices

Experimental

Simulation

Survey

Observational

Question 162 pts

(CO 1) To gather information on customer satisfaction, a researcher goes into several stores and interviews randomly selected customers. This sampling technique is called:

Group of answer choices

Convenience

Stratified

Random

Cluster

Question 172 pts

(CO 1) What is the standard deviation and its meaning given this population of customer ages? 45, 76, 30, 22, 24, 40, 63, 66, 27

Group of answer choices

18.1 which means that many of the ages will be within this value of the average age

19.2 which means that many of the ages will be within this value of the average age

19.2 which means that many of the ages will be around the square of this value

18.1 which means that many of the ages will be around this value

Question 182 pts

(CO 1) What is the mode of the following data set?

2, 2, 3, 3, 4, 4, 5, 5, 6, 6, 7, 7, 8, 8

Group of answer choices

no mode

2, 3, 4, 5, 6, 7, and 8

2

2, 4, 5, and 7

Construct Albert Retail Co's Pro Forma Income Statement and Balance Sheet for Years 1 to 3 under the following policies:

COGS+SG&A+Depreciation = 60% of Revenue

Dividend Payout = 50%

Current Assets = 40% of Revenue

Net Fixed Assets = 60% of Revenue

Current Liabilities = 70% of Current Assets

Corporate Tax Rate = 21%

In an effort to evaluate different methods of teaching a foreign language, a researcher examined
the performance of students learning Spanish under four different teaching methods. Group 1 learns in a
traditional lecture/lab format; group 2 is taught from a programmed text; group 3 is taught from podcasts; and
group 4 is taught from videos of people and life in Spain. After several weeks of instruction, all students were
given a Spanish quiz; these scores were recorded:
Group 1 Group 2 Group 3 Group 4
17 14 18 27
18 22 27 30
20 16. 24 25
17 15 18 26
16 16 20 32
21 20 22 27
18 18 19 31
15 14 25 28

a. Describe the statistical test to be done.

b. State the null and alternative hypotheses.
c. What is the critical value of the test statistic? What is the decision rule for rejecting Ho?
CV: ______________________ Reject Ho if F ≥ _________________
d. Paste in SPSS output below, circling the observed value of the test statistic. Also show your work for eta2
, and a

Tukey test, if necessary.

e. Write out an APA Style conclusion about the research project, using the context of the study.

General Electric recently conducted a study to evaluate filaments in their industrial high intensity bulbs. Investigators recorded the number of weeks each high-intensity bulb would last before failure for three test filaments (Groups 1, 2, and 3) and the standard filament (Group 4). The results are as follows. Using ? = 0.01,

Group       1          2       3        4

                 15       14     25     28

                 18       18     19     31

                 21       20     22     27

                 16       16     20     32

                 17       15     18     23

                 20       16     24     25

                18         22     27     30

                              14    18     27     

                                      24     25

                                               26

1. Write an appropriate ANOVA hypothesis to test the difference in means of the four groups (null and alternative).
2. Read the data into R or R-studio, run an ANOVA model in R and paste the code used as well as the output here. What is the decision based on the ANOVA test? You need to explain what part of the output led you to the conclusion you made.
3. Continue using R: Use the Tukey method to test all pairwise contrasts. Show the R code, output, and explain the results of all the comparisons in complete sentences while referencing the parts/numbers on the output that support your conclusions.

Are America's top chief executive officers (CEOs) really worth all that money? One way to answer this question is to look at row B, the annual company percentage increase in revenue, versus row A, the CEO's annual percentage salary increase in that same company. Suppose that a random sample of companies yielded the following data:

Do these data indicate that the population mean percentage increase in corporate revenue (row B) is different from the population mean percentage increase in CEO salary? Use a 1% level of significance. Will you use a left tailed, right tailed, or two tailed test?

The industry averages for 2019 that the company refers to as its benchmarks are provided as follows:

Industry Average

Gross profit ratio                                                                          50.11%

Net income to revenue ratio (after tax)                                        22.02%

Return on shareholders’ equity (after tax)                                   35.66%

Current ratio 1.85 : 1

Quick ratio 1.08 : 1

Accounts receivable collection period (in days)                          14.83 days

Company A:

Gross profit ratio                                                                          54%

Net income to revenue ratio (after tax)                                        25.76%

Return on shareholders’ equity (after tax)                                   33.73%

Current ratio                                                                                1.54

Quick ratio                                                                                   0.41

Accounts receivable collection period (in days)                          21.90 days

Use the above ratios of company A performance compare to the industry averages and provide relevant comments under the headings of ‘profitability’ and ‘liquidity.

Are America's top chief executive officers (CEOs) really worth all that money? One way to answer this question is to look at row B, the annual company percentage increase in revenue, versus row A, the CEO's annual percentage salary increase in that same company. Suppose that a random sample of companies yielded the following data:

​

Do these data indicate that the population mean percentage increase in corporate revenue (row B) is different from the population mean percentage increase in CEO salary? Assume that the distribution of differences is approximately normal, mound-shaped and symmetric. Use a 5% level of significance. What is the alternate hypothesis?

​