Calculate labor productivity

Assignment Help Marketing Management
Reference no: EM13754813

Question 1. A store manager has tracked hours worked and orders processed as given below.

 

Hours Worked

Cashier

1-Feb

2-Feb

3-Feb

4-Feb

5-Feb

6-Feb

7-Feb

8-Feb

Kevin

 

 

8

7

7

 

 

8

Lisa

8

8

 

8

 

8

7

7

Mark

   

7

7

8

 

8

 

Naomi

8

8

 

 

7

7

 

 

Oscar

8

8

8

 

 

8

8

8

 

Orders Processed

Cashier

1-Feb

2-Feb

3-Feb

4-Feb

5-Feb

6-Feb

7-Feb

8-Feb

Kevin

 

 

94

76

73

 

 

102

Lisa

82

83

 

104

 

94

88

88

Mark

 

 

76

75

97

 

96

 

Naomi

107

107

 

 

91

88

 

 

Oscar

75

96

102

 

 

79

78

107

1. For each cashier, compute his or her overall productivity (in orders per hour) over all eight days. You should have one number per cashier.

2. For each cashier, compute his or her productivity (in orders per hour) over the period 2/1 through 2/4. Using the MIN function, find the lowest productivity for 2/1 - 2/4 among the cashiers.

3. For each cashier, computer his or her productivity (in orders per hour) over the period 2/5 through 2/7. Using the MAX function, find the highest productivity for 2/5 - 2/7 among the cashiers.

Question 2. For this question set, you will calculate labor productivity and multifactor productivity, both in tons of rock salt produced per dollar value of inputs.

The Delaware Salt Company employs 90 full-time line workers (each working 40 hours per week at a wage of $12/hr) and 6 managers, each earning a salary of $1,500/week. The company has capital expenses (plant, property, and equipment) of $24,000 per week and produces 180,000 tons of rock salt per week. The company recently installed new equipment that will increase weekly output by 9% and weekly capital expenses by 5%. You will need the following formulas:

Labor productivity =

Multifactor productivity =

After copying the table below into Excel, solve the following questions:

1. Calculate labor productivity using just the line workers (do not include the managers) for the old and new systems, in tons of output per dollar of input.

2. Calculate labor productivity including all employees (line workers & managers) for the old and new systems, in tons of output per dollar of input.

3. Calculate the multifactor productivity (including line workers, managers, and capital expenses) for the old and new systems, in tons of output per dollar of input.

4. Calculate the percentage changes in labor and multifactor productivity. (3pts)

 

Labor Productivity

(excluding managers)

Labor Productivity

(including managers)

Multifactor Productivity

Old System

 

 

 

New System

 

 

 

Percentage Change

 

 

 

Question 3: A small manufacturing plant produces specialized stainless steel valves for high-pressure steam systems. Each valve costs $3000 to produce. The plant incurs $2,700,000 in fixed annual costs. The plant sells the valves directly to power plants for $5400 each.

For this question set, use the following formulas:

[Total Profit] = [Total Revenue] - [Total Cost]
[Total Revenue] = [Production] x [Unit Revenue]
[Total Cost] = [Production] x [Variable Unit Cost] + [Fixed Costs]

1. Create a data table (as demonstrated during lab exercise 2), that shows what total profit would be if the company produced 1500 to 2500 valves, in increments of 50. You must use a data table structure to receive credit for this problem.

2. Create a scatter chart that displays the variable total profit (and no other variables) as a function of the number of valves produced and sold. At low production quantities, total profit will be negative but should still be displayed. Label your chart axes appropriately.

 

Reference no: EM13754813

Questions Cloud

Nmap application and how it can be used : Write a one papge paper APA FORMAT about NMAP application and how it can be used to find vulnerabilities
Create a website that enables interactivity : Create a website from scratch that enables interactivity between a user and the organization. The website is meant for a museum.
Traditional project management : Frederick Brooks has defended and refined NSB since 1986, and the asserts that one point proved to be correct
Write an essay on womens suffrage movement : Write an essay on Women's Suffrage Movement.
Calculate labor productivity : Calculate labor productivity using just the line workers (do not include the managers) for the old and new systems, in tons of output per dollar of input
Compare china and japan : Compare China and Japan. Why China had it harder than Japan to resist Western imperialism and what impact did it?
What meant abraham lincolns accession to power in 1860 : What meant Abraham Lincoln's accession to power in 1860 for the conflict between North and Southern states?
Who is the current chairman of the fed : Who is the current Chairman of the Fed - Should the Fed remain independent from political authority or should the President and Congress have a say in their operations?
What happend in the battle of hastings 1066 : What happend in the battle of hastings 1066?

Reviews

Write a Review

Marketing Management Questions & Answers

  Integrated marketing communication

Developing an IMC plan of Amazon that aims to create awareness and knowledge amongst Singaporean  consumers of the ethics involved in buying clothing made from Bangladeshi factories  .

  Multiple choice questions on e-commerce

The assignment in Computer Science or Information Technology is about multiple choice questions, particularly in e-commerce. Questions such as types of e-commerce websites, commercial websites, disintermediation, Platform for Piracy, the data that ca..

  Balanced scorecard for red lobster

The assignment in marketing is about Red Lobster, which is one US and Canada's most loved seafood restaurant. It has hundreds of outlets in US and Canada and it now wants to expand further. The approach adopted by Red Lobster has been discussed in fu..

  Marketing plan - marketing audit, swot and smart report

The assignment in marketing is about preparing a marketing plan. As part of marketing plan, the SWOT analysis, assessing the competitive position, identifying critical competitive issues, marketing objectives, strategy and actions have been suggested..

  Marketing plan

Marketing deals with preparing a marketing plan for either an existing product or a new product. Various aspects about launching a new product into the market are discussed ranging from the industry the product belongs to, goals and vision of the com..

  Yamato corporation analysis - harvard case study

Please refer to the PDF for the Case Study and questions.The case study from Harvard Business School is about Yamato Corporation, a parcel delivery company which provides door to door delivery in Japan.

  Marketing plan - create a new product

The assignment in marketing is about competitive analysis for a new product namely "heated insoles". These heated insoles can be put in shoes and they can protect the wearer's feet by keeping them warm during cold winters.

  Report on digital marketing strategy for a website

Promotion strategies of  the one's own developed website

  Integrated marketing campaign of mccafe

Integrated marketing campaign for McDonald's McCafe. McCafe has been launched in Canada. This is a case study which involves the use of digital marketing and social media marketing apart from regular marketing such as TV and radio. All these more are..

  New product development at adidas

In this paper, the researcher also determines the different kind of practices used by Adidas to manufacture shoes for its customers.

  Managing services in competitive environment

Services can be defined as separately identifiable, intangible activities which provide want-satisfaction when marketed to household consumers and/or industrial users.

  Prepare a marketing plan

A marketing plan is an essential tool for any marketer, providing direction for a brand, product or organization. A marketing plan describes the marketing environment, marketing objectives and marketing strategies.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd