QUESTION 4 Regression Analysis

Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d

Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12 months:

(a)Using the high-low method to estimate support overhead costs based on machine hours (MH), what would be the estimated support overhead costs (to the nearest $) for a month in which 3,000 machine hours were used?

(b)Using Excel, perform three regression analyses to regress Overhead Cost against Machine Hours, then against Batches, then against both of them simultaneously. Paste your results into Word. State the cost equation from each. Analyse and comment on the results of each regression as you perform it and determine the best one to use as a basis for future use.

(c)If you had to settle for the results of a simple regression, which one would you use and why?

(d)Using the best regression result determine the projected Overhead Cost in a month in which there were 2000 machine hours worked and 150 batches produced.

QUESTION 3 Regression Analysis

Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d

Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12 months:

(a)Using the high-low method to estimate support overhead costs based on machine hours (MH), what would be the estimated support overhead costs (to the nearest $) for a month in which 3,000 machine hours were used?

(b)Using Excel, perform three regression analyses to regress Overhead Cost against Machine Hours, then against Batches, then against both of them simultaneously. Paste your results into Word. State the cost equation from each. Analyse and comment on the results of each regression as you perform it and determine the best one to use as a basis for future use.

(c)If you had to settle for the results of a simple regression, which one would you use and why?

(d)Using the best regression result determine the projected Overhead Cost in a month in which there were 2000 machine hours worked and 150 batches produced.

Directions: Use the Bivatiate Correlation function and the Options submenu to answer each of the questions based on the above scenario.

The superintendent has continued the examination of data by examining the relationship between attendance rate and percent of students eligible for free or reduced priced lunch. The district data used for the analysis are contained below.

1. What is the mean percent of students receiving free or reduced lunch? What is the mean attendance rate?

51.97 free or reduced

94.16 attendance

2. What are the standard deviations for the percent of students receiving free or reduced lunch and attendance rate?

15.68 free or reduced

1.71 attendance

3. State an appropriate null hypothesis for this analysis.

4. What is the value of the correlation coefficient?

5. Based on the value of the correlation coefficient, how would you classify the strength of this relationship?

6. Based on the information from the scenario, what is the appropriate value for the degrees of freedom?

7. What is the reported level of significance?

8. Present the results as they might appear in an article. This must include a table and narrative statement that reports and interprets the results of your analysis.

Note: The table must be created using your word processing program. Tables that are copied and pasted from SPSS are not acceptable.

Janet Jennings is the general manager for Mercashoe 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 existing fixed costs. In addition, Janet is proposing a 5% price decrease ($40 to $38) that 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 Janet’s ideas but concerned about the effects theses changes will have on the break-even point and the margin of safety.

Information provided:

A. Rental expenses for the store: $5,000 per month.

B. Janet has a salary assigned of $60,000 per year.

C. The store has a sales manager who earns $45,000 per year.

D. There are three salesclerks who have a salary assigned of $25,000 each per year.

E. Social security expenses for each the employees represent 30% of their salary.

F. Utilities expense: $600 per month.

Instructions:

1. Compute the current break-even point in units and compare it to the break-even point in units if Janet’s ideas are implemented.

2. Compute the contribution margin ratio under current operations and after Janet’s changes are introduced. (Round to the nearest full percent).

3. Compute the margin of safety under the two proposals.

4. What is the operating income under each scenario?

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

6. Prepare a Cost-Volume-Profit graph under the two scenarios.

7. Prepare a report explaining and justifying whether Janet’s changes should be adopted or not and provide suggestions supported by the information provided above. Show your work in Word of Excel

Case 1 – Cost-Volume-Profit Analysis

Janet Jennings is the general manager for Mercashoe 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 existing fixed costs. In addition, Janet is proposing a 5% price decrease ($40 to $38) that 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 Janet’s ideas but concerned about the effects theses changes will have on the break-even point and the margin of safety.

Information provided:

A. Rental expenses for the store: $5,000 per month.

B. Janet has a salary assigned of $60,000 per year.

C. The store has a sales manager who earns $45,000 per year.

D. There are three salesclerks who have a salary assigned of $25,000 each per year.

E. Social security expenses for each the employees represent 30% of their salary.

F. Utilities expense: $600 per month.

Instructions:

1. Compute the current break-even point in units and compare it to the break-even point in units if Janet’s ideas are implemented.

2. Compute the contribution margin ratio under current operations and after Janet’s changes are introduced. (Round to the nearest full percent).

3. Compute the margin of safety under the two proposals.

4. What is the operating income under each scenario?

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

6. Prepare a Cost-Volume-Profit graph under the two scenarios.

7. Prepare a report explaining and justifying whether Janet’s changes should be adopted or not and provide suggestions supported by the information provided above. Show your work in Word of Excel

Use the same organization as in previous week's projects. Last week, you completed the strengths, weaknesses, opportunities, and threats (SWOT) analysis for your organization. Hopefully, you have begun researching potential social causes, issues, or nonprofits for your company to adopt.

As you consider your options, select three or four possible candidates (social causes) and evaluate whether the alternatives you come across fit with your company's mission, vision, and ethical framework, as well as any existing social responsibility efforts. Finally, select the new cause that will build upon your company's strengths. Will selecting this cause support the responsibility owed to your stockholders and stakeholders?

Tasks:
Propose your top three potential social causes for your organization and why your selected social cause or issue is a good match with your chosen corporation for creating a corporate social responsibility (CSR) campaign. You will want to be sure that you cover the following items in your report:

Evaluate how each of your top three social causes do or do not meet your company's mission, vision, and ethical framework, as well as, any on-going social responsibility efforts.

Defend why the social cause you chose is a good fit with your corporation.

Assess how Stockholder Theory and Stakeholder Theory impacted your final selection (Week 1 reading)

Justify which personal ethical framework impacted your final selection and how it impacted your selection (Week 2 reading)

Analyze the internal and the external ethical impacts of your selection (Week 3 reading)

Submission Details:

Submit your paper in a 5- to 7-page Microsoft Word document, using APA style.

Name the document SU_BUS3001_W3_ LastName_FirstInitial.doc.

Submit your document to the Submissions Area by the due date assigned.

USE FOLLOWING TABLES TO ANSWER FOLLOWING QUESTIONS:
WAREHOUSE (WarehouseID, WarehouseCity, WarehouseState, Manager, SquareFeet)

INVENTORY (WarehouseID, SKU, SKU_Description, QuantityOnHand, QuantityOnOrder)

1.Write an SQL statement to show a unique SKU and SKU_Description for all products having an SKU description starting with ‘Half-dome’.

2.Write an SQL statement to show a unique SKU and SKU_Description for all products having a description that includes the word 'Climb'.

3.Write an SQL statement to show a unique SKU and SKU_Description for all products with a ‘d’ in the third position from the left in SKU_Description.

4.Write an SQL statement that uses all of the SQL built-in functions on the QuantityOn Hand column. Include meaningful column names in the result.

HTML EditorKeyboard Shortcuts

5.Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand grouped by WarehouseID. Name the sum TotalItemsOnHand and display the results in descending order of TotalItemsOnHand.

6.Write an SQL statement to show the SKU, SKU_Description, and WarehouseID for all items stored in a warehouse managed by ‘Lucille Smith’. Use a subquery.

7.Write an SQL statement to show the SKU, SKU_Description, and WarehouseID for all items stored in a warehouse managed by ‘Lucille Smith’. Use a join, but do not use JOIN ON syntax.

8.Write an SQL statement to show the SKU, SKU_Description, and WarehouseID for all items stored in a warehouse managed by ‘Lucille Smith’. Use a join using JOIN ON syntax.

9.Write an SQL statement to show the WarehouseID and average QuantityOnHand of all items stored in a warehouse managed by ‘Lucille Smith’. Use a subquery.

10.Write an SQL statement to show the WarehouseID and average QuantityOnHand of all items stored in a warehouse managed by ‘Lucille Smith’. Use a join, but do not use JOIN ON syntax.

11.What are the functions for DBMS?

Questions: 1) // declare integer variable sum equal to zero // declare variable integer i // declare while loop condition where i is less then 25 // inside of brackets calculate the sum of i (addition) // increment i // outside the loop print the sum of values =============================================

2) Create a sentinel value example if I press number 0 it will display the sum of data // create a scanner // prompt the user to to enter the numbers // declare variable integer and relate that to input scanner // declare variable sum equals to zero // declare while loop condition where the variable you just created above is not equal to 0 // inside of the bracket of while condition sum the data with addition // prompt the user to enter integer unless its not zero // again the same variable that you created outside the while condition will ask to input value through scanner // outside the bracket display the sum of values

3) Declare the do while loop // declare the variable integer which is equal to zero // declare do-while loop and inside of brackets prompt the user to print word "Hello" // increment the variable integer that you declared outside the loop // outside brackets declare while condition where variable that you declared in the beginning is less then 25

4) Continue the same process as exercise number 3, but this time use for loop

5) Create break command in while loop // declare integer variables sum and number and both of them are equal to zero // create while condition where number is less then 25 // inside of brackets increment number // declare if condition where number is equal to 10 // write continue ++ // sum the number (addition) // outside of brackets display sum in console

6) In this exercise do the same thing like number 5 exercise but instead of continue ++ write break;

CHEM 4722/5722 Homework Set #3 (due beginning of class Thu Apr 2)

Homework is to be turned in prior to class and should be done on plain white printer paper. If not, it will be returned for resubmission with a penalty assessed. Word processing should be used for any narrative answers. Calculations and mechanisms can be done freehand but must be very neat, organized, legible and on plain white paper. No lined paper will be accepted.

1. An example of a unsaturated fatty acid is cis-11-heptadecenoic acid. If this compound is oxidized down to CO2 and water via β-oxidation and subsequent pathways, how many ATP equivalents can be obtained? Show all work and list where all of the ATPs come from.

2. Draw out both steps of the malic enzyme mechanism for the conversion of malate to pyruvate. Include nicotinamide moieties, acid/base catalysis, and electron movement.

3. Write a balanced stoichiometric equation for the synthesis of squalene from acetyl-CoA. Indicate the reactions you used to determine your answer and show all work.

4. Refer to your lecture notes or your book for the synthesis of sphingomyelin. Write out the mechanisms (reactant, product structures and electron movement) for each synthetic step to the final product.

5. Mice were divided into four groups, two of which were fed a normal diet and two of which were fed a cholesterol-rich diet. HMG-CoA reductase mRNA and protein levels from liver were measured.

   1. a) What is the effect of cholesterol feeding on HMG-CoA reductase mRNA?

   2. b) What is the effect of cholesterol feeding on HMG-CoA reductase protein?

   3. c) Why is the result in panel B surprising in light of the result in panel A?

   4. d) Suggest possible explanations for the result in panel B.

Variables typically included in a multivariate supply function (other than the price and quantity of the item the supply function represents) are prices of other goods that use similar input resources for production, expectations, the number of suppliers, techniques of production, taxes and subsidies, and prices of input resources, weather. Please answer the following questions about the affect changes in other variables might have on the supply of the item. These changes will either cause supply to increase (shift right) or decrease (shift left). Use either word as applicable, for the short answer.

1. It is rumored that refiners are taxed 5.4 cents/gallon more than they are taxed for gas mixed with Ethanol. The tax is used to subsidize the growth of more corn (from which Ethanol is made). The result is an ____________ in the supply of Ethanol.

2. E-book readers can now be bought for about $100. Digital books are considerably cheaper than printed versions.   Predictably then the supply of e-books will _____________.

3. T. Boone Pickens spent millions of his own money advertising the benefits of “Cleaner American- Produced Natural Gas” as an alternative vehicle fuel. Advertising seeks to increase the demand for an item. Suppose instead he had spent his millions to help service stations install natural gas fueling equipment (pumps ??). This would be an effort to _____________ the supply of readily available natural gas fueling facilities

4. Think of highways as a resource used in the production of highway transportation. Thus building more and better highways is likely to _______________ the supply of vehicles using them.

5. A problem getting the public to buy automobiles equipped to use both gasoline and natural gas as fuel is the cost of adding natural gas capability to the vehicles. Suppose a small amount of tax was added to the cost of a gallon of gas (maybe one cent, for example). This could be used to encourage manufacturers to install natural gas using capability in vehicles, thus ______________ the supply of these vehicles on the road.