Assuming a cash flow statement is prepared using the indirect method, indicate the

reporting of the transactions and events listed below by major categories on the

statement. Use the following code letters to indicate the appropriate category under which

the item would appear on the cash flow statement.

Codes:

A

Cash flows from operating activities (Add to profit)

D

Cash flows from operating activities (Deduct from profit)

IA

Cash flows from investing activities

FA

Cash flows from financing activities

Category

1. Common shares are issued for cash.

_____

2. Merchandise inventory increased during the period.

_____

3. Depreciation expense recorded for the period.

_____

4. Building was purchased for cash.

_____

5. Bonds payable were acquired and retired at their carrying value.

_____

6. Accounts payable decreased during the period.

_____

7. Prepaid expenses decreased during the period.

_____

8. Investment in common shares of another company were acquired for

cash.

_____

9. Land is sold for cash at an amount equal to carrying amount.

_____

10. Loss on sale of equipment was recorded on the income

statement.

____

1. Lucky Buy Company’s stock has suffered due to several warranty-related lawsuits filed against the company. The company revamped their warranty program and introduced additional customer services to improve the customer experience. Yet, its stock price is only $13 per share. Management is planning a two-for-seven reverse stock split to increase the stock price and bring it closer to the average stock price in the industry. Assume that John Thornton, the last remaining co-founder of the firm, owns 420,000 shares. (7 points)

1.    How many shares will he own after the reverse stock split?
2. What is the anticipated price of the stock after the reverse stock split?
3.    Because investors often have a negative reaction to a reverse stock split, assume the stock only goes up to 85 percent of the value computed in part b. What will the stock’s price be?
4. How will the total value of John Thornton’s holdings change from before the reverse stock split to after the reverse stock split (based on the stock value computed in part c)?

NATIONAL FARM AND GARDEN, INC., BACKGROUND

(Everyone reads.)

National Farm and Garden, Inc. (NFG) was incorporated in Nebraska in 1935 and has been a leading supplier of farming equipment for more than sixty years. Over the last five years, however, demand for NFG’s flagship product, the Ultra Tiller, has been declining. To make matters worse, NFG’s market lead was overtaken by the competition for the first time two years ago.

Last year, NFG expanded its product line with the Turbo Tiller, a highly advertised and much anticipated upgrade to the Ultra Tiller. The product launch was timed to coincide with last year’s fall tilling season. Due to the timing of the release, the research and development process was shortened, and the manufacturing department was pressed to produce high numbers to meet anticipated demand. All responsible divisions approved the product launch and schedule. In order to release the product as scheduled, however, the manufacturing department was forced to employ the safety shield design from the Ultra Tiller. When attached, the shield protects the user from the tilling blades; however, it is necessary to remove the shield in order to clean the product. Because of differences between the Ultra and Turbo models, the Turbo’s shield is very difficult to reattach after cleaning and the process requires specialized tools. Owners can have the supplier make modifications on site or at the sales location, or they can leave the shield off and continue operation. All product documentation warns against operating the tiller without the shield, and the product itself has three distinct warning labels on it. Modifications are now available that allow for the shield to be removed and replaced quite easily, and these modifications are covered by the factory warranty. However, most owners have elected to operate the Turbo Tiller without the safety shield after its first cleaning.

Over the last year, a number of farm animals (chickens, cats, a dog, and two goats) have been killed by Turbo Tillers being operated without the guard. Two weeks ago, a seven-year-old Nebraska boy riding on the back of an unshielded tiller fell off. When the tiller caught the sleeve of his shirt, his arm was permanently mangled and required amputation. One of the child’s parents owns the local newspaper, which ran a story about the accident on the front page of the local paper the next day. NFG’s CEO has called an emergency meeting with the company’s divisional vice president, director of product development, director of manufacturing, director of sales, and vice president of public relations to discuss the situation and develop a plan of action.

Divisional Vice President

You are the divisional vice president and have been with the company for many years. Historically, you have not been a pushy individual and generally prefer to stay in the background. When there are major decisions to be made or crises to address, you are frequently not available. The CEO recently put you on a sixty-day action plan to improve your division’s output; failure to achieve this plan will result in your termination, even though you are just a few years shy of retirement. Therefore, you now find it necessary to satisfy not only your own objectives, but the CEO’s very high expectations as well. This has caused great turmoil within all divisions because you place increasing pressure on your subordinates.

As the divisional vice president, you are focused on coordinating all departments. You are responsible for output from the sales, manufacturing, and field service engineering departments. The research and development (R&D) department, which must sign off on all new products before they are approved for production, is not under your supervision.

Recently, you received a memorandum from the director of R&D outlining some potential problems with the development and testing of the Turbo Tiller. The memo was copied to you, the director of manufacturing, and the director of sales. You agreed with the director of manufacturing not to share the contents of the memo with your CEO because you felt that bringing this small concern to his attention would cause unnecessary problems for each division. Moreover, the CEO is known for his abrasive personality and has a history of yelling at bearers of bad news.

The CEO has called an all-hands emergency meeting at 7:00 a.m. tomorrow. You are expected to bring all knowledge of this situation with you for discussion and creation of a comprehensive action plan.

Director of Product Development

You are the director of product development. Although you have a master’s degree in mechanical engineering from Stanford University, you are originally from the inner-city area of Chicago, where you grew up in the school of “hard knocks.” From previous experience, you tend to be rather uncompromising about products that are engineered within your organization. Your engineering team has been very successful in the past, and you are quite proud of the many new successful products your department has developed.

You originally fast-tracked the Turbo Tiller product due to constant pressure, particularly from the director of sales. However, on further investigation, you have become concerned about the implementation of the product’s safety shield. Consequently, you recently sent a memorandum to the director of manufacturing, director of sales, and the divisional vice president outlining the fact that consumers could sue National Farm and Garden under the state’s strict liability doctrine, which holds manufacturers, distributors, wholesalers, retailers, and others in the chain of distribution of a defective product liable for the damages caused by the defect, regardless of fault. Moreover, plaintiffs could cite the state’s concept of defect of manufacture when the manufacturer fails to (1) properly assemble a product, (2) properly test a product, and (3) adequately check the quality of the product component parts or materials used in manufacturing. You now believe that NFG has violated all three of these concepts of “defects of manufacture.”

Having received no response to this memo, you are contemplating whether to escalate the issue by going to the CEO. The only reason you have not already done so is the CEO’s historic temper when confronted with negative situations.

The CEO has called an all-hands emergency meeting at 7:00 a.m. tomorrow. You are expected to bring all knowledge of this situation with you for discussion and creation of a comprehensive action plan.

Director of Manufacturing

You are the director of manufacturing. A graduate from the University of Alabama with a B.S. in industrial manufacturing, you have worked for NFG for twenty years. You are required to provide reports to top management on a weekly, monthly, and quarterly basis. Top management creates the exact measures of performance that you provide; although you have a say in what these reports focus on, you often disagree with their exact focus. Your overall performance is evaluated based more on numbers of units produced than on quality. Despite this, you enjoy working for the company. You consider the group like family, and especially appreciate the effort the CEO has made to make you feel valued and supported.

You are aware of the difficulties that the Ultra Tiller guard poses when used on the Turbo Tiller. Due to the Turbo Tiller’s larger size, the guard is nearly impossible to replace after removal. Re-attachment of the shield requires a professional machine shop and additional assistance. However, with your knowledge of statistics, you know that, even without the shield in place, the chances of an animal or a person being injured by the Turbo Tiller are small. Thus, you agreed with the divisional vice president to bury a memo sent by the director of R&D stating related concerns. You both felt that the risks were small enough and that raising these concerns to your superiors would only cause headaches and paperwork. Furthermore, you need to stay on schedule in order to reach your volume goals if you are to earn your bonus.

You have also received several e-mails from the manager of the field service engineering department about reports of farmers operating the Turbo Tiller without the guard. When you requested statistical data regarding the number and location of occurrences and any related accidents, the field service engineering manager replied with field data indicating that more than 85 percent of all Turbo Tillers are eventually operated without the guard.

The CEO has called an all-hands emergency meeting at 7:00 a.m. tomorrow. You are expected to bring all knowledge of this situation with you for discussion and creation of a comprehensive action plan.

Director of Sales

You are the director of sales and have been with NFG for more than ten years. You were recruited from a competing firm and have more than twenty-five years of sales experience in the industry. Because of sagging sales, you face extreme pressure from above to meet your numbers. However, you feel that sales forecasts have been set unrealistically. Furthermore, these aggressive forecasts create churning within your department as your sales staff consistently complains that their quotas are unrealistic. Although you are adamant that declining sales are industry and product offering issues, you are reluctant to raise these concerns to the CEO because of his history of anger directed at messengers bearing bad news. You have witnessed this phenomenon firsthand as the CEO literally screamed at a coworker who brought a problem to his attention. On the other hand, the CEO has promised you a new BMW if your department reaches its numbers this year. Of course, you enthusiastically promised to achieve these results.

The Turbo Tiller has been a much-anticipated addition to your stagnant product portfolio, but you were concerned that it would be delayed due to red tape and wrote daily e-mails to the R&D manager about getting it to market on a timely basis. You have received a memo from the R&D manager about some legal concerns over the Turbo Tiller. However, you feel that these concerns are manufacturing’s problem, not your department’s. Furthermore, because the director of manufacturing received a carbon copy of the memo, you are sure that the concerns will be addressed appropriately.

You have organized training on this product for your sales staff that included proper operating procedures and the dangers of standing within five feet of the tilling blades. In addition to these training sessions, you arranged a separate class on how to address and downplay these concerns with customers.

The CEO has called an all-hands emergency meeting at 7:00 a.m. tomorrow. You are expected to bring all knowledge of this situation with you for discussion and creation of a comprehensive action plan.

Here is the question. please help me to answer this:

1) List the key stakeholders in this scenario.

2) What actions will you take with the family of the injured boy?

3) What actions will you take to move customers from the old tiller to the new version?

4) Are there any other actions you think that should be done?

Runiowa is a fashion shoe company that tries to manufacture much more durable heels in 2020. The management team of Runiowa suggests two rubber materials A and B and the research team of Runiowa is asked to design an experiment to gauge whether the rubber A is more durable than the rubber B. 300 people in the US aged between 18 and 65 were randomly chosen. The rubber A is allocated at random to the right shoe or the left shoe of each individual. Then, the rubber B has been assigned to the other. For example, if Mr. Nathaniel is one of 300 people randomly chosen, then the right heel of Mr. Nathaniel is randomly assigned to be made with the rubber A and then his left heel is to be made with the rubber B. The research team measures the amounts of heel wear both the rubber A (wA) and the rubber B (wB) in each individual and records the difference wA − wB of 300 individuals. Even though the individuals are heterogeneous with different heights and weights, those individual heterogeneities will not obscure the comparison of treatment groups by focusing on the paired differences of each individual. Also as long as the heel materials are randomly assigned for each individual, there has been no restrictions on shoe styles. Note that the age of subjects is ranging from 18 to 65. In this way, researchers compare treatments within blocks controlling heterogeneity of individuals. The research team also repeats this experiment design with 300 people in the US aged between 18 and 65 chosen at random.

Question:

What are the experimental units?

What is the control?

Hoe much replication was used?

How was randomization used?

Question 1 :
Corporate sustainability is a new and evolving alternative to the traditional growth and profit
maximisation model. Under corporate sustainability, corporate growth and profitability are
still recognised as important, but it requires the corporation to also pursue societal goals
including environmental protection, social justice as well as economic development.

The Global 100 ranks large corporations across the globe on their reducing carbon waste,
gender diversity and overall sustainability. The top three from this list in 2019 were:
1 Chr. Hansen Holding A/S Denmark Food or other Chemical Agents
2 Kering SA France Apparel and Accessories
3 Nestle Corporation Finland Petroleum Refineries

Applying your understanding of sustainability accounting, critically analyse one of the above
companies. With your analysis, consider the aspects of profitability, share price growth along
with the societal goals.

Use the adjusting journal entry information to prepare the formal adjusting journal entries as of December 31, 2020. Remember to skip a line between each adjusting journal entry and use AJ1, AJ2, AJ3, etc, instead of the actual date.

Information for Year End Adjusting Journal Entries December 31, 2020

1) The building(cost of $180,000)was purchased on January 1, 2019 and it is expected to have a useful life of 30 years with no salvage value. Depreciation expense has been recorded through November 30, 2020.

2) Office equipment(cost of $130,000)as of November 30, 2020 was purchased on January 1, 2015. The office equipment is expected to have a useful life of 10 years with $10,000 salvage value. Depreciation expense has been recorded through November 30, 2020.

3) Insurance in the amount of $4,800 was paid on April 1, 2020 covering the period of April 1, 2020 through March 31, 2021. The insurance expense and prepaid insurance accounts have been properly adjusted through November 30, 2020.

4) A December 31, 2020 count of supplies showed $3,300 of supplies remaining on hand.

5) Salaries earned but unpaid as of December 31, 2020 amount to $31,500.

6) The company has earned one of the three months rent previously received on December 1 from Bullwinkle Inc.

7) Interest at an annual rate of 3¼% is owed for the month of December 2020 on the Mortgage Note Payable due in 5 years (round interest to nearest whole dollar).

8) The savings account was opened on December 31, 2019. It earns interest at an annual rate of 1.5%, compounded monthly. Interest has been received and recorded through November 30, 2019. The bank notified the company that interest for the month of December was deposited in the savings account on December 31, 2020(round interest to the nearest dollar).

9) Uncollectible accounts are expected to be $11,500 based on net sales.

10) Income taxes owed for the year amounted to $15,000.

A popular blog reports that 42% of college students use Twitter. The director of media relations at a large university thinks that the proportion may be different at her university. She polls a simple random sample of 200 students, and 101 of them report that they use Twitter. Can she conclude that the proportion of students at her university who use Twitter differs from 0.42? Answer by showing the five steps of signigicance test, allowing a Type I error rate of 0.05.

The president of a university claims that the mean time spent partying by all students at this university is not more than 7 hours per week. A random sample of 30 students taken from this university showed that they spent an average of 9.50 hours partying the previous week with a standard deviation of 2.3 hours. Test at a significance level of 0.025 whether the president’s claim is true.

1. Write the null and the alternative hypothesis.
2. Calculate the test statistics.
3. Obtain the p-value.
4. Give your conclusion.

You would like to study the height of students at your university. Suppose the average for all university students is 67 inches with a SD of 18 inches, and that you take a sample of 19 students from your university.

a) What is the probability that the sample has a mean of 61 or less inches?
probability =  

b) What is the probability that the sample has a mean between 68 and 71 inches?
probability =  

Note: Do NOT input probability responses as percentages; e.g., do NOT input 0.9194 as 91.94.

A. Project 1 case: DDL’s and Business Rules - The SQL queries for this project are based on the business rules from PROJECT 1. Thus, the SQL queries will run against the tables from Project 1 (see section B below). The following is a list of the business rules derived from the Project 1 assignment:

- A university is identified by its name and located in a particular city.

- A university has many researchers, each of whom can only be associated with only one university.

- A researcher is identified by an identification number, and has a name, phone, and email address.

- A researcher can attend many conferences.

- A conference is identified by an identification number; it also has a name, a location, and a date.

- For each conference, a researcher may or may not present a scientific research paper.

- For each conference, one university is in-charge of its logistic, while another university is in-charge of its marketing.

- A university can be involved in either role with any conference.

B. Run the following DDL’s and add your own data rows to the tables

CREATE TABLE `university` (

`UNIVERSITY_ID` int(11) NOT NULL,

`UNIVERSITY_NAME` varchar(45) DEFAULT NULL,

`UNIVERSITY_CITY` varchar(45) DEFAULT NULL,

`UNIVERSITY_STATE` varchar(2) DEFAULT NULL,

PRIMARY KEY (`UNIVERSITY_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `conference` (

`CONFERENCE_ID` int(11) NOT NULL,

`CONFERENCE_NAME` varchar(45) DEFAULT NULL,

`CONFERENCE_CITY` varchar(45) DEFAULT NULL,

`CONFERENCE_DATE` date DEFAULT NULL,

`UNIVERSITY_ID_LOGISTICS` int(11) NOT NULL,

`UNIVERSITY_ID_MARKETING` int(11) NOT NULL,

`CONFERENCE_STATE` varchar(2) DEFAULT NULL,

PRIMARY KEY (`CONFERENCE_ID`,`UNIVERSITY_ID_LOGISTICS`,`UNIVERSITY_ID_MARKETING`),

KEY `fk_CONFERENCE_UNIVERSITY1_idx` (`UNIVERSITY_ID_LOGISTICS`),

KEY `fk_CONFERENCE_UNIVERSITY2_idx` (`UNIVERSITY_ID_MARKETING`),

CONSTRAINT `fk_CONFERENCE_UNIVERSITY1` FOREIGN KEY (`UNIVERSITY_ID_LOGISTICS`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `fk_CONFERENCE_UNIVERSITY2` FOREIGN KEY (`UNIVERSITY_ID_MARKETING`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `researcher` (

`researcher_id` int(11) NOT NULL,

`res_lname` varchar(45) DEFAULT NULL,

`res_fname` varchar(45) DEFAULT NULL,

`res_title` varchar(45) DEFAULT NULL,

`university_UNIVERSITY_ID` int(11) NOT NULL,

PRIMARY KEY (`researcher_id`,`university_UNIVERSITY_ID`),

KEY `fk_researcher_university1_idx` (`university_UNIVERSITY_ID`),

CONSTRAINT `fk_researcher_university1` FOREIGN KEY (`university_UNIVERSITY_ID`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `conference_has_researcher` (

`CONFERENCE_CONFERENCE_ID` int(11) NOT NULL,

`RESEARCHER_RESEARCHER_ID` int(11) NOT NULL,

PRIMARY KEY (`CONFERENCE_CONFERENCE_ID`,`RESEARCHER_RESEARCHER_ID`),

KEY `fk_CONFERENCE_has_RESEARCHER_RESEARCHER1_idx` (`RESEARCHER_RESEARCHER_ID`),

KEY `fk_CONFERENCE_has_RESEARCHER_CONFERENCE_idx` (`CONFERENCE_CONFERENCE_ID`),

CONSTRAINT `fk_CONFERENCE_has_RESEARCHER_CONFERENCE` FOREIGN KEY (`CONFERENCE_CONFERENCE_ID`) REFERENCES `conference` (`CONFERENCE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `fk_CONFERENCE_has_RESEARCHER_RESEARCHER1` FOREIGN KEY (`RESEARCHER_RESEARCHER_ID`) REFERENCES `researcher` (`researcher_id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

C. Data Queries   “Good questions to ask of your data” – The business rules from section A above were used to derive the following 10 query descriptions below. Read each description and write the equivalent SQL query.

1. List the universities sorted by city.

2. List the Researchers sorted by last name.

3. List the researchers and their corresponding universities sorted by the university city. You must use an INNER JOIN with RESEARCHER and UNIVERSITY tables.

4. List the university and “count” of researchers at each university sorted by the university name.

You CANNOT use an inner join. You must use a subquery with RESEARCHER.

5. List the university and “count” of researchers at each university where there is more than 1 researcher. Also, sort this query by the university name. You must user an INNER JOIN (NOT A SUBQUERY)

6. List all conferences in the state of georgia. Include the city and state with the query.

7. List the conference and researcher count for conferences in georgia. You CANNOT use an inner join. You must use “two” subqueries that are nested.

8. List the researcher, university and conferences where the conference is in California. You must user an INNER JOIN (NOT A SUBQUERY).

9. List the university and count of researchers that are planning to present at a conference in 2021. You CANNOT use an inner join. You must use a subquery.

10. List the Universities in the database table. If the university appears in a conference that is in charge of its marketing. Each university can only be listed once. You must user an OUTER JOIN (NO INNER JOIN OR SUBQUERY).

I have part A completed. I am stuck on part C mostly, but help on part B would be greatly appreciated.