this question was previously answered wrong. can you please help me find the correct answer. can you please give explanations as to how you arrived at the numbers. thanks so much.
Cash Collections | ||||
April | May | June | Quarter | |
Sales Units | 65200 | 100200 | 50200 | 215600 |
Sales Price | $ 11 | $ 11 | $ 11 | |
Sales Amount | $ 717,200 | $ 1,102,200 | $ 552,200 | $ 2,371,600 |
Cash Collections | ||||
February | $ 28,820 | $ 28,820 | ||
March | $ 309,540 | $ 44,220 | $ 353,760 | |
April | $ 143,440 | $ 502,040 | $ 71,720 | $ 717,200 |
May | $ 220,440 | $ 771,540 | $ 991,980 | |
June | $ 110,440 | $ 110,440 | ||
Total Cash Collections | $ 481,800 | $ 766,700 | $ 953,700 | $ 2,202,200 |
Working
Cash Collections | ||||
April | May | June | Quarter | |
Sales Units | 65200 | 100200 | 50200 | 215600 |
Sales Price | $ 11 | $ 11 | $ 11 | |
Sales Amount | $ 717,200 | $ 1,102,200 | $ 552,200 | $ 2,371,600 |
Cash Collections | ||||
February | =26200*11*10% | |||
March | =40200*11*70% | =40200*11*10% | ||
April | =717200*20% | =717200*70% | =717200*10% | |
May | =1102200*20% | =1102200*70% | ||
June | =552200*20% | |||
Total Cash Collections | 0 | 0 | 0 |
Merchandise Purchase Budget | ||||
April | May | June | Quarter | |
Sales Units | 65200 | 100200 | 50200 | 215600 |
Ending Inventory | 40080 | 20080 | 12080 | 12080 |
Total Needs | 105280 | 120280 | 62280 | 227680 |
Beginning Inventory | 26080 | 40080 | 20080 | 26080 |
Purchases Units | 79200 | 80200 | 42200 | 201600 |
Purchase Price | $ 4.10 | $ 4.10 | $ 4.10 | $ 4.10 |
Purchase Amount | $ 324,720 | $ 328,820 | $ 173,020 | $ 826,560 |
Ending Inventory working
Ending Inventory | =100200*40% | =50200*40% | =30200*40% |
Cash Payments | ||||
April | May | June | Quarter | |
Cash Payments | $ - | |||
Accounts Payable | $ 101,000 | $ 101,000 | ||
April | $ 80,196 | $ 80,196 | $ 160,392 | |
May | $ 123,246 | $ 123,246 | $ 246,492 | |
June | $ 61,746 | $ 61,746 | ||
Total Cash Collections | $ 181,196 | $ 203,442 | $ 184,992 | $ 569,630 |
Working
Cash Payments | |||
April | May | June | |
Cash Payments | |||
Accounts Payable | 101000 | ||
April | =160392*50% | =160392*50% | |
May | =246492*50% | =246492*50% | |
June | =123492*50% |
this question was previously answered wrong. can you please help me find the correct answer. can...
can you please answer this and show me how you arrived at the answer. thanks Check my work You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting,...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting. you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earnings United, a distributor of earrings to various retail outlets located in shopping malls across the country in the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash Since you are well trained in budgeting you have decided to prepare a master budget for the upcoming second quarter to this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting. you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...