Jean-Marie Bourjolly's restaurant has the following inventory items that it orders on a weekly basis. Fill in the blanks in the following table. Remember that annual dollar volume (not weekly) is requested. The restaurant is open 52weeks a year. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.)The class of French fries isThe class of Oil isIDItem1 Rib eye steak23 Pasta4 Salt5 Napkins6 Tomato saucec) What is the total annual dollar volume for all items? $Lobster tail(enter you78 Pepper9 Garlic powder10 Trash can liners11 Table cloths12 Fish filets13 Prime rib roasts14 Oil15 Lettuce (case)16 Chickens17 Order pads18 Eggs (case)19 Bacon20 SugarFrench friesC♥B# Ordered per Cost/CaseWeek($)31402452331225ANOENEN was du w w w 8 N N N N w Wa whole number).312212303335106324147248311123214316621357512225644Annual DollarVolumea) What is the highest annual dollar volume for any one item? $(enter your response as a whole number).b) For the following three questions consider only Rib eye steak, French fries, and Oil items for relative classification (these are some of the items for which you computed the metrics).Given the percentages of dollar volume, the class of Rib eye steak is38,22014,3523121,2484681,7161,8728,32074,36051,792*.43,68054,6001,2488,00814,560416% of DollarVolume8.873.330.070.290.110.400.431.9317.2612.0210.1412.680.291.86.3.380.10

Answered: Image /qna-images/answer/d202028a-9fc6-40f9-bf51-5a299dddf8eb.jpg

Answered: a) What is the highest annual dollar…

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

A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .99. The order interval is 12 days, and lead time is 4 days. Average demand for one item is 63 units per day, and the standard deviation of demand is 6 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Cycle On Hand 1 38 2 10 3 93 Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number) Cycle Units 1 1019 Numeric ResponseEdit Unavailable. 1019 incorrect. 2 1047 Numeric ResponseEdit Unavailable. 1047 incorrect. 3 964 Numeric ResponseEdit Unavailable. 964 incorrect.
a car rental agency uses 96 boxes of staples a year. the boxes cost $4 each. it costs $10 to order staples, and holding costs are $0.80 per box on an annual basis. (/5) showing your work, determine: (i) the order quantity that will minimize the sum of ordering and holding boxes of staples (ii) the annual cost of ordering and carrying the boxes of staples
a school consumes liquid detergent annually. see related info, below: D = 408 gallons per year S = $20 H = $15 per gallon range price 1 to 179 $40 180 to 249 37.25 250 or more 37.19 A. initial EOQ (common minimum) is _____ (round up) B. total cost (at initial EOQ) is ___ (2 decimals) C. overall optimal order quantity is ___ show solutions
Genesis Company is a wholesaler. It purchases 60,000 units of Product X per month for sale to retailers. The cost of placing an order is P100. The cost of holding one unit of inventory for one year is P4. Note: Kindly input your answer with comma.Example: 10,000 Required: a. Compute the economic order quantity. b. How many orders would be placed under the EOQ policy? c. Compute the annual ordering cost for the EOQ. d. Compute the annual carrying cost for the EOQ. e. Compute the total inventory-related cost at the EOQ.
How do I find the Economic Order Quantity (EOQ), the optimal order quantity, and the total annual inventory cost (TC) for the products shown in the attached screenshot? Would the EOQ be ((2*C2*E2)/D2)^(1/2) for the CPU? What about the optimatal order quanitity and total annual inventory cost?
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.
Design your own inventory management problem with the required input data and answer the following questions : a. What is the optimal order size? b. What is the optimal number of orders per year? What is the optimal number of days between orders? d. What is the annual inventory cost? e. If the lead time were X days/weeks/months, what would be the reorder point? f. For what value of ordering cost would Y units of order size be optimal?
Among the following multi-period inventory models, which one has the highest probability of stockout? A. Fixed Order Quantity with Safety Stock B. Fixed Time Period Model C. Fixed Order Quantity D. Both Fixed Order Quantity & Fixed Order Quantity with Safety Stock
please solve D,E and F (a) What is the expected jet fuel yearly average demand D? =4160 tons(b) Given D, find the order lot size Q that gives the economic order quantity (EOQ). =60.39 unit(c) Given the EOQ, what is the total inventory holding cost?= $1067695.2(d) Given the EOQ, what is the total inventory ordering cost?(e) Given the EOQ, what is the total annual inventory cost?(f) What is the time between orders in weeks?
United Airlines has an agreement to buy jet fuel from Exxon. The goal is to minimize total cost (i.e., ordering cost + holding cost). The annual demand for fuel is 201,000 barrels. Exxon charges United $3740 to process each order. United incurs a holding cost of $20 per barrel. When purchasing using the EOQ (from last question), what is the order cycle time (days between orders) for United? Note: round your answer to the nearest 1 decimal place. For example, answer like 12.3 Answer: Check
An organization manufactures supplies for landscaping companies which has an annual demand of 16,000. The cost of storing each unit is $2.5/year and $50 to make an order. Say the company has 300 days of annually, answer the following questions: a. What is the optimal order quantity? b. How many orders in a year? c. How many days between orders? d. How much is the total inventory cost?
A restaurant uses 5,000 quart bottles of ketchup each year. The ketchup costs $3.00 per bottle and is served only in whole bottles because its taste quickly deteriorates. The restaurant figures that it costs $10.00 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes 3 weeks for an order to arrive. The restaurant operates 50 weeks per year. The restaurant would like to use an inventory system that minimizes inventory cost. The restaurant has figured that the most economical order size or EOQ is approx. 409 (rounding up the decimals). Suppose that things have become uncertain and that customer demand is no more constant. Customer demand is now normally distributed with mean being the same as given in the problem description and standard deviation = 30 units per week. The supply source is still very reliable and as a result the lead time is constant. Find out the safety stock needed to achieve 95% customer service level. O 55 65 075 85 None of…

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