You have a siomai business. You obtain the data below for the past one (1) month about your operation. Days 7/1/2021 Friday 7/2/2021 Saturday 7/3/2021 Sunday Date Revenue 7/4/2021 Monday 7/5/2021 Tuesday 7/6/2021 Wednesday 7/7/2021 Thursday 7/8/2021 Friday 7/9/2021 Saturday 7/10/2021 Sunday 7/11/2021 Monday 7/12/2021 Tuesday 7/13/2021 Wednesday 7/14/2021 Thursday P 41.00 P 41.25 P 46.75 P 58.25 P 69.25 P 43.00 P 61.00 P 52.25 P 57.25 P 59.50 P 70.50 P 56.25 P 46.00 P 51.75 P 80.00 P 65.50 P 95.50 7/15/2021 Friday 7/16/2021 Saturday 7/17/2021 Sunday 7/18/2021 Monday 7/19/2021 Tuesday 7/20/2021 Wednesday 7/21/2021 Thursday 7/22/2021 Friday 7/23/2021 Saturday 7/24/2021 Sunday 7/25/2021 Monday 7/26/2021 Tuesday 7/27/2021 Wednesday 7/28/2021 Thursday 7/29/2021 Friday 7/30/2021 Saturday 7/31/2021 Sunday P111.50 P103.50 P 56.50 P 66.50 P 93.50 P101.00 P101.50 P134.50 P106.75 P 60.20 P 55.65 P 58.10 P 50.75 P 43.05
You have a siomai business. You obtain the data below for the past one (1) month about your operation. Days 7/1/2021 Friday 7/2/2021 Saturday 7/3/2021 Sunday Date Revenue 7/4/2021 Monday 7/5/2021 Tuesday 7/6/2021 Wednesday 7/7/2021 Thursday 7/8/2021 Friday 7/9/2021 Saturday 7/10/2021 Sunday 7/11/2021 Monday 7/12/2021 Tuesday 7/13/2021 Wednesday 7/14/2021 Thursday P 41.00 P 41.25 P 46.75 P 58.25 P 69.25 P 43.00 P 61.00 P 52.25 P 57.25 P 59.50 P 70.50 P 56.25 P 46.00 P 51.75 P 80.00 P 65.50 P 95.50 7/15/2021 Friday 7/16/2021 Saturday 7/17/2021 Sunday 7/18/2021 Monday 7/19/2021 Tuesday 7/20/2021 Wednesday 7/21/2021 Thursday 7/22/2021 Friday 7/23/2021 Saturday 7/24/2021 Sunday 7/25/2021 Monday 7/26/2021 Tuesday 7/27/2021 Wednesday 7/28/2021 Thursday 7/29/2021 Friday 7/30/2021 Saturday 7/31/2021 Sunday P111.50 P103.50 P 56.50 P 66.50 P 93.50 P101.00 P101.50 P134.50 P106.75 P 60.20 P 55.65 P 58.10 P 50.75 P 43.05
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Create a chart that would show the fluctuation of revenue throughout the month.
Put a note in the worksheet stating which day of the month has the highest sale
show the solution using excel
![You have a siomai business. You obtain the data below for the past one (1) month about your operation.
Date
Days
7/1/2021 Friday
7/2/2021 Saturday
7/3/2021 Sunday
7/4/2021 Monday
7/5/2021 Tuesday
7/6/2021 Wednesday
7/7/2021 Thursday
Revenue
P 41.00
P 41.25
P 46.75
P 58.25
P 69.25
P 43.00
P 61.00
P 52.25
7/8/2021 Friday
7/9/2021 Saturday
7/10/2021 Sunday
P 57.25
P 59.50
P 70.50
P 56.25
P 46.00
P 51.75
P 80.00
P 65.50
7/11/2021 Monday
7/12/2021 Tuesday
7/13/2021 Wednesday
7/14/2021 Thursday
7/15/2021 Friday
7/16/2021 Saturday
7/17/2021 Sunday
7/18/2021 Monday
7/19/2021 Tuesday
7/20/2021 Wednesday
7/21/2021 Thursday
* 95.50
P111.50
P103.50
* 56.50
* 66.50
P 93.50
7/22/2021 Friday
7/23/2021 Saturday
7/24/2021 Sunday
7/25/2021 Monday
7/26/2021 Tuesday
7/27/2021 Wednesday
P101.00
P101.50
P134.50
P106.75
7/28/2021 Thursday
7/29/2021 Friday
7/30/2021 Saturday
7/31/2021 Sunday
P 60.20
P 55.65
P 58.10
P 50.75
P 43.05](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff3fff265-7567-4569-8e04-af7a33d1f5f6%2F08d32e8c-8d02-41f6-9949-66b0ad6ac3ab%2Fla1fwk_processed.png&w=3840&q=75)
Transcribed Image Text:You have a siomai business. You obtain the data below for the past one (1) month about your operation.
Date
Days
7/1/2021 Friday
7/2/2021 Saturday
7/3/2021 Sunday
7/4/2021 Monday
7/5/2021 Tuesday
7/6/2021 Wednesday
7/7/2021 Thursday
Revenue
P 41.00
P 41.25
P 46.75
P 58.25
P 69.25
P 43.00
P 61.00
P 52.25
7/8/2021 Friday
7/9/2021 Saturday
7/10/2021 Sunday
P 57.25
P 59.50
P 70.50
P 56.25
P 46.00
P 51.75
P 80.00
P 65.50
7/11/2021 Monday
7/12/2021 Tuesday
7/13/2021 Wednesday
7/14/2021 Thursday
7/15/2021 Friday
7/16/2021 Saturday
7/17/2021 Sunday
7/18/2021 Monday
7/19/2021 Tuesday
7/20/2021 Wednesday
7/21/2021 Thursday
* 95.50
P111.50
P103.50
* 56.50
* 66.50
P 93.50
7/22/2021 Friday
7/23/2021 Saturday
7/24/2021 Sunday
7/25/2021 Monday
7/26/2021 Tuesday
7/27/2021 Wednesday
P101.00
P101.50
P134.50
P106.75
7/28/2021 Thursday
7/29/2021 Friday
7/30/2021 Saturday
7/31/2021 Sunday
P 60.20
P 55.65
P 58.10
P 50.75
P 43.05
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education