Question

In: Accounting

It is January 1 of Year 2, Purchases for Yosef Company for Hanuary, February, and March...

It is January 1 of Year 2, Purchases for Yosef Company for Hanuary, February, and March of Year 2 are forecasted to be as follows: January, 200,000

February, 400,000

March, 500,000

20% of purchases are for cash. Of the credit purchases, 30% are paid during the month of the purchases, 50% in the month following the purchase, and 20% in the second month following the purchase. Total purchases for November and December of Year 1 were 200,000 and 400,000 respectively. What is the forecasted amount of the total cash payments for purchases in january of year 27(Note this is the sum of immediate payments from cash purchases, same-month cash payments of credit purchases and cash payments for credit purchases made in prior months).

Solutions

Expert Solution

PURCHASES BUDGET
Particulars November December January February March
A Purchase For the Month                      2,00,000                    4,00,000                   2,00,000                   4,00,000                   5,00,000
1) 20% Purchase for Cash                          40,000                        80,000                      40,000                      80,000                   1,00,000
B Credit Purchase                      1,60,000                    3,20,000                   1,60,000                   3,20,000                   4,00,000
2) 30% of Credit Puchase paid in Month of payment                          48,000                        96,000                      48,000                      96,000                   1,20,000
3) 50% of Credit Purchase paid in following month of payment -                        80,000                   1,60,000                      80,000                   1,60,000
4) 20 % of Credit Purchase paid in second month following the purchase - -                      32,000                      64,000                      32,000
C Total Cash Forcasted Payment                          88,000                    2,56,000                   2,80,000                   3,20,000                   4,12,000

Related Solutions

It is January 1 of Year 2. Sales for Harry Company for January, February, and March...
It is January 1 of Year 2. Sales for Harry Company for January, February, and March are forecasted to be as follows: January, $200,000; February $400,000; March, $500,000. 80% of sales are credit sales; the remaining 20% of sales are cash sales. Of these credit sales, 10% are collected during the month of sale, 30% in the following month, and 60% in the second following month. TOTAL sales for November and December of Year 1 were $200,000 and $400,000, respectively....
As the year progresses towards February and March, the incidence of that common cold from January...
As the year progresses towards February and March, the incidence of that common cold from January has increased to 0.45 (45%). Consider the class size n=25. a) If the random variable X represents the number of people sick with the common cold, what distribution it follows? b) What is the possibility of 20 people being sick? c) What is the possibility of at least 10 people being sick? d) What is the possibility of at most 5 people being sick?
Bill Johnson's Company Sales for January, February, and March are expected to be $200,000, $210,000, and...
Bill Johnson's Company Sales for January, February, and March are expected to be $200,000, $210,000, and $190,000, respectively. All sales are on account and are collected 50% in the month of the sale and 45% in the following month. The remaining 5% is determined to be uncollectible. Raw materials are purchased one month before being needed, and all purchases and expenses are paid for as incurred. The cash balance at February 1 is $8,750. Activities for January, February, and March...
SALES PER MONTH DURING THE LAST YEAR 20X1 JANUARY $ 550,000 FEBRUARY $ 825,000 MARCH $...
SALES PER MONTH DURING THE LAST YEAR 20X1 JANUARY $ 550,000 FEBRUARY $ 825,000 MARCH $ 575,000 APRIL $ 870,000 MAY $ 1,080,000 JUNE $ 1,065,000 JULY $ 1,070,000 AUGUST $ 1,060,000 SEPTEMBER $ 1,180,000 OCTOBER $ 1,140,000 NOVEMBER $ 1,290,000 DECEMBER $ 1,460,000 I. Sales Projection: 20X2 After consulting the Company's Management Committee, it was agreed that business plans and strategies were deemed appropriate, a 35% increase in sales reported during the months of last year 20x1. All sales...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The company’s past experience indicates that 60% of the accounts receivable are collected in the month of sale, 40% in the month following the sale. The anticipated cash inflow for the month of March is $247800. $365800. $413000. $401200.
Bramble Company purchases equipment on January 1, Year 1, at a cost of $552,000. The asset...
Bramble Company purchases equipment on January 1, Year 1, at a cost of $552,000. The asset is expected to have a service life of 12 years and a salvage value of $49,680. Compute the amount of depreciation for each of Years 1 through 3 using the straight-line depreciation method. Compute the amount of depreciation for each of Years 1 through 3 using the sum-of-the-years'-digits method. Compute the amount of depreciation for each of Years 1 through 3 using the double-declining-balance...
tamarisk Company purchases equipment on January 1, Year 1, at a cost of $564,000. The asset...
tamarisk Company purchases equipment on January 1, Year 1, at a cost of $564,000. The asset is expected to have a service life of 12 years and a salvage value of $50,760. Compute the amount of depreciation for each of Years 1 through 3 using the straight-line depreciation method. (Round answers to 0 decimal places, e.g. 5,125.) Depreciation for Year 1 $enter a dollar amount rounded to 0 decimal places Depreciation for Year 2 $enter a dollar amount rounded to...
Lansbury Company purchases equipment on January 1, Year 1, at a cost of $518,000. The asset...
Lansbury Company purchases equipment on January 1, Year 1, at a cost of $518,000. The asset is expected to have a service life of 12 years and a residual value of $50,000. (a) Compute the amount of depreciation for each of Years 1 through 3 using the straight-line depreciation method. (b) Compute the amount of depreciation for each of Years 1 through 3 using the sum-of-the- years’-digits method. (c) Compute the amount of depreciation for each of Years 1 through...
11 Coronado Company purchases equipment on January 1, Year 1, at a cost of $540,000. The...
11 Coronado Company purchases equipment on January 1, Year 1, at a cost of $540,000. The asset is expected to have a service life of 12 years and a salvage value of $48,600. Compute the amount of depreciation for each of Years 1 through 3 using the straight-line depreciation method. (Round answers to 0 decimal places, e.g. 5,125.) Depreciation for Year 1 $enter a dollar amount rounded to 0 decimal places Depreciation for Year 2 $enter a dollar amount rounded...
Example #2, On January 1, 2019 a company purchases an automobile for $100,000 by signing a...
Example #2, On January 1, 2019 a company purchases an automobile for $100,000 by signing a note for the $100,000, with 4% interest rate. The note is to be paid in three equal payments of $36,034.85 at the end of each year beginning December 31, 2019. Below is the loan reduction schedule (please be sure you understand it)!!!!!! Date Beg. Balance interest expense Cash Payment Reduction in Principal Principal Balance 2019 100,000 100,000.00*.04=4,000.00 36,034.85 36,034.85-4,000.00=32,034.85 100,000.00-32,034.85=67,965.15 2020 67,965.15 67,965.15*.04=2,718.60 36,034.85...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT