Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP. CONFUSE Checkbook ? = Date Account Payment Deposit Balance COGS Adv./Promo. COGS $770.00 $1,400.00 $561.00 $1,200.00 $900.00 Description Beginning Balance 110 lb. Bulk

PLEASE HELP. CONFUSE

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Checkbook ? = Date Account Payment Deposit Balance COGS Adv./Promo. COGS $770.00 $1,400.00 $561.00 $1,200.00 $900.00 Description Beginning Balance 110 lb. Bulk Coffee Online Ad Baked Goods 20000 Small Cups w/Logo 10000 Large Cups w/Logo Monday Receipts Tuesday Receipts Wednesday Receipts Utilities Thursday Receipts Manager Pay Staff Pay Friday Receipts Purchase 5 lb. Coffee Saturday Receipts Sunday Receipts Feb 5 Feb 5 Feb 5 Feb 5 Feb 5 Feb 6 Feb 7 Feb 8 Feb 8 Feb 9 Feb 9 Feb 9 Feb 10 Feb 11 Feb 12 Feb 12 $3,066.75 $3,035.25 $3,146.00 Inventory Inventory Revenue Revenue Revenue Utilities Revenue Management Staff Revenue $22,478.79 $21,708.79 $20,308.79 $19,747.79 $18,547.79 $17,647.79 $20,714.54 $23,749.79 $26,895.79 $26,345.79 $29,379.04 $27,235.69 $24,348.19 $27,477.94 $27,437.94 $30,008.94 $32,274.69 $550.00 $3,033.25 $2,143.35 $2,887.50 $3,129.75 $40.00 COGS Revenue $2,571.00 $2,265.75 Revenue Daily Receipts and Customer Traffic ? E Date Cups Served Daily Capacity 688 Avg. Price $4.68 $4.69 688 688 Feb 5 Feb 6 Feb 7 Feb 8 Feb 9 Feb 10 Feb 11 Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday 581 573 598 573 Receipts $3,066.75 $3,035.25 $3,146.00 $3,033.25 $3,129.75 $2,571.00 $2,265.75 688 688 $4.67 $4.69 $4.68 $4.68 $4.69 593 688 486 439 688 Total 4,816 3,843 $4.68 $20,247.75 Units Unit Price Weekly Totals Small Coffee Medium Coffee Large Coffee Baked Goods 1,377 1,590 876 1,122 $4.25 $4.75 $5.25 $2.00 Receipts $5,852.25 $7,552.50 $4,599.00 $2,244.00 Total $20,247.75 Income Statement for February, Month to Date Previous Month ? = February to Date $33,285.15 $1,963.79 $31,321.36 % of Rev. 100% 6% Revenue COGS Gross Margin Year to Date $90,881.75 $6,685,46 $84,196.29 % of Rev. 100% 7% 93% 94% 17% 23% 16% 20% 23% 4% Management Staff Adv./Promo. Rent Utilities Depreciation Expense Interest on Loan Other Total Expenses $5,583.67 $7,500.81 $1,400.00 $2,000.00 $550.00 $0.00 $0.00 $(0.00) $17,034.48 $14,717.42 $17,982.71 $21,000.00 $4,000.00 $550.00 $233.33 $208.33 $1,141.00 $59,832.79 4% 1% 6% 2% 0% 0% -0% 51% 0% 0% 1% 66% Net Income $14,286.88 43% $24,363.50 27% Balance Sheet for February, Month to Date Previous Month ? = Assets Cash Liabilities Taxes Payable Loans Total Liabilities $3,042.90 $25,000.00 $28,042.90 Deposits Equipment Accumulated Depreciation Inventory Prepaid Exp. $32,274.69 $2,500.00 $14,000.00 $(233.33) $2,306.04 $1,559.00 Equity Retained Earnings Total Equity Total Liab. & Eq. $24,363.50 $24,363.50 Total Assets $52,406.40 $52,406.40 Cash Flow Statement for February, Month to Date Previous Month ? = Cash Flow From Operations Net Income Depreciation Increase (Decrease) in Payables Decrease (Increase) in Inventory Decrease (Increase) in Deposits Decrease (Increase) in Prepaid Expenses Net Cash From Operations $14,286.88 $0.00 $3,042.90 $(1.587.21). $0.00 $0.00 $15,742.57 Investment Activities Furniture and Equipment Net Investment $0.00 $0.00 Financing Activities Increase (Decrease) in Short-Term Debt Net Financing $0.00 $0.00 Net Increase (Decrease) in Cash $15,742.57 Weekly Purchases Save Undo ? E Perishable Wasted Sold Emergency Next Week's Purchases Coffee O lb. 115 lb. 5 lb. 115 lb. Organic ($7.00/lb.) Non-Perishable Inventory Sold Emergency Next Week's Purchases Small Cups 18,623 cups 1,377 cups 0 cups None Medium Cups 1,590 cups 0 cups None 5,250 cups 9,124 cups Large Cups 876 cups 0 cups None Coffee Calculator Estimated Cup Sales Coffee per Cup Coffee Required Small 1,377

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Anthony Saunders, Marcia Cornett

5th Edition

0078034663, 978-0078034664

More Books

Students also viewed these Finance questions

Question

Describe the concept and evolution of rulebased expert systems (ES)

Answered: 1 week ago