Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Jan 2026 Feb 2026 Mar 2026 Apr 2026 May 2026 Jun 2026 Jul 2026 Aug 2026 Sep 2026 Oct 2026 Nov 2026 Dec 2026 Total
| Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026 | May 2026 | Jun 2026 | Jul 2026 | Aug 2026 | Sep 2026 | Oct 2026 | Nov 2026 | Dec 2026 | Total | |
| Income | I know that july has the highest net income. Let me know between net sales and net income as the difference.
| ||||||||||||
| 490 Sales Discount | -10.60 | -25.54 | -25.39 | -23.57 | -31.01 | -31.01 | -42.23 | -41.30 | -41.47 | -49.59 | -46.83 | -45.69 | -414.23 |
| Sales | |||||||||||||
| 405 Massage | 2,548.00 | 2,181.80 | 8,331.80 | 12,641.80 | 14,931.80 | 22,063.60 | 23,323.60 | 18,633.60 | 25,718.40 | 24,883.40 | 21,308.40 | 16,558.40 | 193,124.60 |
| 410 Facials | 468.40 | 508.40 | 2,118.40 | 1,878.40 | 2,018.40 | 4,616.80 | 2,106.80 | 1,656.80 | 2,075.20 | 2,025.20 | 1,765.20 | 1,765.20 | 23,003.20 |
| 415 Spa treatments | 951.50 | 891.70 | 4,101.70 | 4,969.10 | 3,134.10 | 5,593.40 | 10,023.40 | 7,653.40 | 6,813.40 | 3,332.20 | 2,937.20 | 2,397.20 | 52,798.30 |
| 420 Products | 544.14 | 277.24 | 437.00 | 100.00 | 525.00 | 703.78 | 49.98 | 293.68 | 7.84 | 132.30 | 0.00 | 29.40 | 3,100.36 |
| 425 Membership Fees | 276.00 | 276.00 | 276.00 | 276.00 | 276.00 | 276.00 | 276.00 | 276.00 | 345.00 | 345.00 | 345.00 | 345.00 | 3,588.00 |
| Total Sales | $ 4,788.04 | $ 4,135.14 | $15,264.90 | $19,865.30 | $20,885.30 | $33,253.58 | $35,779.78 | $28,513.48 | $34,959.84 | $30,718.10 | $26,355.80 | $21,095.20 | $275,614.46 |
| Total Income | $ 4,777.44 | $ 4,109.60 | $15,239.51 | $19,841.73 | $20,854.29 | $33,222.57 | $35,737.55 | $28,472.18 | $34,918.37 | $30,668.51 | $26,308.97 | $21,049.51 | $275,200.23 |
| Cost of Goods Sold | |||||||||||||
| COGS | |||||||||||||
| 505 Products | 279.00 | 164.00 | 188.00 | 54.00 | 254.00 | 207.00 | 32.00 | 151.00 | 6.00 | 65.00 | 20.00 | 1,420.00 | |
| 510 Independent Contractors | 580.00 | 526.50 | 2,488.50 | 2,437.50 | 2,287.00 | 2,948.00 | 2,915.00 | 2,555.00 | 2,120.00 | 2,130.00 | 1,810.00 | 1,445.00 | 24,242.50 |
| 519 Purchase Discount | -2.25 | -72.52 | -49.83 | -4.55 | -129.15 | ||||||||
| Total COGS | $ 859.00 | $ 688.25 | $ 2,676.50 | $ 2,418.98 | $ 2,541.00 | $ 3,155.00 | $ 2,897.17 | $ 2,701.45 | $ 2,126.00 | $ 2,195.00 | $ 1,810.00 | $ 1,465.00 | $ 25,533.35 |
| Total Cost of Goods Sold | $ 859.00 | $ 688.25 | $ 2,676.50 | $ 2,418.98 | $ 2,541.00 | $ 3,155.00 | $ 2,897.17 | $ 2,701.45 | $ 2,126.00 | $ 2,195.00 | $ 1,810.00 | $ 1,465.00 | $ 25,533.35 |
| Gross Profit | $ 3,918.44 | $ 3,421.35 | $12,563.01 | $17,422.75 | $18,313.29 | $30,067.57 | $32,840.38 | $25,770.73 | $32,792.37 | $28,473.51 | $24,498.97 | $19,584.51 | $249,666.88 |
| Expenses | |||||||||||||
| 520 Salaries and Wages Expense | 6,272.00 | 5,880.00 | 5,880.00 | 5,756.00 | 5,498.00 | 5,880.00 | 5,880.00 | 7,840.00 | 7,840.00 | 8,096.00 | 7,500.00 | 5,880.00 | 78,202.00 |
| 530 Rent Expense | 750.00 | 750.00 | 712.50 | 712.50 | 712.50 | 712.50 | 750.00 | 712.50 | 712.50 | 712.50 | 712.50 | 712.50 | 8,662.50 |
| 535 Insurance Expense | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 6,000.00 | ||||||
| 540 Office supplies | 61.19 | 118.84 | 44.99 | 44.99 | 44.99 | 44.99 | 44.99 | 44.99 | 44.99 | 44.99 | 44.99 | 44.99 | 629.93 |
| 550 Massage and Spa Supplies | 50.64 | 504.84 | 207.00 | 157.00 | 103.00 | 66.82 | 75.87 | 1,165.17 | |||||
| 560 Merch Serv | 298.00 | 95.76 | 68.00 | 335.34 | 347.28 | 407.53 | 368.35 | 431.81 | 226.08 | 376.70 | 327.70 | 3,282.55 | |
| 570 Marketing Expense | 2,150.00 | 2,150.00 | |||||||||||
| 575 Continuing Education | 204.00 | 204.00 | |||||||||||
| 580 Payroll Tax Expense | 744.31 | 694.57 | 847.03 | 905.60 | 890.13 | 976.75 | 874.40 | 921.98 | 1,032.15 | 987.47 | 886.93 | 814.96 | 10,576.28 |
| 585 Utilities | 745.00 | 428.00 | 408.00 | 678.00 | 358.00 | 353.00 | 683.00 | 401.00 | 449.00 | 657.00 | 341.00 | 423.00 | 5,924.00 |
| 590 Interest Expense | 352.26 | 209.69 | 203.84 | 199.64 | 144.70 | 194.39 | 135.80 | 131.34 | 126.85 | 122.35 | 117.84 | 1,938.70 | |
| Total Expenses | $ 8,870.50 | $ 8,370.07 | $ 8,675.05 | $ 8,636.27 | $ 8,050.54 | $ 8,726.47 | $ 9,952.13 | $13,945.08 | $11,502.88 | $12,001.51 | $10,935.47 | $ 9,069.16 | $118,735.13 |
| Net Operating Income | -$ 4,952.06 | -$ 4,948.72 | $ 3,887.96 | $ 8,786.48 | $10,262.75 | $21,341.10 | $22,888.25 | $11,825.65 | $21,289.49 | $16,472.00 | $13,563.50 | $10,515.35 | $130,931.75 |
| Other Income | |||||||||||||
| 430 Facility Fee | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 5,000.00 | |||||||
| Total Other Income | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | $ 5,000.00 |
| Other Expenses | |||||||||||||
| 595 Depreciation Expense | 1,599.20 | 1,599.20 | |||||||||||
| Total Other Expenses | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 1,599.20 | $ 1,599.20 |
| Net Other Income | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | -$ 599.20 | $ 3,400.80 |
| Net Income | -$ 4,952.06 | -$ 4,948.72 | $ 3,887.96 | $ 8,786.48 | $10,262.75 | $21,341.10 | $22,888.25 | $12,825.65 | $22,289.49 | $17,472.00 | $14,563.50 | $ 9,916.15 | $134,332.55 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Internal Control Audit And Compliance Documentation And Testing Under The New COSO Framework
Authors: Graham
1st Edition
1118996216, 978-1118996218
