Question

3. CDE Ltd has provided the following budgeted Income Statement extract for the July-September quarter in...

3. CDE Ltd has provided the following budgeted Income Statement extract for the July-September quarter in 2020.

July             August       September
$,000               $’000               $’000

Sales (all on credit) 85                    88                    91
Purchases (43)                  (45)                 (47)
Depreciation expense (5)                    (5)                   (5)
Electricity expense (6)                    (6)                   (6)
Other expenses (25)                  (25)                 (25)

You are also given the following additional information:

  • All sales are collected in cash the month after sale.
  • All purchases are made on credit and paid for in cash the month after purchase.
  • Electricity is paid at the end of each quarter (i.e. on 30 September)
  • Other expenses are paid in cash in the same month they are incurred.
  • The business plans to buy a delivery van in August for $40,000 cash.
  • The cash balance is $17,000 on 31 July 2020.

(10 marks total)

  1. Prepare a cash budget for CDE Ltd for the month of August and September.
  2. Assess the cash position of CDE Ltd. Should CDE Ltd proceed with the purchase of delivery van as planned?
  3. Give your reasons and suggest alternatives if applicable.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Bluebird Ltd has provided the following forecasted items for the months of July through to September...
Bluebird Ltd has provided the following forecasted items for the months of July through to September 2020. July August September $ $ $ Sales 13,000 14,000 15,000 Purchases 9,400 8,000 10,000 Operating expenses 3,600 6,400 5,000 Other Information: • 35% of Sales are cash sales, the remaining 65% of credit sales which are collected as follows: o 30% in the month of the sale o 40% in the month after the sale o 28% in the 2nd month after the...
Hector Company reports the following:      July August September Sales $ 15,000 $ 23,000 $ 27,000...
Hector Company reports the following:      July August September Sales $ 15,000 $ 23,000 $ 27,000 Purchases 9,000 13,800 15,000 Payments for purchases are made in the month after purchase. Selling expenses are 16% of sales, administrative expenses are 11% of sales, and both are paid in the month of sale. Rent expense of $2,100 is paid monthly. Depreciation expense is $1,400 per month. Prepare a schedule of budgeted cash payments for August and September. HECTOR COMPANY Budgeted Cash Payments...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August,...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. 3. Each month’s ending inventory must equal 25%...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were 190,000 and in June 180,000. 60% of sales are cash, 30% of sales are to be collected the next month, and the remaining 10% in 2 months. Budgeted purchases of the required materials for production are: July​​100,000 August​​105,000 September​95,000 Purchases in June were 90,000. 70% of purchases are cash and 30% should be paid the next month. Direct Labor is 35% of purchases Selling...
Winnie's Wearable Masks Budgeted Income Statement For the Quarter Ending September 30, 2020 Sales Variable Expenses:...
Winnie's Wearable Masks Budgeted Income Statement For the Quarter Ending September 30, 2020 Sales Variable Expenses:    Variable Manufacturing Expense Variable S&A Expense Contribution Margin Fixed Expenses:    Fixed Manufacturing Expense    Fixed S&A Expense Net Operating Income Interest Expense Net Income following balance sheet as of the end of the 2nd quarter on June 30, 2020: Each mask is referred to as a finished good unit. Although the company makes both adult and children’s sizes, each mask will be...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 140,000 Inventory 66,500 Plant and equipment, net of depreciation 227,000 Total assets $ 508,500 Liabilities and Stockholders’ Equity Accounts payable $ 88,000 Common stock 311,000 Retained earnings 109,500 Total liabilities and stockholders’ equity $ 508,500 Exercise 8-12...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 62,500 $ 78,500 $ 49,500 Budgeted cash payments for Direct materials 16,460 13,740 14,060 Direct labor 4,340 3,660 3,740 Factory overhead 20,500 17,100 17,500 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 83,000 Accounts receivable 126,000 Inventory 69,750 Plant and equipment, net of depreciation 220,000 Total assets $ 498,750 Liabilities and Stockholders’ Equity Accounts payable $ 81,000 Common stock 348,000 Retained earnings 69,750 Total liabilities and stockholders’ equity $ 498,750 Exercise 8-12...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 85,000 Accounts receivable 141,000 Inventory 83,250 Plant and equipment, net of depreciation 226,000 Total assets $ 535,250 Liabilities and Stockholders’ Equity Accounts payable $ 87,000 Common stock 350,000 Retained earnings 98,250 Total liabilities and stockholders’ equity $ 535,250 Exercise 8-12...
An Enterprises has the following business transaction estimates relating to the final quarter of 2020.     ...
An Enterprises has the following business transaction estimates relating to the final quarter of 2020.      $                      $                       $                                                             October            November           December    Credit Sales                                              105600                112000                138000                         Cash Sales                                                21200                 26420            31200                          Receipts from Accounts Receivable `1.   calculate           calculate           calculate          Wages                                                        28200                 28200                   28200           Office Furniture                                           6000                  7800                           0 Prepayments                                                             0                          0                     5275 Administrative Expense                             10000                 10000                   11900 Depreciation on Office...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT