The ABC Semi Conductor Company purchase 40,000 units of mother board each year at a cost of $30.00 per unit. The ordering cost is $10.00 per order, and the annual holding cost is estimated at 15% of the unit value. 1. What is the EOQ for the ABC? 2. What is the total annual inventory cost for the mother board if it is ordered in economic quantities? 3. How many orders should be placed each year?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

with formula in excel

C D
G
A
B
E
F
H
M
N
1
The ABC Semi Conductor Company purchase 40,000 units of mother board each year at a cost of
2
$30.00 per unit. The ordering cost is $10.00 per order, and the annual holding cost is estimated
3
at 15% of the unit value.
4
1. What is the EOQ for the ABC?
2. What is the total annual inventory cost for the mother board if it is ordered in economic
7 quantities?
3. How many orders should be placed each year?
8
9
10
11 D Demand
40000 units
12 H Holding Cost
4.5 S/unit/yr
13 s Ordering Cost
10 $/order
14
15
16
17
Case 1
Case 2
Case 3
Case 4
Case 5
Case 6
Case 7
18
Quantity
100
200
300
400
500
1000
2000
19
Average
20
Total Holding Cost
21
Total Ordering Cost
22
Total COST =
23
un vo
Transcribed Image Text:C D G A B E F H M N 1 The ABC Semi Conductor Company purchase 40,000 units of mother board each year at a cost of 2 $30.00 per unit. The ordering cost is $10.00 per order, and the annual holding cost is estimated 3 at 15% of the unit value. 4 1. What is the EOQ for the ABC? 2. What is the total annual inventory cost for the mother board if it is ordered in economic 7 quantities? 3. How many orders should be placed each year? 8 9 10 11 D Demand 40000 units 12 H Holding Cost 4.5 S/unit/yr 13 s Ordering Cost 10 $/order 14 15 16 17 Case 1 Case 2 Case 3 Case 4 Case 5 Case 6 Case 7 18 Quantity 100 200 300 400 500 1000 2000 19 Average 20 Total Holding Cost 21 Total Ordering Cost 22 Total COST = 23 un vo
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Investment in Stocks
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education