Income Statement - Week 2

xlsx

School

National University College-Caguas *

*We aren’t endorsed by this school

Course

1000

Subject

Accounting

Date

Nov 24, 2024

Type

xlsx

Pages

15

Uploaded by CorporalGoat1514

Report
Income Statement for January, Month to Date Three J' Coffe Shop - Week 2 Revenue $3,656.75 100% $3,656.75 100% COGS $313.60 9% $313.60 9% Gross Margin $3,343.15 91% $3,343.15 91% Management $2,365.00 65% $2,365.00 65% Staf $510.63 14% $510.63 14% Adv./Promo. $3,920.00 107% $3,920.00 107% Rent $2,000.00 55% $2,000.00 55% Utilities $0.00 0% $0.00 0% Depreciation Expense $0.00 0% $0.00 0% Interest on Loan $0.00 0% $0.00 0% Other $700.00 19% $700.00 19% Total Expenses $9,495.63 260% $9,495.63 260% Net Income -$6,152.48 -168% -$6,152.48 -168% January to Date % of Rev. Year to Date % of Rev.
Revenue Account Details for January Date Description Amount Jan 2 Monday Receipts $371.00 Jan 3 Tuesday Receipts $357.00 Jan 4 Wednesday Receipts $364.00 Jan 5 Thursday Receipts $367.50 Jan 6 Friday Receipts $371.00 Jan 9 Monday Receipts $360.00 Jan 10 Tuesday Receipts $363.75 Jan 11 Wednesday Receipts $367.50 Jan 12 Thursday Receipts $367.50 Jan 13 Friday Receipts $367.50 Total $3,656.75
Revenue Account Details for January, Year to Date Date Description Amount Jan 2 Monday Receipts $371.00 Jan 3 Tuesday Receipts $357.00 Jan 4 Wednesday Receipts $364.00 Jan 5 Thursday Receipts $367.50 Jan 6 Friday Receipts $371.00 Jan 9 Monday Receipts $360.00 Jan 10 Tuesday Receipts $363.75 Jan 11 Wednesday Receipts $367.50 Jan 12 Thursday Receipts $367.50 Jan 13 Friday Receipts $367.50 Total $3,656.75
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
COGS Account Details for January Date Description Amount Jan 1 21 lb. Bulk Cofee $126.00 Jan 8 Cups from Inventory $43.60 Jan 8 17 lb. Bulk Cofee $102.00 Jan 15 Cups from Inventory $42.00 Total $313.60
COGS Account Details for January, Year to Date Date Description Amount Jan 1 21 lb. Bulk Cofee $126.00 Jan 8 Cups from Inventory $43.60 Jan 8 17 lb. Bulk Cofee $102.00 Jan 15 Cups from Inventory $42.00 Total $313.60
Management Account Details for January Date Description Amount Jan 5 Manager Pay $990.00 Jan 5 Manager Withholding $210.00 Jan 5 Manager Payroll Tax $90.00 Jan 12 Manager Pay $825.00 Jan 12 Manager Withholding $175.00 Jan 12 Manager Payroll Tax $75.00 Total $2,365.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Management Account Details for January, Year to Date Date Description Amount Jan 5 Manager Pay $990.00 Jan 5 Manager Withholding $210.00 Jan 5 Manager Payroll Tax $90.00 Jan 12 Manager Pay $825.00 Jan 12 Manager Withholding $175.00 Jan 12 Manager Payroll Tax $75.00 Total $2,365.00
Staff Account Details for January Date Description Amount Jan 5 Staf Pay $144.38 Jan 5 Staf Withholding $30.62 Jan 5 Staf Payroll Tax $13.13 Jan 12 Staf Pay $247.50 Jan 12 Staf Withholding $52.50 Jan 12 Staf Payroll Tax $22.50 Total $510.63
Staff Account Details for January, Year to Date Date Description Amount Jan 5 Staf Pay $144.38 Jan 5 Staf Withholding $30.62 Jan 5 Staf Payroll Tax $13.13 Jan 12 Staf Pay $247.50 Jan 12 Staf Withholding $52.50 Jan 12 Staf Payroll Tax $22.50 Total $510.63
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Adv./Promo. Account Details for January Date Description Amount Jan 1 Online Ad $1,400.00 Jan 1 Radio Ad $560.00 Jan 8 Online Ad $1,400.00 Jan 8 Radio Ad $560.00 Total $3,920.00
Adv./Promo. Account Details for January, Year to Date Date Description Amount Jan 1 Online Ad $1,400.00 Jan 1 Radio Ad $560.00 Jan 8 Online Ad $1,400.00 Jan 8 Radio Ad $560.00 Total $3,920.00
Rent Account Details for January Date Description Amount Jan 1 Rent $2,000.00 Total $2,000.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Rent Account Details for January, Year to Date Date Description Amount Jan 1 Rent $2,000.00 Total $2,000.00
Other Exp. Account Details for January Date Description Amount Jan 1 Green Upgrades $700.00 Total $700.00
Other Exp. Account Details for January, Year to Date Date Description Amount Jan 1 Green Upgrades $700.00 Total $700.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help