Scenario: Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $24,000 in fixed costs to the $270,000 in fixed costs currently spent. In addition, Mary is proposing a 5% price decrease ($40 to $38) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $24 per pair of shoes. Management is impressed with Mary's ideas but concerned about the effects these changes will have on the break-even point and the margin of safety.

Complete the following:

Compute the current break-even point in units, and compare it to the break-even point in units if Mary's ideas are used.

Compute the margin of safety ratio for current operations and after Mary's changes are introduced (Round to nearest full percent).

Prepare a CVP (Cost-Volume-Profit) income statement for current operations and after Mary's changes are introduced.

Prepare a maximum 250-word paper including the answers to the questions above with supporting calculations for management addressing Mary's suggested changes. Explain whether Mary's changes should be adopted. Why or why not? Analyze the above information (three bullet points above) and use this information to support your suggestion.

You should try this code in Microsoft SQL Server to get the practice of using the command line and getting syntax errors. You can submit to me your sql files or just copy and paste of your code in a word document. I may try to run it, so make sure it is error free. Or you can show screen shots of code running.

1. Write SQL CREATE Table statement to create the following table with  Owner ID  as a surrogate key.  Owner ID is a surrogate key (starts at 1 and increments by 1)

hint: IDENTITY (1, 1) is syntax for surrogate key.

PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

You can try inserting some data into your tables too!

2. Write SQL CREATE Table statement to create the following table with  Pet ID as a surrogate key.  Pet ID is a surrogate key (starts at 1 and increments by 1)

hint: IDENTITY (1, 1) syntax for surrrogate key..

PET (PetID, PetName, PetType, PetBreed, PetDOB, OwnerID)

You don’t need to create referential integrity constraint on OwnerID in PET table.

3. Now create the referential integrity constraint on OwnerID in PET. You can use ALTER TABLE command.

5. You are evaluating a firm’s shares which are currently sold for $22 for investment. You are using 10% of the margin of safety that is applied to the value per share. Use the following information. Last year the firm posted sales of $500 million. You expect sales to grow at 10 percent for 3 years and 8 percent for another two years before the firm matures with a sales growth rate of about 4%. Assume that the company currently has 25% operating margin which will increase to 27% in year 3 and after. Corporate tax rate and will remain at the current rate of 25%. Interest is paid at after-tax cost of debt rate of 5%. The company has $250 million debt which is a quarter of assets. Use CAPM to calculate the company’s cost of equity (Risk free rate is 2%, market risk premium is 8% and the company’s equity beta is 1.20). Capital expenditures will be 10% of sales and depreciation will be 1% of sales every year. Company also invests 0.5% of sales in expanding net working capital every year. The number of shares outstanding is 30 million. Would you invest in this stock? Solve the problem in Excel and copy-paste your tables to your word document – make sure they are organized, properly labeled and readable. (25 points)

You should try this code in Microsoft SQL Server to get the practice of using the command line and getting syntax errors. You can submit to me your sql files or just copy and paste of your code in a word document. I may try to run it, so make sure it is error free. Or you can show screen shots of code running.

1. Write SQL CREATE Table statement to create the following table with  Owner ID  as a surrogate key.  Owner ID is a surrogate key (starts at 1 and increments by 1)

hint: IDENTITY (1, 1) is syntax for surrogate key.

PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

You can try inserting some data into your tables too!

2. Write SQL CREATE Table statement to create the following table with  Pet ID as a surrogate key.  Pet ID is a surrogate key (starts at 1 and increments by 1)

hint: IDENTITY (1, 1) syntax for surrrogate key..

PET (PetID, PetName, PetType, PetBreed, PetDOB, OwnerID)

You don’t need to create referential integrity constraint on OwnerID in PET table.

3. Now create the referential integrity constraint on OwnerID in PET. You can use ALTER TABLE command.

Measuring the Economy’s Performance For this assignment, you should use the information in the textbook and the information found on the official government website: www.bea.gov/index.htm Based on the information contained in the textbook and on the Web site above, answer the following questions: What does gross domestic product (GDP) tell us? How did GDP change from 2008? What caused these changes? What is real GDP? What was real GDP in 2008 and has it changed since 2008? What was national income (NI) for 2008? What does national income tell us? What is the difference between GDP and NI? How has NI changed since 2008? What caused these changes? What was disposable income (DI) for 2009? What does disposable income consist of? How did DI change from 2008? What caused these changes? Does GDP measure the well-being of society? Why or why not? What was GDP in 2008 (sometimes called GSP) for your state? How does your state rate when compared to other states? Submission Details: Submit a 4 to 6 page Microsoft Word document, using APA style. Name your document SU_ECO2072_W2_ LastName_FirstInitial Submit your document to the Submissions Area by the due date assigned.

using Dr java

Objective:

Write a program that takes a phrase and then counts the number of vowels (case does not matter) in the phrase. It then should display all of the vowels in sorted ascending order according to their count. Only consider {AEIOU} as the vowels.

Hint:

It may be a good idea to keep track and sort two arrays:

Has the vowels in alphabetic order
Has the number of said vowels

Whenever one would swap then it swaps the values in both arrays.

Example Dialog:

Welcome to the vowel counter and sorter!

Enter a phrase!

aaaaaeeeeiiioou

The vowels and their count

u 1

o 2

i 3

e 4

a 5

Another Example

Welcome to the vowel counter and sorter!

Enter a phrase!

Facetious is the only word in English that contains all vowels in order!

The vowels and their count

u 1

a 4

e 5

i 6

o 6

Yet another Example

Welcome to the vowel counter and sorter!

Enter a phrase!

I have a pen, I have an apple. Uh! Apple Pen I have a pen, I have pineapple. Uh! Pineapple Pen Apple pen... Pineapple pen... uh! Pen Pineapple Apple Pen! Pen Pineapple Apple Pen

The vowels and their count

o 0

u 3

i 9

a 17

e 29

Research results suggest a relationship between TV viewing habits of 5-year old children and their future performance at high school. Wright and Collins (1998) reported that children who regularly watched Sesame Street as children receives better grades than those had not watched the show as children. Suppose another researcher wants to replicate this study on 20 high school children. The researcher first surveyed the parents of the students to obtain information about their TV viewing habits during the times that the students were 5 years old. Based on the survey results researcher selects a sample of n=10 with a history of watching Sesame Street and n=10 that did not watch the program. The average high school grade is recorded for each student and the data are as follows:

How would the researcher test if there were a significant difference between the two groups of students? Use JASP to conduct an independent sample t-test. Write all the steps of hypothesis testing using t-test (as shown in the handout) and attach the document (WORD DOC) here.  

A company institutes an exercise break for its workers to see the effect on job satisfaction, as measured by a questionnaire that assesses workers’ satisfaction. Scores for 10 randomly selected workers before and after the implementation of the exercise program are shown in the following table. Determine if there is a significant increase in worker job satisfaction after the implementation of the exercise program using a 5% level of significance.

Job Satisfaction Index Table

Must complete all parts of this problem:

• PART 1: Use Excel to perform a Matched Pairs Test on the data (di = before – after). Copy and paste the output from Excel into a word document.
• PART 2: Write 3 - 4 sentences on the findings from the Matched Pairs Test. Is there a significant increase in worker job satisfaction after the implementation of the exercise program using a 5% level of significance? Support your answer by using the output from the test. You must include: the hypotheses for the test, a discussion of the p-value, and the decision you reach and why.

In this assignment, you will write a cover letter and a resume (or customize your current resume) for a specific job posting. Follow the steps below:

1. Select a job that you would like to apply for now. This could be a full-time position, part-time position, or internship. In your assignment submission, be sure to provide a link to the job posting or a copy of the position description.
2. Based on this job posting, write and customize your resume as if you were going to apply for this position. Before you write your resume, refer to the lecture for this Module for ideas to include. You may also want to visit websites that show example resumes like Monster.com or Resume.com.
3. Write a customized cover letter that highlights your qualifications for the position. Before you write your cover letter, refer to the lecture for this Module or search for examples online.
4. Submit a single Word document that includes the specific job posting, your cover letter, and your customized resume.

Submit your completed assignment using the link below.

For reference, here are examples of a poorly written resume and cover letter, along with a well-written resume and cover letter:

Poorly Written Resume.docx

Poorly Written Cover Letter.docx

Well-Written Resume.docx

Well-Written Cover Letter.docx

Code definitions: Purchase 0 – Not purchased and 1 – Purchased;   Gender 1 – Male and 2 – Female

Fit a logistic regression model to predict purchase decision. Identify significant predictors and comment on classification accuracy.

Submit a word doc including key results and their interpretation for both parts A and B. Attach Excel files to support your results which is a must to get credit for the assignment.