What's new

Help Pa unlock po ng chegg

1620205263141.png

1620205299793.png


1620205397616.png
 

Attachments

The answer is 49. There are 12 months in a year * 4 = 48. That would guarantee a minimum of 4 people in each month. The adding 1 guarantees that 1 month will have 5 friends in that month.
 
Hi 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!
1. Sales and Administrative expenses Budget

ParticularsQ-1Q-2Q-3Q-4Total
Variable Cost:
Delivery Cost (5200/4)1,3001,3001,3001,3005,200
Commission (6500/4)1,6251,6251,6251,6256,500
Office Supplies (2300/4)5755755755752,300
Total Variable Cost3,5003,5003,5003,50014,000
Fixed Cost:
Accounting and Professional service (1800/4)4504504504501,800
Administrative salaries (35000/4)8,7508,7508,7508,75035,000
Advertising (9000/4)2,2502,2502,2502,2509,000
Computer lease (4200/4)1,0501,0501,0501,0504,200
Print Collateral(1400/4)3503503503501,400
Insurance3003003003001,200
Interest on Notes Payable (500/4)125125125125500
Rent (20000/4)5,0005,0005,0005,00020,000
Utilities (3000/4)7507507507503,000
Total fixed cost19,02519,02519,02519,02576,100
Total Sales and Admin budget22,52522,52522,52522,52590,100
2. Cost of goods sold schedule

ParticularsQ-1Q-2Q-3Q-4Total
Sales Units4,3004,6004,5004,80018,200
Material Cost 50/spft*$8/sqft*Units17,20,00018,40,00018,00,00019,20,00072,80,000
Direct Labour Cost 2h*$14*Units1,20,4001,28,8001,26,0001,34,4005,09,600
Manufacturing OH 4h*$8.75*units1,50,5001,61,0001,57,5001,68,0006,37,000
Sales and Administrative expenses22,52522,52522,52522,52590,100
Total Cost of Goods sold20,13,42521,52,32521,06,02522,44,92585,16,700
3. Budgeted Income Statement

ParticularsAmount $
Sales Revenue91,00,000
Less: Total Cost of goods sold(85,16,700)
Budgeted Income5,83,300
4.Cash Collection Schedule

ParticularsQ-1Q-2Q-3Q-4
Cash Sales (40%)8,60,0009,20,0009,00,0009,60,000
Collection of Credit Sales (80% current Month)10,32,00011,04,00010,80,00011,52,000
Collection of credit sales in following months (20%)1,56,0002,58,0002,76,0002,70,000
Total Cash collection20,48,00022,82,00022,56,00023,82,000
5. Cash Payment Schedule

ParticularsQ-1Q-2Q-3Q-4
Direct Labour Cost1,14,8001,28,8001,26,0001,34,400
Direct Maufacturing overhead1,43,5001,61,0001,57,5001,68,000
Direct Material Cost (70% current Quarter)12,04,00012,88,00012,60,00013,44,000
Direct Material following Month (30%)4,50,0005,16,0005,52,0005,40,000
Sales and admin expenses22,52522,52522,52522,525
Instalment of Machine Purchase3,50,000-3,50,000-
Dividends---60,000
Total Cash Payment22,84,82521,16,32524,68,02522,68,925
6.Cash Budget for each Quarter

ParticularsQ-1Q-2Q-3Q-4
Cash collected20,48,00022,82,00022,56,00023,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 Bal15,00010,0001,69,32010,000
Add: Borrowing2,11,825-39,060
Less: Interest Payment-(6,355)(6,355)(7,527)
Closing Balance10,0001,69,32010,0001,15,548
 
1. Sales and Administrative expenses Budget

ParticularsQ-1Q-2Q-3Q-4Total
Variable Cost:
Delivery Cost (5200/4)1,3001,3001,3001,3005,200
Commission (6500/4)1,6251,6251,6251,6256,500
Office Supplies (2300/4)5755755755752,300
Total Variable Cost3,5003,5003,5003,50014,000
Fixed Cost:
Accounting and Professional service (1800/4)4504504504501,800
Administrative salaries (35000/4)8,7508,7508,7508,75035,000
Advertising (9000/4)2,2502,2502,2502,2509,000
Computer lease (4200/4)1,0501,0501,0501,0504,200
Print Collateral(1400/4)3503503503501,400
Insurance3003003003001,200
Interest on Notes Payable (500/4)125125125125500
Rent (20000/4)5,0005,0005,0005,00020,000
Utilities (3000/4)7507507507503,000
Total fixed cost19,02519,02519,02519,02576,100
Total Sales and Admin budget22,52522,52522,52522,52590,100
2. Cost of goods sold schedule

ParticularsQ-1Q-2Q-3Q-4Total
Sales Units4,3004,6004,5004,80018,200
Material Cost 50/spft*$8/sqft*Units17,20,00018,40,00018,00,00019,20,00072,80,000
Direct Labour Cost 2h*$14*Units1,20,4001,28,8001,26,0001,34,4005,09,600
Manufacturing OH 4h*$8.75*units1,50,5001,61,0001,57,5001,68,0006,37,000
Sales and Administrative expenses22,52522,52522,52522,52590,100
Total Cost of Goods sold20,13,42521,52,32521,06,02522,44,92585,16,700
3. Budgeted Income Statement

ParticularsAmount $
Sales Revenue91,00,000
Less: Total Cost of goods sold(85,16,700)
Budgeted Income5,83,300
4.Cash Collection Schedule

ParticularsQ-1Q-2Q-3Q-4
Cash Sales (40%)8,60,0009,20,0009,00,0009,60,000
Collection of Credit Sales (80% current Month)10,32,00011,04,00010,80,00011,52,000
Collection of credit sales in following months (20%)1,56,0002,58,0002,76,0002,70,000
Total Cash collection20,48,00022,82,00022,56,00023,82,000
5. Cash Payment Schedule

ParticularsQ-1Q-2Q-3Q-4
Direct Labour Cost1,14,8001,28,8001,26,0001,34,400
Direct Maufacturing overhead1,43,5001,61,0001,57,5001,68,000
Direct Material Cost (70% current Quarter)12,04,00012,88,00012,60,00013,44,000
Direct Material following Month (30%)4,50,0005,16,0005,52,0005,40,000
Sales and admin expenses22,52522,52522,52522,525
Instalment of Machine Purchase3,50,000-3,50,000-
Dividends---60,000
Total Cash Payment22,84,82521,16,32524,68,02522,68,925
6.Cash Budget for each Quarter

ParticularsQ-1Q-2Q-3Q-4
Cash collected20,48,00022,82,00022,56,00023,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 Bal15,00010,0001,69,32010,000
Add: Borrowing2,11,825-39,060
Less: Interest Payment-(6,355)(6,355)(7,527)
Closing Balance10,0001,69,32010,0001,15,548
thank you po!! :)
 
Back
Top