File Home Insert Page Layout Formulas Data Review View Help Arial 10 AA Insert v ab General E A Delete Paste BIU v v $ ~ % ? .00 Conditional Format as Cell Sort & Formatting Table Styles * Format Filter ~ S Undo Clipboard Font Alignment Number Styles Cells Editing J26 vi XVf A B C D E F G H J K L M N 0 P Q R S T Solution to Homework var. cost per unit 100 Questions A) Average per week total stock level. selling price 300 B) Average per week sales in units and dollars (revenue) inv. cost per unit 30 C) Average per week beginning inventory and inventory charges. cost of lost sales per unit 201 D) Average per week lost sales in units and lost sales cost. beg. inventory (units) 10 E) Average per week total cost. order amount (units) 240 F) Average per week profit and the standard deviation of the profits Cost 10 of 11 Beg In Demand Amt End Lost Inv Lost Total Total Total 12 Period Inv Order Stock RN Amt Sold Inv Sales Ordering Cost Cost Sales Cost Rev Profit 13 10 14 15 16 17 18 19 20 co co - INN 23 Tota 24 Average 25 StdEv of Profit 26 Answers: 27 28 29 30 31