Industry Analysis

.xlsx

School

The University of Oklahoma *

*We aren’t endorsed by this school

Course

5902

Subject

Business

Date

Jul 2, 2024

Type

xlsx

Pages

39

Uploaded by MegaTeam6104

R&D Industry Analysis Input numbers from situation analysis in the top cells and let the rest calculate based on the formula.
Drift rates Ideal Spot Offsets Pfmn Size Pfmn Size Traditional 0.7 -0.7 Traditiona 0 0 Low End 0.5 -0.5 Low End -0.8 0.8 High End 0.9 -0.9 High End 1.4 -1.4 Performanc 1 -0.7 Performa 1.4 -1 Size 0.7 -1 Size 1 -1.4 Traditional Low End High End Round Pfmn Size Round Pfmn Size Round Pfmn Size 3 7.1 12.9 3 4.0 16.0 3 10.2 9.8 4 7.8 12.2 4 4.5 15.5 4 11.1 8.9 Traditional Low End High End Round Pfmn Size Round Pfmn Size Round Pfmn Size 3 7.1 12.9 3 3.2 16.8 3 11.6 8.4 4 7.8 12.2 4 3.7 16.3 4 12.5 7.5 Each month during the year the segment drifts 1/12th of the distance from t Ideal spot offsets; customers prefer products in t
Performance Size Round Pfmn Size Round Pfmn Size 3 11.0 14.9 3 5.1 9.0 4 12.0 14.2 4 5.8 8.0 Performance Size Round Pfmn Size Round Pfmn Size 3 12.4 13.9 3 6.1 7.6 4 13.4 13.2 4 6.8 6.6 the starting position to the ending position these locations
Team Segment Units Sold Digby Daze Traditional 1,427 0 119 356.75 Digby Dune Size 1900 0 158 475 Digby Dot Performanc 511 54 43 127.75 Digby Dell Low 436 8 36 109 Digby Duck High 437 22 36 109.25 (highlighte d if 0) e sales per month as 3 months)
Revision Date Age Ideal Age MTBF Stockout 8/23/2025 2.2 2 -0.2 17500 Stockout 2/13/2025 5.6 1.5 -4.1 17000 Good 12/14/2025 1.4 1 -0.4 23000 Good 11/21/2025 1.9 7 5.1 27000 Good 10/8/2025 1.9 0 -1.9 19000 (forecasting) issues? Offset from Ideal
Performance Size 14000 19000 6.3 5.7 13.8 14.3 16000 21000 3 4.7 17 9.6 22000 27000 9.2 10.4 11 15.3 12000 17000 10.4 2.2 15 17.8 20000 25000 4.5 9.8 9.8 10.2 for segment for segment Performance for segment for segment
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help