File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Calibri 11 -A A X Cut Da Copy - Format Painter 2 Wrap Text Paste BIU A S% , Conditional Fas Formatting Table Insert Dell Clipboard Font Alignment Number Styles A25 4 B M 3 2 MIDDLE TENNESSEE STATE UNIVERSITY JONES COLLEGE OF BUSINESS 3 4 Data: Metric Sales (units) Labor (hours) Labor Cost ($) Materials Cost ($) Equipment (Hours) Equipment Cost ($) Fixed Costs (5) C D G H Productivity Analysis Assignment Total = 75 points: Productivity Calculation Tab (30 points) + What If Analyis Tab (45 points) Use column Ffor Use column G for questions 8-10 questions 8-10 Parent (Domestic) Subsidiary (LDC) Parent (Domestic) Subsidiary (LDC) 1,400,000 480,000 1,900,000 500,000 40 000 20,000 30,000 28,000 $582 800 $110,400 $437.100 $154,560 S400,000 $200.000 $400.000 $208,333 120.000 30 000 120,000 30,000 $1,359,600 $225,000 $1,500,000 $225,000 $2,000,000 S725,000 $2,000,000 $725,000 5 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 Measure Labor Productivity (units/labor hour) Labor Productivity (units/labor $) Materials Productivity (units/5) Equipment Productivity (units/hour) Equipment Productivity (units/$) Total-Factor Productivity (units/$) Values from Prior Page Parent Organization 35.00 2.40 35.00 11.67 2.40 0.32 Subsidiary Organization 24.00 4.35 24.00 16.00 4.35 0.38 What If Values Parent Organization Subsidiary Organization 63.33 17.86 4.35 4.75 2.40 15.83 16.67 1.27 2.22 0.44 0.38 EU What-it Analysis 67 Reflection 60 11. Based on your experience with the "what-if analysis exercises, summarize what you learned concerning productivity measurement and the impact of making operational changes e interaction of the various 70 72 73 74 75 Productivity Calculations What If Analysis + 2 Type here to search ORA File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Calibri 11 -A A X Cut Da Copy - Format Painter 2 Wrap Text Paste BIU A S% , Conditional Fas Formatting Table Insert Dell Clipboard Font Alignment Number Styles A25 4 B M 3 2 MIDDLE TENNESSEE STATE UNIVERSITY JONES COLLEGE OF BUSINESS 3 4 Data: Metric Sales (units) Labor (hours) Labor Cost ($) Materials Cost ($) Equipment (Hours) Equipment Cost ($) Fixed Costs (5) C D G H Productivity Analysis Assignment Total = 75 points: Productivity Calculation Tab (30 points) + What If Analyis Tab (45 points) Use column Ffor Use column G for questions 8-10 questions 8-10 Parent (Domestic) Subsidiary (LDC) Parent (Domestic) Subsidiary (LDC) 1,400,000 480,000 1,900,000 500,000 40 000 20,000 30,000 28,000 $582 800 $110,400 $437.100 $154,560 S400,000 $200.000 $400.000 $208,333 120.000 30 000 120,000 30,000 $1,359,600 $225,000 $1,500,000 $225,000 $2,000,000 S725,000 $2,000,000 $725,000 5 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 Measure Labor Productivity (units/labor hour) Labor Productivity (units/labor $) Materials Productivity (units/5) Equipment Productivity (units/hour) Equipment Productivity (units/$) Total-Factor Productivity (units/$) Values from Prior Page Parent Organization 35.00 2.40 35.00 11.67 2.40 0.32 Subsidiary Organization 24.00 4.35 24.00 16.00 4.35 0.38 What If Values Parent Organization Subsidiary Organization 63.33 17.86 4.35 4.75 2.40 15.83 16.67 1.27 2.22 0.44 0.38 EU What-it Analysis 67 Reflection 60 11. Based on your experience with the "what-if analysis exercises, summarize what you learned concerning productivity measurement and the impact of making operational changes e interaction of the various 70 72 73 74 75 Productivity Calculations What If Analysis + 2 Type here to search ORA