AutoSave Off Ch 1 Lab Winter 2024 (1) File Home Insert Draw Page Layout Formulas Data...

Transcribed Image Text:

AutoSave Off Ch 1 Lab Winter 2024 (1) File Home Insert Draw Page Layout Formulas Data Review Calibri 11 = Paste BIU 0 Clipboard F14 A B fx Font C D Search View Automate Help ab Wrap Text Currency Merge & Center $ % 9 Alignment Number E F G Insert Aidan Ostrowski AO Comments Share Conditional Format as Formatting Table Cell Styles DX Delete Format Styles Cells Sort & Find & Filter Select Editing Sensitivity Add-ins Analyze Data Sensitivity Add-ins H | J K 123 4567800 Hourly Wage $24.00 $4.00 $16.00 The weekly output of a fabrication process is shown below together with data for labor and material inputs. Standard selling price is $24 per unit. Overhead is charged weekly at the rate of $300 plus 0.2 times direct labor cost. Assume a 40-hour week and an hourly wage of $16. Material cost is $4 per foot. What is the average multifactor productivity in 12 weeks? What is happening to the competitive advantage of this business over time? Selling Price per Unit Material Cost Per Unit Overhead Rate Overhead Fixed Cost .2 x labor cost $300.00 40 Weekly Work Hours per Worker 9 Week Output (units) # of Workers Material (ft) Output ($) Labor Input ($) Material Input ($) Overhead ($) Labor Productivity Material Productivity Multi-Factor Productivity 10 11 12 13 14 15 16 17 12345678 3500 33 2564 3460 32 2625 3504 34 2754 3473 31 2800 3589 34 2807 3615 33 2803 3726 32 2872 3779 35 2983 18 9 3638 34 3138 19 10 3958 32 3091 20 11 3850 32 3290 21 12 3954 32 3317 22 23 24 25 26 27 28 29 30 Intro Example1 Example 2 + Accessibility: Investigate Ready 40F Cloudy Search W NEW + 115% 5:33 PM 12/23/2023 AutoSave Off Ch 1 Lab Winter 2024 (1) File Home Insert Draw Page Layout Formulas Data Review Calibri 11 = Paste BIU 0 Clipboard F14 A B fx Font C D Search View Automate Help ab Wrap Text Currency Merge & Center $ % 9 Alignment Number E F G Insert Aidan Ostrowski AO Comments Share Conditional Format as Formatting Table Cell Styles DX Delete Format Styles Cells Sort & Find & Filter Select Editing Sensitivity Add-ins Analyze Data Sensitivity Add-ins H | J K 123 4567800 Hourly Wage $24.00 $4.00 $16.00 The weekly output of a fabrication process is shown below together with data for labor and material inputs. Standard selling price is $24 per unit. Overhead is charged weekly at the rate of $300 plus 0.2 times direct labor cost. Assume a 40-hour week and an hourly wage of $16. Material cost is $4 per foot. What is the average multifactor productivity in 12 weeks? What is happening to the competitive advantage of this business over time? Selling Price per Unit Material Cost Per Unit Overhead Rate Overhead Fixed Cost .2 x labor cost $300.00 40 Weekly Work Hours per Worker 9 Week Output (units) # of Workers Material (ft) Output ($) Labor Input ($) Material Input ($) Overhead ($) Labor Productivity Material Productivity Multi-Factor Productivity 10 11 12 13 14 15 16 17 12345678 3500 33 2564 3460 32 2625 3504 34 2754 3473 31 2800 3589 34 2807 3615 33 2803 3726 32 2872 3779 35 2983 18 9 3638 34 3138 19 10 3958 32 3091 20 11 3850 32 3290 21 12 3954 32 3317 22 23 24 25 26 27 28 29 30 Intro Example1 Example 2 + Accessibility: Investigate Ready 40F Cloudy Search W NEW + 115% 5:33 PM 12/23/2023