Sino po may alam na makapag unlock ng chegg? Pa unlock po ako nito You do not have permission to view the full content of this post.
Log in or register now.. Thank you!
Sir, baka po pwede pa-unlock rin ako. Huhu. Maraming salamat poReply kalang sa thread nato if my e papa unlock kapa ha? Ako na bahala mention moko
1. Sales and Administrative expenses BudgetHi po pwede po pa unlock nito You do not have permission to view the full content of this post. Log in or register now. Cutthroat thank you po!
Particulars | Q-1 | Q-2 | Q-3 | Q-4 | Total |
Variable Cost: | |||||
Delivery Cost (5200/4) | 1,300 | 1,300 | 1,300 | 1,300 | 5,200 |
Commission (6500/4) | 1,625 | 1,625 | 1,625 | 1,625 | 6,500 |
Office Supplies (2300/4) | 575 | 575 | 575 | 575 | 2,300 |
Total Variable Cost | 3,500 | 3,500 | 3,500 | 3,500 | 14,000 |
Fixed Cost: | |||||
Accounting and Professional service (1800/4) | 450 | 450 | 450 | 450 | 1,800 |
Administrative salaries (35000/4) | 8,750 | 8,750 | 8,750 | 8,750 | 35,000 |
Advertising (9000/4) | 2,250 | 2,250 | 2,250 | 2,250 | 9,000 |
Computer lease (4200/4) | 1,050 | 1,050 | 1,050 | 1,050 | 4,200 |
Print Collateral(1400/4) | 350 | 350 | 350 | 350 | 1,400 |
Insurance | 300 | 300 | 300 | 300 | 1,200 |
Interest on Notes Payable (500/4) | 125 | 125 | 125 | 125 | 500 |
Rent (20000/4) | 5,000 | 5,000 | 5,000 | 5,000 | 20,000 |
Utilities (3000/4) | 750 | 750 | 750 | 750 | 3,000 |
Total fixed cost | 19,025 | 19,025 | 19,025 | 19,025 | 76,100 |
Total Sales and Admin budget | 22,525 | 22,525 | 22,525 | 22,525 | 90,100 |
Particulars | Q-1 | Q-2 | Q-3 | Q-4 | Total |
Sales Units | 4,300 | 4,600 | 4,500 | 4,800 | 18,200 |
Material Cost 50/spft*$8/sqft*Units | 17,20,000 | 18,40,000 | 18,00,000 | 19,20,000 | 72,80,000 |
Direct Labour Cost 2h*$14*Units | 1,20,400 | 1,28,800 | 1,26,000 | 1,34,400 | 5,09,600 |
Manufacturing OH 4h*$8.75*units | 1,50,500 | 1,61,000 | 1,57,500 | 1,68,000 | 6,37,000 |
Sales and Administrative expenses | 22,525 | 22,525 | 22,525 | 22,525 | 90,100 |
Total Cost of Goods sold | 20,13,425 | 21,52,325 | 21,06,025 | 22,44,925 | 85,16,700 |
Particulars | Amount $ |
Sales Revenue | 91,00,000 |
Less: Total Cost of goods sold | (85,16,700) |
Budgeted Income | 5,83,300 |
Particulars | Q-1 | Q-2 | Q-3 | Q-4 |
Cash Sales (40%) | 8,60,000 | 9,20,000 | 9,00,000 | 9,60,000 |
Collection of Credit Sales (80% current Month) | 10,32,000 | 11,04,000 | 10,80,000 | 11,52,000 |
Collection of credit sales in following months (20%) | 1,56,000 | 2,58,000 | 2,76,000 | 2,70,000 |
Total Cash collection | 20,48,000 | 22,82,000 | 22,56,000 | 23,82,000 |
Particulars | Q-1 | Q-2 | Q-3 | Q-4 |
Direct Labour Cost | 1,14,800 | 1,28,800 | 1,26,000 | 1,34,400 |
Direct Maufacturing overhead | 1,43,500 | 1,61,000 | 1,57,500 | 1,68,000 |
Direct Material Cost (70% current Quarter) | 12,04,000 | 12,88,000 | 12,60,000 | 13,44,000 |
Direct Material following Month (30%) | 4,50,000 | 5,16,000 | 5,52,000 | 5,40,000 |
Sales and admin expenses | 22,525 | 22,525 | 22,525 | 22,525 |
Instalment of Machine Purchase | 3,50,000 | - | 3,50,000 | - |
Dividends | - | - | - | 60,000 |
Total Cash Payment | 22,84,825 | 21,16,325 | 24,68,025 | 22,68,925 |
Particulars | Q-1 | Q-2 | Q-3 | Q-4 |
Cash collected | 20,48,000 | 22,82,000 | 22,56,000 | 23,82,000 |
Cash Payment | (22,84,825) | (21,16,325) | (24,68,025) | (22,68,925) |
Net Cash position | (2,36,825) | 1,65,675 | (2,12,025) | 1,13,075 |
Add: Opening Cash Bal | 15,000 | 10,000 | 1,69,320 | 10,000 |
Add: Borrowing | 2,11,825 | - | 39,060 | |
Less: Interest Payment | - | (6,355) | (6,355) | (7,527) |
Closing Balance | 10,000 | 1,69,320 | 10,000 | 1,15,548 |
thank you po!!1. Sales and Administrative expenses Budget
2. Cost of goods sold schedule
Particulars Q-1 Q-2 Q-3 Q-4 Total Variable Cost: Delivery Cost (5200/4) 1,300 1,300 1,300 1,300 5,200 Commission (6500/4) 1,625 1,625 1,625 1,625 6,500 Office Supplies (2300/4) 575 575 575 575 2,300 Total Variable Cost 3,500 3,500 3,500 3,500 14,000 Fixed Cost: Accounting and Professional service (1800/4) 450 450 450 450 1,800 Administrative salaries (35000/4) 8,750 8,750 8,750 8,750 35,000 Advertising (9000/4) 2,250 2,250 2,250 2,250 9,000 Computer lease (4200/4) 1,050 1,050 1,050 1,050 4,200 Print Collateral(1400/4) 350 350 350 350 1,400 Insurance 300 300 300 300 1,200 Interest on Notes Payable (500/4) 125 125 125 125 500 Rent (20000/4) 5,000 5,000 5,000 5,000 20,000 Utilities (3000/4) 750 750 750 750 3,000 Total fixed cost 19,025 19,025 19,025 19,025 76,100 Total Sales and Admin budget 22,525 22,525 22,525 22,525 90,100
3. Budgeted Income Statement
Particulars Q-1 Q-2 Q-3 Q-4 Total Sales Units 4,300 4,600 4,500 4,800 18,200 Material Cost 50/spft*$8/sqft*Units 17,20,000 18,40,000 18,00,000 19,20,000 72,80,000 Direct Labour Cost 2h*$14*Units 1,20,400 1,28,800 1,26,000 1,34,400 5,09,600 Manufacturing OH 4h*$8.75*units 1,50,500 1,61,000 1,57,500 1,68,000 6,37,000 Sales and Administrative expenses 22,525 22,525 22,525 22,525 90,100 Total Cost of Goods sold 20,13,425 21,52,325 21,06,025 22,44,925 85,16,700
4.Cash Collection Schedule
Particulars Amount $ Sales Revenue 91,00,000 Less: Total Cost of goods sold (85,16,700) Budgeted Income 5,83,300
5. Cash Payment Schedule
Particulars Q-1 Q-2 Q-3 Q-4 Cash Sales (40%) 8,60,000 9,20,000 9,00,000 9,60,000 Collection of Credit Sales (80% current Month) 10,32,000 11,04,000 10,80,000 11,52,000 Collection of credit sales in following months (20%) 1,56,000 2,58,000 2,76,000 2,70,000 Total Cash collection 20,48,000 22,82,000 22,56,000 23,82,000
6.Cash Budget for each Quarter
Particulars Q-1 Q-2 Q-3 Q-4 Direct Labour Cost 1,14,800 1,28,800 1,26,000 1,34,400 Direct Maufacturing overhead 1,43,500 1,61,000 1,57,500 1,68,000 Direct Material Cost (70% current Quarter) 12,04,000 12,88,000 12,60,000 13,44,000 Direct Material following Month (30%) 4,50,000 5,16,000 5,52,000 5,40,000 Sales and admin expenses 22,525 22,525 22,525 22,525 Instalment of Machine Purchase 3,50,000 - 3,50,000 - Dividends - - - 60,000 Total Cash Payment 22,84,825 21,16,325 24,68,025 22,68,925
Particulars Q-1 Q-2 Q-3 Q-4 Cash collected 20,48,000 22,82,000 22,56,000 23,82,000 Cash Payment (22,84,825) (21,16,325) (24,68,025) (22,68,925) Net Cash position (2,36,825) 1,65,675 (2,12,025) 1,13,075 Add: Opening Cash Bal 15,000 10,000 1,69,320 10,000 Add: Borrowing 2,11,825 - 39,060 Less: Interest Payment - (6,355) (6,355) (7,527) Closing Balance 10,000 1,69,320 10,000 1,15,548