Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 7,100 items in its inventoryand has hired Joan Blasco-Paul to manage its inventory. Joan has determined that 9% of the items in inventory are Aitems, 39% are B items, and 52% are C items. She would like to set up a system in which all A items are counted monthly(every 19 working days), all B items are counted quarterly (every 60 working days), and all C items are countedsemiannually (every 119 working days). How many items need to be counted each day?The total number of items that need to be counted each day is _______ items (round your response to the nearest wholenumber).To find the number of items counted per day for each class of items, use the following formula:Number of items counted per day=Inventoryx Percent of inventory/ Working days.Sum the number of items for each class to arrive at the total number of items that need to be counted each day.

Total Inventory = 7100 Items Inventory with Item A = 9% and counted in every 19 days Inventory with…

Answered: Lindsay Electronics, a small…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The following data represent the beginning inventory and, in order of occurrence, the purchases and sales of Meow, Inc. for an operating period. Units Unit Total Units Cost Cost Sold Beginning Inventory 50 $62 $3,100 Sale No. 1 40 Purchase No. 1 30 50 1,500 Sale No. 2 32 Purchase No. 2 40 44 1,760 Totals 120 $6,360 72 Assuming Meow, Inc. uses LIFO perpetual inventory procedures, the ending inventory cost is:
A grocery store starts each day with a stock of 245 bananas in their produce section. Daily demand for bananas is normally distributed with a mean of 200 and a standard deviation of 30. What is the store's safety stock for bananas?
The Pedal Pusher Bicycle Shop operates 7 days per week, closing only on Christmas Day. The shop pays $300 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle is estimated to be 25% of the dollar value of inventory. The shop sells an average of 25 bikes per week. Frequently, the dealer does not have a bike in stock when a customer purchases it, and the bike is back-ordered. The dealer estimates his shortage cost per unit backordered, on an annual basis, to be $250 due to lost future sales (and profits). The ordering cost for each order is $100. Determine the optimal order quantity and shortage level and the total minimum cost.
The Simple Simon Bakery produces fruit pies for freezing and subsequent sale. The bakery,which operates 5 days per week, 52 weeks per year, can produce pies at the rate of 64 pies perday. The bakery sets up the pie production operation and produces until a predetermined number(Q) of pies has been produced. When not producing pies, the bakery uses its personnel and facilitiesfor producing other bakery items. The setup cost for a production run of fruit pies is $500.The cost of holding frozen pies in storage is $5 per pie per year. The annual demand for frozenfruit pies, which is constant over time, is 5,000 pies. Determine The optimal number of production runs per year
13.20. Southwood Furniture Company is a U.S.-based furniture manufacturer that offshored all of its actual manufacturing opera- tions to China about a decade ago. It set up a distribution center in Hong Kong from which the company ships its items to the United States on container ships. The company learned early on that it could not rely on local Chinese freight forwarders to arrange for sufficient containers for the company's shipments, so it contracted to purchase containers from a Taiwanese manufacturer and then sell them to shipping companies at the U.S. ports the containers are shipped to. Southwood needs 715 containers each year. It costs $1200 to hold a container at its distribution center, and it costs $6000 to receive an order for the containers. Determine the optimal order size, min- imum total annual inventory cost, number of annual orders, and time between orders.
The Fast Service Food Mart stocks frozen pizzas in a refrigerated display case. The average daily demand for the pizzas is normally distributed, with a mean of 8 pizzas and a standard deviation of 2.5 pizzas. A vendor for a packaged food distributor checks the market’s inventory of frozen foods every 10 days, and during a particular visit, there were no pizzas in stock. The lead time to receive an order is 3 days. Determine the order size for this order period that will result in a 99% service level. During the vendor’s following visit, there were 5 frozen pizzas in stock. What is the order size for the next order period?
Please do not give solution in image format thanku
Peet’s Coffees in Menlo Park, California, sells Melitta Number 101 coffee filters at afairly steady rate of about 60 boxes of filters monthly. The filters are ordered from asupplier in Trenton, New Jersey. Peet’s manager is interested in applying some inventorytheory to determine the best replenishment strategy for the filters.Peet’s pays $2.80 per box of filters and estimates that fixed costs of employee timefor placing and receiving orders amount to about $20. Peet’s uses a 22 percent annualinterest rate to compute holding costs.c. What are the average annual holding and fixed costs associated with these filters,assuming they adopt an optimal policy?
Ray wishes to determine the optimal order quantity for its best-selling bike in his bike store. Ray pays the supplier a wholesale price of $118 each for this bike. Ray has estimated the average daily demand for this bike is 23 units. The store opens 304 days a year. The cost to carry one bike in the store for a whole year is 8% of the unit bike cost. Ray has estimated that, on average, the order processing cost, i.e., ordering cost, with the bike supplier each time is $152, and it roughly takes 20 working days to receive the order from the supplier. Ray wishes to avoid the stock-out situation with a probability of 95%, and this requires Ray to carry a safety stock of 30 bikes in the store. What is the optimal order quantity (EOQ value) that Ray should order each time from the bike supplier to minimize his long-run inventory cost?
The TCC Art Gallery prints a brochure for visitors to the senior art showcase it sponsors at the college. There are about 16000 visitors per year to this event (held year round). Holding costs for the brochures are 25% and it costs $40 to place an order with the printer. The printer has offered the following discount schedule: Category Order Size Unit Cost 1 0 - 1499 $2.60 2 1500 - 2999 $2.30 3 3000 and over $1.90 Answer the following questions in a text box in the worksheet excel How many orders should be made? How many brochures should be printed at a time?
ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% How much is the EOQ for each quantity discount? How much should be the EOQ?
Jantel Mitchell's bakery prepares all its cakes between 4 A.M.and 6 A.M.so they will be fresh when customers arrive. Day-old cakes are virtually always sold, but at a 50% discount off the regular $16 price. The cost of baking a cake is $10, and demand is estimated to be normally distributed, with a mean of 25 and a standard deviation of 7. What is the optimal stocking level? Refer to the standard normal table for z-values. The optimal stocking level for the bakery is cakes (round your response to the nearest whole number).

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS