Question

In: Accounting

Bands, a Division of Euro Ltd., manufactures small planter boxes. In March 2019 the manager decided...

Bands, a Division of Euro Ltd., manufactures small planter boxes. In March 2019 the manager decided the business needed to have the security of a two-month loan of $100,000 starting on 1 May 2019 as its cash balance had been diminished because of recent equipment purchases. The bank would charge interest at the equivalent of 6 per cent per annum on the loan and require the business to repay interest monthly commencing on 31 May 2019. The principal is paid at the end of the two-month term. To consider the loan application, the bank requested the provision of a number of budgets for May including the Cash Budget.

The following information is available:

* Budgeted sales are 90,000 units per month for April, June and July, and 100,000 units for May of 2019. The selling price is $20 per unit.

* Finished Goods inventory on April 1 for 24,000 units was $240,000. The company follows a policy requiring ending finished goods inventory each month to be 10% of next month’s sales. There is no WIP.

* The inventory of raw materials on April 1 was 11,400kg (@$20/kg). The ending inventory is required to be 20% of next month’s production requirements.

* Selling & administrative expenses are expected to be $75,000 plus 10% of sales (this includes depreciation of $12,500).

* The manufacturing costs budget (based on a practical capacity of 100,000 units per month) follows:

Materials (0.25 kg per box, $20 per kg) $500,000

Direct Labour (6 minutes per box @ $24 per hour)   240,000

Variable Overhead (allocated @$3 per DLH) 30,000

Fixed Overhead (allocated per unit)   100,000

Total $870,000

* Budgeted Fixed manufacturing overhead excludes $28,000 of depreciation.

REQUIRED:

a) Prepare the following budgets for April and May 2019:

(i) Production Budget                                  

(ii) Materials Purchases Budget in dollars

b) You have been provided with the following additional information:

All sales are made on credit and customers pay 50% in the month of sale; 45% in the month following. The remaining 5% is uncollectable.

Assume that materials are paid 50% in the month purchased and 50% in the following month. Labour and relevant overhead costs are paid in the month the liability is incurred. Selling and administration expenses are paid each month as incurred. The opening cash balance at 1 May (before the loan drawdown) was $500.

Assume the short-term loan has been secured, prepare the Cash Budget for the month of May, 2019.

c) The CEO of Euro Ltd., a decentralised company with 4 major divisions (all profit centres), is concerned that the preparation of static budgets by the CEO has resulted in the company’s budgets less effective and not helpful for decision making in a constantly changing operating environment.

What is the issue that the CEO is facing? How can this issue be addressed? Discuss the issue briefly and provide at least one recommendation to address the issue.

Solutions

Expert Solution


Related Solutions

Boxes Ltd manufactures two types of boxes, plastic and cardboard, and currently it applies manufacturing overhead...
Boxes Ltd manufactures two types of boxes, plastic and cardboard, and currently it applies manufacturing overhead to all units at the rate of $50 per direct labour hour. Production information is as follows:                   Product Information Plastic box Cardboard box Direct material cost per unit   $20 $10 Direct labour cost per hour $20 $10 Number of units produced 100,000 200,000 The management accountant Sally suggests that Activity-Based Costing (ABC) is more appropriate for the firm. She suggests the firm’s overhead...
Fox Co. successfully completed the sale of its Snack division in March 2021 that it decided...
Fox Co. successfully completed the sale of its Snack division in March 2021 that it decided to discontinue operations in November 2020. From January 2021 through the date of the sale, the Snack Division generated a $600,000 operating profit. The Snack division was sold at a pre-tax gain of $1,000,000. Fox Co. has pre-tax profit from all operations in 2021 of $50,000,000. What is Fox Co’s Income from Discontinued Operations reported on its income statement in 2021? Fox Co’s income...
On 1 March 2019, Heckle Ltd acquired 40% of the voting shares of Jeckle Ltd. Under...
On 1 March 2019, Heckle Ltd acquired 40% of the voting shares of Jeckle Ltd. Under the company’s constitution, each share is entitled to one vote. On the basis of past experience, only 65% of the eligible votes are typically cast at the annual general meetings of Jeckle Ltd. No other shareholder holds a major block of shares in Jeckle Ltd. The financial year of Jeckle Ltd ends on 30 June each year. The directors of Heckle Ltd argue that...
What is an example of a noble cause the plant manager of a division that manufactures...
What is an example of a noble cause the plant manager of a division that manufactures oilfield equipment might use to motivate workers?
Petula Corporation’s small motor division manufactures small electrical motors that are used in the manufacture of...
Petula Corporation’s small motor division manufactures small electrical motors that are used in the manufacture of electric appliances. The Appliance division manufactures appliances and uses one small electrical motor in each appliance. These motors are currently purchased from another company at a cost of $28. The appliance division requires 15,000 motors annually. The small motor division sells its motors to the outside market at a price of $32 each. The cost to manufacture one motor is as follows: Variable cost...
On 1 August 20X5, Graham Ltd. decided to discontinue the operations of its services division. The services division is not a separate corporation, but it
On 1 August 20X5, Graham Ltd. decided to discontinue the operations of its services division. The services division is not a separate corporation, but it is a major operating segment, financially and operationally. On 22 September 20X5, Graham closed a deal to sell the division to Frost Ltd. Frost will assume responsibility for the current liabilities (e.g., accounts payable and accrued liabilities) that pertain to the division. The facts pertaining to the sale are as follows: On 31 December 20X5,...
At the beginning of 2019, three entrepreneurs decided to form a small business and organize as...
At the beginning of 2019, three entrepreneurs decided to form a small business and organize as a corporation. Their business is called The Property People, and they will serve homeowners who require assistance with home maintenance and small home improvement projects. Until the business is established, the owners will not leave their full-time jobs. However, they all have flexibility to arrange their work schedules and cover for one another. Each investor received 100 shares of stock. In return for the...
Accounting policies At a meeting on 16 June 2019, the directors of Swan Ltd decided to...
Accounting policies At a meeting on 16 June 2019, the directors of Swan Ltd decided to change the company’s accounting policy in regard to research and development expenditure. In previous years, research and development expenditure had been capitalized and amortized over 3 years. In line with this policy, $75 000 was capitalized on 1 January 2018. The new policy is to write off all research and development to expense when incurred. During the year ended 30 June 2019, the company...
1. A division in ABC Co. had the following financial data for March 2019: sales $9,000,000,...
1. A division in ABC Co. had the following financial data for March 2019: sales $9,000,000, average operating assets $3,000,000, return on investment 18%, minimum required rate of return 16%. What was the amount of margin (or profit margin) for the division A. 4% B. 5% C. 6% D. 7% 2. A division in ABC Co. had the following financial data for March 2019: sales $9,000,000, average operating assets $3,000,000, return on investment 18%, minimum required rate of return 16%....
Chen Company's Small Motor Division manufactures a number of small motors used in household and office...
Chen Company's Small Motor Division manufactures a number of small motors used in household and office appliances. The Household Division of Chen then assembles and packages such items as blenders and juicers. Both divisions are free to buy and sell any of their components internally or externally. The following costs relate to small motor LN233 on a per unit basis. Fixed cost per unit $4.65 Variable cost per unit $11.20 Selling price per unit $35.10 a.) Assuming that the Small...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT