Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hope it is clear now, let me know if it not. thank you Sales Office process: Fabien Ltd is a manufacturer of bespoke products for

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
hope it is clear now, let me know if it not.
thank you image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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: Fabien Ltd - continued: Trading (production and sales): You should assume that today is Monday 234 November 2020. Sales: The company has the following sales orders to be delivered during December 2020. Order product. Order 118 118 1183 M Quantity to be delivered ali 450 Selling Price per i Production: The production schedule for December 2020 (product quantities and production resources requirement) is shown below. Order product order 110 der 14de 1199 Moon Pished prode 790 Note: Tech 200 there will be open in de Reson requirement for productie Direct custs variable Order/product order to order order 11 "S "Men' 14 | Machining department Increment materials Direct labour hourly Machine betal 30 14 TE 38 14 11, Painting department Increase Direct labeur hon Machine bestel 11 Assembly departe incrementaria Dinast lahuta 1,150 210 2 Production: The production schedule for December 2020 (product quantities and production resources requirement) is shown below. Order/produt Order 110 der 118de 1988 "Sky mishad good Onty to be perdowed Note December 2000 will be opening of wished Rources requirement for production Direct costs variabilecek Order produtorder onder 18 order Me CLIN Machining department incrementala Director) Machine borse 40 10 15 44 Painting department Incrccal material.com Direct show busca Machine boursel) 11 104 114 30h Assembly department inctementales Direct lub house Machine house LL.IS 200 LLLS 25 LTD 24 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: 1:29 -central-1-prod-fleet01-xythos.s3.eu-central-1.amazonaws.com 2861 255 204783 Direct la hotel Machine hontal 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: Machine Paletines That Fiseloos (allocatie/appartement 1933.02 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. Task 4: Re-calculate the gross profit (and gross profit margin) if product 'Sun is removed from the production and sales schedule. Note: It has been established that, if product 'Sun' was removed from the catalogue, specific fixed cost savings of 12,800 would be made. 4 Marks Draft a memo to Catherine Smith in reply to his comment (with clear explanatory supporting reasons to a non-accountant). 7 Marks Note: Your memo should be prepared in a good style and show effective skills in written communication and quality of information' aspects Fabien Ltd - continued: The finance office (cost and management accounts) recently performed an activity - based production systems analysis for the fixed production overheads. The result is the table below: Cou Cost drher Total de period 10,000 Production scheduling 3.2000 Joway 17.300 De 19.200 Maine law 1.300 trailer | Marai Total 11,500 1 2.50 1.00 10 A further analysis has produced the following indirect production overhead resource required for each product: Activity - Based Resource (Cost driver quantity) Requirement (by product) I UULLU LILIULU. 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 FMIS 02. Lecture SL 35565 FMIS assess 35565 FMIS - assess 35565 FMIS - Assess Seu centrado 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 1101 Order / product: Order 1102 'Sky "Sun' Quantity to be delivered (sales in units) 650 950 Selling price (per unit) 90 35 Order 1103 "Moon' 1,150 55 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,320 Quantity to be produced Note: At 1* December 2020 there will be no opening inventory of finished goods. 1,000 Resources requirement for production: Direct costs (variable costs): Order / product: Order 1101 "Sky' Order 1102 'Sun' Order 1103 "Moon' Machining department: Incremental materials cost Direct labour hours (total) Machine hours (total) 1,440 102 186 E720 144 221 1,150 72 Totals 3,310 318 hours 551 hours 144 Daindadas 35565 FMIS - assess 35565 FMIS - assess 35565 FMIS - assess FMIS 02 - Lecture SL life 39615303 X 9615303 em X X Gyoutube - Google Sear entral-1.amazonaws.com/5e7520cc59b1/9615303?response-cache-control-private%2C%20max-age%3D21600 Resources requirement for production: Direct costs (variable costs): Order/product: der 1101 'Sky' Order 1102 'Sun' Order 1103 "Moon' Totals Machining department: Incremental materials cost Direct labour hours (total) Machine hours (total) E1,440 102 720 144 1,150 72 3,310 318 hours 551 hours 186 221 144 Painting department: Incremental materials cost Direct labour hours (total) Machine hours (total) 864 144 114 1,740 114 60 E288 90 30 E2,892 348 hours 204 hours 1,150 Assembly department: Incremental materials cost Direct labour hours (total) Machine hours (total) 1,150 216 60 720 204 102 3,020 678 hours 258 72 234 hours 6 Fabien Ltd - continued: Fixed Indirect production overheads: me X 39615303 X 9615303 X G youtube - Google Search atral-1.amazonaws.com/5ef7520cc59b1/9615303?response-cache-control=private%2C%20max-age%3D216008 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 Fixed costs (allocation / apportionment) 19,400 Painting 8,600 Assembly 13,500 Total 41,500 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. Catherine Smith, the company sales manager has commented that product 'Sun' (Order 1102) is not performing well and the company profits would increase if this product was removed from the range. Task 4: a. Re - calculate the gross profit (and gross profit margin) if product 'Sun' is removed from the production and sales schedule. Note: It has been established that, if product 'Sun' was removed from the catalogue, specific fixed cost savings of 12,800 would be made. 4 Marks b. Draft a memo to Catherine Smith in reply to his comment (with clear explanatory supporting reasons to a non-accountant). 7 Marks Note: Your memo should be prepared in a good style and show effective skills in written communication and "quality of information' aspects 8 Fabien Ltd - continued The finance office (cost and management accounts) recently performed an 'activity-based production systems analysis for the fixed production overheads. The result is the table below: Total cost Indirect Cost production Cost driver driver quantity overhead per period recovery rate E Set up costs 10,000 Set ups 140 71.43 Production scheduling 3,200 Set ups 140 22.86 Quality control 17,300 Inspections 2,500 6.92 Depreciation 9,200 Machine hours 1,000 9.20 Raw materials storage 1,800 Materials movements 1,800 1.00 Total: 41,500 A further analysis has produced the following indirect production overhead resource required for each product: Activity-Based Resource (Cost driver quantity) Requirement (by product) Order 1101 Order 1102 Order 1103 Order/product: Total 'Sky' 'Sun' "Moon' Set ups 45 45 15 105 Inspections 1,000 800 1,190 2,990 Machine hours 320 420 250 990 Materials movements 900 500 1,800 400 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: Fabien Ltd - continued: Trading (production and sales): You should assume that today is Monday 234 November 2020. Sales: The company has the following sales orders to be delivered during December 2020. Order product. Order 118 118 1183 M Quantity to be delivered ali 450 Selling Price per i Production: The production schedule for December 2020 (product quantities and production resources requirement) is shown below. Order product order 110 der 14de 1199 Moon Pished prode 790 Note: Tech 200 there will be open in de Reson requirement for productie Direct custs variable Order/product order to order order 11 "S "Men' 14 | Machining department Increment materials Direct labour hourly Machine betal 30 14 TE 38 14 11, Painting department Increase Direct labeur hon Machine bestel 11 Assembly departe incrementaria Dinast lahuta 1,150 210 2 Production: The production schedule for December 2020 (product quantities and production resources requirement) is shown below. Order/produt Order 110 der 118de 1988 "Sky mishad good Onty to be perdowed Note December 2000 will be opening of wished Rources requirement for production Direct costs variabilecek Order produtorder onder 18 order Me CLIN Machining department incrementala Director) Machine borse 40 10 15 44 Painting department Incrccal material.com Direct show busca Machine boursel) 11 104 114 30h Assembly department inctementales Direct lub house Machine house LL.IS 200 LLLS 25 LTD 24 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: 1:29 -central-1-prod-fleet01-xythos.s3.eu-central-1.amazonaws.com 2861 255 204783 Direct la hotel Machine hontal 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: Machine Paletines That Fiseloos (allocatie/appartement 1933.02 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. Task 4: Re-calculate the gross profit (and gross profit margin) if product 'Sun is removed from the production and sales schedule. Note: It has been established that, if product 'Sun' was removed from the catalogue, specific fixed cost savings of 12,800 would be made. 4 Marks Draft a memo to Catherine Smith in reply to his comment (with clear explanatory supporting reasons to a non-accountant). 7 Marks Note: Your memo should be prepared in a good style and show effective skills in written communication and quality of information' aspects Fabien Ltd - continued: The finance office (cost and management accounts) recently performed an activity - based production systems analysis for the fixed production overheads. The result is the table below: Cou Cost drher Total de period 10,000 Production scheduling 3.2000 Joway 17.300 De 19.200 Maine law 1.300 trailer | Marai Total 11,500 1 2.50 1.00 10 A further analysis has produced the following indirect production overhead resource required for each product: Activity - Based Resource (Cost driver quantity) Requirement (by product) I UULLU LILIULU. 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 FMIS 02. Lecture SL 35565 FMIS assess 35565 FMIS - assess 35565 FMIS - Assess Seu centrado 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 1101 Order / product: Order 1102 'Sky "Sun' Quantity to be delivered (sales in units) 650 950 Selling price (per unit) 90 35 Order 1103 "Moon' 1,150 55 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,320 Quantity to be produced Note: At 1* December 2020 there will be no opening inventory of finished goods. 1,000 Resources requirement for production: Direct costs (variable costs): Order / product: Order 1101 "Sky' Order 1102 'Sun' Order 1103 "Moon' Machining department: Incremental materials cost Direct labour hours (total) Machine hours (total) 1,440 102 186 E720 144 221 1,150 72 Totals 3,310 318 hours 551 hours 144 Daindadas 35565 FMIS - assess 35565 FMIS - assess 35565 FMIS - assess FMIS 02 - Lecture SL life 39615303 X 9615303 em X X Gyoutube - Google Sear entral-1.amazonaws.com/5e7520cc59b1/9615303?response-cache-control-private%2C%20max-age%3D21600 Resources requirement for production: Direct costs (variable costs): Order/product: der 1101 'Sky' Order 1102 'Sun' Order 1103 "Moon' Totals Machining department: Incremental materials cost Direct labour hours (total) Machine hours (total) E1,440 102 720 144 1,150 72 3,310 318 hours 551 hours 186 221 144 Painting department: Incremental materials cost Direct labour hours (total) Machine hours (total) 864 144 114 1,740 114 60 E288 90 30 E2,892 348 hours 204 hours 1,150 Assembly department: Incremental materials cost Direct labour hours (total) Machine hours (total) 1,150 216 60 720 204 102 3,020 678 hours 258 72 234 hours 6 Fabien Ltd - continued: Fixed Indirect production overheads: me X 39615303 X 9615303 X G youtube - Google Search atral-1.amazonaws.com/5ef7520cc59b1/9615303?response-cache-control=private%2C%20max-age%3D216008 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 Fixed costs (allocation / apportionment) 19,400 Painting 8,600 Assembly 13,500 Total 41,500 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. Catherine Smith, the company sales manager has commented that product 'Sun' (Order 1102) is not performing well and the company profits would increase if this product was removed from the range. Task 4: a. Re - calculate the gross profit (and gross profit margin) if product 'Sun' is removed from the production and sales schedule. Note: It has been established that, if product 'Sun' was removed from the catalogue, specific fixed cost savings of 12,800 would be made. 4 Marks b. Draft a memo to Catherine Smith in reply to his comment (with clear explanatory supporting reasons to a non-accountant). 7 Marks Note: Your memo should be prepared in a good style and show effective skills in written communication and "quality of information' aspects 8 Fabien Ltd - continued The finance office (cost and management accounts) recently performed an 'activity-based production systems analysis for the fixed production overheads. The result is the table below: Total cost Indirect Cost production Cost driver driver quantity overhead per period recovery rate E Set up costs 10,000 Set ups 140 71.43 Production scheduling 3,200 Set ups 140 22.86 Quality control 17,300 Inspections 2,500 6.92 Depreciation 9,200 Machine hours 1,000 9.20 Raw materials storage 1,800 Materials movements 1,800 1.00 Total: 41,500 A further analysis has produced the following indirect production overhead resource required for each product: Activity-Based Resource (Cost driver quantity) Requirement (by product) Order 1101 Order 1102 Order 1103 Order/product: Total 'Sky' 'Sun' "Moon' Set ups 45 45 15 105 Inspections 1,000 800 1,190 2,990 Machine hours 320 420 250 990 Materials movements 900 500 1,800 400

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra With Modeling And Visualization

Authors: Gary Rockswold

6th Edition

0134418042, 978-0134418049

Students also viewed these Accounting questions