Question

In: Accounting

Bravo Pty Ltd (Bravo) sells educational stationery for students. Estimated sales for the second half of...

Bravo Pty Ltd (Bravo) sells educational stationery for students. Estimated sales for the second half of the coming year are: Month Sales in units July 10,000 August 11,400 Sept 12,000 Oct 15,600 Nov 18,000 Dec 22,000 Each unit sells for $35 and the actual revenue for May and June were $355,000 and $325,000, respectively. 30% of any month’s sales are for cash with the remaining sales on credit. 20% of the credit sales are collected in the month of sale, 70% are collected in the following month and 8% are collected in the second month after the sale. The remaining credit sales are never collected and are considered bad. Purchase and inventory information Bravo likes to have 25% of the forecasted demand for the next month in closing stock and it pays for 75% of their stock in the month of purchase and the remainder in the following month. The units cost $22 each. Other information Non-manufacturing costs which are generally paid in the month incurred consist of: Salaries $7,000/month Commissions 5% of sales revenue Rent $14,000/month Depreciation $2,500/month There is a scheduled dividend payment of $100,000 and $60,000 in July and Sept respectively. Bravo also needs to make a payment of $80,000 in August for equipment previously purchased on credit in May. Bravo maintains a minimum cash balance of $15,000 with a line of credit available to fund any shortfalls. For simplicity, assume that the bank will only lend and accept repayments in $1,000 increments (e.g., if $123,456 is needed, the bank will only lend and accept repayment of $124,000) and that months, rather than days are used for interest calculations. Interest is charged at 10% on all outstanding borrowings and this is charged and paid in the following month based on the prior month’s closing balance. The tax rate is 30% and there are tax payments due in July of $8,000 and $19,000 in Sept. 30 June Balances Closing stock 2,500 units at a cost of $22.50/unit Cash at bank $26,000 Accounts Payable $280,000 Line of credit balance $50,000 Page 2 of 2 Required: Marks Prepare a cash budget for the months of July and August.

Solutions

Expert Solution

WORKINGS

Assumption: $80,000 in August for equipment previously purchased on credit in May - this 80,000 is assumed to be included in Accounts Payable of $280,000. So 80,000 is for equipment payment and rest 200,000 is assumed to be for purchases of inventory


Related Solutions

Junkyard dog Pty Ltd sells toys for pre-primary children for students. Estimated sales for the second...
Junkyard dog Pty Ltd sells toys for pre-primary children for students. Estimated sales for the second half of the coming year are: Month Sales in units July 10,000 August 11,400 Sept 12,000 Oct 15,600 Nov 18,000 Dec 22,000 Each unit sells for $35 and the actual revenue for May and June were $355,000 and $325,000, respectively. 30% of any month’s sales are for cash with the remaining sales on credit. 20% of the credit sales are collected in the month...
The heights of 500 female students, half of whom are college students while the other half are second-grade students.
The heights of 500 female students, half of whom are college students while the other half are second-grade students.Describing Distributions. For each distribution described in Exercises, answer the following questions:a. How many modes would you expect for the distribution?b. Would you expect the distribution to be symmetric, left skewed, or right-skewed?
BAF Ltd produces and sells to wholesalers various kinds of office stationery. The company is planning...
BAF Ltd produces and sells to wholesalers various kinds of office stationery. The company is planning to introduce one new product for this coming summer. The new product is a newly designed stapler. The product will be sold to wholesalers in batches of 20 for $9 each. The capacity is available so no additional fixed costs in this will be incurred to produce the new product. Instead, a $190,000 fixed fee will be assigned to allocate a fair share of...
BAF Ltd produces and sells to wholesalers various kinds of office stationery. The company is planning...
BAF Ltd produces and sells to wholesalers various kinds of office stationery. The company is planning to introduce one new product for this coming summer. The new product is a newly designed stapler. The product will be sold to wholesalers in batches of 20 for $9 each. The capacity is available so no additional fixed costs in this will be incurred to produce the new product. Instead, a $190,000 fixed fee will be assigned to allocate a fair share of...
BAF Ltd produces and sells to wholesalers various kinds of office stationery. The company is planning...
BAF Ltd produces and sells to wholesalers various kinds of office stationery. The company is planning to introduce one new product for this coming summer. The new product is a newly designed stapler. The product will be sold to wholesalers in batches of 20 for $9 each. The capacity is available so no additional fixed costs in this will be incurred to produce the new product. Instead, a $190,000 fixed fee will be assigned to allocate a fair share of...
Vitalife Pty Ltd is considering buying a new vitamin C extraction machine. The machine is estimated...
Vitalife Pty Ltd is considering buying a new vitamin C extraction machine. The machine is estimated to cost $140,000 which can last for 7 years before it becomes too costly to maintain and can be sold for scrap at $20,000. The project is estimated to bring in additional $27,000 cash inflow and incur $12,000 in additional expenses related to the running the machine in the first year. The company expects there will be an annual sales growth of 6% from...
Question 5 [45] Gentronics (Pty) Ltd manufactures and sells a rechargeable battery-operated lamp. The company sells...
Question 5 [45] Gentronics (Pty) Ltd manufactures and sells a rechargeable battery-operated lamp. The company sells the lamps both for cash and on credit. Company management is contemplating relaxing its existing credit standards in order to boost sales and profits. The company provided you with the following information relating to this lamp:  The current selling price is R150.00 per unit.  Total sales for 2018 were 80 000 units. The variable cost per unit is R80.00.  The total...
Below is the abbreviated cash budget for DEF Pty Ltd. Beginning Cash Balance Estimated Cash Receipts...
Below is the abbreviated cash budget for DEF Pty Ltd. Beginning Cash Balance Estimated Cash Receipts 34,000 Cash Available 39,000 Estimated Cash Payments Purchases Operating Expenses 13,000 Payment of Dividend 10,000 Total Estimated Cash Payments Ending Cash Balance -4,000 (a) Calculate the amount of Beginning Cash Balance, Purchases, and Total Estimated Cash Payments. (b) What action if any should DEF Pty Ltd take as a result of preparing this budget? Briefly justify your answer.
Below is the abbreviated cash budget for ABC Pty Ltd. Beginning Cash Balance 50,000 Estimated Cash...
Below is the abbreviated cash budget for ABC Pty Ltd. Beginning Cash Balance 50,000 Estimated Cash Receipts Cash Available 390,000 Estimated Cash Payments Purchases 210,000 Operating Expenses Office Equipment Purchases 50,000 Total Estimated Cash Payments Ending Cash Balance 40,000 (a) Calculate the amount of Estimated Cash Receipts, Operating Expenses, and Total Estimated Cash Payments. (b) What action if any should ABC Pty Ltd take as a result of preparing this budget? Briefly justify your answer.
Below is the abbreviated cash budget for DEF Pty Ltd. Beginning Cash Balance Estimated Cash Receipts...
Below is the abbreviated cash budget for DEF Pty Ltd. Beginning Cash Balance Estimated Cash Receipts 34,000 Cash Available 39,000 Estimated Cash Payments Purchases Operating Expenses 13,000 Payment of Dividend 10,000 Total Estimated Cash Payments Ending Cash Balance -4,000 (a) Calculate the amount of Beginning Cash Balance, Purchases, and Total Estimated Cash Payments. (b) What action if any should DEF Pty Ltd take as a result of preparing this budget? Briefly justify your answer.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT