Question
Square Ltd’s projected sales report is given for the Month fromJuly to December 2017. Consider all sales would be credit sales. The actual sales for the months of May and June 2017 are also given.
Square Ltd Sales Report For the year end 2017 |
||||||||
May |
June |
July |
August |
September |
October |
November |
December |
|
$2,000 |
$5,890 |
$6,000 |
$13,200 |
$14,900 |
$22,000 |
$32,000 |
$22,600 |
Accounts Receivable is calculated at 50% current month, 30% last month and 20% second to last month.Build the projected cash collection for the last six months ending in December by using suitable mathematical tools.
Collection pattern: | ||||||||||||
Accounts receivable | ||||||||||||
50% of current month | Hence,50% collected in the month of sale | |||||||||||
30% of last month | 50% collected in the first month of sale | |||||||||||
Hence,collection in 2nd month=(100-50-30)%=20% | ||||||||||||
20% of second to last month | 50% collected in the first month of sale | |||||||||||
20% collected in the second month of sale | ||||||||||||
Hence,collection in 3rd month=(100-50-20-20)=10%' | ||||||||||||
Collection in last month | Balance=(100-50-20-10)=20% | |||||||||||
Collection pattern: | ||||||||||||
50% in the month of sale | ||||||||||||
20% in the second month of sales | ||||||||||||
10% in the third month of sales | ||||||||||||
20% in the fouth month of sales | ||||||||||||
Projected cash collections | ||||||||||||
July | August | September | October | November | December | Total | ||||||
May sales | 2000 | |||||||||||
10% in the third month of sales | 200 | |||||||||||
20% in the fouth month of sales | 400 | |||||||||||
June sales | 5890 | |||||||||||
20% in the second month of sales | 1178 | |||||||||||
10% in the third month of sales | 589 | |||||||||||
20% in the fouth month of sales | 1178 | |||||||||||
July sales | 6000 | |||||||||||
50% in the month of sale | 3000 | |||||||||||
20% in the second month of sales | 1200 | |||||||||||
10% in the third month of sales | 600 | |||||||||||
20% in the fouth month of sales | 1200 | |||||||||||
August sales | 13200 | |||||||||||
50% in the month of sale | 6600 | |||||||||||
20% in the second month of sales | 2640 | |||||||||||
10% in the third month of sales | 1320 | |||||||||||
20% in the fouth month of sales | 2640 | |||||||||||
September sales | 14900 | |||||||||||
50% in the month of sale | 7450 | |||||||||||
20% in the second month of sales | 2980 | |||||||||||
10% in the third month of sales | 1490 | |||||||||||
20% in the fouth month of sales | 2980 | |||||||||||
October sales | 22000 | |||||||||||
50% in the month of sale | 11000 | |||||||||||
20% in the second month of sales | 4400 | |||||||||||
10% in the third month of sales | 2200 | |||||||||||
November sales | 32000 | |||||||||||
50% in the month of sale | 16000 | |||||||||||
20% in the second month of sales | 6400 | |||||||||||
December sales | 22600 | |||||||||||
50% in the month of sale | 11300 | |||||||||||
Total | 4378 | 8789 | 11868 | 16500 | 24530 | 22880 | 88945 | |||||
Question Square Ltd’s projected sales report is given for the Month fromJuly to December 2017. Consider...
Question 4 Agapanthus Berhad projected sales and purchases for the month of October to December 2018 as below: Sales (RM 17,000 22,000 18,000 14,000 2018 Purchases (RM 12,000 14,000 13,000 14,000 tember October November December Wages of RM1,500 are paid in the month that they are incurred. Overhead expenses of RM1,200 are due each month and these are paid one month in arrears. On 1 November 2018, the company plan to buy a second-hand van for RM8,000 Sales are all...
4 points 4. Sombo Company is preparing cash budget for the month of June. Projected sales for the months follow: Save An Sales on Account May 8,000 June 5,000 July 10,000 The company collects payment on 50 percent of sales on account in the month of sale, 45 percent in the month following the sale, and 5 percent of sales are uncollectible. What is the expected cash collection for the month of June? O A $4,750 OBS6,500 Oc. $2,500 OD...
Fielding Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Fielding Corporation has experienced the following collection pattern: 25% received in the month of the we November sales for last year were $85,000, while December sales were $115.000. Projected sales for the next three months are as follows: January sales.................$ 180,000 February sales....... ..$ 120,000 Marche s.................$ 105,000 Requirement Prepare a cash collections budget...
Monette Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Monette Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 22% received two months after the sale 3% of the credit sales are never received November sales for last year were $85,000, while December sales were $115,000. Projected sales for...
Samson Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Samson Corporation has experienced the following collection pattern: November sales for last year were $110,000, while December sales were $115,000. Projected sales for the next three months are as follows: 20% received in the month of the sale 40% received in the month after the sale 25% received two months after the sale 15%...
Monachino Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Monachino Corporation has experienced the following collection pattern: November sales for last year were $105,000, while December sales were $125,000. Projected sales for the next three months are as follows: 170,000 25% received in the month of the sale January.sales..... . . . . . . . . . $ February.sales...............$ 135,000 50% received...
Sharpe Corporation’s projected sales for the first eight months of 2019 are as follows: January $ 90,000 May $300,000 February 120,000 June 270,000 March 135,000 July 225,000 April 240,000 August 150,000 Of Sharpe’s sales, 10 percent is for cash, another 60 percent is collected in the month following the sale, and 30 percent is collected in the second month following sale. November and December sales for 2018 were $220,000 and $175,000, respectively. Sharpe purchases its raw materials two months...
Alderman Corporation has found that 80% of its sales in any given month are credit sales, while the remainderare cash sales of the credit sales, Alderman Corporation has experienced the following collection pattern November sales for last year were $100,000, while December sales were $120,000. Projected sales for the next three months are as follows S January sales February sales March sales 150.000 125.000 165,000 $ 25% received in the month of the sale 50% received in the month after...
E9-28A (similar to) Question Help November sales for last year were $100,000, while December sales were $110,000. Projected sales for the next three months are as follows: Moraching Corporabon has found at of sales in any given month are credit sales, while the remainder are cash sales of the credit sales, Monachino Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 15% received two months after...
(Cash budget) The Sharpe Corporation's projected sales for the first 8 months of 2016 are shown in the following table: January $170,000 May $280,000 February $100,000 June $250,000 March $115,000 July $205,000 April $220,000 August $130,000 Of Sharpe's sales, 30 percent is for cash, another 40 percent is collected in the month following the sales, and 30 percent is collected in the second month following sales. November and December sales for 2015 were $200,000 and $155,000, respectively. Sharpe...