Question 3, Problem 12 Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answerthe following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.)Dollar% of Total DollarItemAnnual Demand Cost/UnitVolumeVolumeA225020B840001248,00067,5005.56C71500457.81D11502000E910002020,0002.31F36015034.721.39G22001500300,00012,000H26002015300300J8250012,5001.45ItemAnnual DemandCost/UnitA225020B8400012C7150045D11502000E9100020F360150G22001500H26002015300300J825005

Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Dollar Item Annual Demand Cost/Unit Volume % of Total Dollar Volume A2 250 20 B8 4000 12 48,000 5.56 C7 1500 45 67,500 7.81 D1 150 2000 E9 1000 20 20,000 2.31 F3 60 150 G2 200 1500 300,000 34.72 H2 600 20 12,000 1.39 15 300 300 J8 2500 12,500 1.45

Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Dollar Item Annual Demand Cost/Unit Volume % of Total Dollar Volume A2 250 20 B8 4000 12 48,000 5.56 C7 1500 45 67,500 7.81 D1 150 2000 E9 1000 20 20,000 2.31 F3 60 150 G2 200 1500 300,000 34.72 H2 600 20 12,000 1.39 15 300 300 J8 2500 12,500 1.45

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

As part of the employment interview for an accounting job at Sound Design, you have been asked to answer the questions below, based on an invoice from one of Sound Design's vendors, Target Electronic Wholesalers. Invoice Stock # Description Unit Price Amount 4811V Stereo Receivers 50 ✕ $293.50 = _______________________ 511CX Blu-Ray Players 25 ✕ $136.28 = _______________________ 6146M Home Theater Systems 40 ✕ $656.12 = _______________________ 1031A LCD TVs 20 ✕ $594.00 = _______________________ Merchandise Total _______________________ Insurance + Shipping $1,250.00 Invoice Total _______________________ An invoice. The top of the invoice is divided into several distinct sections. The first section is located in the top left of the invoice, is unlabeled, and contains an image of a target with an arrow in the center of the target. The second section is located in the top center of the invoice, is unlabeled,…
Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) % of Total Dollar Dollar Volume Item Annual Demand Cost/Unit Volume A2 250 20 48,000 67,500 5.56 7.81 B8 4000 12 C7 1500 45 D1 150 2000 E9 1000 20 20,000 2.31 F3 60 150 300,000 12,000 G2 200 1500 34.72 H2 600 20 1.39 15 300 300 J8 2500 12,500 1.45
Please complete the problem usinf EXCEL, Show ALL formulas Demand for a popular athletic shoe is nearly constant at 800 pairs per week for a regional division of a national retailer. The cost per pair is $54. It costs $72 to place an order, and annual holding costs are charged at 22% of the cost per unit. The lead time is two weeks. a. What is the EOQ? b. What is the reorder point? c. What is the cycle time? d. What is the total annual cost?
Do you think the safety stock (safety inventory) could be negative? What is the meaning of a negative safety inventory (hint: safety stock is the difference between the optimal inventory and the average demand)?
Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item Annual Demand Cost/Unit Dollar Volume % of Total Dollar Volume A2 250 20 5000 .58 B8 4000 12 48,000 5.56 C7 1500 45 67,500 7.81 D1 150 2000 300000 34.72 E9 1000 20 20,000 2.31 F3 60 150 9,000 1.04 G2 200 1500 300,000 34.72 H2 600 20 12,000 1.39 15 J8 58 300 2500 300 5 90,000 12,500 10.42 1.45 For the following two questions consider only items A2 and F3 for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item A2 should be classified as B C A
What does the ABC analysis entail! What is the underlying premise? What are the three criteria for conducting an ABC inventory analysis?
As inventory manager, you must decide on the order quantity for an item that has an annual demand of 2,000 units. Placing an order costs you $20 each time. Your annual holding cost, expressed as a percentage of average inventory value, is 20 percent. Your supplier has provided the following price schedule:Minimum Order Quantity Price per Unit1 $2.50200 $2.40300 $2.251,000 $2.00What ordering policy do you recommend?
The children’s buyer needs to average a 51% markup. He needs topurchase 300 dresses that will retail for $28,200 total. He hasalready placed an order for 148 dresses at $42.00 each (cost) thatwill retail for $90.00 each. What is the most that he can pay ofeach of the remaining dresses in order to obtain the 51% markup?Round to 2 decimal points.
An ophthalmologist's office operates 52 weeks per year, 6 days a week. It purchases disposable contact lenses for $11.70 per pair and sells for $50. The demand is 90 pairs per week. Order cost is $54 per order. Annual interest rate is 27%. Lead-time is 3 weeks. Standard deviation of weekly demand is 15 pairs. Given that 98% service-level. Clearly identify different types of stocks: cycle, safety and pipeline. a. Find a (Q, r) policy for this situation c. Find average service level (fill rate) of the policy (a) d. Find average backorder level of the policy (a) e. Find average inventory level of the policy (a)
Variety Manufacturer purchases a component from a Asian supplier. The demand for that component is exactly 70 units each day. The company is open for business 250 days each year. When the company reorders the product, the lead time from the supplier is exactly 10 days. The product costs $14.00. The company determined that its inventory carrying cost is 20%. The company’s order cost is $30.00. What is the annual holding cost?
Sam is at the post office to mail a package. After he pays for mailing the package, the clerk asksif he would like to buy some stamps. Sam pauses to think before he answers. He doesn’t have acredit card with him. After paying for the package, he has about $30 in his pocket. Analyze thisfrom an inventory standpoint. Identify the relevant considerations.
10 Use the information presented in the graph to answer the following questions: Annual Cost C3 C2 Q1 You are also given the following information: Q1 =450 .Q2 = 700 C1 = 350 C2 = 750 1300 Q2 Order Quantity Which annual inventory cost component does the blue line represent? Total cost Which annual inventory cost component does the green line represent? Holding cost What is the Economic Order Quantity (EQ9) based on th Which annual inventory cost component does the red line represent? Ordering cost 220