Premium Essay

Project B

In:

Submitted By yuithegreat
Words 1352
Pages 6
Project Part A

Exploratory Data Analysis

Keller Graduate School of Management

GM533: Managerial Statistics (Downers Grove, IL)

Michael Knapp

Table of Contents

I. Introduction...pg 3 II. Individual Variables a. Location…pg 3 b. Income…pg 3 and 4 c. Size…pg 4 and 5 III. Relationships d. Size and Location…pg 5 and 6 e. Income and Location…pg 7 and 8 f. Size and Income…pg 8 and 9

This analysis is to compare the information presented by AJ DAVIS which is a department store chain, which has many credit customers and wants to find out more information about these customers. A sample of 50 credit customers is selected with data collected on five variables, I have selected 3 to compare side by side to one another and analyze the data provided. The 3 variables are LOCATION (Rural, Urban, Suburban), INCOME (in $1,000ʼs – be careful with this) and SIZE (Household Size, meaning number of people living in the household). After I cover each variable I will compare the relationship between size and location, income and location, and size and income.

The first variable is location. The location refers to three categories: rural, suburban and urban. Based off of the information provided I found that 13/50 or 26% of the sample group live in a rural area, 15/50 or 30% of the sample group live in a suburban area and 22/50 or 44% live in a urban area.
Tally for Discrete Variables: Location

Location Count Percent Rural 13 26.00
Suburban 15 30.00 Urban 22 44.00 N= 50

The second variable is income. Income which is measured in thousands of dollars refers to the amount of money that is earned by the person in the sample. I chose income because it would be very informative to compare to other variables that I selected. I found that the average or mean income

Similar Documents

Free Essay

Mission Project B

...Math-144 December 8, 2015 Professor Mission Project B On This mission trip we are heading to Viedma Argentina. There will be 10 people going including myself and we will stay for a total of 4 weeks. The purpose of our mission trip is to bring supplies to the poor people of this country. The reason I chose Argentina is because of its economic issues in regards to there being so many people living in poverty (Reed, D. 2014). The supplies we will be bringing will be all donated items from churches and from different companies. This includes clothes, food, toys, pampers, toiletries, school supplies, household items (pots, dishes etc), and linens. These supplies will be sent over ahead of time eliminating us having to bring it ourselves. I will break down the total amount of expenses needed to cover this trip to make sure we are on budget and covered in every aspect. A flight to Viedma Argentina costs $3,185.60 per person round trip from May 16th until June 13th, I found this price on the Priceline website. For ten people this will cost $31,856. The flight will take 25 hours and 19 minutes from Savannah, Ga to Viedma because there will be 3 different layover stops. For our lodging instead of booking a hotel I chose to find a vacation rental because hotels don’t have kitchens in the rooms and room service will eventually be more costly. The home, Casa balneario el condor Viedma costs $130 per night instead of per person, per night at the hotels. For the duration of 27 nights the...

Words: 1714 - Pages: 7

Premium Essay

Course Project B

...Clark Paints – Course Project B, Question 2 The production department determined that 1,100,000 cans would need to be manufactured each year for the next 5 years if Clark Paints were to begin making their paints cans instead of purchasing them. Considering all relevant costs it was determine that it would cost the company $422,460 annually to make the paints can versus $495,000 they are currently paying to buy the paint can. Clark Paints should accept the proposal to manufacture paint cans because it would result in an annual, before tax, cash savings of $72,540, as well as $32,000 in tax savings as a result of equipment depreciation. The total annual cash flow generated, after tax, is $ 58,351. The initial investment of $200,000, for equipment, would paid back in 3.43 years due to a 13.18% annual rate of return and overall decreased costs. The Net Present Value was calculated at $33,035. The Positive NPV indicates positive future cash flows and present equity. Annual cash flow generated within the 5 years would result in an Internal Rate of Return of 18%. The high Internal Rate of Return indicates an increased rate of future growth as a result of the reduced cost and increased cash flow. Again, this proposal should be accepted because of the significant reduction in cost, the attractive positive Net Present Value and the high Internal Rate of Return. Calculations Summary: Annual cash flows over the expected life of the equipment = $ 58,351 Payback period = 3.4 Years ...

Words: 277 - Pages: 2

Premium Essay

Course Project B

...Funches Math 533 Introduction The department store AJ Davis wants to study the customers that use credit with them. They collected a sample group of 50 people and broke them down to 5 different variables. The 5 different variables are broken down by location, income, household size, years in current location, and credit balance. I plan on creating different graphs and tables to make things easier to study to see the difference in groups. 1st individual variable The pie chart above clearly shows that most/max of the customers to buy from AJ Davis live in the urban location. Even though the rural location is the min of the three, rural and suburban is very close to each other that they both make-up for the rest of the sales. 2nd individual variable The histogram above shows how many people fall into the different income ranges. It seems that the middle class has the lowest amount of people in that category where the lower and upper class mirror each other in the chart above. 3rd individual variable The dotplot above shows how many families fall into the category of how many people are in the household size. It looks as if the families with two people is the largest group out of everyone by a long shot, and households with one, five, six leaving there are equal. 1st pairing of variables The boxplot above shows the connection between the three different locations and the credit balance with AJ Davis. The Rural location seems to be the...

Words: 576 - Pages: 3

Premium Essay

Ac505 Project B

...AC505-Managerial Accounting Project BClark Paint Capital Budgeting ProblemData: Cost of new equipment200,000$Expected life of equipment in years5Disposal value in 5 years40,000$Life production - number of cans5,500,000 Annual production or purchase needs1,100,000 Initial training costsNumber of workers needed3Annual hours to be worked per employee2000Earnings per hour for employees12.00$Annual health benefits per employee2,500$Other annual benefits per employee-% of wages18%Cost of raw materials per can0.25$Other variable production costs per can0.05$Costs to purchase cans - per can0.45$Required rate of returnTax rate35%12% MakePurchaseCost to Produce Annual cost of direct material:Need of 1,1,000,000 cans per year275,000$Annual cost of direct labor for new employees:Wages72,000$Health benefits7,500$Other benefits12,960$Total wages and benefits92,460$Other variable cost:55,000$Total annual production costs422,460$Annual cost to purchase cans495,000$ Part 1 Cash Flows over the life of the projectBefore TaxTax EffectAfter Tax ItemAmountAmountAnnual cash savings (make vs buy)72,540$ 65%47,151$ * Tax effect on Annual Cash Savings is 1 - tax ratTax savings due to depreciation32,000$ 35%11,200$ * Tax effect on Depreciation is the tax rate Total annual cash flow 104,540$ 58,351.00$Part 2 Payback Period ($200,000)/ $87,690 = 3.4yearsPart 3 Annual Rate of Return Accounting income as result of decreased costsAnnual cash savings (before tax effect)104,540$Less Depreciation(32...

Words: 447 - Pages: 2

Free Essay

Course Project B

...In the following paragraphs I have prepared my results of the mean average income, population of urban customers to total customers, number of years customers have lived in their current homes, and average customers credit balance. The first variable I will discuss is the likelihood the average income is less than $50,000. After looking at the sample of the customers I have discovered that the average annual income falls between $39,680 and $47,800. When it was tested further we have strong evidence that the average income for all customers is less than $50,000. The second variable I will discuss is the whether the percentage of urban customers is more than 40%. Initial testing revealed that the percentage of urban customers falls between 30 and 57%. Further testing revealed that we have strong evidence that the percentage of urban customers is greater than 40%. The third variable to be discussed is whether the average years a customer has lived at their current residence is less than 13 years. The mean years a customer has lived at their current residence is between 11 and 14 years. Based on some further testing there is strong evidence that the average number of years is more than 13 years. The fourth and final variable to be discussed is whether the average credit balance for customers is more than $4,300. The average credit balance for customers is between $3,712 and $4,228. Based on the averages we have strong evidence that the average credit balance is not more than...

Words: 529 - Pages: 3

Premium Essay

Accounting 505 Project B

...Accounting 505 Course Project B Jodi Metzger Capital Budgeting Decision Clark Paints has been investigating possible ways to trim production costs. One option is to make their paint cans instead of purchasing them from a supplier. The company estimates that it will need to manufacture 1,100,000 paint cans over the next 5 years. They have determined that their minimum rate of return for all new projects is 12%. Upon calculating the total cost of materials, labor and other variable production costs against the cost of purchasing the paint cans from a supplier, there is an annual cash savings of $72,540 in favor of making the paint cans. There is an addition cash savings due to depreciation of $32,000 and after taxes the total positive impact to cash flows is $58,351. This amount when figured into the payback period of the new equipment cost of $200,000 will make the payback period 3.4275 years which is a positive indicator for the project which has a 5 year length. The annual rate of return has been calculated at 13.18% which is above the required 12% for new projects. The net present value of the project is a positive $33,035.36 and the internal rate of return is 17.99% which is also above the required 12% for new projects. Every indicator shows a positive impact on the company. The decision should be made to move forward with the project to manufacture their own paint cans and discontinue the purchase of paint cans from a...

Words: 262 - Pages: 2

Free Essay

Team B Final Project

...Companies for a long time have strived to be successful and going global is the ultimate business goal of any large company. Because there are other countries selling similar products and services global competition is no secret. Wal-Mart is one of those companies that went global and did it quickly. They became the largest retail stores in the world which now employs a whopping 2.1 million people global wide. In order to go global, Wal-Mart had to make choices on how they wanted to go about it and be successful. Wal-Mart had to look at several things such as culture, job wages, property, management, etc. Because they knew that doing business in other countries would bring change in the company they had to cater to that area and its population to make max sales. Wal-Mart went hug quickly in the global industry which made other retailers struggle to catch up and stay competitive. Most of Wal-Mart’s products are now made overseas which keeps their costs down and labor costs low. One of the global issues that Wal-Mart has had to do concerning their competition is always looking for cheaper prices on products and goods. By doing this it affects poverty stricken countries in a good way by providing jobs for them. It is hard to say that there is global competition for Wal-Mart because Wal-Mart dominates most of the world and it might be said that global competition is effected by Wal-Mart. Right now Wal-Mart employs a staggering 1% (1.4 Million) of all working people in the United...

Words: 395 - Pages: 2

Premium Essay

Acct 505: Course Project B

...elaborating and supporting your answer. I would recommend the acceptance of Clark Paints’ proposal to purchase the new machine to make the paint cans instead of purchasing them. My decision to accept the proposal is supported by the net present value method. The net present value of this project is $33,035. Our textbook, Managerial Accounting, provides an explanation of this concept: “Under the net present value method, the present value of a project's cash inflows is compared to the present value of the project's cash outflows. The difference between the present values of these cash flows is called the net present value” (Garrison, 2012, p.583). Furthermore, our textbook, states: “Whenever the net present value is zero or greater an investment project is acceptable. Whenever the net present value is negative (the present value of the cash outflows exceeds the present value of the cash inflows), an investment project is not acceptable” (Garrison, 2012, p. 583). Below is a chart taken from our textbook, Managerial Accounting, found on page 583: EXHIBIT 13–1 Net Present Value Analysis of a Proposed Project I included this chart because it clearly explains the rules of when to accept or reject a project. And it further supports my decision to accept the proposal of the new machine because the net present value is a positive value: $33,035. According to this analysis Clark Paints should purchase the new machine. References Garrison, R. (2012). Managerial Accounting (14th ed)....

Words: 275 - Pages: 2

Premium Essay

B. H. Rube Goldberg Project Report

...Stapling Papers There were many steps that were included in the B.L.A.S.H. Rube Goldberg project. Our group members were Lucas Simmons, Amber Owens, Sam Eason, and Haley Phillips. We had to fulfill the task of stapling papers together. Our project consisted of 12 steps and had 6 different types of steps. The different types of steps were rolling, sliding, falling, flowing, springing, and pulling. All of these steps worked together, like a chain reaction, to complete our assigned task. Our group had to select 8 items that we picked from the stage. These were two golf balls, short pvc ramp, long pvc ramp, pvc tube, 8 dominoes, screw, and toothpaste. We had to bring in many different items that included: slinky, nails, glue, tape, plywood, hook, string, solo cups, water, cardboard, pool ball, ping pong ball, toy car, two by four wood, white trim, hard cup, two science books, stapler, two pieces of paper, water bottle funnel, and pvc elbow. These all served a certain purpose in our Rube Goldberg Project. The first...

Words: 1419 - Pages: 6

Free Essay

Week 6 Course Project Parts B and C

...Week 6 Course Project B) Written below is a sample communication via the use of a memorandum George Fisher has sent out to his employees at Kodak. In this communication message it will give information about the change Kodak is making into the digital world. Memorandum To: All Staff From: Mr. George Fisher, CEO Date: January 12, 2002 Subject: Changes to come For the past ten years we have been designing a strategy to embark on a new change into the digital world, leaving behind the existence of the use of film. It is crucial that we stay above our competitors and continue to change and explore new ways of finding our way in staying competitive in this ever-changing market. That is why we are beginning our conversion from film to digital imaging in the weeks to come. We will launch the changes immediately to in order to get our production started as our estimates are growth show much potential for success. Now, we might face some obstacles along the way in executing the change. Such as the need to invest in research and “release incrementally updated products in a number of different fields” as soon as possible, but we believe this will work. Therefore, we need you on board because you are the essential factor in helping us making this change a success story, and a great moment in Kodak’s history. We might have to cut some of our losses along the way, such as factories and jobs, in order to keep up with our counterparts and competitors, but there is more information...

Words: 867 - Pages: 4

Free Essay

Math 533 Week 6 Course Project Part B

...MATH 533 WEEK 6 COURSE PROJECT PART B To purchase this, Click here http://www.activitymode.com/product/math-533-week-6-course-project-part-b/ Contact us at: SUPPORT@ACTIVITYMODE.COM MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 Week 6 Course Project Part B MATH 533 WEEK 6 COURSE PROJECT PART B To purchase this, Click here http://www.activitymode.com/product/math-533-week-6-course-project-part-b/ ...

Words: 560 - Pages: 3

Premium Essay

Poo on Women: Is This Bad?

...session 10.00-12.00 | Afternoon Session 1.00-3.00 | | Subject/course | Teacher | Room | Subject/course | Teacher | Room | | Extend Diploma Electrical Engineering EDENGE22A | Barbara Walsh | C434A/C434B | Extend Diploma Engineering Electrical EDENGE22A | Barbara Walsh | C434A/C434B | | Extend Diploma Mechanical Engineering EDENGM22A/B | Peter Kempen | C402/C405 | Extend Diploma Mechanical Engineering EDENGM22A/B | Peter Kempen | C402/C405 | | GCSE English | Katherine Davey | G4 | GCSE English | Katherine Davey | G4 | | AS English Literature | Francesca Thomas | A58 | | | | | Archaeology: Unit 1 | Caroline Wilcox | B254 | Archaeology: Unit 2 | Caroline Wilcox | B254 | | Vocational Business assignment completion | Kemi Osoba | A49 | Vocational Business assignment completion | Bekoe Newman | A49 | | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | Spring Term Revision Schedule 2013-14 Week 1 | Tuesday 8th April | | Morning session 10.00-12.00 | Afternoon Session 1.00-3.00 | | Subject/course | Teacher | Room | Subject/course | Teacher | Room | | A2 Business (China Research Theme) | Nessa | A25 | AS Business | Nessa | A25 | | A2 Economics |...

Words: 883 - Pages: 4

Premium Essay

My Paper

...FOR PROJECT A Cash Flows DCF (13%) PV 350,000 0.8850 309,750 350,000 0.7831 274,085 350,000 0.6931 242,585 826,420 NPV = 826,420 – 735,000 NPV = 91,420 FOR PROJECT B Cash Flows DCF (13%) PV 300,000 0.8850 265,500 300,000 0.7831 234,930 300,000 0.6931 207,930 708,360 NPV = 708,360 – 690,000 NPV = 18,360 FOR PROJECT C Cash Flows DCF (13%) PV 200,000 0.8850 177,000 200,000 0.7831 156,620 200,000 0.6931 138,620 472,240 NPV = 472,240 – 600,000 NPV = (127,760) Assuming the cost of capital increase to 15%, the new NPV will be as follows FOR PROJECT A Cash Flows DCF (15%) PV 350,000 0.8696 304,360 350,000 0.7561 264,635 350,000 0.6575 230,125 799,120 NPV = 799,120 – 735,000 NPV = 64,120 FOR PROJECT B Cash Flows DCF (15%) PV 300,000 0.8696 260,880 300,000 0.7561 226,830 300,000 0.6575 197,250 684,960 NPV = 684,960 – 690,000 NPV = (5,040) FOR PROJECT C Cash Flows DCF (15%) PV 200,000 0.8696 173,920 200,000 0.7561 151,220 200,000 0.6575 131,500 456,640 NPV = 456,640 – 600,000 NPV = (143,360) At this point it is necessary for one to determine the sensitivity of the change in NPV of the three projects due to the increase in cost of capital. SUMMARY OF NPVS’ CALCULATIONS PROJECT | NPV @ 13% | NPV @ 15% | % CHANGE IN NPV | A | 91,420 | 64,120 | * 29.86% | B | 18,360 | (5,040) | * 127.45% | C | (127,760) | (143,360) | * 12.2% | From the table above it is clear that all three projects had...

Words: 350 - Pages: 2

Premium Essay

Half Term Revision Dates

...session 10.00-12.00 | Afternoon Session 1.00-3.00 | | Subject/course | Teacher | Room | Subject/course | Teacher | Room | | Extend Diploma Electrical Engineering EDENGE22A | Barbara Walsh | C434A/C434B | Extend Diploma Engineering Electrical EDENGE22A | Barbara Walsh | C434A/C434B | | Extend Diploma Mechanical Engineering EDENGM22A/B | Peter Kempen | C402/C405 | Extend Diploma Mechanical Engineering EDENGM22A/B | Peter Kempen | C402/C405 | | GCSE English | Katherine Davey | G4 | GCSE English | Katherine Davey | G4 | | AS English Literature | Francesca Thomas | A58 | | | | | Archaeology: Unit 1 | Caroline Wilcox | B254 | Archaeology: Unit 2 | Caroline Wilcox | B254 | | Vocational Business assignment completion | Kemi Osoba | A49 | Vocational Business assignment completion | Bekoe Newman | A49 | | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | Spring Term Revision Schedule 2013-14 Week 1 | Tuesday 8th April | | Morning session 10.00-12.00 | Afternoon Session 1.00-3.00 | | Subject/course | Teacher | Room | Subject/course | Teacher | Room | | A2 Business (China Research Theme) | Nessa | A25 | AS Business | Nessa | A25 | | A2 Economics |...

Words: 883 - Pages: 4

Free Essay

Kanpur

...knowledge to serve my best to the organization as well as my professional growth. Academics Relevant Courses: • Completed six weeks course and training in JAVA from SLR Infotech Pvt. Ltd, CHANDIGARH. • Pursuing 6 Months course and training in JAVA from DUCAT,NOIDA. • Completed six weeks course in C++ From ICT, KAITHAL B. Tech Projects: S.No Name Of the Project Description Team Members Roles and Responsibilities 1. CHANDIGARH TOURISM (B.Tech Summer Training Project) It was a software project based on core JAVA. It includes all the places to visit , map of chandigarh , hotel room booking , slides . Backend was based on MS-ACCESS . 2 Coding of Some pages, database manipulation & connectivity and preparing Crystal Reports. 2. DELHI TOURISM (B.Tech Minor Project ) It was a software project based on core JAVA. It includes all the places to visit , map of delhi , hotel room booking , slides . Backend was based on MS-ACCESS . 2 Coding of Some pages, database manipulation & connectivity and preparing Crystal Reports. 3. CRIME FILE MANAGEMENT (B.Tech Major Project ) It was a website describing various departments in crime department. It includes 3 modules WRITER , INSPECTOR , ADMIN. Writer writes complaints , Inspector investigates by watching the record using id’s and admin has all the controls. Platform used was ECLIPSE and backend was ORACLE database. 2 Overall designing of pages & coding of Admin Panel. ...

Words: 375 - Pages: 2