Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Thank you in advance for your help; could you please provide an excel spreadsheet solution too, to help in my understanding? 12. E00. reorder point.

Thank you in advance for your help; could you please provide an excel spreadsheet solution too, to help in my understanding?

image text in transcribed
12. E00. reorder point. and safety stock Alexis Company uses 626 units of a product per year on a continuous basis. The product has a xed cost of $51 per order. and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed. and the rm Wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the ECG. . 1). Determine the average level of inventory. (Note: Use a SSS-day year to calculate daily usage.) c. Determine the reorder point. d. indicate which of the following variables change if the rm does not hold the safety stock: (1) order cost, (2) carrying cost. (3) total inventory cost, (4) reorder point, (5) economic order quantity. 3. Alexis' EOQ is units. (Round to the nearest whole number.) b. Alexis' average level of inventory is units. (Round to the nearest whole number.) c. Alexis' reorder point is units. (Round to the nearest whole number.) Which of the following will change if the firm does not hold the safety stock? (Select the best answer below.) O A. Carrying Cost, Total Inventory Cost. and Reorder Point O B. Reorder Point, Economic Order Quantity, and Order Cost 0 C. Order Cost, Carrying Cost, and Total Inventory Cost 0 D. Total Inventory Cost. Reorder Point, and Economic Order Quantity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Financial Accounting Theory

Authors: William R Scott

5th Edition

0132072866, 978-0132072861

Students also viewed these Accounting questions