Question

In: Accounting

Koshy Company is planning a cash budget for the next three months. Estimated sales revenue is:...

Koshy Company is planning a cash budget for the next three months. Estimated sales revenue is:

Month

Revenue

Month

Revenue

January

$175,000

March

$125,000

February

150,000

April

100,000

Month Sales Revenue Month Sales Revenue

All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 80 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $26,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $35,000.

Prepare monthly cash budgets for February, March, and April.

Solutions

Expert Solution

Answer

It is mentioned that 60% sales is collected in the month of sale and 40% is collected in the next month, So

In the month of February, 60% of February sales are collected and 40% of Jan sales is collected.

In the month of March, 60% of March sales are collected and 40% of February sales is collected.

In the month of April, 60% of April sales are collected and 40% of March sales is collected.

Cost of Goods Sold, COGS is 80% of sales and payment of current month is made next Month.

Jan COGS is deducted from Feb.

Feb. COGS is deducted from March.

March COGS is deducted from April.

Cash Budget

February

March

April

Cash Balance, Beginning

    35,000

     29,000

       18,000

Cash Receipts:

Jan

    70,000

            -  

               -  

Feb

    90,000

     60,000

               -  

March

            -  

     75,000

       50,000

April

            -  

            -  

       60,000

Total Cash Receipts

160,000

   135,000

     110,000

Total Cash Available

195,000

   164,000

     128,000

Disbursements

Cost of Goods Sold (80% of last month sales)

140,000

   120,000

     100,000

Operating Expenses

    26,000

     26,000

       26,000

Total Disbursements

166,000

   146,000

     126,000

Cash Balance, Ending

    29,000

     18,000

         2,000


Related Solutions

Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 185,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 80 percent of sales. Payments for merchandise sold are made in the month following the month of...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 190,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 190,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 245,000 April 155,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of...
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are:...
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are: September $ 350,000 October $ 500,000 November $ 400,000 Sales for August were $400,000 and December is estimated as $420,000. All sales are on account. Galaxy Lighting Company estimates that 80% of the accounts receivable are collected in the month of sale with the remaining 20% collected the following month. The units sell for $40 each. Generally, 60% of purchases are due and payable...
The probability that house sales will increase in the next 6 months is estimated to be...
The probability that house sales will increase in the next 6 months is estimated to be 0.25. The probability that the interest rates on housing loans will go up in the same period is estimated to be 0.74. The probability that house sales or interest rates will go up during the next 6 months is estimated to be 0.89. 1) The probability that house sales will increase but interest rates will not is 2) The events increase in house sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $269,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $251,000 September $52,000 $269,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 9% are collected in the third month following sale, and the remaining...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters as follows: (40 ptos) Q1 Q2 Q3 Q4 Sales $105 $90 $122 $140 Sales for the first quarter of the year after this one are projected at $120 million. Accounts receivable at the beginning of the year were $34 million. Wiggles, has a 45-day collection period. Wiggle’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales,...
Now that a business has prepared it budget for the next three months, and the budget...
Now that a business has prepared it budget for the next three months, and the budget indicated that there will be cash shortage (negative cash balance at the end of the month, mainly due to the large total cash payments in the month than the total cash receipts) in the second month.What actions should the managers take when he is presented with this information? What actions should the managers make if in the third month, there will be a cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT