Please need help ASAP. Looking for help with my formulas (grade of 63% with these answers). Thank you!
D17 =avergae(C14:C16) *formula dragged down through D22
D26 =D22
F26 =D22/30
D27 and D28 Given
D29 =D28/12
D30 and D31 given
D35 =(2*D26*D27/D29)^(1/2)
D38 =(D26/D35)*D27+(D35/2)*D29
D41 =D38*12
D44 =D30*F26
j 2 3 A B D E G . 1 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. 4 5 6 7 8 9 10 11 b) Compute the optimal order quantity, the total monthly and annual minimum inventory cost, and the reorder point. 12 13 a) 14 15 16 17 18 Month 1 2 3 4 5 3-Month Demand Moving Average 8,000 12,000 7,000 9,000 9,000 15,000 9,333 11,000 10,333 10,000 11,667 12,000 12,000 11,000.00 19 6 20 7 8 9 21 22 23 24 25 b) 26 27 366.67 yards per day 11,000 yards per month or $425 28 0.63 Demand = Order costs, C, - Annual carrying costs, C. = Monthly carrying costs, C = Lead time = Production, p = 29 0.05 7.00 1,200.00 yards per day 30 31 32 33 34 35 36 37 What is the optimal order quantity? Q = 13,345.23 yards What is the monthly total minimum inventory cost? TC = $700.62 38 39 40 41 42 43 44 What is the annual total minimum inventory cost? TC $8,407.50 What is the reorder point? R = 2566.67 yards j 2 3 A B D E G . 1 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. 4 5 6 7 8 9 10 11 b) Compute the optimal order quantity, the total monthly and annual minimum inventory cost, and the reorder point. 12 13 a) 14 15 16 17 18 Month 1 2 3 4 5 3-Month Demand Moving Average 8,000 12,000 7,000 9,000 9,000 15,000 9,333 11,000 10,333 10,000 11,667 12,000 12,000 11,000.00 19 6 20 7 8 9 21 22 23 24 25 b) 26 27 366.67 yards per day 11,000 yards per month or $425 28 0.63 Demand = Order costs, C, - Annual carrying costs, C. = Monthly carrying costs, C = Lead time = Production, p = 29 0.05 7.00 1,200.00 yards per day 30 31 32 33 34 35 36 37 What is the optimal order quantity? Q = 13,345.23 yards What is the monthly total minimum inventory cost? TC = $700.62 38 39 40 41 42 43 44 What is the annual total minimum inventory cost? TC $8,407.50 What is the reorder point? R = 2566.67 yards
