Barbara Flynn's company has compiled the data below on a small set of products. Based on the percentages of dollar volume, perform an ABC analysis on her data by completing the table below. Assume that class A items representabout 72% of the total dollar usage, class B-about 23%, class C-less than 5% (round your responses to the nearest whole number).ItemABCDEAnnual Demand5075150500400Unit Cost$90$140$100$70$90Annual Dollar Volume Classification$4,500$10,500$

ItemAnnual DemandUnit costA5090B75140C150100D50070E40090

Answered: Barbara Flynn's company has compiled…

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

Knowing how to use the ABC analysis, make up a list of 10 items in a stores inventory, then decide which 10 items sold at the store would constitute 80% of the revenue and create a Word document using the ABC analysis.
Please give fast answer. And give typed answer. I wil give positive rating. Economic Production Quantity (EPQ) TC = D * C + (D / Q) * S + (Imax / 2) * H A bicycle manufacturer uses 50,000 wheels per year for its popular cycle. The firm can make its own wheels, which it can produce at 600 per day. Assembly is uniform numbers over the entire year. The carrying cost is $1.00 per wheel per year, and the setup cost for a production run of wheels is $45. Consider that the plant operates 250 days per year, what is the order quantity and Imax? Using the same numbers, calculate the Average Inventory per day to determine inventory performance.
The total stockout cost = $ enter your response here. (Enter your response as a whole number.)
can you please help me answer this question.... Rebar Company prepared the following analysis of its year-end inventory on December 31. First, determine the total lower of cost or market value for each product in Rebar Company's inventory. Second, prepare the journal entry needed at year-end to value the inventory at LCM, if applicable. Historical Cost Replacement Cost Product Quantity per unit per unit A 17 $430 $499 B 140 325 299 C 38 75 69
That One Book sells its books through The Witch and the Wardrobe bookstores. It costs That One Book $0.80 to print each book; it sells the book to The Witch and the Wardrobe for $2.50. The Witch and the Wardrobe then sells the books at retail for $6.00. Whatever doesn’t sell gets thrown away. Demand for the book each issue is normal with a mean of 5219 and a standard deviation of 1610. To give The Witch and the Wardrobe incentive to order more books, it proposes a revenue-sharing contract. Instead of selling the book to The Witch and the Wardrobe for $2.50, That One Book will sell its books to The Witch and the Wardrobe for only $1.00. However, for each book that The Witch and the Wardrobe sells at retail, The Witch and the Wardrobe must give $2.00 back to That One Book. With this revenue sharing agreement in place, what is the optimal order amount that will maximize The Witch and the Wardrobe expected profit? Please do fast ASAP
At a recent manufacturing workshop, XYZ, Incorporated explained that demand for disposable masks increase rapidly in March 2020 when quarantine mandates first took effect. At the time, retailers could only place a single order to cover demands through the end of the summer. A certain retailer purchased disposal masks from a supplier at a cost of $20 per unit and sold them for $30 per unit. By the end of summer, demand for masks subsided considerably and all masks that weren't sold during the summer could be sold at a discounted price of $18 per unit. The retailer estimated that demand between March and August would be Normally distributed with mu = 10,000 and sigma = 1525 units With, supply chains becoming more stable since March 2020, the retailer is currently in the process of establishing a contract with a disposable mask supplier. The supplier has agreed to sell masks to the retailer for $18 per unit and will make deliveries any time the supplier places an order for a cost of $100…
Which one of the following represent FIFO method of inventory evaluation? a. Old merchandise is sold first b. Average number of goods are sold c. Old items remain in inventory d. New merchandise is sold first
You are in charge of inventory control of a highly successful product retailed by your firm. Weekly demand for this item varies, with an average of 200 units and a standard deviation of 16 units. It is purchased from a wholesaler at a cost of $12.50 per unit. You are using a continuous review system to control this inventory. The supply lead time is 4 weeks. Placingan order costs $50, and the inventory carrying rate per year is 20 percent of the item’s cost. Your firm operates 5 days per week, 50 weeks per year.a. What is the optimal ordering quantity for this item?b. How many units of the item should be maintained as safety stock for 99 percent protection against stockouts during an order cycle?c. If supply lead time can be reduced to 2 weeks, what is the percent reduction in the number of units maintained as safety stock for the same 99 percent stockout protection?d. If through appropriate sales promotions, the demand variability is reduced so that the standard deviation of weekly…
Please help with the numbers given below! Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 80 $215 81 160 $195 161 320 $175 321 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 80 $215 81 160 $195 161 320 $175 321 and up $155 172
SoundsUp, a local amphitheater is getting ready for the upcoming summer concert season. They want to purchase reusable plastic water bottles to sell to concert attendees. Bottles cannot be reused as they will be customized with that week's artist and date. The expectation for this upcoming concert is an average demand for 3000 bottles with a standard deviation of 600. The bottles sell for $20.00 each and cost SoundsUp $12 per bottle. In the event some bottles are left over after the concert, a local radio station has indicated that they will purchase some of the leftover bottles for $15 per bottle for use in promotions, but they have not committed to any particular number that they will buy. SoundsUp estimates a 5% chance that the radio station will purchase no bottles, a 10% chance they purchase 150, a 40% chance they purchase 175, a 30% chance they purchase 225, and a 15% chance they purchase 275. If SoundsUp has any leftover bottles that are not purchased by the radio station, then…
21- Which one of the following represent FIFO method of inventory evaluation? a. Old items remain in inventory b. Old merchandise is sold first c. New merchandise is sold first d. Average number of goods are sold
The manager of an auto parts store is reviewing the inventory policy for one of their fastest selling products — car batteries. The store sells an average of 40 car batteries every week. The cost to hold one battery in inventory for a year is $15. The ordering cost per order is estimated at $50. The store operates all 52 weeks in a year.Use the information in Scenario 9.5. If the manager decides to order at the economic order quantity, what is the sum of the annual ordering cost and holding cost? Group of answer choices greater than $1800 but less than or equal to $2100

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