Question
In: Operations Management
The cost accounting department has asked you to check their EOQ figures. You have been given...
The cost accounting department has asked you to check their EOQ figures. You have been given the following data:
| Demand | 17,036 units per quarter |
| Setup | $120 per setup |
| Price | $5 per unit |
| Percent of price (I) | 25% per unit per year |
| EOQ | 3,126 units |
Calculate total annual inventor costs including setup, holding and product cost.
*two decimal places
Solutions
Expert Solution
Annual Demand = D= 17,036 units per quarter * 4 quarters = 68,144 units
Setup cost = S = $120 per setup
Price = P = $5 per unit
Percent of price (I) 25% per unit per year
Holding cost = H = 25% * 5 = $1.25
EOQ given = 3,126 units
However, EOQ = 
= 
= 3,617.13 = 3617 units
Hence, the EOQ given is incorrect.
We will calculate Total annual inventory costs for both the EOQs (Given as well as calculated) since it is not specified in question that these costs have to be calculated for which quantity.
Total annual inventory costs for given EOQ (3126 units) = Annual setup costs + Annual holding costs + product cost
Total annual inventory costs = 
= 
= 2,615.89 + 1,953.75 + 3,40,720 = $3,45,289.64
Total annual inventory costs for calculated EOQ (3126 units) = $3,45,289.64
Total annual inventory costs for given EOQ (3617 units) = Annual setup costs + Annual holding costs + product cost
Total annual inventory costs =
= 
= 2,260.79 + 2,260.63 + 3,40,720 = $3,45,241.42
-----------------------------------------------------------------------------------------------------------------------
In case of any doubt, please ask through the comment section before Upvote/downvote.
If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!
keosha answered 5 hours agoRelated Solutions
1. From the figures given below, calculate Economic OrderQuantity (EOQ) and Total cost at E0Q? Total...
1. From the figures given below, calculate Economic
OrderQuantity (EOQ) and Total cost at E0Q? Total consumption of
material per year Unit cost of material10,000 kgsBuying cost per
order $ 50$ 2 per kgCarrying and storage cost 8%2. The XR stocks
carpet in its warehouse and sells it through anadjoining showroom.
The store keeps several brands and styles of carpet in stock;
however, its biggest seller is Super Shag carpet. The store wants
to determine the optimal order size and...
Assume that you have been asked to design an experiment for the marketing department of a...
Assume that you have been asked to design an experiment for the
marketing department of a major automotive company. They would like
to know what color(s) are most appealing to 18-24 year olds who
purchase new trucks.
Design an appropriate experiment, and then submit a short (<
3 pages) Technical Memo presenting your proposal.
At a minimum, your memo should include:
• A clear objective statement for your experiment
• Procedure for collecting data
• Methodology for analyzing the data...
As the representative of the local accounting club, you have been asked by the dean to...
As the representative of the local accounting club, you have
been asked by the dean to help her understand the costs of the
different degrees offered at the school. You decide to use an
activity-based cost system. Write a report outlining the first two
steps of developing an ABC system for this purpose: (1) Identify
the activities, and (2) identify the activities associated with
each activity.
Part I. You have been provided check figures. In good form, prepare a multiple step income...
Part I.
You have been provided check figures.
In good form, prepare a multiple step income statement,
statement of retained earnings, and classified balance sheet.
Include Earnings Per Share on the Income Statement. You must use
Excel.
In Excel, use the Bottom Border function, not the Underline
function. Also, use the Accounting format for cells, not Currency.
However, do not show decimal places. Nobody is counting pennies.
Refer to 211 regarding the placement of $, underlining and double
underlining.
Show...
You are just starting work at a new health department and you have been asked to...
You are just starting work at a new health department and you
have been asked to outline the steps that should be taken to update
the department’s preparedness plan for an influenza outbreak.
Outline the steps of the report and explain why each is an
important component of a preparedness plan.
You have been asked to oversee the management of risk for your team or department at...
You have been asked to oversee the management of risk for your
team or department at work, where an expansion process is currently
being considered. If you do not have an example you can draw upon,
you are able to make up an example as long as you demonstrate your
understanding on what is requested.
You will need to identify the key stakeholders with whom
you will communicate and conduct the stakeholder analysis.
You have been supplied a template to...
The head of the accounting department at a major software manufacturer has asked you to put...
The head of the accounting department at a major software
manufacturer has asked you to put together a pro forma statement of
the company's value under several possible growth scenarios and the
assumption that the company’s many divisions will remain a single
entity forever. The manager is concerned that, despite the fact
that the firm’s competitors are comparatively small, collectively
their annual revenue growth has exceeded 50 percent over each of
the last five years. She has requested that the...
Imagine that you work in the accounting department of a university and your boss has asked...
Imagine that you work in the accounting department of a university
and your boss has asked you to explain components of revenue,
expenses, and changes in net asset that are reported on the
university’s statement of revenues.
Respond to the following in a minimum of 175 words:
Discuss at least two unique situations or transactions that you may
encounter. Describe any circumstances the entity may engage in
activities that result in Unrelated Business Income Tax (UBIT).
The head of the accounting department at a major software manufacturer has asked you to put...
The head of the accounting department at a major software
manufacturer has asked you to put together a pro forma statement of
the company's value under several possible growth scenarios and the
assumption that the company’s many divisions will remain a single
entity forever. The manager is concerned that, despite the fact
that the firm’s competitors are comparatively small, collectively
their annual revenue growth has exceeded 50 percent over each of
the last five years. She has requested that the...
Imagine that you work in the accounting department of a university and your boss has asked...
Imagine that you work in the accounting department of a
university and your boss has asked you to explain components of
revenue, expenses, and changes in net asset that are reported on
the university’s statement of revenues. Respond to the following in
a minimum of 175 words: Discuss at least two unique situations or
transactions that you may encounter. Describe any circumstances the
entity may engage in activities that result in Unrelated Business
Income Tax (UBIT).
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- <Python Coding> Book : Discovering Computer Science chap3.2 (open source) 1. Write a modified version of...
- You are a supply chain analyst for Good-Buy Inc., which is a large retail chain. Good-Buy...
- A random sample of n=100 observations produced a mean of x⎯⎯=30 with a standard deviation of...
- e. Task 5 (3 pts): (This task uses Strings and an if..then..elseif cascade) A program that...
- Java Palindrome (Timelimit: 10seconds) Problem Description Write a Java program to solve the following problem. A...
- I am having trouble figuring out how to To-Do list using java. Can anyone guide me...
- Think about a DATABASE PROJECT (BUSINESS PROBLEM) you want to do after school show me the...
ADVERTISEMENT