Cost of Goods Sold Beginning Inventory Add: Purchases Freight-in Direct Labor Indirect Expenses Inventory Available Less: Ending Inventory Cost of Goods Sold Gross Profit (Loss) Sales Budget Actual Sales $ 604,461.00 $ 97,400.00 Less Cost of Sales $ 91,421.57 $ 14,731.24 Net Sales $ 513,039.43 $ 82,668.76 Operating Expenses Accounting $ 53,040.00 $ 8,840.00 Advertising $ 15,000.00 $ 2,400.00 Wages $ 128,000.00 $ 21,500.00 Vehicle Expense $ 3,600.00 $ 700.00 Bank Charges $ 2,400.00 $ 400.00 Printing $ 4,800.00 $ 600.00 Insurance $ 15,600.00 $ 2,600.00 Interest Expense $ 3,600.00 $ 625.00 Taxes $ 12,000.00 $ 2,250.00 Rent $ 28,800.00 $ 4,900.00 Telephone $ 4,800.00 $ 800.00 Utilities $ 12,000.00 $ 2,450.00 Deprecation Expense $ 6,000.00 $ 1,000.00 Office Expense $ 3,000.00 $ 450.00 Other Expense $ 1,200.00 $ 270.00 Total Expenses $ 293,840.00 $ 49,785.00 Net Profit $ 219,199.43 $ 32,883.76 Cash Flow Analysis Net Profit (Loss) $ 219,199.43 $ 32,883.76 Depreciation Expense $ 6,000.00 $ 1,000.00 Cash from Operations $ 225,199.43 $ 33,883.76 Plus Initial Cash $ 24,000.00 $ 23,524.86 Less Principal Payment* $ 96,000.00 $ 16,000.00 Cash After Princ. Payment $ 153,199.43 $ 41,408.62 Plus Loan Advance** $ - Less Loan Payment*** $ 60,000.00 $ 10,000.00 Plus Misc. Cash Inflow**** $ - Minus Misc. Cash Outflow $ 60,000.00 $ 8,000.00 Ending Cash Flow $ 33,199.43 $ 23,408.62
| Cost of Goods Sold | |||
| Beginning Inventory | |||
| Add: Purchases | |||
| Freight-in | |||
| Direct Labor | |||
| Indirect Expenses | |||
| Inventory Available | |||
| Less: Ending Inventory | |||
| Cost of Goods Sold | |||
| Gross Profit (Loss) | |||
| Sales | Budget | Actual |
| Sales | $ 604,461.00 | $ 97,400.00 |
| Less Cost of Sales | $ 91,421.57 | $ 14,731.24 |
| Net Sales | $ 513,039.43 | $ 82,668.76 |
| Operating Expenses | ||
| Accounting | $ 53,040.00 | $ 8,840.00 |
| Advertising | $ 15,000.00 | $ 2,400.00 |
| Wages | $ 128,000.00 | $ 21,500.00 |
| Vehicle Expense | $ 3,600.00 | $ 700.00 |
| Bank Charges | $ 2,400.00 | $ 400.00 |
| Printing | $ 4,800.00 | $ 600.00 |
| Insurance | $ 15,600.00 | $ 2,600.00 |
| Interest Expense | $ 3,600.00 | $ 625.00 |
| Taxes | $ 12,000.00 | $ 2,250.00 |
| Rent | $ 28,800.00 | $ 4,900.00 |
| Telephone | $ 4,800.00 | $ 800.00 |
| Utilities | $ 12,000.00 | $ 2,450.00 |
| Deprecation Expense | $ 6,000.00 | $ 1,000.00 |
| Office Expense | $ 3,000.00 | $ 450.00 |
| Other Expense | $ 1,200.00 | $ 270.00 |
| Total Expenses | $ 293,840.00 | $ 49,785.00 |
| Net Profit | $ 219,199.43 | $ 32,883.76 |
| Cash Flow Analysis | ||
| Net Profit (Loss) | $ 219,199.43 | $ 32,883.76 |
| Depreciation Expense | $ 6,000.00 | $ 1,000.00 |
| Cash from Operations | $ 225,199.43 | $ 33,883.76 |
| Plus Initial Cash | $ 24,000.00 | $ 23,524.86 |
| Less Principal Payment* | $ 96,000.00 | $ 16,000.00 |
| Cash After Princ. Payment | $ 153,199.43 | $ 41,408.62 |
| Plus Loan Advance** | $ - | |
| Less Loan Payment*** | $ 60,000.00 | $ 10,000.00 |
| Plus Misc. Cash Inflow**** | $ - | |
| Minus Misc. Cash Outflow | $ 60,000.00 | $ 8,000.00 |
| Ending Cash Flow | $ 33,199.43 | $ 23,408.62 |
Expert Answer
Related Accounting Q&A
Q: how company's financial statement reflects the potential tax avoidance? For example?
A: Click to see the answer
Q: conduct horizontal and vertical analyses for the balance sheet and income statement accounts and rep...
A: Use basic financial analysis to examine any horizontal changes in Starbuck’s short- and long-term de...
Q: Income StatementThe revenues and expenses of Sentinel Travel Service for the year ended August 31, 2...
A: Prepare an income statement:
Q: Depreciation for Financial Statements and Income Tax Purposes Dinkle Company purchased equipment for...
A: Under straight line method, the depreciation is computed by subtracting the residual value from the ...
Q: Stellar Corporation began operations on December 1, 2016. The only inventory transaction in 2016 was...
A: Prepare a schedule to determine the total units available for sale and cost of goods available for s...
Q: Just part B
A: Working:
Q: Bramble Corp. sells its product for $60 per unit. During 2019, it produced 60000 units and sold 5000...
A: Calculate the unit cost and the cost for 50,000 units.
Q: Operating Leverage Snellville Co. reports the following data: Sales $483,900 Variable costs 329,100 ...
A: Degree of Operating Leverage: Degree of operating leverage is an efficiency ratio which evaluates t...
Q: Question is pinned below please answer all parts
A: Required journal entries to record the cost of 90 laptops sold on 10 May:a. Specific cost identifica...
