Answered step by step
Verified Expert Solution
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
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,377Step 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