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 :)

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!

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...

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...

Carpet City orders Soft Shag from the Carpet City Mill. The production rate at the mill is 1 2 0 0 yards per day, and the mill operates 2 6 0 days per year. The annual carrying cost is $ 0 . 6 3 ,...

quantitative analysis 13. In Problem I in Chapter 15, the Saki motorcycle dealer in Minneapolis-St. Paul orders the Saki Super TXII motorcycle it sells from the manufacturer in Japan. Using the...

In Problem 2 in Chapter 15, Carpet City orders Soft Shag carpet from its own mill. Using the 3-month moving average forecast of demand for month 9 as the monthly forecasts for all of next year, a...

In Problem 12-2 in Chapter 12, Carpet City orders Soft Shag carpet from its own mill. Using the three-month moving average forecast of demand for month 9 as the monthly forecasts for all of next...

Carpet City orders Soft Shag from the Carpet City Mill. The production rate at the mill is 1 2 0 0 yards per day, and the mill operates 2 6 0 days per year. The annual carrying cost is $ 0 . 6 3 ,...

Assume all PCs got the IP address from DHCP server already. Table 1 and Table 2 are shown after some commands issued. i. Which command on S1 can show Table 1? ii. Which command on R3 can show Table...

William Smith, an Australian investor, has tremendous interests to expand his portfolio from a bunch of Australian stocks to the U.S. index and the Crypto currency. He would like to gain some...

Which of the following is the best way for an auditor to determine that every name on a company's payroll for the Rodgers factory is that of a bona fide employee presently on the job? Question 3 6...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...