Andria Mullins, financial manager of Webster Electronics, has been asked by the firm's CEO, Fred Weygandt, to evaluate the company's inventory control techniques and to lead a discussion of the subject with the senior executives. Andria plans to use as an example one of Webster's "big ticket" items, a customized computer microchip which the firm uses in its laptop computer. Each chip costs Webster P200, and in addition it must pay its supplier a P1,000 fee on each order. Further, the minimum order size is 250 units; Webster's annual usage forecast is 5,000 units; and the annual carrying cost of this item is estimated to be 20 percent of the average inventory unit cost. Andria plans to begin her session with the senior executives by reviewing some basic inventory concepts, after which she will apply the EOQ model to Webster's microchip inventory. Question: Why is inventory management vital to the financial health of most firms?

Andria Mullins, financial manager of Webster Electronics, has been asked by the firm's CEO, Fred Weygandt, to evaluate the company's inventory control techniques and to lead a discussion of the subject with the senior executives. Andria plans to use as an example one of Webster's "big ticket" items, a customized computer microchip which the firm uses in its laptop computer. Each chip costs Webster P200, and in addition it must pay its supplier a P1,000 fee on each order. Further, the minimum order size is 250 units; Webster's annual usage forecast is 5,000 units; and the annual carrying cost of this item is estimated to be 20 percent of the average inventory unit cost. Andria plans to begin her session with the senior executives by reviewing some basic inventory concepts, after which she will apply the EOQ model to Webster's microchip inventory. Question: Why is inventory management vital to the financial health of most firms?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

ANT Infra orders two kinds of precast items: A and B for use in its projects from two different suppliers. The precasts are needed throughout the entire 52-week year. Precast A are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. While, precast B is ordered from a supplier who delivers by every three weeks. Data for both precast items are as follows:Item Precast A Precast BAnnual demand 10,000 5,000Holding cost (% of item cost)20% 20%Order cost $150 $25Lead time 4 weeks 1 weekSafety stock 55 units 5 unitsItem cost $10.00 $2.00 a. Employ Q system for precast A and calculate the EOQ, the reorder point, total inventory cost? b. Employ P system for precast B and estimate the target level inventory and total inventory cost?
Long last Appliance Store has a demand of 1300 units per month for one of its fast selling portable smoothie machine (model G), it incurs a fixed order placement, transportation and receiving cost of $3000 each time an order is delivered. Each machine cost the company $550 and the company has a holding cost of 12%. The company has two other models of the smoothie machine which are also popular with consumers. Evaluate the company’s inventory management policy if lots for each model are ordered and delivered independently by determining the following: The optimal order size The cycle inventory The number of orders per year The annual ordering and holding cost The total cost of the inventory Briefly state rationale for the approach used for (a-e)
ABC firm uses roughly 3,400 pounds of chemical dye a year. Currently, the firm purchases 300 pounds per order and pays P120.00 per pound. The supplier has just announced that orders of 1,000 pounds or more will be filled at a price of P80.00 per pound. The manufacturing firm incurs a cost of P4,000.00 each time it submits an order and assigns an annual holding cost of 17% of the purchase price per pound. a. Determine the order size that will minimize the total cost.b. If the supplier offered the discount at 1,500 pounds instead of 1,000 pounds, what order size would minimize total cost?
Cryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…
Grand Styles Furniture Store is overstocked in (has excess inventory of) one type of chair. Based on the Price-Demand Relationship, what advice would you provide to the store manager to deal with this problem? Fancy Fashions sells jeans for $59 and sweaters for $39. To increase sales of jeans and sweaters, Fancy Fashions promotes this Product Price Bundle: “Buy a pair of jeans and a sweater for $98”. Will this Product Price Bundle will work well to increase the sales of jeans and sweaters?
A Mercedes dealer must pay $20,000 for each carpurchased. The annual holding cost is estimated to be 25%of the dollar value of inventory. The dealer sells an averageof 500 cars per year. He believes that demand is backloggedbut estimates that if he is short one car for one year he willlose $20,000 worth of future profits. Each time the dealerplaces an order for cars, ordering cost amounts to $10,000.Determine the Mercedes dealer’s optimal ordering policy.What is the maximum shortage that will occur?
The catering manager of La Vista Hotel, LisaFerguson, is disturbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enoughknives. She decides she needs to order some more silverware,but wants to take advantage of any quantity discounts hervendor will offer.For a small order (2,000 or fewer pieces), her vendorquotes a price of $1.80Ypiece.If she orders 2,001–5,000 pieces, the price drops to$1.60Ypiece. 5,001–10,000 pieces brings the price to$1.40Ypiece, and 10,001 and above reduces the price to $1.25.Lisa’s order costs are $200 per order, her annual holdingcosts are 5%, and the annual demand is 45,000 pieces. For thebest option:a) What is the optimal order quantity?b) What is the annual holding cost?c) What is the annual ordering (setup) cost?d) What are the annual costs of the silverware itself with anoptimal order quantity?e) What is the total annual cost, including ordering,…
Bold Vision, Inc., must purchase toner from a local supplier. The company does not wish to carry raw material inventory and therefore only purchases enough toner to satisfy the demand of each individual batch of cartridges. Each toner cartridge requires one pound of toner. The raw material supplier offers Bold Vision a purchase discount of $2.00 per pound if the company orders at least 2,000 pounds at a time. Should Bold Vision accept this offer and alter its toner purchase quantity?
Kris Lee, the owner and manager of the Quality Hardware Store, is reassessing his inventory policy for hammers. He sells an average of 50 hammers per month, so he has been placing an order to purchase 50 hammers from a wholesaler at a cost of $20 per hammer at the end of each month. However, Kris does all the ordering for the store himself and finds that this is taking a great deal of his time. He estimates that the value of his time spent in placing each order for hammers is $75. What would the unit holding cost for hammers need to be for Kris' current inventory policy to be optimal according to the basic EOQ model? What is this unit holding cost as a percentage of the unit acquisition cost? What is the optimal order quantity if the unit holding cost actually is 20 percent of the unit acquisition cost? What is the corresponding value of TVC? What is TVC for the current inventory policy? If the wholesaler typically delivers an order of hammers in 5 working days (out of 25 working…
Inventory A certain bookstore chain has two stores, one in San Francisco and one in Los Angeles. It stocks three kinds of book: hardcover, softcover, and plastic (for infants). At the beginning of January, the central computer showed the following books in stock. Hard Soft Plastic San Francisco 3,000 5,000 6,000 Los Angeles 2,000 4,000 3,000 Suppose its sales in January were as follows: 700 hardcover books, 1,300 softcover books, and 1,900 plastic books sold in San Francisco, and 400 hardcover, 200 softcover, and 400plastic books sold in Los Angeles. Write the given inventory table as a 2 ✕ 3 matrix. Write the given sales figures as a similar matrix. Compute the inventory remaining in each store at the end of January.
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store’s leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a price 12% higher than the market price the distributor pays for the beans. The current market price is $0.45 per pound for Brazilian Natural and $0.67 per pound for Colombian Mild. The compositions of each coffee blend are as follows: Blend Bean Regular DeCaf Brazilian Natural 60% 40% Colombian Mild 40% 60% Romans sells the Regular blend for $3.3 per pound and the DeCaf blend for $4.5 per pound. Romans would like to place an order for the Brazilian and Colombian coffee beans that will enable the…
One of the products stocked at Weiss’s paint store, mentioned in Problem 14, is a certain type of highly volatile paint thinner that, due to chemical changes in the product,has a shelf life of exactly one year. Al Weiss purchases the paint thinner for $20 a galloncan and sells it for $50 a can. The supplier buys back cans not sold during the yearfor $8 for reprocessing. The demand for this thinner generally varies from 20 to 70cans a year. Al assumes a holding cost for unsold cans at a 30 percent annual interestrate.a. Assuming that all values of the demand from 20 to 70 are equally likely, what is theoptimal number of cans of paint thinner for Al to buy each year?b. More accurate analysis of the demand shows that a normal distribution gives abetter fit of the data. The distribution mean is identical to that used in part (a), andthe standard deviation estimator turns out to be 7. What policy do you nowobtain?