Can you help me with the projected budget?
Use the information from the financial statements: Income
Statement, Balance Sheet and Cash Flow Statement.
Based on the info above, please complete the following:
Santa Clara Food and More Income Statement - Week 1 & Week 2 Week 1 Week 2 2157.5 5659 432.32 1176.92 1725.18 4482.08 1182.5 2418.75 1241.63 2520.88 1400 1960 2000 2000 0 0 0 0 700 6524.13 ($4,798.95) May to June 2022 Revenue Cost of Good Sold Gross Margin Management Staff Adv./Promo Rent Utilities Depreciation Expense Interest on Loan Other Expenses Total Expenses Net Income 0 0 700 9599.63 ($5,117.55)
Santa Clara Food and More Balance Sheet - Week 1 & Week 2 Week 1 Liabilities 9537.12 Taxes Payable 563.75 25000 2500 Loans 8000 0 Total Liabilities 25563.75 727.68 Equity 20764.8 Retained Earnings -4798.95 Total equity -4798.95 Total Lab. & Eq. 20764.8 Liabilities Taxes Payable 1148.75 Loans 25000 Total Liabilities 26148.75 Equity Retained Earnings -5117.55 Total equity -5117.55 Total Liab. & Eq. 21031.2 May to June 2022 Assets Cash Deposits Equipment Accum. Depreciation Inventory Total Assets May to June 2022 Assets Cash Deposits Equipment Accum. Depreciation Inventory Total Assets 9891.12 2500 8000 0 640.08 21031.2 Week 2
Santa Clara Food Cash Flow Statement - Week 1 & Week 2 Week 1 -4798.95 0 563.75 -727.68 0 0 -4962.88 0 0 0 0 -4962.88 -5117.55 0 1148.75 -640.08 0 0 -4608.88 0 0 0 0 -4608.88 May to June 2022 Cash Flow from Ops. Net Income Depreciation Increase (decrease) in Payables Decrease (increase) in inventory Decrease (increase) in deposits Decrease (increase) in prepaid Exp. Net Cash From Operations Invesment Activities Furnitures and Equipment Net Investment Financial Activities Increase (decrease) in short-term debt Net financing Net Increase (Decrease) in cash May to June 2022 Cash Flow from Ops. Net Income Depreciation Increase (decrease) in Payables Decrease (increase) in inventory Decrease (increase) in deposits Decrease (increase) in prepaid Exp. Net Cash From Operations Invesment Activities Furnitures and Equipment Net Investment Financial Activities Increase (decrease) in short-term debt Net financing Net Increase (Decrease) in cash Week 2
Please evaluate the result obtained ($) from both weeks of business. Calculate an average of sales, purchases and operating expenses, using the historical data of the first two (2) weeks of operation. Week 1 & 2 Sales: Week I & II Sales: $2,157.50+ $5,659.00 Week I & II Purchases: $432.32 + $1,176.92 ITEM AVERAGE BASE ($) The sales The purchases The operating costs and expenses
This information will help you make your sales, purchases and operational budget projected per week: Sales Budget: ELEMENT Week 3 (Month 3) Week 4 (Month 4) Total Projected Units Sales Price Total Sales ($) Purchase Budget: ELEMENT Week 3 (Month 3) Week 4 (Month 4) Total Projected Units Sales Price Total Sales ($) +
Operational Budget: ELEMENT Sales Costs of Good Sales Gross Margin ($) Expenses Administrative Exp. Staff Payroll Exp. Marketing Promo. Rent Utilities Depreciation Insurance loan interest Total Expenses Net Income Week 3 (Month 3) Week 4 (Month 4) Total Projected
Can you help me with the projected budget? Use the information from the financial statements: Income Statement, Balance
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am