Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have included a screenshot of an example problem I am taking about. When trying to determine the economic order quantity, I seem to be

image text in transcribed

I have included a screenshot of an example problem I am taking about. When trying to determine the economic order quantity, I seem to be having some troubles. This type of question is advanced for the class I am in. Can you please help me understand how to solve each part in an equation/logarithmic form? I AM NOT USING YOUR WORK AS MY OWN. I just included the problem so that you would be provided with numerical values in your explanation.

image text in transcribed
Economic order quantity. Exact Copies Incorporated currently orders paper every month for its operations and stores them at a central warehouse. Annually, the company uses 12,800,000 reams of paper. Each order costs $465 for delivery to the warehouse. Exact also estimates that the average cost per year to store a ream of paper is $0.04. Using a spreadsheet, determine the total annual inventory cost of ordering every week, every other week, monthly, every other month and quarterly. Find the economic order quantity (EOQ) for Exact Copies. How often should it order? Finally, visually prove the E00 by calculating the total order cost for order sizes at 25,000 increments (up and down) over a range of 500,000 (EOQ - 250,000 to E00 + 250,000) with the E00 as the midpoint by graphing total inventory costs, total annual ordering costs, and total annual carrying costs. Using a spreadsheet, determine the total annual inventory cost of ordering every week, every other week, monthly, every other month and quarterly. Calculate the total annual inventory cost below: (Round up the quantity ordered to the nearest whole number and the dollar mounts to the nearest dollar.) Order Quantity Annual Annual Annual Total Annual Frequency Ordered Number of Orders Order Costs Carrying Costs Inventory Costs Weekly lIlI $ll $ll $lI

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Modeling

Authors: Simon Benninga

4th Edition

0262027283, 9780262027281

More Books

Students also viewed these Finance questions