ZuoTi.Pro
Question

Prepare a cash budget

Shakespear Book Ltd has been formed to open a book shop.

1.      Sales for 2020 are expected to be as follows: January $40,000, February $50,000, March $70,000.

2.      90% of sales are for cash, the remainder of sales are on credit terms and collected 1 month later.

3.      Inventory purchases are estimated to be 40% of sales each month purchased as sales are made. Suppliers are paid one month in arrears.

4.      2 staff members will be employed at a cost of $5,000 a month which is paid in the month incurred. Overheads are forecast to be $3,000 per month and paid one month in arrears.

5.      Rent is $36,000 per year payable annually in advance.

6.      The Shop require minimum cash balance of $20,000. Assuming the beginning cash balance of February is $22,000.

Prepare a cash budget for February, 2020.


college   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Prepare a cash budget
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget...

    Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: Collection of accounts receivable Dividends Total cash receipts January February March Sales $88,000 $110,000 $150,000 Manufacturing costs 37,000 47,000 54,000 Selling and administrative expenses 26,000 30,000 33,000 Capital expenditures - 36,000 Estimated cash payments for: Manufacturing costs Selling and administrative expenses Capital expenditures Other purposes: The company expects to sell about...

  • Use the information provided below to prepare the Cash Budget of Project M for June, July...

    Use the information provided below to prepare the Cash Budget of Project M for June, July and August 2020. (Note: Use separate monetary columns for each month. A total column is not required.)      INFORMATION      The management accountant of Remax Limited prepared the following forecasted sales schedule of Project M for the five months ended 31 August 2020:    April R100 000 May R130 000 June R150 000 July R160 000 August R210 000      Additional information 1. Cash...

  • A. ABC Industries is in the Business of manufacturing agro equipment. Prepare the cash budget for...

    A. ABC Industries is in the Business of manufacturing agro equipment. Prepare the cash budget for the quarter April to June, based upon the following data and additional information. Month Sales Purchases Wages Selling Overheads Office Overheads Mfg. Overheads $ $ $ $ $ $ January 60,000 36,000 9,000 4,000 2,000 4,000 February 62,000 38,000 8,000 5,000 1,500 3,000 March 64,000 33,000 10,000 4,500 2,500 4,500 April 58,000 35,000 8,500 3,500 2,000 3,500 May 56,000 39,000 9,000 4,500 1,000 4,000...

  • Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures:...

    Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures: Actual Forecast November December January February March April $200,000 $220,000 $280,000 $320,000 $340,000 $330,000 Thirty percent of each month's sales are in cash, 50% are paid the month after sale and 20% are paid two months after sale. Materials cost 30% of sales and are purchased one month prior to sale and paid for 30 days later. Labor expense is 40% of sales, selling...

  • Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget...

    Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: January February March Sales $100,000 $122,000 $166,000 Manufacturing costs 42,000 52,000 60,000 Selling and administrative expenses 29,000 33,000 37,000 Capital expenditures _ _ 40,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in full in the month...

  • Question 1 Ceylon Ltd produces and sells product X. The company is in the process of...

    Question 1 Ceylon Ltd produces and sells product X. The company is in the process of preparing its budgets for the first 6 months of 2020, and it expects sales units in January, February and March 2020 to be 12,000; 15,000 and 18,000 units respectively. Thereafter, it is expected that sales will increase at a rate of 20% per month until June 2020. The following information regarding Product X is provided in the table below. It is expected that selling...

  • Q 3. Prepare the cash budget of the company from January to June based on the...

    Q 3. Prepare the cash budget of the company from January to June based on the following (15) information.(Rs.in lakh) Production Overheads 6.000 Month January February March April May June Sales 72.000 97,000 86,000 88,600 102,500 108,700 Material Purchases 25,000 31,000 25,500 30.600 37,000 38,800 Salaries & wages 10,000 12.100 10.600 25.000 22.000 23.000 6,300 6,000 6,500 8,000 8,200 Office & Sedligads 5,500 6.700 7.500 8.900 11,000 11,500 The opening cash balance for the year may be taken as Rs.72,500...

  • Prepare the Cash Budget of Project R for June, July and August. The following are forecasted...

    Prepare the Cash Budget of Project R for June, July and August. The following are forecasted sales schedule of Project M for the five months ended 31 August : April R100 000 May R130 000 June R150 000 July R160 000 August R210 000 Cash sales usually comprise 70% of the total sales. The remaining sales are on credit and these are collected as follows: 30% in the month of the sale, with a 5% cash discount applicable; 70% in...

  • HTM 241 EX11-2 Name: Please prepare a cash budget for February based on the information below. January February $38...

    HTM 241 EX11-2 Name: Please prepare a cash budget for February based on the information below. January February $38,400 (14.208) $24,192 Sales revenue $39,300 (14.541) $24,759 Cost of sales Gross margin Wage expense Other operating expense Depreciation expense Total operating expense Operating income $13,056 5,760 768 $13,362 5,895 768 (19.584) $4.608 (20.025) S4.734 January ending cash balance was $4,448 86% of sales revenue is collected in the current month and the remainder in the next month 75% of cost of...

  • The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next thr...

    The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budgetinformation: March April May Sales $129,000 $156,000 $206,000 Manufacturing costs 54,000 67,000 74,000 Selling and administrative expenses 37,000 42,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the sale and the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT