Question: please help me with this assignment, calculate the EOQ based on the givens below using excel: A = annual demand = 2 0 , 0

please help me with this assignment, calculate the EOQ based on the givens below using excel: A = annual demand =20,000 Cp = Cost of an order which includes preparing and following up the order = $100.00 Ch = Unit inventory cost per year or item cost (P) $100 times annual carrying cost rate (r)(25%) Use an excel file to calculate the EOQ order, use the formula bar to create the EQO formula.

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!

Q:

AirPower Products, Inc. AirPower Products, Inc. (API) is a new entrepreneurial venture located in the San Francisco Bay Area's Livermore Valley, just west of the famous Altamont Pass wind power...

Q:

AirPower Products, Inc. (API) is a new entrepreneurial venture located in the San Francisco Bay Areas Livermore Valley, just west of the famous Altamont Pass wind power farms. APIs products are...

Q:

Question 1 Optimizing Inventory and Maximizing Profits at Revolution Bikes Revolution Bikes keeps an inventory of high-quality bike frames on hand for all their custom jobs and would like to minimize...

Q:

Hello, Thank you for your response. The attached spread sheet is for the questions you answered before. # 1, # 2, # 3, # 4 and # 8. I sent these questions prior and you responded to all of them. The...

Q:

Hello, Thank you for your response. The attached spread sheet is for the questions you answered before. # 1, # 2, # 3, # 4 and # 8. I sent these questions prior and you responded to all of them. The...

Q:

Hello, Thank you for your response. The attached spread sheet is for the questions you answered before. # 1, # 2, # 3, # 4 and # 8. I sent these questions prior and you responded to all of them. The...

Q:

You have been hired as a consultant by the Ontario Provincial Government to help identify "efficiencies". One potential area of cost reduction is to centralize the procurement of basic supplies...

Q:

INSTRUCTIONS Complete this assignment in Word or Excel. Upload into the Assignment 3 Module in Brightspace for grading. Assignments need to be submitted on or before the due date specified by the...

Q:

Please help me with this assignment in the attached file Name Problem 1: On January 1, 2013, Queen Corporation issued 12-year, 6% bonds payable with a face value of $10 million. The bonds require...

Q:

Please help me with this assignment in the attached file Name Problem 1: On January 1, 2013, Queen Corporation issued 12-year, 6% bonds payable with a face value of $10 million. The bonds require...

Q:

A 0.50-kg mass is suspended on a spring that stretches 3.0 cm. (a) What is the spring constant? (b) What added mass would stretch the spring an additional 2.0 cm? (c) What is the change in potential...

Q:

Wilcox Company has prepared the following reconciliation of its pretax financial income with its taxable income for 2007: Pretax financial income ............................$3,000 Add: Estimated...

Q:

5 Write the correct sign, , between each pair of measurements. Copy and complete the working. a 3.5g 380 mg b 0.4t 845 kg 0.4t=0.41000 3.5g 3.5x1000=3500 mg kg 3500 mg 380 mg kg 845 kg C 2.5cm...

Q:

What are some food related health care issues that inner cities are more likely to see than more affluent areas? Why are certain areas most likely to experience inadequate healthy food options than...