Reference no: EM13990130
I need assistance with the following assignment:
Case study - Corporate Greenhouse Gas Accounting - Carbon footprint analysis (UVA-ENT-0113) April 14,2009
GHG Accounting Problem
Frito-Lay is considering an ambitious plan to take its Casa Grande, Arizona manufacturing plant "off the grid" through the installation of the latest energy saving and water saving technologies. The plant makes Lay's potato chips, Doritos tortilla chips, Fritos corn chips, and Cheetos cheese flavored snacks. The plant uses energy in the two principal forms: natural gas from their local pipeline supplier and electricity from the grid. The energy is used to power production equipment, heat ovens, and to heat cooking oil. The company also uses water from the local water utility.
After the energy upgrades are installed, the company expects a 75% reduction in water use, an 80% reduction in natural gas consumption, and a 90% reduction in purchased electricity. Frito-Lay calls this plan the Net Zero Plan. The company's historical and projected consumption of electricity and natural gas are shown in the attached spreadsheet.
For this assignment, you should carefully read the methodology for calculated greenhouse gases described in the "Corporate Greenhouse Gas Accounting: Carbon Footprint Analysis" case, and understand the difference between Scope 1 emissions and Scope 2 emissions. Then you should complete the following two tasks:
Frito Lay Student Template Excel Document
Task 1: Refer to the case exhibits and then fill in the data in the Excel spreadsheet to compute the GHG emissions for the Net Zero Plan assuming that the plan is implemented fully on January 1, 2008. In the final step (Step 6), you will compute the estimated total dollar savings for Frito Lay for the period 2008-2010.
Task 2: Write a one-paragraph capital spending justification for the project.
Will need to submit and Excel document and a word document.
The GHG Frito Lay accounting exercise is due on Day 5 - Friday. If you have trouble finding it, which some students have, here is a link to it:
https://2012books.lardbucket.org/books/entrepreneurship-and-sustainability/s09-03-frito-lay-north-america-the-ma.html
Attachment:- STUDENT TEMPLATE.xlsx
|
Calculate the non-relativistic speed of these electrons
: An evacuated tube uses a potential difference of V = 0.3 kV to accelerate electrons, which then hit a copper plate and produce X-rays. Write an expression for the non-relativistic speed of these electrons v in terms of eV, and m, assuming the el..
|
|
Find the cumulative distribution function
: The random variable x takes on the values 1, 2, and 3 with probabilities (1 + 3k) / 3, (1 + 2k) / 3, and (0.5 + 5k) / 3, respectively.
|
|
What can be done to improve crm
: Explain the way(s) an organization with which you are familiar measures quality and customer satisfaction. What can be done to improve CRM
|
|
If debt ratio 15 percent and roe 13 percent what is the roa
: If Debt Ratio = 15% , and ROE = 13% What is the ROA?
|
|
Capital spending justification for the project
: Case study - Corporate Greenhouse Gas Accounting and compute the GHG emissions for the Net Zero Plan assuming that the plan - Write a one-paragraph capital spending justification for the project.
|
|
Which country is relatively capital abundant
: supposing that cars are capital intensive relative to shoes, which country will have comparative advantage in the production of cars? Of shoes? Explain.
|
|
What mass of water must evaporate from the skin
: What mass of water must evaporate from the skin of a 66.0 kg man to cool his body 1.30oC? The heat of vaporization of water at body temperature (37.0 oC) is 2.42x106J/kg. The specific heat capacity of a typical human body is 3480 J/(kg.K).
|
|
What is the likelihood the sample mean is greater than
: Assume a random sample of 40 gasoline stations is selected and their mean cost for regular gasoline is computed. What is the likelihood the sample mean is greater than $3.08?
|
|
Determine the unit contribution margin and the break-even
: Determine the unit contribution margin and the break-even volume in units and in dollars per month. What sales volume in units and in dollars per month will be necessary to produce an operating income equal to a 30 percent annual return on Teguh's $4..
|