Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Review Supplier Data Adam - Jenkins Group Qualidade Distribuci n Crosby Suppliers, LLC Lupa Industries Inc. Minimum Order Quantity 5 0 0 3 , 0

Review Supplier Data
Adam-Jenkins Group Qualidade Distribucin Crosby Suppliers, LLC Lupa Industries Inc.
Minimum Order Quantity 5003,0001,0006,000
Maximum Order Quantity 2,5007,0006,00012,500
Minimum Multiples 555250
Unit Cost $31.50 $27.50 $28.75 $25.50
Per Order Cost $500.00 $500.00 $500.00 $500.00
Per Unit Holding Cost $0.61 $0.53 $0.56 $0.50
Full Quarter Forecast 37,95637,95637,95637,956
Lead Time 2548
Create Purchase Orders
Week 14 Week 15 Week 16 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Week 25 Week 26
Adam-Jenkins Group
500
Qualidade Distribucin
5000
Crosby Suppliers, LLC
0
Lupa Industries Inc.
0
Review the Forecast
Week 14 Week 15 Week 16 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Week 25 Week 26 Week 27 Week 28 Week 29 Week 30 Week 31 Week 32 Week 33 Week 34 Week 35 Week 36 Week 37 Week 38 Week 39
Forecasted Beginning Inventory 109221127904143581154584169084177092186113192146197190194246191311188387185471182565179658176751173844170938168031165124162217159311156404153497150590147684
Forecasted Demand 25172923299630012991297929672956294529342925291529072907290729072907290729072907290729072907290729072907
Forecasted Fulfillment 25172923299630012991297929672956294529342925291529072907290729072907290729072907290729072907290729072907
Forecasted Inventory Received 21200186001400017500110001200090008000000000000000000000
Forecasted Ending Inventory 127904143581154584169084177092186113192146197190194246191311188387185471182565179658176751173844170938168031165124162217159311156404153497150590147684144777
Forecasted Weeks of Inventory 50.8149.1251.5956.3559.2162.4764.7666.7265.9665.264.4163.6262.8161.8160.8159.8158.8157.8156.8155.8154.8153.8152.8151.8150.8149.81

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

The Restaurant From Concept to Operation

Authors: John R Walker

6th Edition

9781118139950, 470626437, 111813995X, 978-0470626436

More Books

Students also viewed these General Management questions