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 https://www.Çℎḙḡḡ.com/homework-help...b-sales-administrative-expense-budg-q76930103 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
