Question: High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and

High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and packaged; and then orders are shipped to the customers, A fixed-order-quantity inventory control system (FQS) helps monitor and control these SKUs. The following information is for one of the calculators that High Tech stocks, sells, and ships Average demand Lead time Order cost Unit cost Carrying charge rate Number of weeks tandard deviation of weekly demand SKU service level Current on-hand inventory Scheduled receipts Backorders 12.5 calculators per week 3 weeks $20/order $8.000.2552 weeks per year 3.75 calculators 95 percent 35 calculators 20 calculators 2 calculators a. What are the economic order quantity? b. What are the total annual order and inventory-holding costs for the EOQ? c. What is the reorder point without safety stock? d. What is the reorder point with safety stock? e. Based on the previous information, should a fidixed-order quantity be placed, and if so, for how many calculators?
DO THIS ON EXCEL PLEASE......With the formulas used....

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!