Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 EOQ by calculating the total order cost for order sizes at 25,000 increments (up and down) over a range of 500,000 (EOQ250,000 to EOQ+250,000) with the EOQ 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

$

$

$

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

Technical Analysis Of Stock Trends

Authors: Robert D. Edwards, John Magee

6th Edition

1599180219, 978-0139043437

More Books

Students also viewed these Finance questions

Question

Did the researcher use negative case analysis?

Answered: 1 week ago