Our Services

Get 15% Discount on your First Order

Accounting

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental

December 8, 2024

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental agency, their data is available to the public. Excerpts from the public data concerning its changes in pricing for October 2021 are presented in the Excel file and include the location, the type of meter class, the date type as weekend versus weekday, time of day, occupancy rate, the original parking rate, the proposed change to the parking rate, and the final rate after adjustment.

Module 4 CTA Excel File TemplateDownload Module 4 CTA Excel File Template

Requirements

There are four parts to this problem. Use Excel and the Excel file provided to perform the following.

Create a scatter plot that illustrates the occupancy rate and the final parking rate charged. Add a trendline, the equation of the line, and R-squared. Include a descriptive chart title, axes labels, and properly formatted axes in the chart.
Discuss the relationship between the data and the expected trend line you see in part 1. Do the data points suggest a strong relationship?
Create a scatter plot that illustrates the occupancy rate and the rate change recommended. Include a descriptive chart title, axes labels, and properly formatted axes in the chart.
Discuss the relationships you see in part 3. What does the date data suggest about the rate recommendations as compared to the occupancy rate?

Submit the provided Excel spreadsheet containing your answers to each of the above requirements. Use Excel functions to make any required calculations described in the requirements. Post your completed Excel spreadsheet containing your answers for your instructor to grade.

Accounting

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Select one of the following (either Council of Europe’s Convention on Cybercrimes or Reporting Cyberattacks) and address the associated items or

Select one of the following (either Council of Europe’s Convention on Cybercrimes or Reporting Cyberattacks) and address the associated items or questions as your initial post for this discussion board. Copy and paste your selected item into your initial response in bold type, so that you are sure to answer each aspect

Read the following article: Lawson, R. (2019, March 1). New competencies for management accountants. Links to an external site.. Strategic

Read the following article: Lawson, R. (2019, March 1). New competencies for management accountants. Links to an external site.. Strategic Finance. · Focus on one of the major subjects of this article that is of interest to you. These subjects include (but are not limited to): o The changing role of

“It all comes down to the bottom line. The numbers never lie.” Do you agree with this statement? Note: The bottom line in Accounting typically refers to

“It all comes down to the bottom line. The numbers never lie.” Do you agree with this statement? Note: The bottom line in Accounting typically refers to Net Income. Your responses should be in essay format. This means you need to use paragraphs. Do NOT use bullet points or numbered

Ken, the manager of the marketing department, tells you that “budgeting simply does not work.” He says that he made budgets for his employees and when he

Ken, the manager of the marketing department, tells you that “budgeting simply does not work.” He says that he made budgets for his employees and when he reprimanded them for failing to accomplish budget goals, he got unfounded excuses. Suggest how Ken could encourage employee cooperation. Your responses should be

if you were to open a business, what type of business entity would you choose and why? Be sure to include the industry as well as the business entity.

if you were to open a business, what type of business entity would you choose and why? Be sure to include the industry as well as the business entity. Use topics and concepts covered this week. Your responses should be in essay format. This means you need to use paragraphs.

Option #2: Fraud Risk Brainstorming at Tesla Read the following case study: Hess, M. F., & Andiola, L. M. (2018). Fraud risk brainstorming at Tesla

Option #2: Fraud Risk Brainstorming at Tesla Read the following case study: Hess, M. F., & Andiola, L. M. (2018). Fraud risk brainstorming at Tesla Motors.Links to an external site.. Issues in Accounting Education, 33(2), 19–34. Case Requirements: Answer the following questions as a Presentation. Fraud risks related to revenue recognition at

The Association of Certified Fraud Examiners (ACFE) has excellent resources including: white papers from industry-leading companies on emerging trends in

The Association of Certified Fraud Examiners (ACFE) has excellent resources including: white papers from industry-leading companies on emerging trends in the fraud industry, tips to stay ahead of fraudsters, and industry-specific strategies to stay current in the forensic accounting and fraud examination professions. Review the free white papers from the ACFELinks to

Liabilities Our textbook tells us that liabilities are obligations of the entity or as defined by the FASB, “probable future sacrifices of economic

Liabilities Our textbook tells us that liabilities are obligations of the entity or as defined by the FASB, “probable future sacrifices of economic benefits arising from present obligations of a particular entity to transfer assets or provide services to other entities in the future as a result of past transactions

Using Excel, and using Excel functions and formulas to perform all necessary calculations, provide answers to items A, B, and C in the exercise.

Using Excel, and using Excel functions and formulas to perform all necessary calculations, provide answers to items A, B, and C in the exercise. Submissions with only numbers and no formulas or functions will not receive credit for this assignment. Your submission must be neatly organized and must clearly present

Final Project Assignment InstructionsScenario Background: A marketing company based out of New York City is doing well and is looking to expand

Final Project Assignment InstructionsScenario Background: A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on whether or not to invest in expansion. Collapse AllIntroduction This portfolio work project will help you to not only

In your course textbook, specifically in Chapter 10, page 10-33, read Exercise 28, Dexter Manufacturing In an appropriate level of detail, answer items 1

In your course textbook, specifically in Chapter 10, page 10-33, read Exercise 28, Dexter Manufacturing In an appropriate level of detail, answer items 1 and 2 below. Required: Answer the following questions: How much in losses do you believe Dexter may have experienced on the current contract so far? How much more in

Selected Accounting Standard – Intangibles – Goodwill and other Crypto Assets (Subtopic 350-60) – crypto assets (ASU 2023-08) Select a converged,

Selected Accounting Standard – Intangibles – Goodwill and other Crypto Assets (Subtopic 350-60) – crypto assets (ASU 2023-08) Select a converged, revised, or new accounting standard from the Financial Accounting Board (FASB) that has been issued within the last three years and that is of interest to you. Refer to

Option #2: Toshiba’s Creative Accounting for Construction Contracts Read the following case study: Dugar, A., Gujarathi, M. R. (2018). Toshiba’s creative

Option #2: Toshiba’s Creative Accounting for Construction Contracts Read the following case study: Dugar, A., Gujarathi, M. R. (2018). Toshiba’s creative accounting for construction contracts.Links to an external site.. Issues in Accounting Education, 33(3), 117–134. Case Requirements: The FASB and the IASB have issued a joint standard on revenue recognition. Although the

Acme-Aviation Case Study In your course textbook, read Exercise 24, Acme-Aviation (AA) in Chapter 10, page 10-30. Then answer the following

Acme-Aviation Case Study In your course textbook, read Exercise 24, Acme-Aviation (AA) in Chapter 10, page 10-30. Then answer the following questions. You are an expert who has been hired by Acme Aviation to develop a damages estimate for them that you will defend in deposition and at trial, if necessary. Using

Conduct an Internet search for information on internal control and Sarbanes-Oxley Act. Discuss some of the advantages and disadvantages of the

Conduct an Internet search for information on internal control and Sarbanes-Oxley Act. Discuss some of the advantages and disadvantages of the Sarbanes-Oxley Act. Include at least 5 Scholarly/peer reviewed APA citation and References.

Aurora Electric Case Study Aurora Electric has a contract with an agency of the Federal Government to provide electrical power to the agency for a

Aurora Electric Case Study Aurora Electric has a contract with an agency of the Federal Government to provide electrical power to the agency for a five-year period. The contract stipulates, in part, that the power will be provided ‘at the lowest reasonable cost without compromising safety.’ In connection with this

Within the attached files, one contains the instructions and the other contains the excel template to complete it. I will do my best to answer any

Within the attached files, one contains the instructions and the other contains the excel template to complete it. I will do my best to answer any questions.