Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Tracey Chen, the CFO, has received numerous emails over the last few months, from David Matthews, the Business Unit Manager of Foleo Retailing NZ. His

Tracey Chen, the CFO, has received numerous emails over the last few months, from David Matthews, the Business Unit Manager of Foleo Retailing NZ. His correspondence has identified serious inventory management issues, allegedly stemming from the Australian operations, which are affecting the performance of his business unit. Assume you are the management accountant for the Foleo Group and have been called into a meeting with Tracey to discuss this issue. Below is an excerpt from the data sent to her by David, which highlights regular instances of stock-outs, indicating poor inventory management. Tracey asks you to look into this data, analyse the inventory management processes of the NZ Warehouse and provide a recommendation for improvement. "The monthly demand for SliFones in the NZ market is unpredictable, but typically fluctuates between 400 and 700 units per month. Our Warehouse orders 1,600 units every two months, however the maximum that are delivered on any order from Foleo Fones is 800 units, making it impossible to meet demand let alone build up any sort of stock. The reason given by the Australian Warehouse Supervisor is that there simply isn't enough stock of the SliFones to send. Based on our last 6 months of operations, I estimate that our annual requirement for SliFones will be 6,000 units, and our associated carrying costs for this inventory item is $5.22 per unit. Each time we place an order with Foleo Fones, the order takes a month and a half to arrive and costs our NZ operations $75.28 for the activities required - this is why we only order every two months."

Calculate

a) The optimal order quantity of SliPhones that Foleo Retailing NZ should be ordering, using the EOQ formula

(b) The number of orders that would be placed per year by Foleo Retailing NZ

(c) The total annual cost of ordering and holding the inventory of SliFones, using the order quantity calculated in part (a)

1. Calculate the average usage per month, the safety stock and the reorder point for the SliFones.

2. Use your calculations from the previous parts, suggest how David can better manage his inventory of SliFones. In your answer, include the following: identifying the current practice of inventory ordering, suggesting the new order quantity and frequency that he should place orders, explaining the concept of safety stock and reorder point and make appropriate suggestions

please focus on 1 and 2 not a, b or c please thanks

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

Intermediate Accounting Reporting and Analysis

Authors: James M. Wahlen, Jefferson P. Jones, Donald Pagach

2nd edition

978-1285453828

Students also viewed these Accounting questions