Explain the formula you have used in break even worksheet

Assignment Help Advanced Statistics

Reference no: EM13751744

Task - Spreadsheet

EnviroCo offers a service to customers to advise them about the government Feed In Tariff (FIT) payments.

The file FIT_Rates.csv contains a table of rates set by the government for different types of domestic renewable systems. The values given are the amount in pence per unit for electricity generated that the government pays the owner of a system. Fig. 2.1 shows a suggested form design to enter the parameters that are required to calculate the FIT payment rate.

1176_tariff calculator.png

The parameters that must be entered are the EPC, Size of system (kWh), Renewable type, House type, Certification granted? And the Date of installation, A FIT is calculated that is based on these values.

Model requirements

A worksheet should be designed to calculate the FIT a system would be eligible for when the parameters are set.

• EPC. Houses are rated in terms of energy efficiency. Houses in bands A to D are rated high and houses in bands E to G are rated low. A dropdown list should be used to select the EPC band (A to G).
• FIT rate. Any Solar PV system fitted before 03/03/2012, or one fitted on a property in the high EPC band at any date, qualifies for the higher FIT rate. Any Solar PV system fitted on a property in the low EPC band on or after 03/03/2012 qualifies for the lower FIT rate.
• Size of system (kWh). Domestic systems can be up to a maximum size of 9.99 kWh. A scroll bar or spinner should be used to select the system capacity. The control should allow values between 0 and 9.99 kWh to be input with increments of 0.01 kWh.
• Renewable type. Option buttons should be used to allow either a Solar PV system or a Wind system to be selected.
• House type. House types can either be new build or retrofit. Option buttons should be used to select the type of house.
• Micro renewable certification. A system is either certified or it is not. Systems that have not been certified will not be eligible for any FIT payments. A check box should be used to enter the certification status.
• Date of installation. Systems installed before 01/04/2010 are not eligible. A validation rule should be set up to generate a customized error message if an invalid date is entered.
• The actual value of the FIT must be calculated.
• If the system is not eligible for payments the FIT rate should be set to zero. The message 'Your system DOES NOT qualify' should be displayed. The background to the cell containing the FIT rate should automatically be set to red.
• If the system is eligible for payments the FIT rate should be displayed. The message 'Your system DOES qualify' should be displayed. The background to the cell containing the FIT rate should automatically be set to green.

(a) (I) Print screenshot evidence of the completed interface for the FIT Tariff worksheet.

(II) Produce annotated evidence to explain how the interface was set up to meet the requirements. You should explain any values that the form controls use.

(III) Produce annotated evidence to explain how the print button was implemented.

(IV) Print the worksheet showing the formulae. The row and column headings must be displayed.

(b) (I) Set the values in the FIT_Tariff worksheet to those in Figure 2.1 and enter the following values for the variables in the Break Even worksheet:

• Export Rate = £0.0450
• Units Generated = 2300
• Installation Cost = £10,000

Print the Break_Even worksheet on one side of A4 making sure that you show row and column headings on the printout.

(II) Produce annotated evidence to explain the formula you have used in the Break Even worksheet.

All named ranges should be identified and row and column headings should be displayed.

(III) Choose a formula in your solution which uses both relative and absolute addressing Explain why you decided to use both forms of addressing in this formula, and how it helped you to create the solution.

Reference no: EM13751744

Questions Cloud

Discuss the dangers of a high debt to gdp ratio : Discuss the dangers of a high debt to GDP ratio and a growing budget deficit and What is the first action you would take as the president? As the chairman of the Fed? Why? What would be your subsequent steps?

Desribe the contents of the bible dictionary : Desribe the contents of the Bible dictionary and how it is organized what kinds of articles are included, who is the author / editor, is each article is autjored by a different person, etc.

Equipment for the cardiac catheterization : You are considering acquiring new equipment for the cardiac catheterization lab. You have the option to lease, or to buy the equipment. Your proposal will need to be vetted or cleared through the CFO, who will want all the details and reasoning in..

Compliance and ethics in risk management : During the past couple of decades there have been high profile cases of corporate scandals resulting in not only criminal prosecutions of senior executives within the guilty firm, but severe financial loss or even dissolution of the corporation.

Explain the formula you have used in break even worksheet : Produce annotated evidence to explain the formula you have used in the Break Even worksheet. Produce a help sheet(s) to show how to protect cells and worksheets in the system

Identify historical factors and explain their significance : Identify historical factors and explain their significance in contributing to change and continuity in the ancient world?

Write a summary of the life and careers of mae street kid : Passing for Black: The Life and Careers of Mae Street Kid is an oral auto-biography. It is a translation and summarization of some forty hours of taped interviews.

Describing spot market and comparing foreign markets : In this assignment, you will write a paper describing spot market and comparing foreign markets to the domestic market.

Write paper that analyzes colonists attitudes toward british : Write a paper that analyzes the colonists' attitudes toward British rule in the 1760s and 1770s, and how those attitudes changed during the course of the Imperial Crisis from 1765 to 1775.

User Account

All Pages