Question

In: Accounting

Assume you are the management accountant for the Foleo Group. Tracey Chen, the CFO, has called...

Assume you are the management accountant for the Foleo Group. Tracey Chen, the CFO, has called you into a meeting, to discuss the performance of the Warehouse Manager of the Foleo Fones business unit in managing his inventory stocks. After his last meeting with the Production Manager, Allan Raymond, the Business Unit GM, has supplied Tracey with below data relating to the inventory management practices for the current year. Tracey asks you analyse this data and before her Board meeting next week.

Inventory Management Activities

Current Year’s Cost

Selection of Supplier $300

Warehouse rental (variable) $90,000

Handling of inventory $1,100

Transportation of inventory $600

Insurance $7,400

Unloading delivered inventory from freight truck $750

Inspecting delivered orders $900

Spoilage and obsolescence of inventory $6,000

Theft of inventory $4,300

The Production Manager has indicated that the Foleo Fones plant requires 24,000 kg of plastics annually and on average, the lead time for deliveries of the plastics is one month. He has also advised he orders 2,000 kg per month, and that the monthly usage typically fluctuates between 1,800 and 2,500 kg. This practice has resulted regularly in stock-out situations. The Manager has also estimated that the above ordering costs will increase by 5% and the carrying costs by 7% next year.

(a) Using the above data, calculate the following: the amount of ordering cost that should be used in the EOQ formula, the amount of carrying cost that should be used in the EOQ formula, and the optimum order quantity for the plastics raw materials required to produce the SliFones for the CURRENT YEAR using the EOQ formula. (HINT: show all your workings and round up your EOQ if necessary.) (HINT: the above data is for the entire year, so you will need to calculate the total components for the year and then convert them to what you will need for the EOQ formula.)

(b) Based on your calculations above, how many orders at the EOQ would be made for the plastics raw materials this year? (HINT: Show all your workings and round the number of orders up if necessary) (0.25 mark)

(c) Based on the Production Manager’s estimations of cost increases, calculate the EOQ for the plastics raw materials for the NEXT YEAR. (HINT: Show all your workings and round your EOQ up if necessary) (1 mark)

(d) Based on your calculations in part (c), how many orders will now be made for the plastics raw materials next year? (HINT: Show all workings and round the number of orders up if necessary) (0.25 mark)

(e) Using the appropriate formula and your EOQ from part (c) above, calculate the total annual cost of ordering and holding inventory for the plastics raw materials for the coming year (show all your workings). (1 mark)

(f) Calculate the Safety Stock for the plastics raw materials (show all your workings). (0.5 mark)

(g) Calculate the Reorder Point for the plastics raw materials (show all your workings) (0.5 mark)

Solutions

Expert Solution

a. I. Ordering Cost:

Cost

Amount ($)

Selection of Supplier

300

Transportation of Inventory

600

Unloading

750

Inspection

900

2550

II. Inventory Handling Cost:

Cost

Amount ($)

Warehouse rent (Variable)

90000

Handling of Inventory

1100

Insurance

7400

Spoilage

6000

Theft

4300

108800

III Optimum Order Quantity:

Required Quantity = 24000kg

Ordering cost per order = 2250/12 = 212.5

Inventory Handling cost per unit= 108800/24000 = 4.53

EOQ = Under root of 2 x Required Quantity x Ordering cost / Inventory handling cost per unit

           = 1500 units

B. According to EOQ Number of orders to be placed in a year = 24000 kg/ 1500 kg = 16 orders

C. Ordering cost for next year = 2250 plus 5% = 2363

      Inventory Handling cost for next year = 108800 plus 7% = 116416

EOQ for next year = root of 2 x 24000 x 188.58 / 4.85 = 1366 units

D. Number of orders for next year = 24000/1366 = 17.56 i.e. 18 orders

       


Related Solutions

Assume you are the management accountant for the Foleo Group. Tracey Chen, the CFO, has called...
Assume you are the management accountant for the Foleo Group. Tracey Chen, the CFO, has called you into a meeting, to discuss the performance of the Warehouse Manager of the Foleo Fones business unit in managing his inventory stocks. After his last meeting with the Production Manager, Allan Raymond, the Business Unit GM, has supplied Tracey with below data relating to the inventory management practices for the current year. Tracey asks you analyse this data and before her Board meeting...
Assume you are the management accountant for the Foleo Group and Tracey Chen has asked you...
Assume you are the management accountant for the Foleo Group and Tracey Chen has asked you to assist her in assessing the organisation’s internal control environment before her meeting with Peter Singh next week. Specifically, she asks you to look at the Finance Department that you manage. Tracey provides you with her detailed observations of the Department’s current control environment below, and asks for your input. Finance Department: This Department presents the highest control risk for the Foleo Group, by...
Assume you are the management accountant for the Foleo Group and have been called to a...
Assume you are the management accountant for the Foleo Group and have been called to a meeting with James and Tracey, the CFO, regarding the assessment of a special offer for the premium model of SliFones that James has negotiated with Vodafone – the offer is for 6,000 phones at the discounted price of $760 each.  You have been asked to work with Allan Raymond, the Foleo Fones Business Unit General Manager, and look into the current manufacturing practices, with the...
Assume you are the management accountant for the Foleo Group.  After her meetings with the various business...
Assume you are the management accountant for the Foleo Group.  After her meetings with the various business units, Tracey Chen has identified a number of opportunities for the organisation to improve its sustainability performance.  One such opportunity is Robyn Smith’s suggestion for moving the manufacturing operations of Foleo Fones and Accessories off-shore to address the local residents’ concerns.  Robyn had done some research and has supplied Tracey with the below data relating to the relocation of Foleo’s manufacturing plants offshore (specifically to Guangzhou...
Assume you are the management accountant for the Foleo Group.  After her meetings with the various business...
Assume you are the management accountant for the Foleo Group.  After her meetings with the various business units, Tracey Chen has identified a number of opportunities for the organisation to improve its sustainability performance.  One such opportunity is Robyn Smith’s suggestion for moving the manufacturing operations of Foleo Fones and Accessories off-shore to address the local residents’ concerns.  Robyn had done some research and has supplied Tracey with the below data relating to the relocation of Foleo’s manufacturing plants offshore (specifically to Guangzhou...
FOLEO FONES CASE STUDY – Chapter 9: Assume you are the management accountant for the Foleo...
FOLEO FONES CASE STUDY – Chapter 9: Assume you are the management accountant for the Foleo Group & Tracey Chen has asked you to assist her in assessing the organisation’s internal control environment before her meeting with Peter Singh next week. Specifically, she asks you to look at the Foleo Fones & Foleo Accessories Business Units. Tracey provides you with her detailed observations of their current control environments below, & asks for your input. Foleo Fones & Accessories: Allan Raymond...
FOLEO FONES CASE STUDY – Chapter 9: Assume you are the management accountant for the Foleo...
FOLEO FONES CASE STUDY – Chapter 9: Assume you are the management accountant for the Foleo Group and Tracey Chen has asked you to assist her in assessing the organisation’s internal control environment before her meeting with Peter Singh next week.  Specifically, she asks you to look at the Finance Department that you manage.  Tracey provides you with her detailed observations of the Department’s current control environment below, and asks for your input. Finance Department: This Department presents the highest control risk...
Level 4 In this group projects: Assume that you are an accountant in Maida Vale company....
Level 4 In this group projects: Assume that you are an accountant in Maida Vale company. Your manager provided you with the following balances that shows the balances for the year ended December 31, 2018 ( as shown below). He asked you to prepare the trail balance for the company. While you were looking at the trial balance, you found that some numbers are missing. When you informed your manager about the them, he provided you with some documents that...
You are a Junior Accountant for X-RAY Inc., and you receive from the CFO the following...
You are a Junior Accountant for X-RAY Inc., and you receive from the CFO the following information which affects the Financial Statements of the company. X-RAY Incorporate Unadjusted Trial Balance 31.12.2016 Debit Credit Cash 43.820 Accounts receivable 22.000 Supplies 1.230 Prepaid Expenses 5.200 Prepaid Interests 18.750 Vehicles 10.000 Computers 3.000 Furniture 8.000 Building 55.000 Accumulated Depreciation 7.000 ST Debt (Loan) 25.000 LT Debt (Loan) 100.000 Accounts payable 2.000 Unearned Revenue 10.000 Common stock 5.000 Retained earnings 18.000 Loss/Profit Total 167.000...
Please assist to explain the differences between a financial accountant and a management accountant Thanks you...
Please assist to explain the differences between a financial accountant and a management accountant Thanks you so much.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT