Question

In: Finance

Novelty Gifts, Inc. is experiencing some inventory control problems. The manager, Wanda LaRue, currently orders 5,000...

Novelty Gifts, Inc. is experiencing some inventory control problems. The manager, Wanda LaRue, currently orders 5,000 units four times each year to handle annual demand of 20,000 units. Each order costs $15 and each unit costs $1.50 to carry. Ms. LaRue maintains a safety stock of 200 units.

A) What is Novelty Gifts' current total annual inventory cost?

B) Calculate the economic ordering quantity (EOQ).

C) What is average inventory under EOQ if Ms. LaRue maintains a safety stock of 200 units?

D) Calculate total annual inventory cost under EOQ.

Solutions

Expert Solution

A) What is Novelty Gifts' current total annual inventory cost?

  • Average inventory level = Q/2 = 5,000/2 = 2500 units + 200 units = 2,700 units
  • Number of orders placed per year (N) = D/ Q = 20,000/5,000 = 4 orders
  • Annual inventory holding cost = (Q/ 2) x H = (2,700)(1.5) = $4,050
  • Total annual ordering cost = (D/Q) (S) = (4)(15) = $60
  • Total annual cost = $4,050 + $60 = $4,110

B) Calculate the economic ordering quantity (EOQ).

, where

D = 20,000

S = 15

H = 1.5           

Hence, EOQ = 632 units

C) What is average inventory under EOQ if Ms LaRue maintains a safety stock of 200 units?

Average inventory level = 632/2 + 200 = 516 units

D) Calculate total annual inventory cost under EOQ.

  • Average inventory level = Q/ 2 = 632/2 = 316 units + 200 units = 516 units
  • Number of orders placed per year (N) = D/ Q = 20,000/5,000 = 32 orders
  • Annual inventory holding cost = (Q/ 2) x H = (516)(1.5) = $774
  • Total annual ordering cost = (D/Q)(S) = (32)(15) = $480

E) Total annual cost = $774+ $480 = $1,254


Related Solutions

[PHB] is an organisation in the building industry and is currently experiencing problems with managing their...
[PHB] is an organisation in the building industry and is currently experiencing problems with managing their workplace health and safety issues. Senior management of the organisation is concerned for many reasons. Senior management wishes to develop a strategic human resource model for managing their workplace health and safety. When formulating such a model what would you advise senior management is the major range of issues that need to be considered.------- 1500 words
What skill needed to be an effective inventory manager? What are possible problems that inventory managers...
What skill needed to be an effective inventory manager? What are possible problems that inventory managers deal with and what are the solutions? Explain with examples please.
Analyze the current system and identify specific internal control problems Inventory control department receives a list...
Analyze the current system and identify specific internal control problems Inventory control department receives a list of items in inventory and total amounts in each category. The inventory control clerk, Keith Fernando, is given the quantity-onhand for all gloves (softball, infielder, outfielder, catcher, and pitcher). The quantity-onhand of each inventory is calculated by the inventory control system, called PICS (Physical Inventory Control Scanner). PICS is an automated computer system used to determine the quantity-on-hand of inventories at specific times. It...
determine which part of the endocrine system could be experiencing problems. List some other info that...
determine which part of the endocrine system could be experiencing problems. List some other info that could confirm or rule out your initial diagnosis (test you might be able to run or questions to ask the patient or relatives). Explain your reasoning. A 27 year old female enters the clinic complaining of fatigue, fluid retention (especially in her face), and a cold that she just cannot kick. She is studying for her midterms (she is a first year physician's assistant...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently allocated using direct labor-hours, but the controller has recommended an activity-based costing system using the following data: Cost Driver Volume Activity Cost Driver Cost Pencils Pens Setting up Number of setups $ 96,000 17 31 Inspecting Number of parts 29,000 4 6 Packing and shipping Number of boxes shipped 50,000 55,000 70,000 Total overhead $ 175,000 Required: a. Compute the amount of overhead to...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently allocated using direct labor-hours, but the controller has recommended an activity-based costing system using the following data: Cost Driver Volume Activity Cost Driver Cost Pencils Pens Setting up Number of setups $ 98,000 19 30 Inspecting Number of parts 30,000 4 6 Packing and shipping Number of boxes shipped 52,500 40,000 65,000 Total overhead $ 180,500 Required: a. Compute the amount of overhead to...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently allocated using direct labor-hours, but the controller has recommended an activity-based costing system using the following data. Cost Driver Volume Activity Cost Driver Cost Pencils Pens Setting up Number of setups $ 72,000 20 30 Inspecting Number of parts 21,600 4 6 Packing and shipping Number of boxes shipped 43,200 45,000 75,000 Total overhead $ 136,800 Required: a. Compute the amount of overhead to...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently...
Isadore’s Implements, Inc., manufactures pens and mechanical pencils often used for gifts. Overhead costs are currently allocated using direct labor-hours, but the controller has recommended an activity-based costing system using the following data: Cost Driver Volume Activity Cost Driver Cost Pencils Pens Setting up Number of setups $ 102,000 22 29 Inspecting Number of parts 26,100 3 6 Packing and shipping Number of boxes shipped 50,000 50,000 75,000 Total overhead $ 178,100 Required: a. Compute the amount of overhead to...
Inventory Control You are the production manager of GVT Manufacturing, a company that manufactures a wide...
Inventory Control You are the production manager of GVT Manufacturing, a company that manufactures a wide range of products, including fire extinguishers. Data shows that GVT is projected to manufacture 30,000 of these fire extinguishers next year. A production-year for GVT covers 300 days. Information on the product also reveals that each extinguisher requires one handle. Additional information gleaned from the production records shows the following: annual carrying cost per handle is US$1.50; production setup cost is US$150 and daily...
Create a Control Limit chart for the following: You are a manager at RadioTag Inc., a...
Create a Control Limit chart for the following: You are a manager at RadioTag Inc., a maker of RFID tags for US military and private use (e.g., Wal Mart). Your process assembles radio id tags to certain specifications – 95.5 confidence intervals, however as they come off the assembly line a test is run on each tag to determine whether the frequency works or does not (hint the data are dichotomous distributed binary). Below are the data you collected over...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT