Description
every thing is in the attachment please follow all the instructions i want 2 files to be sent sepratley i will put them in one zip
Unformatted Attachment Preview
Data Validation and Input Controls
If you add extra controls features, you will also submit a brief note, typed in Word, as the
documentation of the extras. You will submit the electronic document(s) in ONE ZIP archive . Create a
spreadsheet in EXCEL to reconcile bank statement. Organize it as follows:
•
•
•
•
•
•
All the cells must be appropriately formatted, e.g. dollar amounts must use the accounting
format, etc. Other formatting such as bold, underline and italic are expected to be used in
appropriate places.
All the negative adjustments must be typed in as negative values. The input must be
validated by using data validation tools. The values must also be displayed in RED by using
conditional formatting.
Appropriate input controls, such as range check or length check, must be applied to
attributes/elements such as check numbers.
All the (sub-)totals of continuous ranges must be prepared by using the aggregation
functions provided in EXCEL.
The IF function should be used to make logical judgment.
Additional control features are encouraged but not required.
Use the numbers below to show how your spreadsheet works.
Balance per Bank Statement
Balance per Book
$ 107,525.33
$ 106,928.68
Collection of Notes receivable by the bank:
Principal
Interests
Fee charged by the bank for collection
$ 10,000.00
$
30.00
$
20.00
Interests on the reconciled account
$
11.95
Monthly Charge by the bank
$
25.00
Deposit in Transit
Note
Payment, Beethoven
Payment, Mozart
Payment, Mikey
Refund, Pooh
Amount
$ 12,000.00
$ 13,000.00
$ 8,000.00
$ 7,000.00
Outstanding Cheks
Check number
1234
1235
1237
1239
1240
Amount
$ 2,256.75
$ 4,775.50
$ 3,567.45
$ 7,500.00
$ 12,500.00
1
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Hey, It's my hope that you're fine. Find the two completed files attached below for your review. I have used two different approaches to reconcile the bank balance and the cash book balance. Let me know in case you need anything edited.Best regards.
Data Validation
Name
...
Completion Status:
100%
Review
Review
Anonymous
Great! 10/10 would recommend using Studypool to help you study.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
assignment
The attached Excel sheet contains two years of quarterly sales data for a company. Based on the data, develop the followin ...
assignment
The attached Excel sheet contains two years of quarterly sales data for a company. Based on the data, develop the following sales forecasting models for the quarters 1, 2, 3 and 4 for year 3:1.Moving average technique based on the previous four quarters2.Simple exponential smoothing with an alpha factor of 0.13.Simple exponential smoothing with an alpha factor of 0.24.Linear regression
Colgate-Palmolive Case analysis and Marketing Mix, marketing homework help
***Instructions: Please answer the following questions with a minimum of 200-word count for each question, total of 800-wo ...
Colgate-Palmolive Case analysis and Marketing Mix, marketing homework help
***Instructions: Please answer the following questions with a minimum of 200-word count for each question, total of 800-word count or more. A cover page/title page is not needed. Use scholarly articles to support your answer, include in-text citations and a reference page, APA format. Please use the reference that I provided in the attached file, here is the reference: Solomon, M. R., Marshall, G. W., & Stuart, E. W. (2012). Marketing: Real people, real choices. New Jersey: Prentice Hall. Also, 2 outside scholarly articles for in-text citation and references are required. Do not use Wikipedia, ask.com, online dictionaries, or etc. No PLAGIARISM and let me know if you have any questions or concerns!Read the Chapter 1 Case: Real Choices at Colgate-Palmolive (page 37 of pdf., last page on the attached file)1. Summarize the case and identify the dilemma facing Colgate-Palmolive.2. Research the product at www.colgatewisp.com. Discuss each element of the marketing mix for Wisp. (use this website for in-text citation and reference page)*note* Marketing Mix elements:•Product (or Service) includes packaging design, branding, trademarks, warranties, guarantees, product life cycles and new product development•Price setting profitable and justifiable prices•Place (Distribution) Channels your product will go through to reach the customer•Promotion (Advertising, Sales Promotion, Publicity, Personal Selling)- (New) Positioning is where you place your product in the mind of the consumer.- (New) People are those who create, produce, and then market the product- (New) Packaging creation, design of packaging (related to product/promotion)3. A key to long-term business success lies in a firm’s ability to offer value to customers through its product offerings. Identify and discuss the key sources of value at Colgate-Palmolive. How might these value-adding properties be communicated to customers?4. What decision(s) do you recommend to Colgate-Palmolive? Discuss specific implementation tactics supporting your recommendation. Within the discussion identify the target market, market segment(s) and the competitive advantage.
WTAMU Murky Ethics of Data Gathering in a Post Cambridge Analytica World Discussion
Writing Assignment 4
This week is focused on ethics. Read the article advanced technology” and provide your critique on ...
WTAMU Murky Ethics of Data Gathering in a Post Cambridge Analytica World Discussion
Writing Assignment 4
This week is focused on ethics. Read the article advanced technology” and provide your critique on what you agree with, what you disagree with, and what you would do as a firm to implement this information. Focus on determining what the ethical issues presented are, who the stakeholders are that will be involved with this/these decision(s), and what actions you would take based on this information.
Writing Sample
I need a two page document created around this topic.Questions (pick one):1. Most decisions are made with analysis, but so ...
Writing Sample
I need a two page document created around this topic.Questions (pick one):1. Most decisions are made with analysis, but some are judgment calls not susceptible to analysis due to time or information constraints. Please write about a judgment call you’ve made recently that couldn’t be analyzed. It can be a big or small one but should focus on a business issue. What was the situation, the alternatives you considered and evaluated, and your decision-making process? Be sure to explain why you chose the alternative you did relative to others considered.OR2. What is the most inventive or innovative thing you’ve done? It doesn’t have to be something that’s patented. It could be a process change, product idea, a new metric or customer facing interface – something that was your idea. It cannot be anything your current or previous employer would deem confidential information. Please provide us with context to understand the invention/innovation. What problem were you seeking to solve? Why was it important? What was the result? Why or how did it make a difference and change things?
Change Initiative: Implementation, Evaluation, and Sustainability
You will utilize your change model for this assignment. Review the feedback submitted by your instructor on your previous ...
Change Initiative: Implementation, Evaluation, and Sustainability
You will utilize your change model for this assignment. Review the feedback submitted by your instructor on your previous change model assignment. Make any changes or modifications necessary for the submission of this assignment.Evaluate the performance of your organization or department. Identify an area that would significantly benefit from initiating a change. Write a paper (1,500-1,750 words) in which you describe the particular area you propose to address through a change initiative. Include the following for your company:Discuss the issues in this area and the current outcomes as a result of the issues.Describe the external and/or internal driving forces, contributing issues, and the people affected.Evaluate the stakeholders involved and discuss how they will be affected by your change initiative.Clarify your role and responsibility as a change leader. Discuss the leadership theory (or theories) you will use to guide the change process. Discuss the change agents you need to recruit in order to successfully implement your change. Describe the roles of these change agents.Utilize your change model to develop strategies: (a) Explain the relevance of this model to your organization; and (b) Present the strategic aspects using your model. Be sure to clearly define the purpose of each aspect, the people involved, and the actions that need to be taken.Identify, or predict, the potential barriers to change. Discuss possible ways to overcome these obstacles, including methods for dealing with emerging or unforeseen circumstances that could impede implementation.Describe the evaluation methods you will use to determine the level of success of your change initiative. Discuss what metrics or measureable determinates you will use.Propose strategies to anchor change or support continuous change.Establish how your change plan supports the organizational mission/goal, genuinely addresses stakeholder concerns, and will serve as an equitable contribution for the community or society overall. Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
ACC201 Milestone 2 Accounting Workbook
I provided you with my excel you only have to complete theses ones. trial balance, adjusting entries, and adjusted trial ...
ACC201 Milestone 2 Accounting Workbook
I provided you with my excel you only have to complete theses ones. trial balance, adjusting entries, and adjusted trial
balance. The instructions are provide down below in the documents. Follow the steps that are provided.
Similar Content
ECOM 500 Saudi Electronic University Amazon Inc Mission and Values Discussion
Discussion Question, 15 lines, 2-3 paragraphs, 1-2 references and no outlineIdentify a case of corporate fraud by finding ...
MAN3710 Rasmussen Section 02 Role of the Human Resource Manager Paper
For this project assignment on ACME Company, Inc. consider the following concepts: Minimum of two pagesThe issues facing M...
Marketing Question
help me finish this marketing practice exam, time is 3 th Nov 12-14pm ( China Beijing time)...
Crisis Management, business and finance homework help
Need homework help answering the question attached and the read material which is also attached. Internet sources can also...
Conestoga College HR Strategies and Business Strategies Paper
6:20
conestoga.desire2learn.com
Prepare a written report that describes the business case for
having HR report to the CEO ...
Central Texas College Project Management Case Study
Read the case study "The Invisible Sponsor" on page 658 and then pick one (1) of the following sets of three (3)
questions...
Operational Metrics Benchmarking And Analysis
Operations analysis is one of the most indispensable aspects of any business that wants to keep on making improvements on ...
Cnc Machines
There are various pros to using high-speed machines, especially when dealing with plastics and nonferrous metals. Among th...
Acct 202
Starting Salary for an Aviation manager and Flight OPS in Jacksonville, Florida The average cost of groceries for a month ...
Related Tags
Book Guides
The Metamorphosis
by Franz Kafka
The English Patient
by Michael Ondaatje
A Wrinkle as Time
by Madeleine L'Engle
Robinson Crusoe
by Daniel Defoe
The Red Badge of Courage
by Stephen Crane
The Call of the Wild
by Jack London
What Happened
by Hillary Clinton
Steppenwolf
by Hermann Hesse
Twelve Years A Slave
by Solomon Northrup
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
assignment
The attached Excel sheet contains two years of quarterly sales data for a company. Based on the data, develop the followin ...
assignment
The attached Excel sheet contains two years of quarterly sales data for a company. Based on the data, develop the following sales forecasting models for the quarters 1, 2, 3 and 4 for year 3:1.Moving average technique based on the previous four quarters2.Simple exponential smoothing with an alpha factor of 0.13.Simple exponential smoothing with an alpha factor of 0.24.Linear regression
Colgate-Palmolive Case analysis and Marketing Mix, marketing homework help
***Instructions: Please answer the following questions with a minimum of 200-word count for each question, total of 800-wo ...
Colgate-Palmolive Case analysis and Marketing Mix, marketing homework help
***Instructions: Please answer the following questions with a minimum of 200-word count for each question, total of 800-word count or more. A cover page/title page is not needed. Use scholarly articles to support your answer, include in-text citations and a reference page, APA format. Please use the reference that I provided in the attached file, here is the reference: Solomon, M. R., Marshall, G. W., & Stuart, E. W. (2012). Marketing: Real people, real choices. New Jersey: Prentice Hall. Also, 2 outside scholarly articles for in-text citation and references are required. Do not use Wikipedia, ask.com, online dictionaries, or etc. No PLAGIARISM and let me know if you have any questions or concerns!Read the Chapter 1 Case: Real Choices at Colgate-Palmolive (page 37 of pdf., last page on the attached file)1. Summarize the case and identify the dilemma facing Colgate-Palmolive.2. Research the product at www.colgatewisp.com. Discuss each element of the marketing mix for Wisp. (use this website for in-text citation and reference page)*note* Marketing Mix elements:•Product (or Service) includes packaging design, branding, trademarks, warranties, guarantees, product life cycles and new product development•Price setting profitable and justifiable prices•Place (Distribution) Channels your product will go through to reach the customer•Promotion (Advertising, Sales Promotion, Publicity, Personal Selling)- (New) Positioning is where you place your product in the mind of the consumer.- (New) People are those who create, produce, and then market the product- (New) Packaging creation, design of packaging (related to product/promotion)3. A key to long-term business success lies in a firm’s ability to offer value to customers through its product offerings. Identify and discuss the key sources of value at Colgate-Palmolive. How might these value-adding properties be communicated to customers?4. What decision(s) do you recommend to Colgate-Palmolive? Discuss specific implementation tactics supporting your recommendation. Within the discussion identify the target market, market segment(s) and the competitive advantage.
WTAMU Murky Ethics of Data Gathering in a Post Cambridge Analytica World Discussion
Writing Assignment 4
This week is focused on ethics. Read the article advanced technology” and provide your critique on ...
WTAMU Murky Ethics of Data Gathering in a Post Cambridge Analytica World Discussion
Writing Assignment 4
This week is focused on ethics. Read the article advanced technology” and provide your critique on what you agree with, what you disagree with, and what you would do as a firm to implement this information. Focus on determining what the ethical issues presented are, who the stakeholders are that will be involved with this/these decision(s), and what actions you would take based on this information.
Writing Sample
I need a two page document created around this topic.Questions (pick one):1. Most decisions are made with analysis, but so ...
Writing Sample
I need a two page document created around this topic.Questions (pick one):1. Most decisions are made with analysis, but some are judgment calls not susceptible to analysis due to time or information constraints. Please write about a judgment call you’ve made recently that couldn’t be analyzed. It can be a big or small one but should focus on a business issue. What was the situation, the alternatives you considered and evaluated, and your decision-making process? Be sure to explain why you chose the alternative you did relative to others considered.OR2. What is the most inventive or innovative thing you’ve done? It doesn’t have to be something that’s patented. It could be a process change, product idea, a new metric or customer facing interface – something that was your idea. It cannot be anything your current or previous employer would deem confidential information. Please provide us with context to understand the invention/innovation. What problem were you seeking to solve? Why was it important? What was the result? Why or how did it make a difference and change things?
Change Initiative: Implementation, Evaluation, and Sustainability
You will utilize your change model for this assignment. Review the feedback submitted by your instructor on your previous ...
Change Initiative: Implementation, Evaluation, and Sustainability
You will utilize your change model for this assignment. Review the feedback submitted by your instructor on your previous change model assignment. Make any changes or modifications necessary for the submission of this assignment.Evaluate the performance of your organization or department. Identify an area that would significantly benefit from initiating a change. Write a paper (1,500-1,750 words) in which you describe the particular area you propose to address through a change initiative. Include the following for your company:Discuss the issues in this area and the current outcomes as a result of the issues.Describe the external and/or internal driving forces, contributing issues, and the people affected.Evaluate the stakeholders involved and discuss how they will be affected by your change initiative.Clarify your role and responsibility as a change leader. Discuss the leadership theory (or theories) you will use to guide the change process. Discuss the change agents you need to recruit in order to successfully implement your change. Describe the roles of these change agents.Utilize your change model to develop strategies: (a) Explain the relevance of this model to your organization; and (b) Present the strategic aspects using your model. Be sure to clearly define the purpose of each aspect, the people involved, and the actions that need to be taken.Identify, or predict, the potential barriers to change. Discuss possible ways to overcome these obstacles, including methods for dealing with emerging or unforeseen circumstances that could impede implementation.Describe the evaluation methods you will use to determine the level of success of your change initiative. Discuss what metrics or measureable determinates you will use.Propose strategies to anchor change or support continuous change.Establish how your change plan supports the organizational mission/goal, genuinely addresses stakeholder concerns, and will serve as an equitable contribution for the community or society overall. Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
ACC201 Milestone 2 Accounting Workbook
I provided you with my excel you only have to complete theses ones. trial balance, adjusting entries, and adjusted trial ...
ACC201 Milestone 2 Accounting Workbook
I provided you with my excel you only have to complete theses ones. trial balance, adjusting entries, and adjusted trial
balance. The instructions are provide down below in the documents. Follow the steps that are provided.
Earn money selling
your Study Documents