Answered step by step
Verified Expert Solution
Question
1 Approved Answer
GAM Ltd manufactures a variety of industrial kitchen utensils at its manufacturing plant in West Dublin. It is currently reviewing production data for one
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
Step by Step Solution
★★★★★
3.42 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
aProduction Budget Apr May Jun Jul Aug 3mthperiod Sep Oc Sales uni...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started