Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone help me figure out where to input the numbers on the excel sheet to figure out the carrying cost for question 1 and

can someone help me figure out where to input the numbers on the excel sheet to figure out the carrying cost for question 1 and 2.
image text in transcribed
image text in transcribed
* Question Completion Status: QUESTION 1 SCENARIO A Acme retail inc. wants to import shampoo from Brazil. The daily demand at Acme stores for shampoo is 1800 bottles per day with a standard deviation of 550. Acme is considering two suppliers to source from. Option 1) Amazon Products Inc. will charge $5 per bottle, and the transportation from its factory to our distribution center (DC) in Texas will cost $0.8 per bottle. The supplier carries a large reserve of shampoo and only needs to fill up specially designed bottles for us on receiving an order. Filling up the bottles and getting them ready to be shipped takes 2 days. The transit from the factory to our DC takes 17 days. Option 2) Rio Products Inc. will charge $4.5 per bottle, and the transportation from its factory to our DC in Texas will cost $1 per bottle. Rio Products also keeps a large quantity of shampoo ready and only needs to fill up bottles upon receiving the order. It takes Rio Products 3 days to fill up the bottles and get them ready to be shipped. The transit time from its factory to our DC is 21 days. The cycle service level of shampoo is set at 95% (therefore z 1.65 and Ez = 0.020637). An out of stock situation results in lost sales which incurs a loss of 5$. For both suppliers shipments will be in FEU containers, and each container can carry 30,000 shampoo bottles. Orders will be placed for 1 container at a time and the ordering cost is $100 for both suppliers. Acme's inventory carrying cost is 0.20 $/S/year. Acme's stores are open 6 days a week, 52 weeks a year. Q1: What is the annual inventory carrying cost for Acme, if Amazon Products Inc. is selected as the supplier? (please enter your answer rounded to 2 decimal places) 10 pe QUESTION 2 What is the annual inventory carrying cost for Acme Inc, if Rio Products Inc is selected as the supplier? (please enter your answer rounded to 2 decimal places) Save All Answers Click Save and Submit to save and submit. Click Save All Answers to save all answers. In Re Data Formulas SmartArt Charts Tables Layout A Home Alignment Font Edit A A- abc Wrap Calibri (Body) - 11 Fill M- BIU Clear Paste fx C18 28 k(Stock-out cost or back-order cost $/unit) 29 S (Ordering cost $/order) 30 h (Inventory holding cost $/$/year) 0.4 31 32 33 Intermediate Calculations 34 Q(EOQ Order Qty / Batch Size) 35 sdl (Std dev of demand during lead-time) 36 AIL (Avg. Inventory Level) 37 N (number of ordering cycles) 38 Fill Rate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 24 - The Auditors??? Opinion

Authors: Kate Mooney

2nd Edition

0071719466, 9780071719469

More Books

Students also viewed these Accounting questions

Question

What would you do?

Answered: 1 week ago