Income Statement - Week 2
xlsx
keyboard_arrow_up
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
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
Related Questions
Question Completion Status:
QUESTION 7
Using the following information, calculate the monthly net profit
Sales for the month
Food costs
73,904
25% of Sales
Labor costs
45% of Sales
Rent and Insurance
$1500/month
Supplies
$2217/month
Other expenses
$3791/month
OA. $51,733
O B. $22,171
O C. $7508
OD. $14,663
QUESTION 8
Calculate the profit margin from the last problem
O A. 17.5%
OB. 19.84%
OC. 18.29%
Click Save and Submit to save and submit. Click Save All Answers to save all answers
OD.22.22%
arrow_forward
Accounting
arrow_forward
DN Hill Enterprises
Income Statement
For Months Ended
January
February March
Net sales
Cost of goods sold
Gross Profit
266,895 295,750 305,000
175,895 186,850 193,000
91,000 108,900 112,000
Selling expenses
Administrative expenses
45,650 45,950 56,550
37,450 39,750 43,750
Total operating expenses
83,100
85,700 100,300
Income before income taxes
7,900
23,200 11,700
Income tax expense (20%)
1,580
4,640
2,340
Net income
6,320
18,560
9,360
COGS 75% variable / 25% fixed
Sell Exp 80% variable / 20% fixed
Admin Exp 25% variable / 75% fixed
What is your projection for 6/30/24 YTD Net Income?
arrow_forward
20.1 A business has compiled the following information for the year ended 31 October 20X2:
38 mins
$
386,200
989,000
422,700
Opening inventory
Purchases
Closing inventory
The gross profit as a percentage of sales is always 40%
Based on these figures, what is the sales revenue for the year?
$952,500
$1,333,500
$1,587,500
A
C
$1.524.000
arrow_forward
hi teacher provide answer General accounting
arrow_forward
Foc
arrow_forward
General Accounting
arrow_forward
Problem 5
George Washington Company buys one kind of merchandise at $12 per unit and sells it at $25
per unit. The company's sales representatives receive a 20% commission on each sale. The
March Income Statement shows the following information:
Sales
Cost of goods sold
Gross profit
George Washington Company
Income Statement
For Month Ended March 31
Expenses:
Sales commissions
Advertising
Store rent
Administrative salaries
Depreciation
Other
Total expenses
Net Income
$500,000
240,000
$100,000
50,000
5,000
10,000
6,000
12,000
$260,000
$183,000
$ 77.000
The company's management believes that the March results will be repeated during April, May,
and June without any changes in strategy. However, some changes are being considered.
Management believes that unit sales will increase at a rate of 8% each month during the next
quarter (including April) if the item's selling price is reduced to $22.50 per unit and if
advertising expenses are increased by 40% and remain at that level for all…
arrow_forward
Please answer do not image format
arrow_forward
Multiple-Step Income Statement
The following information is available for Bergin Pastry Shop for the year ended December 31.
Gross margin
$34,600
Income from operations
9,200
Income taxes expense (14% of income before taxes)
?
Interest expense
1,800
Net sales
85,800
Required:
Prepare a multiple-step income statement for Bergin for the year ended December 31.
arrow_forward
GENERAL ACCOUNT
arrow_forward
The following data are for Jessee's Candy Store for January: question 19
ss attached thanks
arrow_forward
Solve this accounting question problem
arrow_forward
Ron Company has the following commission schedule:
Commission
rate
2%
3.5%
4%
Calculate the gross earning.
Employee
Sales
Up to $80,000
Excess of $80,000 to $100,000
More than $100,000
Bill Moore
Total sales Gross earning
$ 141,000
arrow_forward
Ron Company has the following commission schedule:
Commission rate
Sales
2
%
Up to $80,000
3.5
%
Excess of $80,000 to $100,000
4
%
More than $100,000
Calculate the gross earning.
Employee
Total Sales
Gross Earnings
Lauren Cleaves
$ 143,000
arrow_forward
Ron Company has the following commission schedule:
Commission rate
Sales
2%
Up to $80, 000
Excess of $80,000 to $100,000
More than $100,000
3.5%
4%
Calculate the gross earning.
Employee
Total sales
Gross earning
Lai Xiaodong
%24
146,000
< Prev
6 of 16
Next
..... .....n
.....
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- Question Completion Status: QUESTION 7 Using the following information, calculate the monthly net profit Sales for the month Food costs 73,904 25% of Sales Labor costs 45% of Sales Rent and Insurance $1500/month Supplies $2217/month Other expenses $3791/month OA. $51,733 O B. $22,171 O C. $7508 OD. $14,663 QUESTION 8 Calculate the profit margin from the last problem O A. 17.5% OB. 19.84% OC. 18.29% Click Save and Submit to save and submit. Click Save All Answers to save all answers OD.22.22%arrow_forwardAccountingarrow_forwardDN Hill Enterprises Income Statement For Months Ended January February March Net sales Cost of goods sold Gross Profit 266,895 295,750 305,000 175,895 186,850 193,000 91,000 108,900 112,000 Selling expenses Administrative expenses 45,650 45,950 56,550 37,450 39,750 43,750 Total operating expenses 83,100 85,700 100,300 Income before income taxes 7,900 23,200 11,700 Income tax expense (20%) 1,580 4,640 2,340 Net income 6,320 18,560 9,360 COGS 75% variable / 25% fixed Sell Exp 80% variable / 20% fixed Admin Exp 25% variable / 75% fixed What is your projection for 6/30/24 YTD Net Income?arrow_forward
- 20.1 A business has compiled the following information for the year ended 31 October 20X2: 38 mins $ 386,200 989,000 422,700 Opening inventory Purchases Closing inventory The gross profit as a percentage of sales is always 40% Based on these figures, what is the sales revenue for the year? $952,500 $1,333,500 $1,587,500 A C $1.524.000arrow_forwardhi teacher provide answer General accountingarrow_forwardFocarrow_forward
- General Accountingarrow_forwardProblem 5 George Washington Company buys one kind of merchandise at $12 per unit and sells it at $25 per unit. The company's sales representatives receive a 20% commission on each sale. The March Income Statement shows the following information: Sales Cost of goods sold Gross profit George Washington Company Income Statement For Month Ended March 31 Expenses: Sales commissions Advertising Store rent Administrative salaries Depreciation Other Total expenses Net Income $500,000 240,000 $100,000 50,000 5,000 10,000 6,000 12,000 $260,000 $183,000 $ 77.000 The company's management believes that the March results will be repeated during April, May, and June without any changes in strategy. However, some changes are being considered. Management believes that unit sales will increase at a rate of 8% each month during the next quarter (including April) if the item's selling price is reduced to $22.50 per unit and if advertising expenses are increased by 40% and remain at that level for all…arrow_forwardPlease answer do not image formatarrow_forward
- Multiple-Step Income Statement The following information is available for Bergin Pastry Shop for the year ended December 31. Gross margin $34,600 Income from operations 9,200 Income taxes expense (14% of income before taxes) ? Interest expense 1,800 Net sales 85,800 Required: Prepare a multiple-step income statement for Bergin for the year ended December 31.arrow_forwardGENERAL ACCOUNTarrow_forwardThe following data are for Jessee's Candy Store for January: question 19 ss attached thanksarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College