Question: please show me the excel equations :) Question 2 Carpet City orders Soft Shag from the Carpet City Mill. The production rate at the mill

please show me the excel equations :)please show me the excel equations :) Question 2

Question 2 Carpet City orders Soft Shag from the Carpet City Mill. The production rate at the mill is 1200 yards per day, and the mill operates 260 days per year. The annual carrying cost is $0.63, the order cost is $425, and a lead time for receiving an order is 7 days. a) Use a 3-month moving average to forecast a value for Month 9. Use this forecast as the demand, with a daily demand assuming this is for September --- a 30-day month. b) Compute the optimal order quantity, the total monthly and annual minimum inventory cost, and the reorder point. a) Month 1 2 3 4 5 6 7 8 9 3-Month Demand Moving Average 8,000 12,000 7,000 9,000 15,000 11,000 10,000 12,000 b) yards per month or yards per day Demand = Order costs, C,= Annual carrying costs, Ce = Monthly carrying costs, Ce = Lead time = Production, p = yards per day What is the optimal order quantity? (= yards What is the monthly total minimum inventory cost? TC = What is the annual total minimum inventory cost? TC - What is the reorder point? R = yards

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!