1 2 3 4 5 File Paste 022 15 16 Home Insert Draw Page Layout Formulas Data Review View Automate Help नै Clipboard Arial BIU ✓ A B Inventory Control X ✓ fx D с ✓14 Font E V ✓ A^ A A✓ F 5 G = a Wrap Text =====Merge & Center Alignment Standard Deviation of Demand during lead time Desired Service Level should be at least H 6 7 8 Part 1: Enter the requested information into the green cells. Round off to 1 decimal point. 9 10 11 12 13 14 V Carrying Cost per sweatshirt per year as a percentage of the cost of a sweatshirt Cost per order placed Lead time in months 5 The online Collegiate Products Store gathered the following information regarding UND sweatshirts: Annual Demand (monthly demand 1/12 of annual demand) Cost per hoodie General $ % 9 500 000 1080 15 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example, if I asked you the sum of cells B5 through D5, this is what I want to see: 1234 2345 3456 30% $50 V Number 17 18 Question 1: If you don't use safety stock, you should place an order when the inventory position reaches what amount? 19 Question 2: If you plan on using safety stock, how many should have have? (Give amount of safety stock only)? 20 Question 3: How much sweatshirts should be ordered when you reach the Re-Order Point? 21 J 1 20 96.00% z-value √ ———— ==> Conditional Format as Cell Formatting Table Styles Styles K ▬▬▬▬ T L 1.75 M N m ←L TIX CA Insert Delete Format | O Cells P Q Σ V AY Sort & Find & Filter Select Editing R S V 7035.0 or 7035.0 Note: cells (J4 & L4) (above) contain formulas that use cell referencing - which is a requirement for responses on all assignments. T Sensitivity Sensitivity U
1 2 3 4 5 File Paste 022 15 16 Home Insert Draw Page Layout Formulas Data Review View Automate Help नै Clipboard Arial BIU ✓ A B Inventory Control X ✓ fx D с ✓14 Font E V ✓ A^ A A✓ F 5 G = a Wrap Text =====Merge & Center Alignment Standard Deviation of Demand during lead time Desired Service Level should be at least H 6 7 8 Part 1: Enter the requested information into the green cells. Round off to 1 decimal point. 9 10 11 12 13 14 V Carrying Cost per sweatshirt per year as a percentage of the cost of a sweatshirt Cost per order placed Lead time in months 5 The online Collegiate Products Store gathered the following information regarding UND sweatshirts: Annual Demand (monthly demand 1/12 of annual demand) Cost per hoodie General $ % 9 500 000 1080 15 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example, if I asked you the sum of cells B5 through D5, this is what I want to see: 1234 2345 3456 30% $50 V Number 17 18 Question 1: If you don't use safety stock, you should place an order when the inventory position reaches what amount? 19 Question 2: If you plan on using safety stock, how many should have have? (Give amount of safety stock only)? 20 Question 3: How much sweatshirts should be ordered when you reach the Re-Order Point? 21 J 1 20 96.00% z-value √ ———— ==> Conditional Format as Cell Formatting Table Styles Styles K ▬▬▬▬ T L 1.75 M N m ←L TIX CA Insert Delete Format | O Cells P Q Σ V AY Sort & Find & Filter Select Editing R S V 7035.0 or 7035.0 Note: cells (J4 & L4) (above) contain formulas that use cell referencing - which is a requirement for responses on all assignments. T Sensitivity Sensitivity U
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Transcribed Image Text:1
2
3
4
5
File
Paste
022
15
16
Home Insert Draw Page Layout Formulas Data Review View Automate Help
नै
Clipboard
Arial
BIU ✓
A
B
Inventory Control
X ✓ fx
D
с
✓14
Font
E
V
✓ A^ A
A✓
F
5
G
=
a Wrap Text
=====Merge & Center
Alignment
Standard Deviation of Demand during lead time
Desired Service Level should be at least
H
6
7
8 Part 1: Enter the requested information into the green cells. Round off to 1 decimal point.
9
10
11
12
13
14
V
Carrying Cost per sweatshirt per year as a percentage of the cost of a sweatshirt
Cost per order placed
Lead time in months
5
The online Collegiate Products Store gathered the following information regarding UND sweatshirts:
Annual Demand (monthly demand 1/12 of annual demand)
Cost per hoodie
General
$ % 9 500 000
1080
15
You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit.
When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example,
if I asked you the sum of cells B5 through D5, this is what I want to see:
1234 2345 3456
30%
$50
V
Number
17
18 Question 1: If you don't use safety stock, you should place an order when the inventory position reaches what amount?
19 Question 2: If you plan on using safety stock, how many should have have? (Give amount of safety stock only)?
20 Question 3: How much sweatshirts should be ordered when you reach the Re-Order Point?
21
J
1
20
96.00% z-value
√
————
==>
Conditional Format as Cell
Formatting Table Styles
Styles
K
▬▬▬▬
T
L
1.75
M
N
m
←L TIX
CA
Insert Delete Format
|
O
Cells
P
Q
Σ
V
AY
Sort & Find &
Filter Select
Editing
R
S
V
7035.0 or
7035.0
Note: cells (J4 & L4) (above) contain formulas that use cell referencing - which is a requirement for responses on all assignments.
T
Sensitivity
Sensitivity
U
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education