Question: Determine the Economic Order Quantity in Excel for: Price of Product: .........$150 Savings Rate: .........12% Annual Usage: ..........16240 Cost of transportation: ......$200/order Cost of PO

Determine the Economic Order Quantity in Excel for:

Price of Product: .........$150

Savings Rate: .........12%

Annual Usage: ..........16240

Cost of transportation: ......$200/order

Cost of PO preparation: .......$60/order

Warehouse Rental: ........$8/piece.

Step by Step Solution

★★★★★

3.52 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Computation of the EOQ Demand rate ... View full answer

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

Document Format (1 attachment)

Excel file Icon

68-B-M-A-C-V-P (1199).xlsx

300 KBs Excel File

Students Have Also Explored These Related Managerial Accounting Questions!

Q:

The economic order quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost, and the cost...

Q:

Determine the Economic Order Quantity if daily demand is 800 units, the ordering cost is $16 per order and the annual average cost of holding is $ 10 per unit. Assume that the company works for 250...

Q:

Vergas Enterprises wishes to determine the economic order quantity (EOQ) for a critical and expensive inventory item that it uses in large amounts at a relatively constant rate throughout the year....

Q:

Determine the economic order quantity in excel: a) Price of product: $150 b) Savings rate : 12% c) Annual Usage: 16240 d) Cost of transportation: $2000/order e) Cost of PO preparation: $60/order f)...

Q:

Topic: Economic Order Quantity Determine the Economic Order Quantity in Excel for: Price of Product: $150 Savings Rate: 12% Annual Usage: 16240 Cost of transportation: $200/order Cost of PO...

Q:

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

Q:

Turn in with an Excel file with your calculations and a report Chard Appliance (B) Exhibit 2: Chard Appliance Sales by State: 2003 Chard Appliance, located in Wichita, Kansas was founded in 1938 as...

Q:

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

Q:

check on the file and download the...

Q:

Lucille Jenkins, the CEO for the Durham International Manufacturing Company (DIMCO), believes that the company can significantly increase its operating profit by implementing supply chain management....

Q:

In 2018, your company purchased a front end loader for $150,000, and a dump truck for $85,000. The front end loader was placed in service in April, 2018 and the dump truck was placed in service in...

Q:

Annie's Antiques uses a perpetual inventory system. Journalize the following sales transactions for Annie's Antiques. Explanations are not required. The company estimates sales returns at the end of...

Q:

Question 1 A $ 2 0 0 0 bill with a $ 2 5 coupon in the US is currently selling at $ 1 8 0 0 , and a 4 0 0 0 Swedish Krona bill with a 2 0 0 Krona coupon is trading for 3 5 0 0 Krona. Both mature in 1...

Q:

Visit www.pearsonhighered.com/Horngren to view a link to Starbucks Corporation's 2013 Fiscal Year Annual Report. Study the audit opinion (labeled Report of Independent Registered Public Accounting...

Q:

The company has 10,000 shares of 6%, $100 par preferred stock outstanding. In addition, the company has 100,000 shares of common stock outstanding. The company started business on January 1, 2010....

Q:

The company has outstanding bonds payable with a total face value of $100,000. On July 1, the company redeemed the bonds by purchasing them on the open market for a total of $102,700. Make the...

Q:

On January 1, the company issued 10-year bonds with a face value of $200,000. The bonds carry a coupon rate of 10%, and interest is paid semiannually. On the issue date, the market interest rate for...

Q:

The company intends to issue 20-year bonds with a face value of $1,000. The bonds carry a coupon rate of 9%, and interest is paid semiannually. On the issue date, the market interest rate for bonds...

Q:

Suppose that the following constraints have been provided for a linear programming model with decision variables x1 and x2. 2x1 3x2 12 3x1 2x2 12 and x1 0, x2 0. (a) Demonstrate graphically...

Q:

Net Present Value Suppose a project has conventional cash flows and a positive we NPV. What do you know about its payback, its discounted payback, its profitability index, its IRR? Explain.

Q:

Payback Period concerning payback: a. Describe how the payback period is calculated, and describe the information this measure provides about a sequence of cash flows. What is the payback criterion...

Q:

Discounted Payback Concerning discounted payback: a. Describe how the discounted payback period is calculated, and describe the information this measure provides about a sequence of cash flows. What...

Q:

Can someone help me solve this? You are considering on investment in 30-year bonds issued by Moore Corporation. The bonds have no special covenants. The Wall Street Joumal reports that 1-year T-bills...

Q:

1) You have started your first job today, and you want to buy a house within 3 years. You are currently saving for the down payment. You plan to save $5,000 the first year. You also anticipate that...

Q:

---Can you please help me on 8c and all parts of number 9? I have A and B on number 8. Thank you! 8. (9 points possible) Suppose your company needs to raise $10 million to construct a new office...