tools is essential to tracking, storing, business and finance homework help

Anonymous
timer Asked: Aug 23rd, 2017
account_balance_wallet $15

Question Description

Using Microsoft Excel or other spreadsheet tools is essential to tracking, storing, reading, and learning from data. It is used by businesses every day to spot trends, issues, growth patterns, and risks.

Unformatted Attachment Preview

Purchasing a new Vehicle – Paying with Cash Takisha Shanta Davis Darcel Ford Introduction to Information Systems August 14, 2017 1 Purchasing a new Vehicle – Paying with Cash Purchasing a New Vehicle My selected problem was the purchase of a new vehicle. I chose this problem because there are so many issues or problems associated with the purchase of a new vehicle and thus so many mistakes are made by people who go ahead to purchase vehicles from an uninformed point of view. I seek therefore to understand all there is to do with purchasing a new vehicle so that the mistakes I am bound to make are significantly reduced as well as ensuring that I make the best decision. Anyone with an intention to purchase a vehicle at a point in their lives will benefit from the information I find out given that there is a lot of fraud associated with the automotive industry. I am also after informing others who would like to purchase a vehicle of the various available options and the best ones that are more feasible and can be explored at the most optimal costs. As earlier identified, some of the major problems identified include identification of the cost, method, and quality of the vehicle one may want to purchase. Proposed Solutions to the Problem Most of the sources listed below are from The Telegraph • Paying with Cash • Using a Car Loan • Leasing • Personal loan 2 Purchasing a new Vehicle – Paying with Cash • Personal contract purchase • Hire Purchase • Loan Purchase • Credit Card Recommended Solution My top recommended solution to the problem identified above is paying with cash. This can be achieved by planning well in advance and making the necessary savings towards the same. I am for purchasing using cash because a car is basically a liability. It is not an income generating project but instead, it consumes cash. A vehicle needs a lot of money for maintenance and it incurs the cost of depreciation over its lifetime. It is therefore unwise to take a loan or any other refundable financing option to purchase a liability that will still need money to be maintained. Also, a loan will need to be paid back with interest which is another cost that people who want to be rich rather not incur it. It, therefore, goes that paying for a vehicle with cash is the best option that an individual could take because of the advantages it has and the peace of mind associated with it. Benefits Risks The costs that could have been incurred on Savings are significantly decreased and more interest are saved. specifically for unforeseen events. Immediate ownership of the vehicle is Investment opportunities for the cash earned. incurred are lost. The buyer may take advantage of discounts. 3 Purchasing a new Vehicle – Paying with Cash The true cost of the vehicle is unmasked as opposed to purchasing using car loans. Additional Online Resources • The Federal Trade Commission: Buying a New Car. Available at https://www.consumer.ftc.gov/articles/0209-buying-new-car • USA.gov: Buying a Car. Available at https://www.usa.gov/buy-a-car • Consumer Reports: 10 common car-buying mistakes. Available at https://www.consumerreports.org/cro/2012/12/10-common-car-buying-mistakes/index.htm • The Telegraph: The best ways to pay for a new car. Available at http://www.telegraph.co.uk/finance/personalfinance/money-saving-tips/6120164/The-bestways-to-pay-for-a-new-car.html 4 Purchasing a new Vehicle – Paying with Cash References Consumer Reports: 10 common car-buying mistakes. Available at https://www.consumerreports.org/cro/2012/12/10-common-car-buying-mistakes/index.htm The Federal Trade Commission: Buying a New Car. Available at https://www.consumer.ftc.gov/articles/0209-buying-new-car The Telegraph: The best ways to pay for a new car. Available at http://www.telegraph.co.uk/finance/personalfinance/money-saving-tips/6120164/The-bestways-to-pay-for-a-new-car.html USA.gov: Buying a Car. Available at https://www.usa.gov/buy-a-car 5 ASSIGNMENT 3 CREATE A PLAN Due Week 8: 150 points OVERVIEW Using Microsoft Excel or other spreadsheet tools is essential to tracking, storing, reading, and learning from data. It is used by businesses every day to spot trends, issues, growth patterns, and risks. As you learned this week, Deidre Jefferies uses Excel to create spreadsheets she sends to potential and current clients, to track inventory and pricing, and to set goals and see potential areas for improvement within the business. In this assignment, you will use Microsoft Excel to outline the steps you would take to implement your plan for your solution that you identified back in Assignment 2, and to outline the costs that will be involved in your plan. Additionally, you’ll use basic functions to analyze your plan. You will format your worksheets to make them easy to work with as well. 1 Follow the steps below to create your Implementation Plan and Costs Chart for your plan to solve your identified problem. [If you don’t remember how to operate these functions in Microsoft Excel, refer back to TestOut, the course material, your instructor, or Google it!] •• Download the Sample Implementation Plan and Costs Chart .xlsx file located in your Blackboard course shell. Note: This sample should only be used as reference and cannot be edited. INSTRUCTIONS 1) Create, title, and save your workbook a) Create a new workbook using Microsoft Excel. b) Create two (2) sheets inside the workbook and title them “Implementation Plan” and “Costs Chart”. You can name the sheets by right clicking the tab at the bottom of the sheet and choosing “Rename.” c) Add the same titles at the top of your spreadsheets in Cell A1, then use “merge and center” on the home ribbon when you are finishing your formatting. This will center your title at the top of your work and make the printed version (if you choose to print out your workbook) look more professional. d) Save your workbook as Firstname_Lastname_Assignment3_CIS105.xlsx 2) Create an Implementation Plan and Timeline on Sheet #1. Regardless of what problem you are trying to solve, a plan is only as good as the effort taken to think through its steps. 2 a) Create labels as shown on the sample in the first three columns of this worksheet; one titled “STEPS,” one titled “TARGET COMPLETION DATES,” and the last titled “TIME ESTIMATES.” STEPS i) List each major step you would need to complete under the “STEPS” column. Bold the font of each step. Customize these to fit your actual ideas (don’t just label them “Step 1”, “Step 2”, etc. like in the sample) and be descriptive of what each step is. For example, “Painting”, “Baking”, “Writing”, etc. Add additional rows as needed. ii) List at least two (2) actions you need to take for each major step. Again, be descriptive (don’t just label them “Action 1”, “Action 2”, etc. like in the sample) TARGET COMPLETION DATES i) List the target deadline for each major step and action under the “TARGET COMPLETION DATES” column. Note that completion dates for the major step should be equal to the last date of the action within that step that will take the longest. Use DD/MM/YYYY format for your target deadlines (ex: 01/31/2017) TIME ESTIMATES i) List a time estimate (in hours) for each major step under the “TIME ESTIMATES” column. ii) Using the Sum function, calculate the total time estimate for your entire implementation plan at the bottom of this column as shown in the example. 3 3) Create a Costs chart on Sheet #2. Even if the problem you chose was personal, there are likely going to be some costs associated with solving it. If you did choose a problem with minimal to no costs involved, (for example, stress management) here is where you would include all potential costs for good and/or services you could purchase to help you reduce stress, such as a massage or a meal delivery service. a) First, create headers for two columns; one titled “ITEM” and one titled “COSTS.” b) List each of the major items or factors you would need for your solution (i.e. your own and others’ time, equipment, transportation, products, etc.) under the “ITEM” column. You’ll need approximately 5-15 items total. If you have fewer than 5 items, break these down into smaller sub-items. If you have more than 15 items, consolidate similar items. Be descriptive here and adjust the width of your columns as needed. c) Include a realistic cost estimate for each of the items involved in your plan under the “COSTS” column. d) Add a third column labeled “Comment” and comment on each of the costs, explaining how you came up with that cost. These notes to yourself are very helpful when you look back on an older spreadsheet, and also help explain to others why things are on the sheet. e) Add up the total costs using the Sum function. Remember to start all function cells with an equal sign (=). f) Next, add an “Average” label and calculate the average cost of the item costs you’ve identified for your plan. This way, you can easily see if each cost is larger or smaller than the average. 4 g) Add a “Lowest” label next, and calculate the smallest of your costs. This might come in handy to show you which item you can easily knock out first. Use the MIN function here. h) Add a “Highest” label after this, to show which item is the largest cost. You’d be surprised how useful this label can be when you have a lot of data to sift through. Use the MAX function here. i) Test your data by putting in some random numbers. Make sure your MIN and MAX functions are working correctly by changing one of the values to a small number and one to a large number. Add up all of the figures on a calculator or use all “1’s” and count them to make sure the sum and average functions are working correctly. After you test your formulas, enter the real data. j) Create a pie chart graphic that shows a breakdown of the percentages of each cost area by using the layout functions. The pie chart is used to represent percentages of the whole. It allows you to see at a glance how much of your total cost is represented by each individual cost. Insert the pie chart as an object in the sheet. Click on one of the pie labels once and select the Enlarge button shown here to make the pie chart large enough to read (size 12-14 font recommended). Right-click on the label and select “Format Data Labels”. When you see the panel options, set them as “percentage”. Uncheck the “Value” option, and ensure that the “Percentage” option is checked. If you have a lot of labels, be sure to check the “Show Leader Lines” option See Format Data Labels options below: 5 k) Merge and Center the title at the top of your spreadsheet just as you did in Sheet #1. 4) Format your workbook. a) Change the font for all dollar amounts to a new font that you feel is clean and easy to read in spreadsheet format. b) Add professional-looking color to some of the font in the sheet (For example, the titles or headers). Remember, the goal is to make your workbook easier to read. So you wouldn’t want to use light yellow fonts, for example, because they would be hard to see against a white background. c) Add additional formatting elements such as centering and bolding to make your sheet more visually appealing and easier to read. d) Be sure to spell check your workbook to check 6 for any typos or errors. e) Don’t forget to re-save your file at the end as Firstname_Lastname_Assignment3_CIS105.xlsx Recommended TestOut Desktop Pro Skills Labs to review prior to completing this assignment are: •• 3.2.4 Skills Lab: Create and Manage Workbooks •• 3.3.5 Skills Lab: Organize and Enter Data •• 3.5.6 Skills Lab: Format Cells •• 3.6.4 Skills Lab: Enter Simple Formulas •• 3.8.4 Skills Lab: Analyze Data in Charts 7 Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric. POINTS: 150 Criteria 1. Create, title, and save your workbook Weight: 10% 2. Create an Implementation Plan and Timeline on Sheet #1. Weight: 40% ASSIGNMENT 3: CREATE A PLAN Unacceptable Meets Minimum Expectations Fair Proficient Exemplary Below 60% - F 60-69% - D 70-79% - C 80-89% - B 90-100% - A Workbook is not submitted or submitted with no title. Workbook is submitted but not titled, or title is not relevant to ongoing problem/solution. File format and/or naming conventions are incorrect. Workbook is submitted, titled partially appropriately, and in the correct file format. Naming conventions are incorrect. Workbook is submitted, titled appropriately, in the correct file format and correct naming conventions. Workbook is submitted, has a clear and relevant title, in the correct file format and correct naming conventions. Implementation plan and timeline are not included in submission. Implementation plan or timeline is included, but is unclear, incomplete, and unformatted. Implementation plan and time line are included, are partially clear, partially complete, and/or partially formatted. Implementation plan and timeline are clear, complete, and formatted, including both major steps and actions; time estimates and date ranges are included. Implementation plan and timeline are thorough, complete, clear, and correctly formatted; includes well-written major steps with at least two (2) actions for each major step; includes reasonably accurate date ranges, reasonably accurate time estimates and an accurate total time for implementation. 8 POINTS: 150 Criteria 3. Create a Costs Chart on Sheet #2. ASSIGNMENT 3: CREATE A PLAN Unacceptable Meets Minimum Expectations Fair Proficient Exemplary Below 60% - F 60-69% - D 70-79% - C 80-89% - B 90-100% - A Costs chart is not included in submission. Costs chart is included, but is unclear and incomplete. No graphic is included. Costs chart is included, is partially clear and partially complete. Pie chart graphic is included but not formatted correctly. Costs chart is clear and complete; includes major cost areas of plan, costs for each area, and total cost for plan. Functions have been used to create costs chart. Costs chart is thorough, complete and clear; Layout and design of costs chart is visually appealing; includes five to fifteen (5-15) major cost areas of plan, reasonably accurate costs for each area, and reasonably accurate total cost for plan. Functions and labels have been used as directed. Data labels in pie chart graphic have been formatted correctly. Workbook is not formatted at all. Workbook is insufficiently formatted. Workbook is partially formatted. Workbook is satisfactorily formatted, including updates to font and color. Workbook has been spellchecked. Workbook is thoroughly formatted, including the use of visually appealing fonts, color, and centering. Workbook has been spellchecked and is free of errors. Weight: 40% 4. Format your workbook. Weight: 10% 9 ...
Purchase answer to see full attachment

Tutor Answer

TutorAR
School: UIUC

Hi,Find attached the completed work.Feel free to ask for any clarification or editing if need be.Looking forward to working with you in the future.Thank you.

Implementation Plan
STEPS
Choosing the desired car
1. Determine the most affordable ones
2. Create a shortlist of the ones I am interested in
3. Browse online for th...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors