Homework Help Question & Answers

part b prepare the cash budget Bee Gee Company prepares monthly cash budgets. Below is a...

part b prepare the cash budget
Bee Gee Company prepares monthly cash budgets. Below is a set of relevant data extracted from existing reports, and the subsi
Bee Gee Company prepares monthly cash budgets. Below is a set of relevant data extracted from existing reports, and the subsidiary budgets for the two months of September and October 2020. Sales Purchases Wages Manufacturing overhead Administration expenses Sale of equipment Cash paid for new IT equipment September RM 3,140,000 1,620,000 514,000 216,000 390,000 October RM 4,120,000 2,160,000 552,000 234,000 390,000 82,000 165,000 All sales are on credit. Collections from debtors normally have the following pattern: 60 per cent in the month of sale, 30 per cent one month later, and 10 per cent two months later. Fortunately, Bee Gee does not have much trouble with bad debts. Sales in June, July and August were RM2,950,000, RM2,660,000 and RM3,020,000 respectively. Purchases are paid for in the next month. Purchases in August were RM1,820,000. Manufacturing overhead includes RM125,000 for depreciation expense, while the administration expenses include an amount of RM56,000 for depreciation expenses. Both manufacturing overhead and administration expenses are paid in the same month. Bee Gee expects to be able to repay the principal on a RM500,000 loan in October. Required: (a) Prepare a schedule of receipts from debtors for the two months ending 31 October 2020. (8 marks) (b) Prepare a cash budget for two months ending 31 October 2020. The cash balance at 31 August 2020 is expected to be RM126,000. (23 marks)
0 0
Add a comment
Answer #1

Cash Budget For 2 month

Particular September RM October RM

Opening Balance (A)

126,000 (104,000)
ADD:Receipts (B)
Debtor 60% (Current Month) 188,4000 247,2000
Collection from debtor 30% and 10%(Previouse Month) 906,000+266000 11,72000 942000+302000 124,4000
Sale Of Equipment ------ 82,000
Total ( A+B) 318,2000 369,4000

Less:Payments

Material purchased 182,0000 162,0000
Wages 514,000 552,000
Manufacturing overhead & depreciation 216000+125000 341,000 234,000
Administrative overhead & Depreciation 390,000+56,000 446,000 390,000
Cash Paid for new It Equipment 165,000 ---------
Loan Repayment ------------ 500,000

ToTal ( C)

32,86,000 32,96,000

Closing Balance (A+B-C)

(104,000) 398,000
Add a comment
Know the answer?
Add Answer to:
part b prepare the cash budget Bee Gee Company prepares monthly cash budgets. Below is a...
Your Answer:

Post as a guest

Your Name:
What's your source?

Earn Coin

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Accounting Help. Pls Multiple Part Question. Current Attempt in Progress Sunland Company prepares monthly cash budgets....

    Accounting Help. Pls Multiple Part Question. Current Attempt in Progress Sunland Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $432,000 Direct materials purchases 135,000 $388,800 129,600 97,200 75,600 Direct labor Manufacturing overhead 108,000 81,000 91,800 Selling and administrative expenses 85,320 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month...

  • Question 4 Crane Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are...

    Question 4 Crane Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses January $446,400 148,800 111,600 86,800 97,960 February $496,000 155,000 124,000 93,000 105,400 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...

  • Ivanhoe Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....

    Ivanhoe Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $414,000 $460,000 Direct materials purchases 138,000 143,750 Direct labor 103,500 115,000 Manufacturing overhead 80,500 86,250 Selling and administrative expenses 90,850 97,750 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...

  • Nigh Corporation prepares monthly cash budgets. Relevant data from operating budgets for 2017 Prepare cash bodget...

    Nigh Corporation prepares monthly cash budgets. Relevant data from operating budgets for 2017 Prepare cash bodget (LO 4) AP P21-3A follow: February January $400,000 $350,000 120,000 80,000 70,000 79,000 130,000 100,000 Sales Direct materials purchases Direct labour Manufacturing overhead Selling and administrative expenses 75,000 81,000 Budgetary Planning All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month followie the sale, and 20% in the second month following the sale....

  • Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of...

    Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of 40,000 units Company policy is to end each month with merchandise inventory equal to 20% of budgeted sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. The company budgets sales of 200,000 units in October Sales (Units) 200.000 Sle, 280,000 Purchases Units) 222,000 304, 264,000 August September Prepare the merchandise purchases budgets for the months of July,...

  • Question 3 Sun and Company prepares monthly cash budgets. Relevant data from operating budgets for 2020...

    Question 3 Sun and Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $420,400 $476,000 Direct materials purchases 142.800 148,750 Direct labor 107,100 119,000 Manufacturing overhead 83,300 89,250 Selling and administrative expenses 94,010 101,150 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of...

  • TUDIM TRU IUCU1UILLIUDIJIVI Blossom Company prepares monthly cash budgets. Relevant data from operating budgets for 202...

    TUDIM TRU IUCU1UILLIUDIJIVI Blossom Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February $442,800 $492,000 147,600 153,750 Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses 110,700 86,100 123,000 92,250 97,170 104,550 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of...

  • Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows...

    Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows January February Sales $363,600 $404,000 Direct materials purchases 121,200 126.250 Direct labor 90,900 101.000 Manufacturing overhead 70,700 75,750 Selling and administrative expenses 79.790 85,850 All sales are on account, Collections are expected to be 50% in the month of sale, 30 % in the first month following the sale, and 20% in the second month following the sale, Sixty percent (60%) of direct materials...

  • Question 4 Crane Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are...

    Question 4 Crane Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses January $446,400 148,800 111,600 86,800 97,960 February $496,000 155,000 124,000 93,000 105,400 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...

  • Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows...

    Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows February January $435,600 $484,000 Sales 151,250 Direct materials purchases 145,200 121,000 Direct labor 108,900 84,700 90,750 Manufacturing overhead 95,590 Selling and administrative expenses 102,850 All sales are on account. Collections are expected to be 50 % in the month of sale, 30 % in the first month following the sale, and 20 % in the second month following the sale. Sixty percent (60 %)...

Free Homework 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.