Question

In: Accounting

Coro Ltd makes two products, Quara and Lock. The following data are relevant for the year...

Coro Ltd makes two products, Quara and Lock. The following data are relevant for the year ending 31st December 2020:

Material prices

Material M      GHS2 per unit

Material N       GHS3 per unit

Direct labour is paid GHS10 per hour.

Production overhead cost is estimated to be GHS 200,000. Production overhead cost is absorbed into product costs using a direct labour hour absorption rate. Selling and administration overhead is budgeted to be GHS 75,000.

Each unit of finished product requires:

                       

Quara

Lock

Material M     

12 units

12 units

Material N      

6 units

8 units

Direct labour

7 hours

10 hours

The sales director has forecast that sales of Quara and Lock will be 5,000 and 1,000 units respectively during the year 2020. The selling prices will be as follows:

Quara                         GHS182 per unit Lock                    GHS161 per unit

She estimates that there will be opening inventory of 100 units of Quara and 200 units of Lock. At the end of the year 2020, the company does not intend holding any inventory of Quara and Lock.

The Production Director estimates that the opening inventories of raw materials will be 3,000 units of M and 4,000 units of material N. At the end of the year 2020, the inventories of these raw materials are to be:

  1. 4,000 units
  2. 2,000 units

Statement of financial position extracts for year ended 31st December 2019 are as follows:

Inventory of finished goods                                       GHS 15,000

Inventory of Raw materials                                        GHS 20,000

Retained earnings                                                       GHS 81,000

The Finance Director advises that the rate of tax to be paid on profits during the year 2020 is likely to be 30%.

Required:

    1. Prepare all functional budgets and budgeted statement of profit or loss for the year ending 31st December 2020.
    2. The Managing Director of Coro Ltd is of the view that the budget preparation and presentation process is a waste of resources considering the time and money invested into it. He thinks the cost far outweighs the benefits and the company could still operate effectively without any budget. Do you agree with him? Explain why?
    1. The Management Accountant suggested that cash budget need to be prepared in addition to the functional budgets and the budgeted statement of Profit or Loss to make the budgeting process complete. Meanwhile, he claims he does not have enough information to prepare the cash budget. Advise him on the process and sources of information for preparation of a cash budget.

Solutions

Expert Solution


Related Solutions

Coro Ltd makes two products, Quara and Lock. The following data are relevant for the year...
Coro Ltd makes two products, Quara and Lock. The following data are relevant for the year ending 31st December 2020: Material prices Material M GHS2 per unit Material N GHS3 per unit Direct labour is paid GHS10 per hour. Production overhead cost is estimated to be GHS 200,000. Production overhead cost is absorbed into product costs using a direct labour hour absorption rate. Selling and administration overhead is budgeted to be GHS 75,000. Each unit of finished product requires: Quara...
QUESTION 1 Coro Ltd makes two products, Quara and Lock. The following data are relevant for...
QUESTION 1 Coro Ltd makes two products, Quara and Lock. The following data are relevant for the year ending 31st December 2020: Material prices: Material M GHS2 per unit Material N GHS3 per unit Direct labour is paid GHS10 per hour. Production overhead cost is estimated to be GHS 200,000. Production overhead cost is absorbed into product costs using a direct labour hour absorption rate. Selling and administration overhead is budgeted to be GHS 75,000. Each unit of finished product...
Question 1 Coro Ltd makes two products, Quara and Lock. The following data are relevant for...
Question 1 Coro Ltd makes two products, Quara and Lock. The following data are relevant for the year ending 31st December 2020: Material prices Material M GHS2 per unit Material N GHS3 per unit Direct labour is paid GHS10 per hour. Production overhead cost is estimated to be GHS 200,000. Production overhead cost is absorbed into product costs using a direct labour hour absorption rate. Selling and administration overhead is budgeted to be GHS 75,000. Each unit of finished product...
Question 1.1 C Ltd makes two products, Alpha and Beta. The following data is relevant for...
Question 1.1 C Ltd makes two products, Alpha and Beta. The following data is relevant for year 3: Material M £2 per unit Material N £3 per unit Direct labour is paid £10 per hour. Production overhead cost is estimated to be £200,000, which includes £25,000 for depreciation of property and equipment. Production overhead cost is absorbed into product costs using a direct labour hour absorption rate. Each finished unit requires: Alpha Beta Material M 12 units   12 units Material...
Duke Ltd makes and sells two products. A and B. The following information is available for...
Duke Ltd makes and sells two products. A and B. The following information is available for period 3:                                                                                                        A             B Production (units                                                                           2,500     1,750 Sales (units)                                                                                  2,300      1,600 Opening inventory (units)                                                                0              0 Financial data:                                                                                                                                                     A                 B                                                                                                         ₵                 ₵ Unit selling price                                                                              90                75 Unit cost:                       Direct materials                                                          15                 12                      Direct labour                                                                  18               12                      Variable production overheads                                      12               8                      Fixed production overheads                                            30             20                      Variable selling overheads                                               1               1 Fixed production overheads...
Anfield Ltd makes two similar products, the Kemlyn and the Kop – the Kemlyn is a...
Anfield Ltd makes two similar products, the Kemlyn and the Kop – the Kemlyn is a basic version, the Kop is a premium version, and information relating to each of these products is set out below. Kemlyn Kop Selling price per unit £90 £180 Annual sales volume 9,000 units 24,000 units Number of sales invoices issued each year 800 350 Labour time per unit 3 hours 6 hours Labour rate per unit £15 £15 Material cost per unit £35 £40...
The Red Company makes two products. Cost data for these two products is as follows: Product...
The Red Company makes two products. Cost data for these two products is as follows: Product A Product B Selling price $10 $20 Variable costs   7 12 Total annual fixed costs are $840,000. The firm's experience has been that about 20 percent of unit sales come from product A, 80 percent from B. The Red Company is taxed at 30% Required: a. Determine the number of units to be sold at the break-even point. b. Determine the number of units...
A business makes two products C and D with the following sales prices and cost data:...
A business makes two products C and D with the following sales prices and cost data:                                                                C                                 D Selling price per unit                             $25                             $30 Direct material cost per unit                 $8                                 $7 Direct labour cost (0.5 hrs. product     $8  per unit                    $6 per hour Variable overhead                                $1 per unit                    $2 per direct labour hour Required 1. Determine the forecast of total costs and profits for a month when the business expects to make and sell 1 200 units of product C and 1 800...
Performance Products Corporation makes two products, titanium Rims and Posts. Data regarding the two products follow:...
Performance Products Corporation makes two products, titanium Rims and Posts. Data regarding the two products follow:     Direct Labor-Hours per unit Annual Production Rims 0.30 27,000 units Posts 0.50 75,000 units Additional information about the company follows: Rims require $12 in direct materials per unit, and Posts require $10. The direct labor wage rate is $20 per hour. Rims are more complex to manufacture than Posts and they require special equipment. The ABC system has the following activity cost pools:...
Performance Products Corporation makes two products, titanium Rims and Posts. Data regarding the two products follow:...
Performance Products Corporation makes two products, titanium Rims and Posts. Data regarding the two products follow: Direct Labor-Hours per unit Annual Production Rims 0.30 26,000 units Posts 0.50 70,000 units Additional information about the company follows: Rims require $15 in direct materials per unit, and Posts require $11. The direct labor wage rate is $15 per hour. Rims are more complex to manufacture than Posts and they require special equipment. The ABC system has the following activity cost pools: Estimated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT