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 saleshow the solution using excel You have a siomai business. You obtain the data below for the past one (1) month about your operation.DateDays7/1/2021 Friday7/2/2021 Saturday7/3/2021 Sunday7/4/2021 Monday7/5/2021 Tuesday7/6/2021 Wednesday7/7/2021 ThursdayRevenueP 41.00P 41.25P 46.75P 58.25P 69.25P 43.00P 61.00P 52.257/8/2021 Friday7/9/2021 Saturday7/10/2021 SundayP 57.25P 59.50P 70.50P 56.25P 46.00P 51.75P 80.00P 65.507/11/2021 Monday7/12/2021 Tuesday7/13/2021 Wednesday7/14/2021 Thursday7/15/2021 Friday7/16/2021 Saturday7/17/2021 Sunday7/18/2021 Monday7/19/2021 Tuesday7/20/2021 Wednesday7/21/2021 Thursday* 95.50P111.50P103.50* 56.50* 66.50P 93.507/22/2021 Friday7/23/2021 Saturday7/24/2021 Sunday7/25/2021 Monday7/26/2021 Tuesday7/27/2021 WednesdayP101.00P101.50P134.50P106.757/28/2021 Thursday7/29/2021 Friday7/30/2021 Saturday7/31/2021 SundayP 60.20P 55.65P 58.10P 50.75P 43.05

Chart is attached for your reference

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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Please explain proper steps by Step and Do Not Give Solution In Image Format And Fast Answering Please ? And Thanks In Advance
Complete the following problems on an excel spreadsheet. Number your problems on a different tab. PA3 requires two special journals and a subsidiary ledger. PA3. The following transactions occurred for Donaldson Inc. during the month of July. Record the transactions for Donaldson Inc. in the proper special journal and subsidiary ledger. Jul. 1 Sold 50 items to Palm Springs Inc. and offered terms of 2/10, n/30, $4,000 on July 1, and issued invoice #12 on account number #312 Jul. 5 Sold 20 thing-a-jigs to Miami Inc. for $2,150 cash on July 5, and issued invoice #13 Jul. 8 Sold 30 what-is to Smith Mfg. for $5,000 and offered terms of 2/10, n/30; issued invoice #14 on account number #178 Jul. 9 Received payment from Palm Springs Inc. Jul. 22 Received payment from Smith Mfg. after expiration of the discount period
Solve the problem with complete solution. 6. Your statement date is every 4th day of the month. You made a purchase on April 3. When is the statement statement date for the said purchase?
What is an estimate in QuickBooks Online? Select an answer: An estimate is a document that outlines a customer's purchase history. An estimate is a document that shows a customer's payment history. An estimate is a document that outlines the expenses a business expects to incur in the future. An estimate is a document that outlines the products or services a business plans to provide to a customer.
Need help with the problem in the image
Qq.8.a
Jay
Download the attached Excel file (First Q Profits Report W Goal Seek_Ver2.xlsx). Instructions: . There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan. • The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab, • Complete the Proportion column, cells G7 through G11 Each proportion value shows the % of the quarterly sale of that item over the entire sale. Calculate the Net Income row, cells B24 through F24. o Compute the Profit Margin row, Cells B25 through E25. o Add Net Income Sparkline for January through March in Cell H24. in For this tab
Determine the following (1-3)::: 1. What is the accounts receivable balance, net of uncollectible accounts, at the end of December? 2. What is the accounts payable at the end of December? 3. What is the retained earnings at the end of December?
i need the answer quickly
A household savings-account spreadsheet shows the following entries for the first day of each month: Month January February March April May June July August Additions Withdrawals Value 148,000 2,500 4,000 1,500 13,460 3,000 23,000 198,000 Required: Use the Excel function XIRR to calculate the dollar-weighted average return for this period. (Round your answer to 2 decimal places.) Dollar-weighted average Answer is complete but not entirely correct. 70.01%
Hi! Please help me to compute the daily, monthly, and yearly revenue projections. Thank you!