Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started