The items listed in the following table are stored in a warehouse.ITEMWEEKLY TRIPSAREA NEEDED (BLOCKS)A68343288C5410413E140a) Which item should be stored at the very front (closest to the dock)?Fill in the table below for the ratios of the number of trips to blocks of storage area (enter your responses as whole numbers).ITEMTRIPS/BLOCKSAEV should be stored at the very front (closest to the dock).b) Which item should be stored at the very back (furthest from the dock)?V should be stored at the very back (furthest from the dock).

Given - Item Weekly Trips Area Needed (BLOCKS) A 68 34 B 328 8 C 54 2 D 104 13 E 140 5

Answered: The items listed in the following table…

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

Two items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by letter. Finished goods Inventory,June1 $61,600 $46,200 (e) Cost of goods manufactured 329,000 (c ) 484,800 Cost of finished goods available for sales (a) $260,400 $540,000 Finished goods Inventory ,June30 72,800 61,600 (f) Cost of goods sold (b) (d) $513,600
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
Hello. I need help with this Order-up-to policy question for homework. I'm stuck! You play a Retailer in the Beer Game. You receive orders directly from the Customer and place orders with the Wholesaler. When you place an order, it takes 2 weeks for the order to be received by the Wholesaler and 2 weeks for the shipment from the Wholesaler to arrive to your warehouse. One period is one week in the game. You are charged $0.5 for each unit of inventory per week, and $1.00 for each unit of backlog per week. It has been estimated that the Customer weekly demand follows a normal distribution with a mean 50,000 cases and a standard deviation 10,000 cases. What should be the order-up-to level to minimize holding and backorder costs? What safety stock should you keep? Assume that the Wholesaler keeps enough inventory to cover your demand and delivers the beer after the lead time with no uncertainty.
I need assistance to solve the following problem in Operations Analysis. 2) A coffee store is experiencing sales of 280 pounds of coffee beans per year. The supplier charges the store $2.40 per pound, and the paperwork and labor costs incurred by the store in placing an order total $45 per order. Holding costs are based on 20% interest rate per annum. a) What is the optimal order size (write down the model name, its parameters and formula)? b) What is the time between order placements (include the formula)? c) What is the average annual holding cost (include the formula)? d) If the lead time is 3 weeks, what is the reorder level based on inventory on hand (include the formula)?
The Hawkins Supply Company is currently faced with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective?
In each of the following, name the term defined or answer the question. Answers are listed at the bottom.1. The model was most appropriate for making a one-time purchase of an item.2. The model most appropriate when inventory is replenished only in fixed intervals of time—for example, on the first Monday of each month.3. The model most appropriate when a fixed amount must be purchased each time an order is placed.4. Based on an EOQ-type ordering criterion, what cost must be taken to zero if the desire is to have an order quantity of a single unit?5. The term used to describe demand that can be accurately calculated to meet the need of a production schedule, for example
Average Inventory Calculation—Fixed–Order Quantity ModelSuppose the following item is being managed using a fixed–order quantity model with safety stock.Annual demand (D) = 1,000 unitsOrder quantity (Q) = 300 unitsSafety stock (SS) = 40 unitsWhat are the average inventory level and inventory turn for the item?
The Big Buy Supermarket stocks Munchies Cereal. Demand for Munchies is 4,000 boxes peryear (365 days). It costs the store $60 per order of Munchies, and it costs $0.80 per box per yearto keep the cereal in stock. Once an order for Munchies is placed, it takes 4 days to receive theorder from a food distributor. Determine The optimal order size
i have found anther answer for this question on bartleby and it has a lot less working out and he didnt give answer to second question but the answer he gave for the first one is very different i am not sure which one to use below is his answer: Step 1: Basic Information The question is related to Economic order quantiy Economic Order Quantity is that level of inventory at which ordering cost and handling cost are minimum. It is calculated with the help of following formula Economic Order Quantity = √2RO ÷ C R = Annual Requirment C = Carrying or Holding cost O = Ordering Cost Step 2: Solution Economic Order Quantity = √2RO ÷ C Economic Order Quantity = √2 × 3000 × 20 ÷ 4.25 Economic Order Quantity = √28,235.294117647 Economic Order Quantity = 168.0336100834 pounds R = Annual Requirment i.e.250 × 12 = 3000 pounds per annum. C = Carrying or Holding cost i.e. £4.25 O = Ordering Cost i.e. £20 Quantity to be ordered = 168.03 pounds. Supplier = Vendor 1 should be used as the cost…
. MBPF Inc. manufactures prefabricated garages. The manufacturing facility purchases sheet metal that is formed and assembled into finished products—garages. Each garage needs a roof and a base, and both components are punched out of separate metal sheets prior to assembly. Production and demand data for the past eight weeks are shown in Table below. Observe that both production and demand vary from week to week. Now, track the inventory at the end of each week, measured in number of finished garages. Also, construct the inventory build-up diagram. MBPF Inc. manufactures prefabricated garages. The manufacturing facility purchases sheet metal that is formed and assembled into finished products—garages. Each garage needs a roof and a base, and both components are punched out of separate metal sheets prior to assembly. Production and demand data for the past eight weeks are shown in Table below. Observe that both production and demand vary from week to week. Now, track the inventory at…
QUESITON 26 Calculate the percentage of assets committed to inventory, where Panda lnc has $44,000,000 in total assets and 11,400,000 of inventory. QUESITON 27 Supply chain management is ... A.a set of procedures connecting suppliers to customers B.Design, operation and improvement of productive systems C.A sequence of activities across organizations that are involved in producing and delivering a product or service D.a series of activities from suppliers to customers that add value to a product or service QUESITON 28 SCOR stands for A.Supply Chain Operations Reference model B.Supply Chain Operations Resilience C.Supply Chain Organsational Resources D.
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…

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