Question: please include any excel calculations! B 10 11 Part 1: Enter the requested information into the green cells. Round off to 1 decimal point. The

please include any excel calculations!

B 10 11 Part 1: Enter the requested information into the green cells. Round off to 1 decimal point. The online Collegiate Products Store gathered the following information regarding UND sweatshirts: Annual Demand (monthly demand 1/12 of annual demand) Cost per hoodie Carrying Cost per sweatshirt per year as a percentage of the cost of a sweatshirt Cost per order placed Lead time in months Standard Deviation of Demand during load time Desired Service Level should be at least 1200 15 30% $50 1 23 95.00% 13 14 2-value 1.84 15 18 17 Question 1: If you don't use safety stock, you should place an order when the inventory position reaches what amount? 10 Question 2: If you plan on using safety stock, how many should have have? (Give amount of safety stock only)? 10 Question 3: How much sweatshirts should be ordered when you reach the Re-Order Point? 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please show formula! D H M T 3 4 5 or 7 A B E F G K L N o R S 1 Inventory Control 2 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not...

Part 1: Enter the requested information into the green cells. Round off to 1 decimal point. The online Collegiate Products Store gathered the following information regarding UND sweatshirts: Annual...

please add any formulas needed and what cell to add that formula Inventory Control You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not...

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Interim Report on Case 3 - Group Project- Home Depot Attached is the syllabus with directions on this project. Please keep in my that the only thing that I'm asking here is just the section below,...

nterim Report on Case 3 - Group Project- Home Depot Attached is the syllabus with directions on this project. Please keep in my that the only thing that I'm asking here is just the section below,...

Assignment RapidBus is a commuter bus company.On regional route A, RapidBus currently charges $10 per passenger (fare).Monthly revenue for this route is $108,000.Currently variable cost is $5 per...

please provide the correct answers to these questions . asap please provide the answers to only wrong ones. if provided asap ! then definately going to provide you a best and good review. This window...

You buy two more properties. You distribute the following cash flows from their operations to your investors each year: 2 3 1 350,000 400,000 450,000 4 500,000 5 550,000 NOI You distribute 100% of...

It is the end of 2023. You (foolishly) played the lottery and won the following cash flows, to be paid at the end of each year: Year 2024 2025 2026 2027 2028 Cash flow 1,200 1,600 1,800 2,000 2,200...

Which of the following is NOT a strength of the Accounting Rate of Return as an investment apprailsal technique? Question 3 Answer a . It is easy to understand b . It considers the risks involved in...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...