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

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter5: Operating Activities: Purchases And Cash Payments
Section: Chapter Questions
Problem 4.7C
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
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage