MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 7,100 items in its inventory and has hired Joan
Blasco-Paul to manage its inventory. Joan has determined that 8% of the items in inventory are A items, 30% are B items, and 62% are C items.
She would like to set up a system in which all A items are counted monthly (every 21 working days), all B items are counted quarterly (every 60
working days), and all C items are counted semiannually (every 124 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 whole number).
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 7,100 items in its inventory
and has hired Joan Blasco-Paul to manage its inventory. Joan has determined that 9% of the items in inventory are A
items, 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 counted
semiannually (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 whole
number).
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.
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 6,900 items in its inventory and has hired Joan Blasco-Paul to manage its inventory. Joan has determined that 12% of the items in inventory are A items, 34% are B items, and 54% are C items. She would like to set up a system in which all A items are counted monthly (every 22 working days), all B items are counted quarterly (every 62 working days), and all C items are counted semiannually (every 123 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 response to the nearest whole number).
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 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…arrow_forwardThe 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?arrow_forwardAlgro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…arrow_forward
- Need new ansarrow_forwardESTRELLA 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% QTY SETUP HOLDING PROODUCT COST TOTAL COST Q1 25423.73 25812.5 what is the product cost what is the total cost Q2 3000 198437.5 what is…arrow_forwardESTRELLA 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?arrow_forward
- UPD Manufacturing produces a range of health care appliances for hospital as well as for home use. The company has experienced a steady demand for its products, which are highly regarded in the health care field. Recently the company has undertaken a review of its inventory ordering procedures as part of a larger effort to reduce costs. One of the company's products is a blood pressure testing kit. UPD manufactures all of the components for the kit in-house except for the digital display unit. The display units are ordered at six-week intervals from the supplier. This ordering system began about five years ago, because the supplier insisted on it. However, that supplier was bought out by another supplier about a year ago, and the six-week ordering requirement is no longer in place. Nonetheless, UPD has continued to use the six-week ordering policy. According to purchasing manager Tom Chambers, “Unless somebody can give me a reason for changing, I'm going to stick with what we've been…arrow_forwardBrynn is the owner of a spa store that operates 50 weeks per year. Dazzle Shampoo is a high margin stock-keeping unit (SKU), but the product goes out of stock frequently. She decides to use a fixed-quantity system (FQS) and orders boxes of Dazzle Shampoo containing 10 bottles per box from a vendor 160 miles away. She collects the following data with respect to the sales of Dazzle Shampoo. Demand 10 boxes per week Order Cost $40 per order Item Cost $80 per box per year Inventory-Holding Cost 15 percent per year Lead Time 3 weeks Standard Deviation in Weekly Demand 6 Service Level 96 percent Using the given data, it can be concluded that the economic order quantity (EOQ) of the Dazzle Shampoo boxes is a. more than 25 but less than or equal to 35 boxes. b. less than 25 boxes. c. more than 35 but less than or equal to 45 boxes. d. more than 55 boxes.arrow_forwardBold 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?arrow_forward
- The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…arrow_forwardA manager must set up inventory ordering systems for two new production items, P34 and P35.P34 can be ordered at any time, but P35 can be ordered only once every four weeks. The companyoperates 50 weeks a year, and the weekly usage rates for both items are normally distributed. Themanager has gathered the following information about the items.Item P34 Item P35Average weekly demand 60 units 70 unitsStandard deviation 4 units per week 5 units per weekUnit cost $15 $20Annual holding cost 30% 30%Ordering cost $70 $30Lead time 2 weeks 2 weeksAcceptable stockout risk 2.5% 2.5%a. When should the manager reorder each item?b. Compute the order quantity for P34.c. Compute the order quantity for P35 if 110 units are on hand at the time the order is placed.arrow_forwardJack Ltd is a market leader in the manufacture of apple juice. They operate areorder level system of inventory management, and the following information isavailable for green apples:Average usage 800 per dayMinimum usage 540 per dayMaximum usage 1260 per dayLead time for replenishment 16-20 dayReorder quantity 19,500 applesRequired:ii Calculate the maximum level of inventoryarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License