Question: PLEASE EXPLAIN ONLY USING EXCEL WITH FORMULAS AND SHOW THE EXCEL SHEET PLEASE! Barbara Brown is the purchasing agent for Central Valve Company, which sells

PLEASE EXPLAIN ONLY USING EXCEL WITH FORMULAS AND SHOW THE EXCEL SHEET PLEASE!

Barbara Brown is the purchasing agent for Central Valve Company, which sells industrial valves and fluid-control devices. One of their most popular valves is the Western, which has an annual demand of 4,000 units. The cost of each valve is $90.00, and the inventory carrying cost is estimated to be 10% of the cost of each valve. Barbara has made a study of the costs involved in placing an order for any of the valves that Central Valve stocks, and she has concluded that the average ordering cost is $25.00 per order. Furthermore, it takes about 8 days for an order to arrive from the supplier. During this time, the demand per week for Central valves is approximately 80.

1. What is the economic order quantity?

2. What is the reorder point? Develop an inventory policy with the reorder point.

3. What is the total annual inventory cost (carrying cost + ordering cost)

4. What is the optimal number of orders per year?

5. What is the optimal number of days between any two orders assuming there are 200 working days per year?

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!

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Show Steps In Excel Please 3. Barbara Brown is the purchasing agent for Central Valve Company, which sells industrial valves and fluid-control devices. One of their most popular valves is the...

Please help me answer parts a, b, c, d, and e using excel format. Thank you! Barbara Brown is the purchasing agent for Central Valve Company, which sells industrial valves and fluid-control devices....

Question 3 for reference: Barbara Brown is the purchasing agent for Central Valve Company, which sells industrial valves and fluid-control devices. One of their most popular valves is the Western,...

Please, help me solve this with Excel or Excel Solver, please. Barbara Bright is the purchasing agent for West Valve Company. West Valve sells industrial valves and fluid control devices. One of the...

1 . The quarterly sales data (number of copies sold ) for a college textbook over the past 3 years are as follows in the Table below: QUARTERLY SALES Quarter Year 1 Year 2 Year 3 16 18 18 9 9 11 AWN...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

I need help with this project. I have attached all of the instructions and relevant information. The final draft is due August 20th. Course Project: A Financial Statement Analysis A Comparative...

Can someone help me with the Accounting Course Project. Instructions are there in the Course Project Instruction and the 10k for Nike and UNder Armour attached. I have also attached the Teamplate....

Using the decision table for this problem, use the following criterion to choose the right order quantity: a. Maximax b. Maximin c. Equally likely d. Minimax regret e. Hurwicz using = 0.8

The counting rate from a radioactive source is measured every minute. The resulting counts per second are 1000, 820, 673, 552, 453, 371, 305, 250. Plot the counting rate versus time on semilog graph...

summarize the following: No HHS awarding agency may place restrictions on the non-Federal entity that limit public access to the records of the non-Federal entity pertinent to a Federal award, except...

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...