Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help ImportHome LLC Revisit: Company Background - Family business: self-financed, home as office, garage as warehouse, self-maintained online store - Annual revenue around $600,000
please help
ImportHome LLC Revisit: Company Background - Family business: self-financed, home as office, garage as warehouse, self-maintained online store - Annual revenue around $600,000 - B2C online retailer of kitchen-ware: soymilk maker, pressure cooker, frying pan, etc. - Target at the Chinese community in North America Assumptions: 1. Estimated Shipping cost, Co=$3300 (full container) Co=$2100 (half container) - Lead time for Full Container is 13 weeks - Lead time for Half Container is 15 weeks. - Inventory holding cost, Cc=18% of the product price - Product Price =$90 - Assume Service level =95% - The aggregated quantity of products needs to be ordered for the business. Please use sales data from the attached excel file to determine The task: Please determine the best inventory model based on 2 years sales data, select the shipping method (full container vs half container) and calculate annual operating cost. ImportHome LLC Revisit: Company Background - Family business: self-financed, home as office, garage as warehouse, self-maintained online store - Annual revenue around $600,000 - B2C online retailer of kitchen-ware: soymilk maker, pressure cooker, frying pan, etc. - Target at the Chinese community in North America Assumptions: 1. Estimated Shipping cost, Co=$3300 (full container) Co=$2100 (half container) - Lead time for Full Container is 13 weeks - Lead time for Half Container is 15 weeks. - Inventory holding cost, Cc=18% of the product price - Product Price =$90 - Assume Service level =95% - The aggregated quantity of products needs to be ordered for the business. Please use sales data from the attached excel file to determine The task: Please determine the best inventory model based on 2 years sales data, select the shipping method (full container vs half container) and calculate annual operating costStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started