Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 cost

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 Assurance And Risk

Authors: W. Robert Knechel, Steve Salterio, Brian Ballou

3rd Edition

0324313187, 9780324313185

More Books

Students also viewed these Accounting questions