Regional Supermarket is open 355 days per year. Daily use of cash register tape averages 20 rolls. Usage appears normallydistributed with a standard deviation of 2 rolls per day. The cost of ordering tape is $.75, and carrying costs are 41 cents per roll a year.Lead time is 4 days.Use Table1 and Table2.a. What is the EOQ? (Round your answer to the nearest whole number.)EOQ118b. What ROP will provide a lead time service level of 51.6 percent? (Round up your answer to the nearest whole number.)ROP61

Given that Today Days = 355 Daily Usage = 20 Annual Demand = 355×20 = 7100 Standard Deviation = 2…

Answered: Regional Supermarket is open 355 days…

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

The company uses cooking oil in its business. The usage of cooking oil is normally distributed with an average of 30 gallons per week and a standard deviation of four gallons per week. The manager asked you to help him decide how to reorder cooking oil in order to achieve a service level of 97.5 percent . Lead time is nine days. a) If cooking oil can be ordered as needed, what reorder point should be used? Answer in 2 decimal places.b) If a fixed interval of 20 days is specified, how much safety stock should the company carry. Answer in 2 decimal places.
The total stockout cost = $ enter your response here. (Enter your response as a whole number.)
A local distributor for a national tire company expects to sell approximately 8,660 tires of a certain size and tread design next year. Annual carrying cost is $15 per tire and ordering cost is $67. The distributor operates 283 days a year. a. What is the EOQ? (Round your answer to a whole number.) EOQ b. How many times per year does the store reorder? (Round your answer to two decimal points.) Number of Orders per Year c. What is the length of an order cycle? (Round your answer to two decimal points.) Length of Order Cycle d. What will the total annual carrying and ordering cost be if the EOQ quantity is ordered? (Round your answer to a whole number.) Total Annual Inventory Cost Novt
It is due today. Please I need help The images are how you are going to do it. For b, I thought the answer for the reorder point was 132, but it is false(not correct). I find a, but i need help with b. 1. Sam's Cat Hotel operates 52 weeks per year, 5 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.50 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. ≻Demand = 100 bags/week ≻Order cost = $58/order ≻Annual holding cost = 29 percent of cost ≻Desired cycle-service level=92 percent ≻Lead time = 1 week(s) (5 working days) ≻Standard deviation of weekly demand = 18 bags ≻Current on-hand inventory is 300 bags, with no open orders or backorders. a. What is the EOQ? Sam's optimal order quantity is 445 bags. (Enter your response rounded to the nearest whole number.) What would be the average time between orders (in weeks)? The average time between…
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
An electronics retailer carries a particular cellular telephone with the following characteristics:Average monthly sales = 120 unitsOrdering cost = $25 per orderCarrying cost = 35 percent per yearItem cost = $300 per unitLead time = 4 daysStandard deviation of daily demand = .2 unitWorking days per year = 250a. Determine the EOQ.b. Calculate the reorder point for a 92 percent service level, assuming normally distributed demand.c. Design a Q system for this item.d. What happens to the reorder point when the lead time changes? What happens to the reorder point when the standard deviation of demand changes?
Thompson Paint Company uses 60,000 gallons of pigment per year. The cost of ordering pigment is $200 per order, and the cost of carrying the pigment in inventory is $1 per gallon per year. The firm uses pigment at a constant rate every day throughout the year. a. Calculate the EOQ. b. If it takes 20 days to receive an order once it has been placed, determine the reorder point in terms of gallons of pigment. (Note: Use a 365-day year.)
Calculate how many of each packet should the store order to maximize the revenue associated with information packets, and what is the store’s expected revenue. WITHOUT EXCEL
ABC classification divides on-hand inventory into three classes, generally based upon a. item quantity. b. unit price. c. the number of units on hand. d. annual demand. e. annual dollar value.
Weekly Average Demand 110 Standard deviation of (weekly) demand 30 Setup cost ($) 1400 Lead time (in weeks) 2 Procurement cost ($) 200 Holding cost /unit/week ($) 3 You are given the demand and inventory related information about a grocery store’s product in the table. The store is open for 46 weeks in a year. What is the reorder point if it wants to achieve a service level of 97%? (Do not round your intermediate calculations. Round your final answers to the nearest whole number.
Demand for a product is relatively constant at 5 units per day. Lead time for this product is normally distributed with a mean of 20 days and a standard deviation of 4 days. (a) What reorder point provides an 80 percent service level? (b) What reorder point provides a 90 percent service level? (c) If the lead time standard deviation can be reduced from 4 days to 1, what reorder point now provides 90 percent service? How much is safety stock reduced by this change?
I need answers A company uses on an average 216 parts a day with a standard deviation of 16 parts per day in a manufacturing process. Cost of placing and receiving an ordering is BDT 40,000. Estimated monthly carrying cost is BDT 90 per part. Orders are delivered approximately 7 days after being placed. The delivery time is normal with a mean of 7 days and a standard deviation of 2 days. The company is open 360 days per year. Find the order quantity that is economical. If the Company takes 3% stock out risk, then find safety stock (SS) quantity and Re-Order Point? 3.If the supplier offers a discount of BDT 8 per circuit board for purchasing of 4000 boards at a time, then financially evaluate and justify whether the company will go with the offer or not? 4.The person who orders the boards follows this rule: Order when the amount on…

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