Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.
4 Pages
SA10 YOUR NAME ib_e05_chartchaos.xlsx
Course: CTS 130, Spring 2011School: Fayetteville Technical CC
Rating:
Word Count: 165
Document Preview
Category Product Trends 50,000 50000 50000 45,000 40000 40,000 35,000 25,000 40000 35000 30000 30000 30000 30,000 Unit Sales 40000 30000 30000 30000 25000 25000 20000 20,000 20000 15,000 10,000 5,000 0 2006 2007 2008 2009 Suits Dress Pants Casual Pants Casual Knits Sales Data for Product Lines Units Sales Product Suits Dress Pants Casual Pants Casual Knits 2006 50,000 35,000 25,000...
Unformatted Document Excerpt
Coursehero >> North Carolina >> Fayetteville Technical CC >> CTS 130Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Category Product Trends
50,000
50000
50000
45,000
40000
40,000
35,000
25,000
40000
35000
30000
30000
30000
30,000
Unit Sales
40000
30000
30000
30000
25000
25000
20000
20,000
20000
15,000
10,000
5,000
0
2006
2007
2008
2009
Suits
Dress Pants
Casual Pants
Casual Knits
Sales Data for Product Lines
Units Sales
Product
Suits
Dress Pants
Casual Pants
Casual Knits
2006
50,000
35,000
25,000
20,000
2007
40,000
30,000
30,000
30,000
2008
30,000
30,000
30,000
40,000
2009
20,000
25,000
40,000
50,000
#
1
Questions
Did the Casual Knits bar in the year 2007 really disappear? Can an
individual bar be formatted on a column chart?
Why some are of the bars cut off at the top of the chart? Look at the
worksheet named Sales Data. What is the highest unit sales value?
2
Compare this to the highest sales value along the Y-axis. How could
the values or scale for the Y-axis change?
3
In the years 2007 and 2008, several data labels merged together. Can
an individual data label be formatted or moved?
Answers
No it did not disappear it had been formatted incorrectly and is now purple
By formatting the axis you can change the maximum to the max units to show all data
By formatting the labels you can change the alignment so that all of the labels do not run
together.
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more.
Course Hero has millions of course specific materials providing students with the best way to expand
their education.
Below is a small sample set of documents:
Below is a small sample set of documents:
Fayetteville Technical CC - CTS - 130
Change in Market Value by Month7.00%6.00%5.00%4.00%3.00%Our Company2.00%DJIAChange in Value Year to Date1.00%0.00%-1.00%-2.00%-3.00%JanuaryMarchJulyMayNovemberSeptember2004 Change in Stock ValueChange in Value Year to DateMonthJanu
Fayetteville Technical CC - CTS - 130
Supply and Demand for Product A12345678910Price$5.00$4.50$4.05$3.65$3.28$2.95$2.66$2.39$2.15$1.94Supply12511310191827466605448Demand240267296329366406452502558619Supply and Demand for Product A$12$10$8Price
Fayetteville Technical CC - CTS - 130
Product Sales History by Category(in Millions)Product Sales History200420052006$35.0Category A$15.3$20.6$27.2$30.0Category B$22.4$21.2$18.3Category C$5.7$14.8$28.9Category D$12.0$14.3$16.5Category E$11.2$12.9$15.1$25.02004200
Fayetteville Technical CC - CTS - 130
Insdustry X Sales Analysis20.0%15.0%14.0%10.0%5.0%3.0%Change in Sales1.0%0.0%-5.0%-6.0%-10.0%-15.0%2000200120022003200420052006Industry XHistorical Sales Growth ResultsCompany ACompany BCompany CAverage200010.0%2.0%-10.0%200
Fayetteville Technical CC - CTS - 130
StockSymbolCoFCoDCoBCoCCoACoECompany NameCompany FCompany DCompany BCompany CCompany ACompany ECurrent StockPrice$9.89$57.60$42.50$23.18$78.60$32.50Historical Data for Company DGross SalesReturnsNet SalesCost of Goods SoldGross
Fayetteville Technical CC - CTS - 130
Investment StrategyCustomer Name:Customer 8Risk PreferenceMDollars InvestingInvestment CategoryBondsMutual FundsStocks$750,000Proposed Investment$10$10$139RiskCategoriesConservativeCBonds80%Mutual Funds20%Stocks0%ModerateM30%30
Fayetteville Technical CC - CTS - 130
Using FinancialFunctionsThis business math workshop will help you to understand how to use certain Financial Functions available through the Funwizard provided by Excel. The function wizard has many available financial functions, but we will only conce
Fayetteville Technical CC - CTS - 130
Financial Review for Company XInvestmentsConservative BConservative AModerate AModerate BRisky BRisky AValue LastYearPresent Value$5,000,000$5,200,000$3,500,000$3,622,500$2,500,000$2,650,000$1,850,000$1,998,000$750,000$840,000$575,000
Fayetteville Technical CC - CTS - 130
#Questions1Do the amounts calculated on the spreadsheetmake sense?2Were the arguments in the PMT and FVfunctions properly defined?3Are the statistics of the investment properlyconsidered in the analysis?Answersnono they were not. For the pmt
Fayetteville Technical CC - CTS - 130
#Questions8Given the current contribution of $75 per month, willthis person reach her taget through any of thescenarios?9How much money will she have to deposit in heraccount per month (approximately) to reach $2 milliontaking the Aggressive inve
Fayetteville Technical CC - CTS - 130
#QuestionAHow many components, not total items, need to beordered?BHow many components, on average, are we orderingfor each of those that need to be ordered?(Hint: use average function)Answer9 comonents520ItemComponent 1Component 2TotalsUn
Fayetteville Technical CC - CTS - 130
#1234QuestionsHe said that he used the Absolute reference on one of thecell locations in the formulas but, he still gets this funnyerror.He used a sum function in cell B8 but he thinks the totallooks a little low for the answer after emailing th
Fayetteville Technical CC - CTS - 130
#Question:12Compare the output of the formulas youcreated in cells C9 and C10. Is this companymaking enough money to cover its fuel cost?131415If fuel prices are increased to $3.05 per gallon,how much will this company have to increaseits charg
Fayetteville Technical CC - CTS - 130
#QuestionsLook at the totals in cells B8, C8, F8. Do the1 numbers add up?Test drive the sheet by changing the amount in cell2 D4 to .10 do you see a new sales plan number in C4that makes sense.Change the value in B4 to 8000000. Do you see a3 new s
Fayetteville Technical CC - CTS - 130
#QuestionAnswerIs this company making any profit servicingNoonly 25 customers per year.Will this business be profitable if 10010Nocustomers are serviced in a year?9How many customers must be services for 152 customers are needed to have a net p
Fayetteville Technical CC - CTS - 130
Errors FoundDept 25 Children's Crib shows that at the beginning of the week there were only1 100 cribs but at the end of the week there are 7500 even though none werereceived.2 weekly sales data title3 column headers4 sales in weekly sales data titl
Fayetteville Technical CC - CTS - 130
Question11How is store 6214 performing relative to other stores in this district?12What stores are experiencing a decrease in sales compared to last year?13Over all, how does the district appear to be perofming?Are most stores seeing an increase in
Fayetteville Technical CC - CTS - 130
#Question9Compare sheet 1 and 2. What formatting techniques make thebiggest impact?10What stores are expected to receive 37 annual truck deliveries,and what is the size of these stores in square feet?11What information was necessary before adding
Fayetteville Technical CC - CTS - 130
Merchandise Performance ReportCategoryItemColorUnit Sales PriceBottomsBottomsBottomsBottomsShoesShoesShoesShoesShoesTopsTopsTopsTopsTopsTopsTopsTopsTopsShortsShortsShortsShortsBootsSandalsBootsSandalsSandalsSweaterSweater
Fayetteville Technical CC - CTS - 130
DeptDeptNumberName40 Shoes10 Jewelry40 Shoes20 Dresses40 Shoes10 Jewelry10 Jewelry20 Dresses30 Suites50 Coats30 Suites50 CoatsItemBrown MuleNecklaceBlack LoaferRose PrintOpen ToeRingWatchLinenBlack SolidTan RainPinstripeLong Wo
Fayetteville Technical CC - BUS - 116
Module 4 Writing AssignmentFrances DrewBus 116 0901SP1. Sugarland granted Carlos the right to sell Sugarland's candy products and to use its trademarkand trade name in connection with his business. One day, Sue bought a piece of Sugarland candyfrom C
Fayetteville Technical CC - BUS - 116
Module 3 Online AssignmentFrances DrewBUS 116 0901SPThe Lily Law Office insists that in order to protect your small bossiness from being liablefor the unauthorized acts of your employees that it is important to protect yourself from the verybeginning
Fayetteville Technical CC - BUS - 116
Module Three Writing AssignmentFrances DrewBus 116 0901SP1. Inverness Corporation markets the Inverness Ear Piercing system, which includes a trainingcourse, an "eye-catching" assortment of selling aids" such as counter displays, and release formstha
Fayetteville Technical CC - BUS - 116
Frances DrewBus 116 0901 SPModule 2 WA1.Baxco Corp. makes and sells several products, and it wants to register the products' names on thePrincipal Register in order to obtain federal trademark protection. Baxco wants to register: (1) "Xeri-fun,"the
Fayetteville Technical CC - BUS - 116
The Club Z! AdvantageClub Z! in-Home Tutoring Services is a franchise that offers us a unique opportunity toprovide a much needed service to todays future. Even with the title of a tutoring service, as theowners of the franchise there is no need for pr
Fayetteville Technical CC - BUS - 116
Online Assignment 1BUS 116 0901SPFrances DrewThe truth about the infamous McDonalds coffee case is that the fast food chain actedrecklessly and it time that someone brought them to trail to make them pay for their recklessness.While many people joke
Fayetteville Technical CC - BUS - 116
Writing Assignment 1Business Law 116 0901SPFrances Drew1. Benes contracts to purchase from Glover one hundred cases of Knee High Corn to be shippedF.O.B. from Glover's warehouse by Reliant Truck Lines. Glover, by mistake, delivers one hundredcases of
Fayetteville Technical CC - BUS - 137
Chapter 14Self-AssessmentBUS 137 Principles of Management 1903SUFrances Drew1. I scored an 80 so I was very surprised by my score. This puts me rather low on theleadership skills bit I suppose there is a difference between leaders and managers. I gue
Fayetteville Technical CC - BUS - 137
Chapter 13Management In ActionBUS 137 Principles of Management 1903SUFrances Drew1. A combination of problem solving teams and project teams are being used atI CU. If you take knowledgeable workers that meet for a temporary team tosolve a problem an
Fayetteville Technical CC - BUS - 137
Test 3, Part 2BUS 137 Principles of Management 1903SUFrances Drew1. The term emotional intelligence refers to the way that a person relates to other persons in theworkplace. For example the most essential trait is self-awareness is the trait that allo
Fayetteville Technical CC - BUS - 137
ZapposMk t 120 1902SUMs. SeafordFrances Drew1. Zappos has made itself a different retailer in many ways. First they start bym arketing themselves to be a service company that sells a lot of differenti tems. Most companies are only about the bottom d
Fayetteville Technical CC - BUS - 137
Chapter 12Management In ActionBUS 137 Principles of Management 1903SUFrances Drew1. Sue Nokes took note that the customer service employees had a 100% turnover rate and a12% daily absenteeism rate. She realized that the basics needs of employees to f
Fayetteville Technical CC - BUS - 137
Chapter 11Self-AssessmentBUS 137 Principles of Management 1903SUFrances Drew1. I scored a 39 in my EI test. This scored did not really surprise me. Actually I thought Iwould have scored lower in this area. While I am able to relate well with other pe
Fayetteville Technical CC - BUS - 137
Principles of ManagementBUS-137TEST #2 (Take-Home)DO NOT WRITE ON THIS TESTPart 1: Multiple-Choice Questions: Select the best answer (2 points each).1. Having just spent $1500 for a new engine for his old car, Roland now learns his transmissionneeds
Fayetteville Technical CC - BUS - 137
Principles of ManagementBUS-137Test #2 (Take-Home) Score SheetNAME:_Frances Drew_ DATE:_July 5 2011_Multiple-Choice Answers (2 points each)1. d16. d2. c17. a3. c18. d4. b19. d5. c20. c6. d21. b7. c22. a8. c23. c9. d24. b10. b25. d
Fayetteville Technical CC - BUS - 137
Chapter 10Self-AssessmentB US 137 Principles of Management 1903SUFrances Drew1. I scored a 44 which is a High Adaptability which I completely agree with. Ihave always taken pride in the fact that I can adjust fairly easily to changeand even welcome
Fayetteville Technical CC - BUS - 137
Chapter 9Management In ActionBUS 137 Principles of Management 1903SUFrances Drew1. A company could inadvertently discriminate when fi ring employees by have tom uch of a personal relationship with an employee. In the lesson Ms.F rederickson says I l
Fayetteville Technical CC - BUS - 137
Chapter 8Management In ActionBUS 137 Principles of Management 1903SUFrances Drew1. Mr. Khosrowshahi is trying to change the culture at Fuji Fire to help take the company tothe next level. Obviously the culture in the organization was not helping the
Fayetteville Technical CC - BUS - 137
Chapter 6: The primary means of sustanining a competitive advantage is to adjust fasterto the environment than your competitors do. Do you agree or disagree with thisstatement? Explain your position.I absolutely agree with this statement. If you are sl
Fayetteville Technical CC - BUS - 137
Chapter 7Self-AssessmentBUS 137 Principles of Management 1903SUFrances Drew1. My highest score of 4 As was a directive style and my lowest score with 2 Ds wasbehavioral style. This says that my style is more of the directive which is efficient,logic
Fayetteville Technical CC - BUS - 137
Chapter 6Management In ActionBUS 137 Principles of Management 1903SUFrances Drew1. I think that of M ichael Porters strategies, Walgreens strategic position isB road needs, few customers. I say this because with Walgreens and the patht hat they have
Fayetteville Technical CC - BUS - 137
Chapter 5Management In ActionBUS 137 Principles of Management 1903SUFrances Drew1. Apple is very ahead of the game when it comes to strategic planning. Theysaw that there was a huge market for the IPhone and even though they knewt hat by doing i t r
Fayetteville Technical CC - MKT - 120
Mkt 120 1902SUMs. SeafordFrances Drew1. Electrolux realize that consumers have an its all about me attitude. Theystart with the consumer that knows what they need and Electrolux realizesthat it is not for them to tell the consumer what it is they nee
Fayetteville Technical CC - MKT - 120
Mkt 120 1902SUMs. SeafordFrances Drew1. No I do not think that Colgate-Palmolives success has anything to do with theeconomy. As the text states It seems as though looking and smelling clean mightjust be recession-proof concepts is true. People are a
Fayetteville Technical CC - MKT - 120
Radian6Mkt 120 1902SUMs. SeafordFrances Drew1. Traditional research methods can be time consuming and not yield all the informationneeded. How does a company know what consumers to target? For the most part it seemsto be a guessing game. Radian6 has
Fayetteville Technical CC - MKT - 120
NetFlixMkt 120 1902SUMs. SeafordFrances Drew1. Netflix is an ingenious way to allow people to have entertainment in their homes for aminimal amount of money. Back in the days of renting movies from Blockbuster andHollywood video one could expect to
Fayetteville Technical CC - MKT - 120
Live NationMkt 120 1902SUMs. SeafordFrances Drew1. Live Nations mission is to bring together people and their favorite artist and to maximizethe concert experience. The basis of its business is selling tickets, marketing andproducing for performers
Central New Mexico Community College - ARTH - 1101
Mary J. VigilJuly 25, 2011ARTH 1101Take Home QuizMovements in Art HistoryDefine specific characteristics or traits that identify or help us understand each movement or period of time. Give at least oneexample including the artists name, title of the
Central New Mexico Community College - ARTH - 1101
Mary J. VigilJuly 18, 2011Art 101 VocabularyArchitectureDefine the following terms and give an example of a building that utilizes eacharchitectural term, including location and time period it was constructed.1) Post and Lintel: In architecture, a s
Ecole Polytechnique Fédérale de Lausanne - ACCT - 1850
BUSA3000COMPREHENSIVEEXAMREVIEWMULTIPLECHOICE.Choosetheonealternativethatbestcompletesthestatementoranswersthequestion.1)Whichofthefollowingstatementsappliestoobtaininganundergraduatecollegedegree?1)_A)Theyareexpensiveandrarelypayoffinincreasedearning
Ecole Polytechnique Fédérale de Lausanne - ACCT - 1850
BMGT500-1901-Principles of Management-FA09-TengYou are logged in as Maulikumar Patel (Logout)You are hereUNVA-Online/ BMGT500-1901-Fa09/ Quizzes/ Final Exam/ Attempt 1Final Exam - Attempt 1Top of FormQuestion 1Marks: 1At Southwest Airlines, _
Ecole Polytechnique Fédérale de Lausanne - ACCT - 1850
BMGT500-191-Principles of ManagementSU09-TengYou are logged in as Vaishali Patel (Logout)You are hereUNVA-Online/ BMGT500-191-SU09/ Quizzes/ Final Exam/ Review of attempt 2Final ExamReview of attempt 2Started onSunday, September 27, 2009, 11:20
Ecole Polytechnique Fédérale de Lausanne - ACCT - 1850
P roblem 3.12.Suppose that in Example 3.4 the company decides to use a hedge ratio of 0.8. How does thedecision affect the way in which the hedge is implemented and the result?I f the hedge ratio is 0.8, the company takes a long position in 16 NYM Dece
Ecole Polytechnique Fédérale de Lausanne - ACCT - 1850
NAME: RINKESH PATELID:109-00-4386UNVA FINA 523 PERSONAL FINANCIAL ADVISINGFinal - EXAM spring 20111. DOWN LOAD THE WORD FILE2. ANSWER PROBLEMS. Total Points = 126 A=113, B = 101, C = 883. SAVE IT and Email it to: NSarin.faculty@UNVA.edu orNelsonsar
Ecole Polytechnique Fédérale de Lausanne - ACCT - 400
Annual Compounding 4.1 Compute the future value of $1,000 compounded annually for a. b. c. 10 years at five percent 10 years at seven percent 20 years at five percent Why is the interest earned in part (c) not twice the amount earned in part (a)?d.4.2C
Ecole Polytechnique Fédérale de Lausanne - ACCT - 400
BMGT500-1901-Principles of Management-FA09-TengYou are logged in as parth patel (Logout)You are hereUNVA-Online/ BMGT500-1901-Fa09/ Quizzes/ Final Exam/ Attempt 1Final Exam - Attempt 1Top of FormQuestion 1Marks: 1Holli Perdue is looking for a
Ecole Polytechnique Fédérale de Lausanne - ACCT - 400
FINA-523 Summer 2011 - First Quiz Chapters 1 thru 41. You need to review your progress, reevaluate, and revise your plan (step 5) becauseA) your financial needs change over your lifecycleB) your employment situation changes from time to timeC) your ne
Ecole Polytechnique Fédérale de Lausanne - ACCT - 400
FIN 353: Exercise Problems on Derivative Assets 1. Sample problem on Futures Hedging: On July 1, an investor holds 50,000 shares of a certain stock. The market price is $30 per share. The investor is interested in hedging against movements in the market o
Ecole Polytechnique Fédérale de Lausanne - ACCT - 400
Chapter 16True/False Questions1. For securities firms, income from investment management is more stable than the income fromunderwriting or trading.Answer: True Page: 457 Level: Medium2. Full line investment banks act as both broker dealers and secur
Ecole Polytechnique Fédérale de Lausanne - ACCT - 400
WORKSHEET 1 - PERSONAL FINANCIAL GOALS WORKSHEETMake sure your goals are realistic and stated in specific, measurable terms. In addition, prioritize your goals and identify a specifictime frame within which you would like to accomplish them. The listing
Ecole Polytechnique Fédérale de Lausanne - ACCT - 400
ASSIGNMENT 6FINA 510SAPAN PANCHALID 110-00-32601. If we examine a typical bank's asset portion of the balance sheet, how are theassets arranged in terms of expected return and liquidity?Answer:In banking, liquidity is the ability to meet obligations