Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Old MathJax webview you should solve with excel Task 1 - Inventory Management & Control Frank's Fasteners a leading company based in UK, which makes

Old MathJax webview

image text in transcribed

you should solve with excel

Task 1 - Inventory Management & Control Frank's Fasteners a leading company based in UK, which makes industrial fasteners has the following average annual inventory level, as given in Table T1a. To have a more proper control over the inventory the company needs to do A-B-C analysis based on the annual consumption value. Cost () per Unit 0.35 0.50 1.35 3.50 Item Machine screw Cable clamp Eyebolt Tape measure Nail Carabiner Wing nut Flat washer S hook Ferrule Annual Number of Units Sold 18,000 10,000 14,000 51,000 14,000 40,000 82,000 121,000 14,000 7,000 Annual Consumption Value () 6,300.00 5,000.00 18,900.00 178,500.00 12,600.00 72,000.00 3,280.00 7,260.00 2,100.00 11,200.00 0.90 1.80 0.04 0.06 0.15 1.60 Table T1a - Average Annual Inventory a. Perform A-B-C classification of the inventory and classify the items based on 70-20-10 rule. (10 Marks) b. Prepare a Pareto Chart with the above information. (05 Marks) c. Suggest what type of stocking policy could be adopted for each class of inventory. Justify your answer with sufficient explanation. (05 Marks) d. The ordering costs and the carrying costs of the three classes of inventory are given in Table T1b. Calculate the annual cost of stock of Frank's Fasteners, if the company follows EOQ for ordering the items. Class Ordering Costs per Order (S) in Carrying Costs (C) A 2.00 10% of Item Cost/Year B 1.50 000 12% of Item Cost/Year 15% of Item Cost/Year 1.00 Table Tab Inventorvaste

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: Timothy J Louwers, Robert J. Ramsay, David Sinason, Jerry R Strawser

1st Edition

0072954442, 9780072954449

More Books

Students also viewed these Accounting questions