Fabien Ltd Fabien Ltd is a manufacturing organisation supplying specialised engineered products to a wide range of public and private sector throughout the UK You are a trainee in the finance office recently recruited by the company. Management planning meeting: On the 24 of every month (or nearest Monday) the business executive management team meets to plan trading and production for the following month The meeting commences with a review of the sales order book and a determination of the following months product sales volumes. The expected sales volumes inform the production planning process and decisions are made with respect to production resources and closing inventory requirements. The agreed plan is the production schedule document. This is forwarded to the production departmental managers who will examine and compare their available resources against the requirement for production Any problems (constraints) or other issues arising are reported back to the executive management team who will consider making adjustments to: The production requirements The available resources At the start of the following month, the production process will commence with a view to meeting the objectives of the agreed production (action plan This process is described by the production planning flowchart (shown below): Production Planning Flowchart Start 24th of the Month (or nearest Monday): Executive management planning meeting for the next month's trading objectives: Expected sales determination Production output levels for the following month Management adjustments to original plan data Plan document passed to functional production managers N Problems / constraints other issues arising? Agreed action plan document ready for the following month's production process End 2 Fabien Ltd - continued: The production process: The production process of Fabien Ltd takes place through 3 production departments; machining, painting and assembly. Machining department: Direct materials are transferred from the direct materials stores to the machining department. These are transformed using direct labour employees and machine processes into machined goods. The total of the prime costs add the fixed production overhead (allocated and / or apportioned) is the total cost of machined goods transferred to the painting department. For the machining department, the direct labour employees are paid at a rate of 13.00 per hour and the variable machine cost is 8.00. Painting department: Incremental direct materials are transferred from the direct materials stores to the painting department. These are combined with the machined goods transferred in and are transformed using direct labour employees and machine processes into painted goods. The total combined costs add the fixed production overhead (allocated and / or apportioned) is the total cost of painted goods transferred to the assembly department. For the painting department, the direct labour employees are paid at a rate of 15.00 per hour and the variable machine cost is 6.00. Assembly department: Incremental direct materials and components are transferred from the direct materials stores to the assembly department. These are combined with the painted goods transferred in and are transformed using direct labour employees and machine processes into saleable finished goods. The total combined costs add the fixed production overhead (allocated and / or apportioned) is the total cost of the saleable finished goods transferred to the finished goods warehouse. For the assembly department, the direct labour employees are paid at a rate of 11.00 per hour and the variable machine cost is 7.00. The production process is described in the production process flowchart below: 3 Fabien Ltd - continued Fabien Ltd - Production Process Flowchart Start Materials movement process Materials movements and internal transfer Inspection processes Machining department: Direct materials Add Direct labour (13.00 per hour) Add Direct expenses (8.00 per machine hour) Add Fixed indirect production overhead costs absorbed = Total cost of machined goods (Transferred out to painting department) Materials movements and internal transfer Inspection processes Painting department: Direct materials Add machined goods transferred IN Add Direct labour (E15.00 per hour) Add Direct expenses (6.00 per machine hour) Add Fixed indirect production overhead costs absorbed Total cost of painted goods (Transferred out to assembly department) Assembly department: Direct materials Add painted goods transferred IN . Add Direct labour (11.00 per hour) Add Direct expenses (7.00 per machine hour) Add Fixed indirect production overhead costs absorbed = Total cost of saleable finished goods produced (Transferred out to finished goods warehouse) Materials movements and internal transfer inspection processes Finished goods warehouse Frid Note: The costs of materials movements between departments and internal inspection checks are included in indirect production overheads. The above flowchart is an outline process only and does not include control decision, documentation raising and filing requirements. 4 Fabien Ltd - continued Sales Office process Fabien Ltd is a manufacturer of bespoke products for the building industry and domestic customers. Sales customers place orders either by phone directly to the sales office or through the business website. Sales staff operators well initially cheque whether the customer is an existing account holder. For existing account holders, staff will examine the account to see if there are any existing problems (e.g. long outstanding accounts and/or disputed invoices). Where this is the case, the customer and order information is passed to the chief credit controller for decision-making. Existing customers, where the account is otherwise in good order, most then be checked against current credit limits. Where an order may take the account beyond the current credit limit, the customer and order information is, again, passed to the chief credit controller for decision-making. Where the sales order is acceptable, the order documentation is passed to the production manager for scheduling. Non-existing (new) customers must pay cash in advance of production, and, if this is acceptable to the customer becomes a potential and is offered an application to the sales Ledger. The customer may accept or decline the invitation. An application form is attached to an email and sent to accepting potentials. The contact details of declining potentials will be held anyway for future promotional activities. Required: Task 1: Prepare a flowchart in a A4 size paper one side only) to describe the sales office process of Fabien Ltd described above. Note: Your flowchart should be prepared in a good style using the Microsoft Office Word: "Insert / Shapes/ Flowchart facility (Maximum 20 marks including 6 marks credit for software use, good style and clear presentation) 20 Marks 5 Fabien Ltd - continued: Trading (production and sales): You should assume that today is Monday 23 November 2020. Sales: The company has the following sales orders to be delivered during December 2020. Order / product: Quantity to be delivered (sales in units) Selling price (per unit) Order 1101 'Sky' 650 90 Order 1102 'Sun' 950 35 Order 1103 "Moon 1,150 ESS Production: The production schedule for December 2020 (product quantities and production resources requirement) is shown below. Order 1101 Order 1102 Order 1103 Order / product: "Sky Sun "Moon' Finished goods: 790 1,000 1,320 Quantity to be produced Note: At 19 December 2020 there will be no opening inventory of finished goods, Resources requirement for production: Direct costs (variable costs): Order 1101 'Sky Order 1102 "Sun" Order 1103 "Moon Order / product: Machining department: Incremental materials cost Direct labour hours (total) Machine hours (total) E1,440 102 186 E720 144 1,150 72 144 Totals 3,310 318 hours 551 hours 221 864 Painting department: Incremental materials cost Direct labour hours (total) Machine hours (total) 1,740 114 144 E288 90 30 2,892 348 hours 204 hours 114 60 E72011 Assembly department: Incremental materials cost Direct labour hours (total) Machine hours (total) 1,150 216 60 E1,150 258 72 204 53,020 678 hours 234 hours 102 6 E13,500 Total 41,500 Fabien Ltd - continued Fixed indirect production overheads: Indirect production Overheads are fixed (unaffected by production activity levels) at 41,500 per month. This value has been allocated and apportioned to the 3 production departments as follows: Production department: Machining Painting Assembly Fixed costs (allocation / apportionment) 19,400 8,600 Bases for absorption: Machining department Machine hours Painting department Direct labour hours Assembly department = Direct labour hours Note: The quantity for absorption basis (for each production department) should be established using the total departmental resources requirement shown in the tables above. Required: Task 2: Prepare (for each product and in total) the following planned values for December 2020: a. Prime costs 11 Marks b. Total (full) costs of production 14 Marks c. Finished goods closing inventories / cost of sales 7 Marks d. Gross profits (and gross profit margins) 3 Marks Note to task 2: The requirement of task 2 should be established using an absorption costing system (as described in the production process flowchart) The total task 2 mark above, includes marks allocated to short descriptive notes to workings (