Annual Target Order Item On-Hand Demand Level Quantity Nut – 6 mm 500 22 Nut – 8 mm 750 54 Bolt – 6 mm 200 Bolt – 8 mm 100 6. Screw #8 - 30 mm 250 12 Screw #8 - 40 mm 200 8. Washer - 8 mm 380 20 Washer - 10 mm 100 5 Pin – Split 400 40

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

A small hardware store uses a periodic review system to control inventory and
calculate order quantities. Inventory is reviewed every 2 weeks and there is a
1-week lead time for delivery. Safety stock is set at 1 week’s supply. The following
table shows the products and the current on-hand inventory. Calculate the target
level and order quantity for each of the items. Use 50 weeks per year for your
calculations.

Annual
Target
Order
Item
On-Hand
Demand
Level
Quantity
Nut – 6 mm
500
22
Nut – 8 mm
750
54
Bolt – 6 mm
200
Bolt – 8 mm
100
6.
Screw #8 - 30 mm
250
12
Screw #8 - 40 mm
200
8.
Washer - 8 mm
380
20
Washer - 10 mm
100
5
Pin – Split
400
40
Transcribed Image Text:Annual Target Order Item On-Hand Demand Level Quantity Nut – 6 mm 500 22 Nut – 8 mm 750 54 Bolt – 6 mm 200 Bolt – 8 mm 100 6. Screw #8 - 30 mm 250 12 Screw #8 - 40 mm 200 8. Washer - 8 mm 380 20 Washer - 10 mm 100 5 Pin – Split 400 40
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Inventory Management
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