Assumptions: 1. Estimated Shipping cost, C, - $3300 (full container) C. $2100 (half container) - • Lead time for Full Container is 13 weeks • Lead time for Half Container is 15 weeks. Inventory holding cost, C, - 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.

Assumptions: 1. Estimated Shipping cost, C, - $3300 (full container) C. $2100 (half container) - • Lead time for Full Container is 13 weeks • Lead time for Half Container is 15 weeks. Inventory holding cost, C, - 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.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Subject: ENTERPRENUERSHIP Convince to the investor base on data analysis for the year 2013 and 2014 for starting business of FOOD PANAD in karachi. (need solid conviancing detail explanation report)
Company: Accor Hotel UK Analysis of the firm in detail Use an appropriate technique to evaluate the firm’s key capabilities and competitive resources identify any resources or capabilities which might be the basis of competitive advantage list-making and assertions are not appropriate; this section should show an ability to apply a suitable technique of analysis Recent firm performance should cover the past four to five years financial performance could include profitability, productivity or efficiency ratios (as appropriate for your firm) identify trends and explain anomalies (can you link them to other sections of the report?) contextualise firm financial performance (compare to industry average or key competitors) marketing performance could include an evaluation of the brand(s) and other marketing metrics available, such as customer loyalty/customer churn rate, return on advertising spend, customer acquisition costs, average lifetime value of customer, amongst others base…
Shortly describe competitive profile matrix of PIA , Airblue and shaheen Air
Pls help with below homework. What was the intent behind DaimlerChrysler merger ? Does this merger was inevitable? Justify your answer
PESTLE Analysis of OQ Company in Oman?
What are some key differences between IKEA and Williams-Sonoma?
Note: Kindly answer nos. 4-7 only. Thank you 1. Did Netflix underestimate the pushback from their price increase? 2. Did Netflix underestimate the bad publicity from their new pricing structure? 3.Did Netflix underestimate the number of subscription cancellations that resulted from their new pricing structure? 4. Is Netflix actually correct in moving from mail order distribution to online streaming? 5. Did Netflix implement too quickly? 6. Can Netflix compete with Amazon Prime? 7. Make a SWOT and PEST analysis of Netflix, Inc.
How is the return at Ashley furniture?
Part 1 BOR Analysis-What is Tesla’s SCA? Brand –How does the TESLA brand create value? What parts (think IBM) are the most valuable? Describe. Use your IBM analysis from earlier this semester Offerings–What does TESLA offer that creates a Sustainable Competitive Advantage (SCA)? Pick one offering (except insurance) that Tesla provides and explain how they create value/moats/barriers to competitors. Relationships–What relationships does TESLA have have that create value/SCA? List all relationships you can think of and explain how they create value/moats/barriers to competitors. Part 2 For the SCA you provided, please discuss the likelihood that a competitor could battle you on that front. In other words, what might a competitor attempt to do to counteract the SCA you described in Part 1?
The Department of Housing and Urban Development's proposed rule on disparate impact will:Question 1 options: Be permanently tabled Have no significance Go into effect shortly after publishing Never go into effectQuestion 2 (1 point) Who invented the credit scoring model most banks rely on for mortgage lending?Question 2 options: Fair Isaac Corporation (FICO) Fair Housing Administration Urban Institute Secondary mortgage marketQuestion 3 (1 point) In 2019, how much did the L.G.B.T.Q. client base of Better.com increase in terms of married couples?Question 3 options: Remained the same Increased by 500% Doubled Increased tenfoldQuestion 4 (1 point) The Fair Housing Act of 1968 prohibits lenders from considering which factors in mortgage underwriting?Question 4 options: Race High school attended Social media profile Vacation spotsQuestion 5 (1 point) Which company originated 98 percent of its mortgages using a digital platform last year?Question 5 options: Roostify Quicken Loans Better.com…
Amazon.com is a purely e-commerce company, yet Barnes & Noble maintains both retail bookstores and a significant internet business. What are theadvantages and disadvantages of Barnes and Noble’s strategy (as contrasted toAmazon’s)?
You have been employed as a business analyst for Kingdom Bank. Your main duties andresponsibilities will include analysing banking transactions, reviewing credit and loan applications,suggesting repayments and interest rates on clients’ accounts and ensuring compliance with thebanking regulations. Q.1.1 What are the five business analyst personal qualities required to fulfil the aboveduties and responsibilities?Q.1.2 Explain what is meant by competitive advantage in the Kingdom Bank perspectiveand what Kingdom Bank must do to sustain a competitive advantage.Q.1.3 What benefits will Kingdom Bank have if it outsourced some of their businessfunctions?