Please calculate and answer in excel The annual demand for a product is 500,000 units The inventory carrying cost for this product is 25 per unit per year and the cost of placing one order is $200 The supplier of this product gives quantity discounts outlined in the table below Provide the following information for the situation above Level 1 Level 2 Level 3 Level 4 Price Order Quantity Annual Item Cost Annual Ordering Cost Annual Carrying Cost Annual Total Cost What is the optimal order quantity and the corresponding total cost If Quantity is Price Level 1 1 to 1999 $20 00 Level 2 Level 3 Level 4 2000 to 999910000 to 49999 50000 or higher $19 80 $19 75 $19 70

The Answer is in the image, click to view ...

Question: Please calculate and answer in excel The annual demand for a product is 500,000 units. The inventory carrying cost for this product is 25% per

Please calculate and answer in excel

The annual demand for a product is 500,000 units. The inventory carrying cost for this product is 25% per unit per year and the cost of placing one order is $200. The supplier of this product gives quantity discounts outlined in the table below.

Provide the following information for the situation above.

Please calculate and answer in excel The annual

	Level 1	Level 2	Level 3	Level 4
Price
Order Quantity
Annual Item Cost
Annual Ordering Cost
Annual Carrying Cost
Annual Total Cost

What is the optimal order quantity and the corresponding total cost?

If Quantity is: Price Level 1 1 to 1999 $20.00 Level 2 Level 3 Level 4 2000 to 999910000 to 49999 | 50000 or higher $19.80 $19.75 $19.70 |

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!

Unlock the code below. The first number reveals the question number answered above. The second number reveals the ordered letter of the answer. For example, 12:2 directs the decoder to question 12...

Rick Jerz is attempting to perform an inventory analysis on one of his most popular products. Annual demand for this product is 4 comma 5 0 0 4 , 5 0 0 units; carrying cost is $ 4 5 4 5 per unit per...

Q2. (20\%) Michele Platini and Diego Maradona, planners for a company that makes several models of footballs are about to prepare the capacity plan that will cover six periods. They have assembled...

Question 1. The Great Southern Automotive Co. buys steering wheels from a supplier. One particular steering wheel has a known and constant demand rate of 2,000 units per year. The fixed cost of...

Franz Beckenbauer and Johan Cruyff are purchasing managers for the headquarters of a large sports marketing company chain with a central inventory operation. Their fastest-moving inventory item has a...

Q: Franz Beckenbauer and Johan Cruyff are purchasing managers for the headquarters of a large sports marketing company chain with a central inventory operation. Their fastest - moving inventory item...

3. (15%) Franz Beckenbauer and Johan Cruff are purchasing managers for the headquarters of a large sports marketing company chain with a central inventory operation. Their fastest-moving inventory...

A local bakery orders flour bags once a month whenever its inventory reaches 35 bags. While the demand is uncertain during lead time, the management calculated the probability/frequency of different...

Please show the necessary steps in Excel. 1 A product is ordered once each year, and the reorder point without safety stock (dL) is 100 units. Inventory carrying cost is $10 per unit per year, and...

need a solution to this question please 2. A product is ordered once each year, and the reorder point without safety stock (dL) is 100 units. Inventory carrying cost is $10 per unit per year, and the...

Jack Spratt is the production manager for a manufacturing firm that produces wizzy-gadgets and other items. The annual demand for a particular wizzy-gadget is 1,500 units. The holding cost is $2 per...

The names of covalent compounds use _____ to state the nuber of atoms which is dervived from the _____ names. For example, 2 atoms would be identified as _____

QUESTION 1) For a protein to be an integral membrane protein, it would have to be A) hydrophilic B) hydrophobic C) exposed on only one surface of the membrane D) amphipathic, with at least one...

Which of the following are examples of cash equivalents? ( Select all that apply. ) Multiple select question. Treasury bills correct Checking accounts Commercial paper correct Currency Coins Money...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...