Knowee
Questions
Features
Study Tools

Innovation Company has furnished the following information:  Forecast sales for 1st month$ 232916Forecast sales for 2nd month$ 459640  Cash sales = 30% of total salesCollection schedule of the sales on credit  In month sold40 %In the next month60 %  What are Innovation Company’s forecast total cash collections for the second month?

Question

Innovation Company has furnished the following information:  Forecast sales for 1st month232916Forecastsalesfor2ndmonth 232916Forecast sales for 2nd month 459640  Cash sales = 30% of total salesCollection schedule of the sales on credit  In month sold40 %In the next month60 %  What are Innovation Company’s forecast total cash collections for the second month?

🧐 Not the exact question you are looking for?Go ask a question

Solution 1

To calculate the total cash collections for the second month, we need to consider both the cash sales of the second month and the collections from the credit sales of the first and second months.

Step 1: Calculate the cash sales for the second month Cash sales = Total sales * Cash sales percentage Cash sales = 459,64030459,640 * 30% = 137,892

Step 2: Calculate the collections from credit sales of the first month Credit sales of the first month = Total sales of the first month - Cash sales of the first month Credit sales of the first month = 232,916(232,916 - (232,916 * 30%) = 163,041.2Collectionsfromcreditsalesofthefirstmonth=CreditsalesofthefirstmonthCollectionpercentageinthenextmonthCollectionsfromcreditsalesofthefirstmonth=163,041.2 Collections from credit sales of the first month = Credit sales of the first month * Collection percentage in the next month Collections from credit sales of the first month = 163,041.2 * 60% = $97,824.72

Step 3: Calculate the collections from credit sales of the second month Credit sales of the second month = Total sales of the second month - Cash sales of the second month Credit sales of the second month = 459,640459,640 - 137,892 = 321,748Collectionsfromcreditsalesofthesecondmonth=CreditsalesofthesecondmonthCollectionpercentageinthemonthsoldCollectionsfromcreditsalesofthesecondmonth=321,748 Collections from credit sales of the second month = Credit sales of the second month * Collection percentage in the month sold Collections from credit sales of the second month = 321,748 * 40% = $128,699.2

Step 4: Add up all the cash collections Total cash collections for the second month = Cash sales of the second month + Collections from credit sales of the first month + Collections from credit sales of the second month Total cash collections for the second month = 137,892+137,892 + 97,824.72 + 128,699.2=128,699.2 = 364,415.92

So, Innovation Company’s forecast total cash collections for the second month is $364,415.92.

This problem has been solved

Solution 2

To calculate the total cash collections for the second month, we need to consider both the cash sales of the second month and the collections from the credit sales of the first and second months.

Step 1: Calculate the cash sales for the second month Cash sales = Total sales * Cash sales percentage Cash sales = 459,64030459,640 * 30% = 137,892

Step 2: Calculate the collections from credit sales of the first month Credit sales of the first month = Total sales of the first month - Cash sales of the first month Credit sales of the first month = 232,916(232,916 - (232,916 * 30%) = 163,041.2Collectionsfromcreditsalesofthefirstmonth=CreditsalesofthefirstmonthCollectionpercentageinthenextmonthCollectionsfromcreditsalesofthefirstmonth=163,041.2 Collections from credit sales of the first month = Credit sales of the first month * Collection percentage in the next month Collections from credit sales of the first month = 163,041.2 * 60% = $97,824.72

Step 3: Calculate the collections from credit sales of the second month Credit sales of the second month = Total sales of the second month - Cash sales of the second month Credit sales of the second month = 459,640459,640 - 137,892 = 321,748Collectionsfromcreditsalesofthesecondmonth=CreditsalesofthesecondmonthCollectionpercentageinthemonthsoldCollectionsfromcreditsalesofthesecondmonth=321,748 Collections from credit sales of the second month = Credit sales of the second month * Collection percentage in the month sold Collections from credit sales of the second month = 321,748 * 40% = $128,699.2

Step 4: Add up all the cash collections Total cash collections for the second month = Cash sales of the second month + Collections from credit sales of the first month + Collections from credit sales of the second month Total cash collections for the second month = 137,892+137,892 + 97,824.72 + 128,699.2=128,699.2 = 364,415.92

So, Innovation Company’s forecast total cash collections for the second month is $364,415.92.

This problem has been solved

Similar Questions

Bowden Company has furnished the following information:  Forecast sales for 1st month$ 339267Forecast sales for 2nd month$ 427051  Cash sales = 20% of total salesCollection schedule of the sales on credit  In month sold60 %In the next month40 %  What are Bowden Company’s forecast total cash collections for the second month?

company has projected the following sales for the spring quarter of 2014:April $200,000May $250,000June $275,00065% of all sales are paid for with cash. The remainder is on credit.  The pattern for credit receivables collections are:  Month of Sale 60%Month After Sale 30%Second Month After Sale 10%What are the forecasted cash collections for the month of June? $248,750 $275,000 $178,750 $269,750

A company plans to purchase inventory for the second half of 2014 as follows:July $100,000August $75,000September $225,000October $125,000November $250,000December $30,000They usually pay 50% of inventory purchases in the month of purchase, 35% in the following month, and 15% in the second month.Based on this information, what are the forecasted total 2014 cash payments for inventory purchased in the second half of 2014? $705,000 $752,500 $790,000 $805,000

Our sourdough bakery had sales of $598 in December. Projected sales for the next quarter are: January $1,173 February $1,387 March $1,652 Sales are 59% cash and the remainder on credit. Debtors pay in the month following the sale. Calculate total cash collected from sales for the month of February. Please enter your answer to 2 decimal places.

Exercise 13-39 (Algo) Estimate Cash Collections (LO 13-4)Hackett Produce Supply is preparing its cash budget for April. The following information is available:Estimated credit sales for April $ 268,000Actual credit sales for March $ 159,000Estimated collections in April for credit sales prior to March $ 15,000Estimated write-offs in April for uncollectible credit sales $ 11,420Estimated provision for bad debts in April for credit sales in April $ 10,430Estimated collections in April for credit sales in April 25%Estimated collections in April for credit sales in March 70%Required:What is the estimated amount of cash receipts from accounts receivable collections in April?

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.