Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

How to calculate total factor productivity in excel

20/10/2021 Client: muhammad11 Deadline: 2 Day

Productivity Calculations
Productivity Analysis Assignment
Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points) Assignment Learning Objectives
Use data in columns C & D for the
Data: Calculation Exercises 1a - 6c 1. Calculate single factor and total factor productivity measures
Metric Parent (Domestic) Subsidiary (Less Developed Country) Hint: Use Excel formulas to calculate your answer. 2. Interpret productivity measures and draw appropriate conclusions
Sales (units) 1,750,000 650,000 For Example: To calculate the Parent's total labor dollars, you multiply labor hours * labor cost 3. Use formulas in Excel
Units Produced 1,400,000 480,000 In Excel, you enter: =C7*C8 4. Use Excel to perform "What-If" Analysis
Labor (hours) 40,000 20,000 The "=" sign tells Excel that you are entering a formula and then you multiply the two cells that contain your data
Labor Cost ($) per hour $14.57 $5.52
Materials Cost ($) $400,000 $200,000
Equipment (Hours) 120,000 30,000
Equipment Cost ($) $1,359,600 $225,000
Fixed Costs ($) $2,000,000 $725,000
Selling Price per Unit $19.99 $19.99 Total points this worksheet = 30 points
Calculation Exercises:
Labor Productivity (units/hour)
1a. Compute the single-factor productivity for labor for the Parent operations in units per hour (enter your formula in cell B20).
Cell B20 must be a formula units/labor hour
1b. Compute the single-factor productivity for labor for the Subsidiary operations in units per hour (enter your formula in cell B23).
Cell B23 must be a formula units/labor hour
1c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor labor productivity in units per hour
Labor Productivity (units/$)
2a. Compute the single-factor productivity for labor for the Parent operations in units per dollar (enter your formula in cell B31).
Cell B31 must be a formula units/labor $
2b. Compute the single-factor productivity for labor for the Subsidiary operations in units per dollar (enter your formula in cell B34).
Cell B34 must be a formula units/labor $
2c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor labor productivity in units per dollar.
Materials Productivity (units/$)
3a. Compute the single-factor productivity for materials for the Parent operations in units per dollar (enter your formula in cell B42).
Cell B42 must be a formula units/$
3b. Compute the single-factor productivity for materials for the Subsidiary operations in units per dollar (enter your formula in cell B45).
Cell B45 must be a formula units/$
3c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor materials productivity in units per dollar.
Equipment Productivity (units/hour)
4a. Compute the single-factor productivity for equipment for the Parent operations in units per hour (enter your formula in cell B53).
Cell B53 must be a formula units/hour
4b. Compute the single-factor productivity for equipment for the Subsidiary operations in units per hour (enter your formula in cell B56).
Cell B56 must be a formula units/hour
4c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor equipment productivity in units per hour.
Equipment Productivity (units/$)
5a. Compute the single-factor productivity for equipment for the Parent operations in units per dollar (enter your formula in cell B64).
Cell B64 must be a formula units/$
5b. Compute the single-factor productivity for equipment for the Subsidiary operations in units per dollar (enter your formula in cell B67).
Cell B67 must be a formula units/$
5c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor equipment productivity in units per dollar.
Total-Factor Productivity:
6a. Compute the total-factor productivity (all factors) for the Parent operations in units per dollar (enter your formula in cell B75).
Cell B75 must be a formula units/$
6b. Compute the total-factor productivity (all factors) for the Subsidiary operations in units per dollar (enter your formula in cell B78).
Cell B78 must be a formula units/$
6c. Interpret your findings by indicating which of the two entities is more productive in terms of total-factor productivity in units per dollar.
What-If Analysis
Productivity Analysis Assignment
Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points)
Current Values Use column F for
Data: question 8
Metric Parent (Domestic) Subsidiary (LDC) Parent (Domestic)
Sales (units) 1,400,000 450,000 1,400,000
Units Produced 1,400,000 480,000 1,400,000
Labor (hours) 40,000 20,000 40,000
Labor Cost ($) per hour $14.57 $5.52 $14.57
Materials Cost ($) $400,000 $200,000 $400,000
Equipment (Hours) 120,000 30,000 120,000
Equipment Cost ($) $1,359,600 $225,000 $1,359,600
Fixed Costs ($) $2,000,000 $725,000 $2,000,000
Selling Price per Unit $9.99 $7.99 $9.99
What-If Productivity Values Based on New Data Entered in Column F
Measure Parent Organization
Labor Productivity (units/labor hour) 35.00
Labor Productivity (units/labor $) 2.40
Materials Productivity (units/$) 3.50
Equipment Productivity (units/hour) 11.67
Equipment Productivity (units/$) 1.03
Total-Factor Productivity (units/$) 0.32
Labor
7. Provide one possible explanation how the Parent can be more productive when considering labor productivity in units per hour, but the subsidiary is more productive in units per dollar.)
Parent Equipment Purchase (Part #1)
8. Assume purchase of new equipment at an incremental, one-time fixed cost of $1,500,000 resulting in a reduction in labor hours to 30,000, a reduction in Equipment Hours to 100,000, and a reduction of Equipment Costs to $1,248,000 with all other costs remaining the same. Change the appropriate values in column F above. Answer the questions below by comparing the new productivity value in cells D18 through D23 to the values you calculated on the "Productivity Calculations" worksheet. For example, if the value in D18 on this worksheet (Labor Productivity in units/labor hour) is less than the value for Labor Productivity in units/labor hour for the Parent operations on the "Productivity Calculations" worksheet, then choose "decreased"
Productivity Measure Choose the correct answer for each productivity calculation
Labor Productivity in terms of units/labor hour
Labor Productivity in terms of units/labor $
Materials Productivity in terms of units/Materials Cost ($)
Equipment Productivity in terms of units/hour
Equipment Productivity in terms of units/$
Total Factor Productivity in terms of units/$
Parent Equipment Purchase (Part #2)
9. Calculate Total Revenue prior to any equipment changes using data in cells C6 through C14 above. The formula for Profit is Total Revenue - Total Costs The formula for Total Revenue is Total Units Sold * Selling Price per Unit
Pre Equipment Purchase Total Profit
Post Equipment Purchase Total Profit
10. Summarize your observations concerning how the potential new equipment purchase will impact each of the productivity values and total revenue. Provide a recommendation whether to purchase the equipment and also provide supporting evidence for your recommendation.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Smart Tutor
Math Specialist
Accounting & Finance Mentor
Top Quality Assignments
Professor Smith
Financial Analyst
Writer Writer Name Offer Chat
Smart Tutor

ONLINE

Smart Tutor

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$48 Chat With Writer
Math Specialist

ONLINE

Math Specialist

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$15 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$21 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$37 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$46 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$25 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

What does yellow balloons mean - Technology worksheet hcs 131 - Vampyr watery sturdy blood sample - The beatles eleanor rigby meaning - Chris rose logan city council - How to create a scrum board - Mth 221 discrete math for information technology - Anglo belgian india rubber company militia - What is a synthesis claim - Build a wind powered car - Concave slope in geography - Protein synthesis practice 2 - Nanda nursing diagnosis 2017 - People in monochronic cultures __________. - How many trapezoids make 4 hexagon - Employee relations strategy ppt - Research methods is the course need these 4 ? Answered - Network identification code - Awakenings movie questions and answers - A byte consist of how many bits - Norse gods family tree - Sheet molding compound disadvantages - Human behavior negative and positive effects on the environment - Cardax access control system - Triple data encryption standard - Why is the social technographics ladder useful - Mamá hola daniela cómo 1 - An example of a persuasive message - Suffolk netball league tables - Was Robert Eaton a Good Coach ( case study essay) - Dixell controller xr02cx manual - ACC 499 Week 6 Discussion 2 "NBC Learn Videos: Cyberattacks on Public Companies" - Newman's own organics is considered a socially responsible company because it ________. - Section 131 quicken loans arena - How many ounces in a medium jamba juice smoothie - Nursing. - Enthusiasm poem omega psi phi - Why the breakfast club is important - 150w pure sine inverter - Enrich history - Bus timetable adelaide to murray bridge - SECURITY ARCHITECTURE AND DESIGN (ISOL-536-M31) PHD IN IT - Heart failure video case study ati - Nursing - Four frames of art - Healthcare Ethics - Im mary poppins yall ringtone - Cathedral raymond carver pdf - Http denali gsfc nasa gov research lowman lowman_map1_lg jpg - Ecological footprint lab - 600-900 APA style paper Healthcare management - HCA320 Discussion Mod 4: - War and Modernity - Petrus aged pale trader joe's 102 - Critical analysis template - Political Science Discussion 4 - Political Parties - Political Competence - Ocr internal moderation form - Ethical guidelines for the use of animals in psychological research - Help with paper - Ebay a the customer marketplace case analysis - 2 chloro 3 3 dimethylbutane - W8 - How to calculate average voltage of square wave - Texaco racial discrimination case study - Maslow's hierarchy of needs mnemonic - Single European Act (Chp.1) - Separation of mixtures post lab answers - Carters country wear helmsley - Hris needs analysis - Www yougetsignal com tools visual tracert - Criminal justice capstone project examples - Two sinusoidal waves with the same amplitude - Computer maintenance and repair questions and answers - Human service delivery system - A person who routinely forgets how he began a long sentence may be suffering from ________ amnesia. - Community health windshield survey - What is reverted gear train - Avon case study answers - Role of human service worker - Ehl online interview questions - Societies in the world 500 word discussion - The cyclotron mastering physics - Mccormack mccance 2010 person centred nursing - Sender of a billet doux crossword - Discussion Board due Saturday 9.26.2020 - Mat 104 algebra with applications - Ezy math tutoring worksheets - Hand gestures in art - Powerpoint lab assignment - Corporation reported the following financial statements - Persona 5 fortune teller affinity reading - Can someone do my Week 1 work for me Discussion 1 & 2 and in Organizational Behavior? - The case of the sweaty salesman - Gcse computer science 8520 1 mark scheme - Hands on quadrilateral activities - Double declining balance depreciation table - Free policy and procedure template healthcare - Thai tea mix target - Calculating cell size worksheet