Based on your understanding of the company, what factors may increase the risk of fraudulent financial reporting in Souper Bowl’s 2016 revenues?  Original Answers Only

Numerical Analysis

Tableau Assignment

Company Background 

You were recently promoted to audit senior at your firm, Aoife & Josephine LLP, and one of your primary clients is Souper Bowl Inc. Souper Bowl (‘‘the company’’) is a privately held business headquartered in Maine, and has a fiscal year-end of December 31. The company has been in business for nine years and prides itself on offering creative soups at a reasonable price and that are made with locally sourced ingredients. The most popular soups include sweet potato corn chowder, curried root vegetable and lentil, and maple-roasted butternut squash. Souper Bowl typically experiences increased sales during winter months since soup hits the spot on a cold and snowy day. To further encourage sales on days when customers often avoid venturing outside, the company provides a delivery service and guarantees that soup can be delivered to anyone no matter what the weather. The company found this strategy to be particularly successful in 2015 when New England (including Maine) experienced record snowfall during February and March.

Souper Bowl sells their soup at several restaurant locations throughout Maine. The company employs three managers that direct the day-to-day operations for a group of stores that are organized by approximate geographic region: northern Maine (Store Type 1), mid-Maine (Store Type 2), and coastal Maine (Store Type 3). Appendix A provides a map of these store locations. Each manager knows their local market well and has the flexibility to advertise and offer promotions with the overall goal of increasing sales year over year. If total sales at the end of the year exceed total sales from the prior year for that manager’s set of locations (i.e., ‘‘Store Type’’), then the manager earns a monetary bonus from the company.


An audit of the company is required to comply with debt covenants related to a large bank loan that the company entered into when it began operations. Specifically, Souper Bowl must provide audited annual financial statements to the bank within 90 days of the fiscal year-end. The company must also provide unaudited quarterly financial statements to the bank within 45 days of the end of each quarter. The debt contract includes a financial covenant that requires pre-tax income in each quarter to be greater than zero. If not met, the bank has multiple remedies at its disposal, including calling the loan such that the entire balance is due immediately, seizing the company’s assets that are posted as collateral, or providing a waiver for the violation. Souper Bowl’s net income for the year ended December 31, 2016 is $468,810, while net income for the prior year ended December 31, 2015 was $825,229.

See also  Who are the most significant (strongest) competitors? How is the company positioned in the industry? Original Answers Only

Based on your experience from prior audits, you know that Souper Bowl’s daily sales fluctuate with temperature and snow accumulation. To perform your revenue analytics, you request a file from the client that includes daily sales by store location for both 2016 (current year) and 2015 ( prior year). You also retrieve daily weather data from the National Oceanic and Atmospheric Administration’s (NOAA) website for the weather centers closest to Souper Bowl’s store locations. Total revenue for the current year ended December 31, 2016 is $18.8 million, while total revenue for the prior year ended December 31, 2015 was $19.1 million. The audit team’s workpapers include the following lead sheet for revenue testing, and the total balances for each year agree to the trial balance and the company’s draft financial statements for 2016.


Souper Bowl Inc. Revenue Lead Sheet

December 31, 2016

2016 2015 Change % Change
Revenue, Store Type 1 $4,062,390.97 $4,032,383.16 $30,007.81 0.74%
Revenue, Store Type 2 9,331,175.81 9,558,584.07 (227,408.26) -2.38%
Revenue, Store Type 3 5,425,421.53 5,546,767.89 (121,346.36) -2.19%
Total Revenue $18,818,988.31 $19,137,735.12 $(318,746.81) -1.67%


Your manager stated that Tableau is a popular data visualization tool that your firm recently adopted and she instructed that you learn how to use it to perform these sales analytics. Since she is busy overseeing the planning and testing of other audit areas, she wants you to take the first pass and then document your results in a memo for her review. The manager wants you to provide thoughtful analyses and a thorough exploration of the possible relationships in the data. You are eager to impress her with your work, especially following your recent promotion to senior.


  1. Auditing standards specifically require auditors to identify revenue recognition as a fraud risk in most audits. Based on your understanding of the company, what factors may increase the risk of fraudulent financial reporting in Souper Bowl’s 2016 revenues? 
  2. Use the daily sales by location as provided by the client (2016 and 2015) and the weather data from NOAA to perform disaggregated sales analytics in Tableau. Your goal is to develop visualizations that identify potential outliers in the 2016 daily sales data related to the significant risks identified by the partner and manager. Using the memo template below, document your analyses and conclusions as to the specific daily sales from certain locations that you recommend selecting for focused substantive testing. is an academic writing platform that provides students and professionals with quality services to ease their assignment challenges. With a wide range of services, the platform has become one of the leading academic writing service providers in the market due to its reliability and affordability. Below, we shall discuss some of the services which provides:

Essay Writing Service
The essay writing service provides customers with quality essays on any subject or topic they requested within a given deadline. The writers at custompaper are experts in their respective fields, and they ensure customer satisfaction by producing original content with thorough research involved backed up with strong evidence from reliable sources available online or offline. All essays come with free plagiarism reports as well as revisions if needed so that customers can trust that they are getting high-quality work for their money’s worth.

Research Paper Writing Service
This is another popular service offered by custom paper help wherein customers are assisted in conducting research papers according to their needs and requirements within specified deadlines. Writers at custom paper help have vast knowledge about various topics belonging to different disciplines such as Management, Arts & Humanities, History etc., allowing them to craft impeccable research papers every time regardless of the complexity or urgency level requested by customers. Additionally, all our research papers come along with proper citation formats which ensures customer’s safety when it comes to plagiarism issues while also helping them save time on formatting procedures thus improving overall efficiency even further!

Dissertation Writing Service
CustomPaperHelp also offers dissertation writing assistance for those who need it most – students preparing for graduation or professionals wanting to further refine their skills through higher education levels such as Master/PhD degrees etc, Our team of writers consists of experienced individuals having Master’s/PhD degrees themselves so you can rest assured that your dissertation will be handled expertly from the start till the end! Furthermore, we offer unlimited revisions until your complete satisfaction is achieved, along with regular checkups being done throughout the process just so everything goes according to course without any hiccups!

Editing And Proofreading Services
If you already have written an essay but want professional feedback before submitting it, then CustomPaperHelp also offers editing & proofreading services which helps in identifying & rectifying errors present in assignments like grammar mistakes, spelling mistakes, punctuation problems etc., thereby ensuring top-notch quality work, before submission takes place! We understand how important accuracy & consistency are when it comes to grading systems used at universities nowadays, so taking extra care during this phase becomes absolutely essential if good grades are desired afterward!

Coursework Help
For those who find coursework difficult due to complications of being quite technical in nature; CustomPaperHelp extends its support here too, by providing quality solutions every single time – starting from understanding concepts properly up until composing flawless answers following university guidelines closely enough making sure no loopholes remain whatsoever! Whether it’s related math problem-solving algorithms or lengthy home assignments – our expert panel has got you covered from head-to-toe leaving no stone unturned during this very crucial stage since final grades depend largely upon the success rate achieved here successfully!

Assignment Help
Assignments form an integral part of getting better scores & ultimately, a degree itself (in case pursuing a masters/PhD) – something only possible if precision is made a priority right away; otherwise, chances of failure increase exponentially over a time period detrimentally affecting performance evaluation systems later down road drastically hence stressing timely importance completion prior commencement other operations associated same project altogether consistently meeting high standards expected each situation respectively! Here too, CustomPaperHelp presents comprehensive solution package exceeding expectations beyond point offering optimal values therein ensuring maximum satisfaction reached under circumstances prevailing accordingly without fail…proving once more why people trust us implicitly without second thought whatsoever!!

See also  Was there a difference with media coverage about your topic in other parts of the world?
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Professional Academic Writers

Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Custom Paper Help, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Customer Support 24/7

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email:

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Custom Paper Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.


Essay Writing Services

At Custom Paper Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.


Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.


Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.


Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.