GAM Ltd manufactures a variety of industrial kitchen utensils at its manufacturing plant in West Dublin....

 

Transcribed Image Text:

GAM Ltd manufactures a variety of industrial kitchen utensils at its manufacturing plant in West Dublin. It is currently reviewing production data for one of its products the griddle" This is a relatively new product in the Irish market and the management of GAM Lid have asked you to prepare budgeted figures for this product for the coming months. The following details have been provided to you: 6) Sales Units Apr May Jun 500 €80 Jul Aug Sep Oct 450 €80 480 480 490 520 €80 €80 470 Selling Price/unit €80 €80 €80 The finished goods stock on hand at the end of each month must be equal to 300 units plus 30% of the following month's sales volumes. (ii) (iii) Each griddle requires 2kg of steel which costs €20 per kg GAM Ltd requires a raw material stock at the end of each month which is equal to 70% of the following month's production needs. (v) 60% of purchases will be paid for in the month of purchase and 40% in the following month. (vi) Labour costs will be €20,000 per month and will be paid as incurred. (vii) Overheads will be €15 per griddle produced plus a fixed cost of €3,000 per month and will be paid as incurred (viii) 20% of sales will be for cash and the balance will be credit sales 40% of credit sales will be settled in the month following sale and the remainder two months following sale (ix) The expected closing cash balance regarding "the griddle" at 31 May is a deficit of €2,500. A one-off cash injection of €10,000 has just been approved for this new product line. It should be implemented into working effect in June. (x) Requirements (a) Prepare a Production Budget for the period June- July - August. (b) Prepare a Materials Purchase Budget for the same period (c) Prepare a cash budget for June, July & August. (d) Discuss the benefits a budgeting system offers an organisation Ensure to show all relevant workings GAM Ltd manufactures a variety of industrial kitchen utensils at its manufacturing plant in West Dublin. It is currently reviewing production data for one of its products the griddle" This is a relatively new product in the Irish market and the management of GAM Lid have asked you to prepare budgeted figures for this product for the coming months. The following details have been provided to you: 6) Sales Units Apr May Jun 500 €80 Jul Aug Sep Oct 450 €80 480 480 490 520 €80 €80 470 Selling Price/unit €80 €80 €80 The finished goods stock on hand at the end of each month must be equal to 300 units plus 30% of the following month's sales volumes. (ii) (iii) Each griddle requires 2kg of steel which costs €20 per kg GAM Ltd requires a raw material stock at the end of each month which is equal to 70% of the following month's production needs. (v) 60% of purchases will be paid for in the month of purchase and 40% in the following month. (vi) Labour costs will be €20,000 per month and will be paid as incurred. (vii) Overheads will be €15 per griddle produced plus a fixed cost of €3,000 per month and will be paid as incurred (viii) 20% of sales will be for cash and the balance will be credit sales 40% of credit sales will be settled in the month following sale and the remainder two months following sale (ix) The expected closing cash balance regarding "the griddle" at 31 May is a deficit of €2,500. A one-off cash injection of €10,000 has just been approved for this new product line. It should be implemented into working effect in June. (x) Requirements (a) Prepare a Production Budget for the period June- July - August. (b) Prepare a Materials Purchase Budget for the same period (c) Prepare a cash budget for June, July & August. (d) Discuss the benefits a budgeting system offers an organisation Ensure to show all relevant workings

Answer rating: 100% (QA)

aProduction Budget Apr May Jun Jul Aug 3mthperiod Sep Oc Sales uni... View the full answer