View the step-by-step solution to:

Dan Brown, owner of the New England Seafood Store, has the only seafood store in town that carries Maine lobsters. The demand for lobsters has been...

I have attached the question in excel. This is an inventory problem.

Mr. Dan Brown, owner of the New England Seafood Store, has the only seafood store in town that carries Maine lobsters. The demand for lobsters has been sufficiently high to warrant continues air transportation of lobsters from Boston. However, Mr. Brown cannot order too many lobsters because of the ever- increasing holding costs and limited salt water space. Mr. Brown asked his son-in-law, Stuart Little, a recent graduate of a business college, to give him some help in determining the best inventory policy for lobsters. After looking over the past records, Stuart identified the following: D = 4000 lobsters per year Ch = \$0.50 per lobster per year Co = \$40 per order (including air freight) LT = 3 days The store operates 300 days per year. Quantitatively analyze the situation and answer the following multiple choice questions. 1. Determine the optimal order quantity , Q*, for lobsters. a. 557 lobsters. b. 355 lobsters. c. 657 lobsters. d. 800 lobsters. e. 400 lobsters. 2. Determine the demand rate per day. a. 13.3 lobsters. b. 10.0 lobsters. c. 23.7 lobsters. d. 9.8 lobsters 3. Determine the optimal reorder point. a. 4 lobsters. b. 12 lobsters. c. 36 lobsters. d. 40 lobsters. e. 48 lobsters 4. Compute the total variable inventory cost with the optimal Q* and R*. a. \$400 b. \$200 c. \$800 d. \$600 e. \$1000

Here is the explanation for... View the full answer

D=4000 lobsters per year
Ch=0.5\$ per lobster per year (which is our holding cost for inventory)
Co=40\$ per order (which is ordering cost)
LT=3 days
And working days are 300 per...

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents