orders food every two weeks. Her chef needs 220 # sugar for the next two weeks and, per company pol- icy, she must target to have 50 # sugar left in inven- tory at the end of the two weeks. If she currently has 70 # sugar on hand, how many pounds of sugar steak. Both Aen hreast. which yiel" 22 CHAPTER EIGHT CONTROL THROUGH THE PURCHASING PROCESS should she order? If the sugar comes in 25 # bags, how many bags does she need to order?

orders food every two weeks. Her chef needs 220 # sugar for the next two weeks and, per company pol- icy, she must target to have 50 # sugar left in inven- tory at the end of the two weeks. If she currently has 70 # sugar on hand, how many pounds of sugar steak. Both Aen hreast. which yiel" 22 CHAPTER EIGHT CONTROL THROUGH THE PURCHASING PROCESS should she order? If the sugar comes in 25 # bags, how many bags does she need to order?

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

Add two (2) new customers, two (2) old customers and two (2) new POS transactions. SalesID InvoiceNo TransDate Item Description Color Size qty Price StoreID YearID Brand Name Address CurrID YEARVAL 82605 10828 06-Dec-09 8720400000227 REGULAR CIGARS 1 21.74 TCS 2009 HENRI WINTERMANS Yetty BDS 2009 47075 45036325 26-Aug-08 POSTCARDS POSTCARDS 1 1.4 CS 2008 Guenna BDS 2008 4590 60007295 14-Jan-08 3707-11-6 BLOUSES BLK/MLT L 1 586 CC 2008 GOTTEX Yankee CORAL REEF HOTEL USD 2008 4599 60007301 15/1/2008 3007-319-18 PANTS CORAL XS 1 200 CC 2008 CUT LOOSE Quigly YEARWOOD RD BLK ROCK USD 2008
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
3. (Ch9) A store has collected the following information on one of its products: Demand = 4,500 units/year Standard deviation of weekly demand = 12 units Ordering costs = $40/order Holding costs = $3/unit/year Cycle-service level = 90% (z for 90% = 1.28) Lead-time = 2 weeks Number of weeks per year = 52 weeks a. If a firm uses the continuous review system to control the inventory, what would be the order quantity and reorder point? b. The firm decided to change to the periodic review system to control the item's inventory. For the most recent review, an inventory clerk checked the inventory of this item and found 300 units. There were no scheduled receipts or backorders at the time. How many units should be ordered? (HINT: Use the EOQ model to derive P, the time between reviews.)
b. Forward Thinking Limited (FTL) has used a fixed-time period inventory system that involvedtaking a complete inventory count of all items each month. However, increasing labor costs, areforcing FTL, to examine alternative ways to reduce the amount of labour involved in inventorystockrooms, yet without increasing other costs, such a shortage costs. Table 4 (below) is arandom sample of 20 FTL’s items.6Table 4. Annual Usage by Value of a sample of FTL’s InventoryItem Number Annual Usage ($) Item Number Annual Usage ($)1 10,700 11 2,8502 14,100 12 1,5003 4,100 13 3,3004 16,100 14 2,6005 8,200 15 110,1006 1,900 16 14,9007 84,100 17 9,6008 990 18 1,8009 1040 19 3,80010 94,100 20 12,600 (i) What would you recommend FTL to do to cut back its labor cost? (Illustrate using an ABCplan).
The Suregrip Tire Company carries a certain type oftire with the following characteristics:Average annual sales = 600 tiresOrdering cost = $40 per orderCarrying cost = 25 percent per yearItem cost = $50 per tireLead time = 4 daysStandard deviation of daily demand = 1 tirea. Calculate the EOQ.b. For a Q system of inventory control, calculate the safety stock required for service levels of 85, 90, 95,97, and 99 percent.c. Construct a plot of total inventory investment versus service level.d. What service level would you establish on the basis of the graph in part c? Discuss.
11. Determine planned purchases (a) at retail and (b) at cost for a month with the following planned figures: Round to the nearest dollar. Sales $148,000 Markdowns 8,400 BOM Stock 310,500 EOM Stock 340,000 Markup 48%
Demand forecasting and planning is not a part of inventory management function. Select one : 1.True 2.Fales
At Matthews Car Repair, customer demand for a certain brand of motor oil is normally distributed with a mean of 15 gallons and a standard deviation of 6 work-days. To be 95% sure that Compact Car Repair will not run out of oil, we should reorder when motor oil in stock is less than _______ gallons. a. 24.9 b. 22.6 c. 23.7 d. 20
Green Grass Industries Limited (GGIL) has used a fixed-time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs, are forcing GGIL, to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such a shortage costs. Table 10 is a random sample of 20 GGIL's items. Table 10. Annual Usage by Value of a sample of GGIL's Inventory Item Number Annual Usage ($) Item Number Annual Usage ($) 1 10,600 11 2,750 2 14,000 12 1,400 3 4,000 13 3,200 4 16,000 14 2,500 5 8,100 15 110,000 1,800 16 14,800 7 84,000 17 9,500 8. 890 18 1,700 9 940 19 3,700 10 94,000 20 12,500 a) What would you recommend GGIL to do to cut back its labor cost? (Illustrate using an ABC plan). b) Item 18 is critical to continued operations at GGIL. i. How would you recommend it be classified? ii. Give the reason(s) for your answer.
Gringer’s Plastics provides plastic parts to the shipbuilding industry. They gathered the following information on their inventory. Based on this data, what products would be considered A class inventory? Product Unit Cost Volume 1 $ 12.50 11,200 2 $ 325.00 160 3 $ 9.75 23,786 4 $ 8.50 29,590 5 $ 175.60 80 6 $ 1,125.99 26 7 $ 756.25 41 8 $ 24.99 5,230 9 $ 109.25 98 10 $ 33.00 7,865 11 $ 6.75 3,489 12 $ 550.80 26 Group of answer choices A. 1, 3, 4, 10 B. 2, 3, 4, 8 C. 1, 2, 4, 7 D. 2, 4, 7
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
The “how much to order” decision always has an influence on the followingcosts except: A. Annual purchasing costs.B. Annual carrying costs.C. Annual procurement costs.D. Total annual inventory costs.