File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Calibri - 11 - A A A ab Wrap Text X Cut En Copy - Format Painter Paste BTU A $ % Conditional Format as Formatting Table Alignment Number Clipboard Font Styles A25 c D F H 1 Productivity Analysis Assignment MIDDLE TENNESSEE 2 Total = 75 points: Productivity Calculation Tab (30 points) + What If Analyis Tab (45 points) STATE UNIVERSITY 3 Use column F for Use column G for 4 IONES COWICE OF BUSINESS Data: questions 8-10 questions 8-10 5 Metric Parent (Domestic) Subsidiary (LDC) Parent (Domestic) Subsidiary (LDC) 6 Sales (units) 1,400,000 480,000 1,900,000 500.000 7 Labor (hours) 40,000 20,000 30,000 28,000 8 Labor Cost (5) $582,800 $110,400 $437,100 $154,560 9 Materials Cost ($) $400,000 $200,000 $400,000 $208,333 10 Equipment (Hours) 120,000 30,000 120,000 30,000 11 Equipment Cost (5) $1,359,600 $225,000 $1.500.000 $225,000 12 Fixed Costs ($) $2,000,000 $725.000 $2,000,000 $725,000 13 Values from Prior Page What If Values 15 Measure Parent Organization Subsidiary Organization Parent Organization Subsidiary Organization 16 Labor Productivity (units/labor hour) 35.00 24,00 63.33 17.86 17 Labor Productivity (units/labor $) 2.40 4.35 4.35 3.23 18 Materials Productivity (units/$) 35.00 24.00 4.75 2.40 19 Equipment Productivity (units/hour) 11.67 16.00 15.83 16.67 Equipment Productivity (units/$) 2.40 4.35 1.27 2.22 Total-Factor Productivity (units/$) 0.32 0.38 0.44 55 0.38 56 Subsidiary Sales Increase 10. Assume the subsidiary undertakes an initiative to increase production to sell 500,000 units to meet customer demand. The result is that labor hours increased to 28,000, labor cost increased to $154,560 and materials cost increased to $208,333. Change the appropriate values in column Fabove and answer the following question in the space provided below. Determine how labor productivity, equipment productivity and total factor productivity impacted by the new equipment by indicating "increased", "decreased", or "stayed the same in column C below and calculating the percent change if your answer in column C is increased" or "decreased". 57 Sa Labor Productivity in terms of units/labor hour 59 Labor Productivity in terms of units/labor $ Equipment Productivity in terms of units/hour Equipment Productivity in terms of units/$ Total Factor Productivity in terms of units/S Productivity Calculations What If Analysis Type here to search File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Calibri - 11 - A A A ab Wrap Text X Cut En Copy - Format Painter Paste BTU A $ % Conditional Format as Formatting Table Alignment Number Clipboard Font Styles A25 c D F H 1 Productivity Analysis Assignment MIDDLE TENNESSEE 2 Total = 75 points: Productivity Calculation Tab (30 points) + What If Analyis Tab (45 points) STATE UNIVERSITY 3 Use column F for Use column G for 4 IONES COWICE OF BUSINESS Data: questions 8-10 questions 8-10 5 Metric Parent (Domestic) Subsidiary (LDC) Parent (Domestic) Subsidiary (LDC) 6 Sales (units) 1,400,000 480,000 1,900,000 500.000 7 Labor (hours) 40,000 20,000 30,000 28,000 8 Labor Cost (5) $582,800 $110,400 $437,100 $154,560 9 Materials Cost ($) $400,000 $200,000 $400,000 $208,333 10 Equipment (Hours) 120,000 30,000 120,000 30,000 11 Equipment Cost (5) $1,359,600 $225,000 $1.500.000 $225,000 12 Fixed Costs ($) $2,000,000 $725.000 $2,000,000 $725,000 13 Values from Prior Page What If Values 15 Measure Parent Organization Subsidiary Organization Parent Organization Subsidiary Organization 16 Labor Productivity (units/labor hour) 35.00 24,00 63.33 17.86 17 Labor Productivity (units/labor $) 2.40 4.35 4.35 3.23 18 Materials Productivity (units/$) 35.00 24.00 4.75 2.40 19 Equipment Productivity (units/hour) 11.67 16.00 15.83 16.67 Equipment Productivity (units/$) 2.40 4.35 1.27 2.22 Total-Factor Productivity (units/$) 0.32 0.38 0.44 55 0.38 56 Subsidiary Sales Increase 10. Assume the subsidiary undertakes an initiative to increase production to sell 500,000 units to meet customer demand. The result is that labor hours increased to 28,000, labor cost increased to $154,560 and materials cost increased to $208,333. Change the appropriate values in column Fabove and answer the following question in the space provided below. Determine how labor productivity, equipment productivity and total factor productivity impacted by the new equipment by indicating "increased", "decreased", or "stayed the same in column C below and calculating the percent change if your answer in column C is increased" or "decreased". 57 Sa Labor Productivity in terms of units/labor hour 59 Labor Productivity in terms of units/labor $ Equipment Productivity in terms of units/hour Equipment Productivity in terms of units/$ Total Factor Productivity in terms of units/S Productivity Calculations What If Analysis Type here to search