Sure Value Convenience Store Case Study:

You work in the corporate office for a nationwide convenient store franchise that operates nearly 10,000 stores. The per-store daily customer count (i.e., the mean number of customers in a store in one day) has been steady, at 900, for some time. To increase the customer count, the chain is considering cutting prices for coffee beverages. The question to be determined is how much to cut prices to increase the daily customer count without reducing the gross margin on coffee sales too much. You decide to carry out an experiment in a sample of 24 stores where customer counts have been running almost exactly at the national average of 900. In 6 of the stores, the price of small coffee will now be $0.59, in 6 stores the price of a small coffee will now be $0.69, in 6 stores, the price of a small coffee will now be $0.79, and in 6 stores, the price of a small coffee will now be $0.89. After four weeks of selling the coffee at the new price, the daily customer counts in the stores were recorded and stored as follows...

1) Analyze the data and determine whether there is evidence of a difference in the daily customer count, based on the price of a small coffee.

2) If appropriate, determine which mean prices differ in daily customer counts.

3) What price do you recommend for a small coffee?

Response should be computer-generated, such as in Word or Excel, not a photo of handwritten work. Preferably excel if at all possible. It should follow a basic memo format with introduction, analysis, and conclusions.

    Please answer all questions in question 1 and question 2.

    Your submission must include a bibliography.

    The word limit for question 1 and 2 combined is 1500 words.

Question 1

Angus is a 44-year-old high school teacher who wishes to invest his savings of $100,000 by building up a blue-chip share portfolio. Angus was a keen observer of the Royal Commission into Misconduct in the Banking, Superannuation and Financial Services Industry in 2019 and has strong views about corporate ethics and the remuneration of directors. Angus wants to exercise his vote as a shareholder to ensure that company directors are not being overpaid. He is also keen to ensure there is proper corporate governance and the directors are managing the company efficiently and ethically. Angus is unsure whether he should buy shares in a public company or a proprietary company. He is also unclear about what class of share/s would best suit his particular investment interests. Angus seeks your professional advice. Required

Answer the following questions for Angus. Support your answer with relevant statute law and/or case law.

a) What is a share and what class, or classes of shares would be most suitable for Angus?

b) On what issues do shareholders have a right to vote and how many votes do they have?

c) How are shares purchased or acquired in a public/proprietary company?

d) Should Angus buy shares in a public company or a proprietary company? Why?

Question 2“

If a company is in financial difficulty, a secured creditor or the court may put the company into receivership.” REQUIRED

Answer the following questions in relation to receivership. Please support your analysis with relevant legislation and/or case law.

a) Who/what is a receiver? Who appoints a receiver and why?

b) What is the effect of the receiver’s appointment on

· the company;

· the directors;

· shareholders;

· secured creditors; and

· unsecured creditors?

For this assignment you have to create tables as reviewed in class Manufacturer table, Product table and Stock table. The code is in Week 7 PPT lecture. You are to add update as needed to make the tables the same as below and match Product, Manufacturer and Stock as below.

For this assignment you will be working with these same tables.  

Please complete the following tasks and submit in word file or notepad.

1. First insert tuples into two of the tables and make sure the contents of the tables match below.  

Write and execute the SQL to insert three records ProductID 844, 555 and 645 to the Product table (see below)

Write and execute the SQL to insert the one record to the Stock table (see below).  

2. Write and execute the SQL select statements to do the following selections of ALL TUPLES IN A TABLE

a. Select all (attributes) tuples in Product

b. Select all (attributes) tuples in Manufacturer

c. Select all (attributes) tuples in Stock

3. Write and execute the SQL select statements to do the following selections of ONLY SOME TUPLED IN A TABLE

a. Select Manufacturer ID = 1 tuples in Product table.

b. Select ProductID of Products that have a quantity of 300.

c. Select ProductID of Products that have quantity of 300 and less.

4. Write and execute the SQL select statements that select attributes (not all) based on a condition.

a. Select ProductID for items with ManufacturerID of 4.

b. Select ProductName for items with ManufacturerID of 1.

c. Select Products with the productName 'Keyboard'

5. Write and execute the SQL select statements that SELECT with and without DISTINCT modifier

a. Select ProductName and ManufacturerID from Product

b. Select Product Name and ManufacturerID from Product with the Distinct modifier.

c. Explain the difference in the results from a and b.

You work in the corporate office for a nationwide convenient store franchise that operates nearly 10,000 stores. The per-store daily customer count (i.e., the mean number of customers in a store in one day) has been steady, at 900, for some time. To increase the customer count, the chain is considering cutting prices for coffee beverages. The question to be determined is how much to cut prices to increase the daily customer count without reducing the gross margin on coffee sales too much. You decide to carry out an experiment in a sample of 24 stores where customer counts have been running almost exactly at the national average of 900. In 6 of the stores, the price of small coffee will now be $0.59, in 6 stores the price of a small coffee will now be $0.69, in 6 stores, the price of a small coffee will now be $0.79, and in 6 stores, the price of a small coffee will now be $0.89. After four weeks of selling the coffee at the new price, the daily customer counts in the stores were recorded and stored as follows...

1) Analyze the data and determine whether there is evidence of a difference in the daily customer count, based on the price of a small coffee.

2) If appropriate, determine which mean prices differ in daily customer counts.

3) What price do you recommend for a small coffee?

Response should be computer-generated, such as in Word or Excel, not a photo of handwritten work. Preferably excel if at all possible. It should follow a basic memo format with introduction, analysis, and conclusions.

Review the following PDF to learn more:

MMWR: Strategies for Reducing Health Disparities—Selected CDC-Sponsored Interventions, United States, 2014

Create a 4- to 5-page Microsoft Word document that addresses the following:

Compare the patterns of the major diseases of Hispanic/Latino groups and their rates and health effects between the other racial or ethnic groups living in the United States.

Identify at least one consequence that a lack of access to healthcare has on Hispanics/Latinos.

Explain why access to care issues will need to be monitored even more closely within the U.S. healthcare system beginning 2014.

Find at least two scholarly journal articles that discuss all or at least one of the topic areas related to Hispanic/Latino health disparities in the United States. Provide a synopsis of each article.

Explain what type of barrier(s) (structural, financial, or socio-cultural) each article examines? Describe at least two policies or strategies that can be implemented to improve access to healthcare services as they relate to the articles you reviewed.

Compare the patterns of the major diseases of Hispanic/Latino groups and their rates and health effects between the other racial or ethnic groups living in the United States.

Identify at least one consequence that a lack of access to healthcare has on Hispanics/Latinos.

Explain why access to care issues will need to be monitored even more closely within the U.S. healthcare system beginning 2014.

Find at least two scholarly journal articles that discuss all or at least one of the topic areas related to Hispanic/Latino health disparities in the United States. Provide a synopsis of each article.

Explain what type of barrier(s) (structural, financial, or socio-cultural) each article examines? Describe at least two policies or strategies that can be implemented to improve access to healthcare services as they relate to the articles you reviewed.

Using Walmarts most recent 10-k report can you please add comparative information in reguards to its previous year as well as add more information to each section so I make the minimum word requirement (of 300 a section).

Part 1: In 1000 words total compute and analyze the following group of ratios for Walmart and explain how they affect the investors’ or creditors’ decisions regarding the company. Please include an introduction sentence referencing the sources of data for ratios. Provide a comparative analysis for each ratio. Make sure your analysis includes a comparison to the company’s prior year ratios OR the competitor’s ratios.

• Liquidity Ratios:

A. Current ratio = Current Assets / Current Liabilities

= 61897/77477

=0.80

The current ratio of the company is 0.80, this means that the current assets of the company are not enough to settle the current liabilities. A current ratio above 1 is optimal.

B. Accounts receivable turnover =Net Sale/Average AR

Accounts receivable turnover=510329/5948.50

=85.79

The Accounts receivable turnover ratio shows the capability of the company to collect the credit sales made. The company (Walmart) has 85.7 as its accounts receivable ratio, which when compared to other companies in the industry (Normally 80 and below) has higher-quality customers that pay their debts quickly.

C. Inventory turnover =Cost of Goods Sold/Average Inventories

Inventory turnover=385301/44026

=8.75

The inventory turnover ratio shows how many times the company has replaced the inventory as a reason for sales. Walmart has an inventory turnover ratio of 8.75, which means that it has replenished the inventory almost 9 times during the year due to its sales.

1. Define the price elasticity of demand? What information does it provide? How is it calculated?
2. Define the income elasticity of demand? What information does it provide? How is it calculated?
3. Define the cross-price elasticity of demand? What information does it provide? How is it calculated?
4. What is total revenue? How is it calculated?
5. Define elastic, inelastic, and unitary elasticity means. How are these related to total revenue? Explain your answers.
6. With respect to the price elasticity of demand, construct a graph using the data in Figure1. Illustrate the ranges on the demand curve that indicate elastic, inelastic, and unitary elasticity. Explain your answers. Enter non-numerical responses in the same worksheet using textboxes.
7. Calculate the total revenue for each level of demand and post into the table, Figure 1. (Copy and paste this table into the Microsoft Word document that will form part of your submission.)
8. Using the midpoints formula presented in the textbook, calculate the price elasticity coefficient for each price level, starting with the coefficient for the $4 to $6 level. For each coefficient, indicate each type of elasticity: elastic demand, inelastic demand, or unitary demand. Post your answers into the table, Figure 1.
9. Assume that the income of consumers changes by 10%, and as a result the quantity demanded for Good A changes by 8%. What is the income elasticity of demand for Good A? What does this mean for your company?
10. Assume that the price of competing Good B decreases by 5% and as a result, the quantity demand for Good A decreases by 8%. What is the cross-price elasticity for your product? What type of goods are Good A and Good B?

Figure 1: The Demand Schedule for Barbeque Dinners