You work for a supermarket that is considering the best way to promote sales of its store-brand canned vegetables. Store managers believe allocating additional shelf space to the store-brand canned vegetables would create additional sales. Company executives, on the other hand, believe increasing advertising expenditures would be a more effective strategy to expand sales. Complete a regression analysis to help answer this question (use the CANVEG Excel file posted on Canvas). NOTE: consider only a simple linear model, a multiple linear regression model, or an interaction model

1.Write out the equation that represents the hypothesized population regression equation for your model

2.Explain whether a positive or negative relationship is hypothesized

3.Use the “Microsoft Excel Data Analysis Toolpak” to determine the regression coefficients for the relationship and write out the final estimated regression equation. You must include the MS Excel output.

4.Give a practical interpretation of the slope(s) of the least squares line

5.Over what range of x-values is the interpretation meaningful?

6.Does the estimated slope support the relationship between the two variables you initially hypothesized (in parts a and b)? Explain.

7.Evaluate the overall utility of the model including any relevant hypothesis tests (be sure to fully write all 6-steps of any hypothesis test conducted, you can specify the rejection region in words it is not necessary to include a graph though you can if you prefer to).

8.Include any hypothesis tests of individual coefficients that are appropriate given your choice of model specification and results.

9.Given your results, would you recommend the company pursue expanding shelf space or increase advertising expenditures.

ID      Year    CornYield       SoyBeanYield
1       1957    48.3    23.2
2       1958    52.8    24.2
3       1959    53.1    23.5
4       1960    54.7    23.5
5       1961    62.4    25.1
6       1962    64.7    24.2
7       1963    67.9    24.4
8       1964    62.9    22.8
9       1965    74.1    24.5
10      1966    73.1    25.4
11      1967    80.1    24.5
12      1968    79.5    26.7
13      1969    85.9    27.4
14      1970    72.4    26.7
15      1971    88.1    27.5
16      1972    97      27.8
17      1973    91.3    27.8
18      1974    71.9    23.7
19      1975    86.4    28.9
20      1976    88      26.1
21      1977    90.8    30.6
22      1978    101     29.4

23      1979    109.5   32.1
24      1980    91      26.5
25      1981    108.9   30.1
26      1982    113.2   31.5

27      1983    81.1    26.2
28      1984    106.7   28.1
29      1985    118     34.1
30      1986    119.4   33.3
31      1987    119.8   33.9
32      1988    84.6    27.0
33      1989    116.3   32.3
34      1990    118.5   34.1
35      1991    108.6   34.2
36      1992    131.5   37.6
37      1993    100.7   32.6
38      1994    138.6   41.4
39      1995    113.5   35.3
40      1996    127.1   37.6
41      1997    126.7   38.9
42      1998    134.4   38.9
43      1999    133.8   36.6
44      2000    136.9   38.1
45      2001    138.2   39.6
46      2002    129.3   38.0
47      2003    142.2   33.9
48      2004    160.3   42.2
49      2005    147.9   43.1
50      2006    149.1   42.9
51      2007    150.7   41.7

Use both predictors. From the previous two exercises, we conclude that year and soybean may be useful together in a model for predicting corn yield. Run this multiple regression.

a)       Explain the results of the ANOVA F test. Give the null and alternate hypothesis, test statistic with degrees of freedom, and p-value. What do you conclude?

b)      What percent of the variation in corn yield in explained by these two variables? Compare it with the percent explained in the previous simple linear regression models.

c)       State the regression model. Why do the coefficients for year and soybean differ from those in the previous exercises?

d)      Summarize the significance test results for the regression coefficients for year and soybean yield.

e)      Give a 95% confidence interval for each of these coefficients.

f)        Plot the residual versus year and soybean yield. What do you conclude?

Learning Outcome:

1. Demonstrate an understanding of how global competitive environments are changing supply chain management and logistics practice.

2. Apply essential elements of core logistic and supply chain management principles.

3. Analyze and identify challenges and issues pertaining to logistical processes.

Assignment Workload:

This assignment is an individual assignment.

Critical Thinking

The global marketplace has witnessed an increased pressure from customers and competitors in manufacturing as well as service sector (Basu, 2001; George, 2002). Due to the rapidly changing global marketplace only those companies will be able to survive that will deliver products of good quality at cheaper rate and to achieve their goal companies try to improve performance by focusing on cost cutting, increasing productivity levels, quality and guaranteeing deliveries in order to satisfy customers (Raouf, 1994).

Increased global competition leads the industry to increasing efficiency by means of economies of scale and internal specialization so as to meet market conditions in terms of flexibility, delivery performance and quality (Yamashina, 1995). The changes in the present competitive business environment are characterized by profound competition on the supply side and keen indecisive in customer requirements on the demand side. These changes have left their distinctive marks on the different aspect of the manufacturing organizations (Gomes et al., 2006). With this increasing global economy, cost effective manufacturing has become a requirement to remain competitive.

To meet all the challenges organizations try to introduce different manufacturing and supply techniques. Management of organizations devotes its efforts to reduce the manufacturing costs and to improve the quality of product. To achieve this goal, different manufacturing and supply techniques have been employed. The last quarter of the 20th century witnessed the adoption of world-class, lean and integrated manufacturing strategies that have drastically changed the way manufacturing firm’s leads to improvement of manufacturing performance (Fullerton and McWatters, 2002).

Consult chapter 7 of your text book or secondary available data on internet and answer the following questions.

Question:

1. Why Companies adopted Lean Thinking and JIT model?
2. Discuss major types of Waste, companies has to keep in mind during production.
3. Assess the reasons for using lean thinking (suitable examples), what are the benefits from Suppliers to end users?
4. Due to COVID 19 emergency do you think agile supply chain is the right concept in this kind of situation? Give reason with example.

The Answer should be within 4- 5 pages.

The Answer must follow the outline points below:

• Lean Thinking and JIT Concept
• Agile Supply chain
• Their Main functions
• Reasons with suitable Examples
• Reference

Ans 1:

Ans 2:

Ans 3:

Ans 4:

National Survey of Family Growth 1982-2010

The National Survey of Family Growth (NSFG) provides nationally representative estimates and trends for infertility, surgical sterilization, and fertility among U.S. women and men aged 15-44. The NSFG survey has been administered since 1973, and its latest round in 2006-2010 consisted of 22,682 interviews. Infertility was defined as a lack of pregnancy in the 12 months prior to the survey despite having had unprotected sexual intercourse in each of those months with the same husband or partner. Women were classified as surgically sterile if they had an unreversed sterilizing operation, for example, a tubal sterilization or hysterectomy. Presumed fertile women were based on the residual category of those who did not meet the definitions for surgically sterile or infertile.

1. Using these data and your knowledge, make a testable hypothesis about some aspect of infertility, fertility, or surgical sterilization using the above mentioned data. Identify and count the cases of infertility depending upon age, education, percent of poverty level in the year 2006-2010. Also compare the groups like surgical sterile, infertile and presume fertile. Clearly defined exposure groups, a specific outcome and a stated direction between the exposure and outcome in the years mentioned.

This question requires the use of the Excel file ‘Assignment 3 Data’ found on ACORN. In the file, you will find the annual returns for Enbridge Inc. (ENB) and the S&P/TSX Composite Index (which we will use for the market portfolio). All parts of this question are to be done in Excel with your results printed and submitted with the other questions in this assignment.

1. Use the data for each of ENB and the S&P/TSX Composite Index to find the historical 95% confidence interval of each. [10 points]

2. Plot the returns of the market against the returns of ENB. Add a trendline to the graph and determine the beta of the stock from your trendline. [5 points]

3. Determine the variance and average annual return of the market portfolio. [3 points]

4. Determine the correlation coefficient between the market portfolio and ENB. [3 points]

5. What is the calculated beta for ENB using the information derived from parts a, c, and d? How does this compare with your answer to part b? [2 points]

6. The current Government of Canada Benchmark 10 Year Bond Yield (which will be our risk-free rate) is 1.61%. What is the required return on ENB stock according to the CAPM? [2 points]

Maggie bought a house which was quite a dump in 1989 for $75,000. She fixed it up with paint and wallpaper but in 1996 she did a major renovation which cost $50,000. In 1993, she bought a dump of a cottage for $35,000 because it was both on a lake and near some good cross-country ski trails. She winterized it immediately for $10,000. Over time, the dumpy cottage has become quite attractive with the addition of a new roof, siding, windows and doors all of which cost $15,000 in 1995. In addition, she is fond of landscaping and has created quite a beautiful garden. I might add that Maggie has only $40,000 in RRSPs since she prefers to sink her money into her living space.

In July 2006, Maggie lost her job and received $60,000 in severance pay. She put as much as she could into her RRSP (included in the $40,000 above) and put the rest in GICs to help finance her plan. Maggie had been taking courses for several years to become a Master Gardener.

When she lost her job, she decided to live out her dream of having a gardening business where she would design gardens for others with cottages near her and maintain them if they needed it because they mostly come to their cottages on the weekend to relax. In the winter, she will keep the lanes clear (with her snow blower) and check up on the cottages now and again. She gave her corporate clothes to her friend Kate with the proviso that she could stay with her when she comes to the City (which won’t be often because she is very fed up).

When she lost her job, she immediately started renting out the house for $1,600 a month plus utilities. She still has to pay the $2,400 a year taxes and maintenance but figures the house will be her retirement fund. When she started renting out the house, it immediately ceased to be her principal residence – her cottage is now her principal residence. In July 2006, her house was worth $300,000 and the cottage is worth $140,000.

Questions:

a.     Maggie’s house increases in value at about 3% a year from 2006 and she sells it in 2017. How much is her taxable capital gain on the house ignoring real estate commissions?

b.    Maggie’s cottage also increases 3% a year in value. If she also sells it in 2017 in order to buy a bed and breakfast, how much is her taxable capital gain?

Please Use your keyboard (Don't use handwriting)

MGT 322

I need new and unique answers, please. (Use your own words, don't copy and paste)

Critical Thinking

The global marketplace has witnessed an increased pressure from customers and competitors in manufacturing as well as service sector (Basu, 2001; George, 2002). Due to the rapidly changing global marketplace only those companies will be able to survive that will deliver products of good quality at cheaper rate and to achieve their goal companies try to improve performance by focusing on cost cutting, increasing productivity levels, quality and guaranteeing deliveries in order to satisfy customers (Raouf, 1994).

Increased global competition leads the industry to increasing efficiency by means of economies of scale and internal specialization so as to meet market conditions in terms of flexibility, delivery performance and quality (Yamashina, 1995). The changes in the present competitive business environment are characterized by profound competition on the supply side and keen indecisive in customer requirements on the demand side. These changes have left their distinctive marks on the different aspect of the manufacturing organizations (Gomes et al., 2006). With this increasing global economy, cost effective manufacturing has become a requirement to remain competitive.

To meet all the challenges organizations try to introduce different manufacturing and supply techniques. Management of organizations devotes its efforts to reduce the manufacturing costs and to improve the quality of product. To achieve this goal, different manufacturing and supply techniques have been employed. The last quarter of the 20th century witnessed the adoption of world-class, lean and integrated manufacturing strategies that have drastically changed the way manufacturing firm’s leads to improvement of manufacturing performance (Fullerton and McWatters, 2002).

Consult chapter 7 of your text book or secondary available data on internet and answer the following questions.

Question:

1. Why Companies adopted Lean Thinking and JIT model?
2. Discuss major types of Waste, companies has to keep in mind during production.
3. Assess the reasons for using lean thinking (suitable examples), what are the benefits from Suppliers to end users?
4. Due to COVID 19 emergency do you think agile supply chain is the right concept in this kind of situation? Give reason with example.

The Answer should be within 4- 5 pages.

The Answer must follow the outline points below:

• Lean Thinking and JIT Concept
• Agile Supply chain
• Their Main functions
• Reasons with suitable Examples
• Reference

II. Show all of your work in each question. In parts (d), (e), and (g) make sure to set up your null and alternative hypotheses and write your conclusions. Also, please round your numbers to 2 decimal points. Write legibly and neatly. III. You can use p-value approach or critical-value approach in writing the conclusions of your hypotheses. A large firm employing tens of thousands of workers has been accused of discriminating against its female managers. The accusation is based on a random sample of 40 managers. The mean annual salary of the 20 female managers is $79,500 while the mean annual salary of the 20 male managers is $103,250. The president of the firm points out that the company has a strict policy of equal pay for equal work and that the difference may be due to other variables. Accordingly, he found and recorded the number of years of education and the number of years of experience for each of the 40 managers in the sample. Also recorded are the salary and gender (1 = female and 0 = male). The data are in attached Excel document. The president wanted to know whether a regression analysis would shed some light on the issue. Use Microsoft Excel to run a regression of annual salary on years of education, years of experience, and gender and round up numbers in your regression results to 2 decimal points. Please use the level of significance of 10 percent (i.e. α = 0.10). On the basis of your Excel results answer following questions. (1 pts.) a. Write down the estimated regression equation.

1. Show all of your work in each question. In parts (d), (e), and (g) make sure to set up your null and alternative hypotheses and write your conclusions. Also, please round your numbers to 2 decimal points. Write legibly and neatly.
2. You can use p-value approach or critical-value approach in writing the conclusions of your hypotheses.

A large firm employing tens of thousands of workers has been accused of discriminating against its

female managers. The accusation is based on a random sample of 40 managers. The mean annual salary of the 20 female managers is $79,500 while the mean annual salary of the 20 male managers is $103,250. The president of the firm points out that the company has a strict policy of equal pay for equal work and that the difference may be due to other variables. Accordingly, he found and recorded the number of years of education and the number of years of experience for each of the 40 managers in the sample. Also recorded are the salary and gender (1 = female and 0 = male). The data are in attached Excel document. The president wanted to know whether a regression analysis would shed some light on the issue.

Use Microsoft Excel to run a regression of annual salary on years of education, years of experience, and gender and round up numbers in your regression results to 2 decimal points. Please use the level of significance of 10 percent (i.e. α = 0.10). On the basis of your Excel results answer following questions.

. At 10 percent level of significance, determine whether each explanatory variable

makes a contribution to the regression model. Show your work.     

AVOIDING PAYING TAXES—CHEATING THE GOVERNMENT

Very few people talk about wanting to pay taxes—for most citizens in most countries it is a natural inclination to avoid paying taxes, particularly when people object to the way the government spends the tax dollars on activities and programs which are contrary to the personal beliefs of individual citizens. Yet most students reading this textbook, and in a college or university course in Canada where this course is being taught, are the beneficiary of tax dollars in the context of how the government collects personal income tax and corporate tax and uses that money to subsidize educational costs—costs such as the building, the salary of the professor, the transportation system that gets you to class etc.

Sometimes national and regional governments operate in areas where there are not enough medium and large-sized companies paying corporate tax—therefore the government has a difficult time obtaining tax revenue to provide educational and health care services to the citizens. When the government does not have the means to collect enough taxes it has to make choices and often one of the primary ways governments cut costs is to cut education funding—meaning cuts to the number of teachers and cuts to facilities, technology, and other things necessary for students to obtain an education.

Recently (in 2012 and 2013), a number of leading American IT companies, such as Apple and Google, have been harshly criticized for using various strategies to avoid paying taxes in the United States, for example by outsourcing, offshoring, and listing income under foreign subsidiaries. The irony of the situation is bitter since both Apple and Google produce products and services that make it easier for students to carry out their studies, yet by avoiding paying millions in tax, these actions deprive the government of tax dollars that could be used to fund education.

Tax avoidance is not limited to the United States. In May 2013, The Economist magazine²¹ reported that “Google came under fire from British politicians, one of whom publicly accused the Internet giant of using unethical methods to avoid paying its fair share of tax.” In the United States, the Senate's Permanent Subcommittee on Investigations reported that “between 2009 and 2012 Apple avoided paying tax in America on at least $74 billion of profits by setting up subsidiaries in Ireland that had no purpose other than to ensure these profits were shielded from tax.”

Questions

1. Tax avoidance has been a hot topic in the United States, has it become a topic in Canada as well? Research some news stories to see if you can find some Canadian companies criticized for avoiding Canadian taxes.

2. The national government in Canada is now making more stringent efforts to collect tax from companies paying late, or not paying the full amount. Searching online, can you find out what the government is doing to recover money owed?

Also, many studies of unethical behaviour in a business setting have concluded that business people sometimes do not realize they are behaving unethically, primarily because they simply fail to ask, “Is this decision or action ethical?”²⁰ Instead, they apply a straightforward business evaluation to what they perceive to be a business decision, forgetting that the decision may also have an important ethical dimension.