Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required: Estimate the fixed and variable components of historic electricity bills. Record your estimates in the excel file under the tab Budget - 2024. a.

Required:\ Estimate the fixed and variable components of historic electricity bills. Record your estimates in the excel file under the tab "Budget - 2024".\ a. Typically, electricity bills have two components:\ i. Fixed delivery charge that does not vary with consumption.\ ii. Variable rate per kilowatt hour

(kWh)

.\ Use the above estimates to forecast monthly electricity costs for 2024 . You've been provided with estimated usage in the excel file under the tab "Budget -2024 ". Record your estimates in the table " 2024 Forecast - 1 ".\ The months May, June, July, and August are considered peak months. This means that electricity generally costs more during these months. You are required to estimate whether the higher cost is usage-based only, or if the delivery charge is higher during peak months also. Record your estimates in the excel file under the tab "Budget - 2024 ".\ Produce a second set of monthly forecasts for 2024 using the updated costs you calculated in requirement 3. Record your estimates in the table "2024 Forecast - 2".\ Note: Do not delete any observation in the dataset. You must use all the data in your analyses. Ignore p-values and statistical significance.\ Record your answers in the excel workbook in the tab "Budget - 2024". You must show all your work within excel. You MUST submit your excel file to Moodle by 10:15 am.

image text in transcribed
1) Estimate the fixed and variable components of historic electricity bills. Record your estimates in the excel file under the tab "Budget - 2024". a. Typically, electricity bills have two components: i. Fixed delivery charge that does not vary with consumption. ii. Variable rate per kilowatt hour (kWh). 2) Use the above estimates to forecast monthly electricity costs for 2024 . You've been provided with estimated usage in the excel file under the tab "Budget - 2024". Record your estimates in the table "2024 Forecast - 1". 3) The months May, June, July, and August are considered peak months. This means that electricity generally costs more during these months. You are required to estimate whether the higher cost is usage-based only, or if the delivery charge is higher during peak months also. Record your estimates in the excel file under the tab "Budget - 2024 ". 4) Produce a second set of monthly forecasts for 2024 using the updated costs you calculated in requirement 3. Record your estimates in the table "2024 Forecast - 2 ". Note: Do not delete any observation in the dataset. You must use all the data in your analyses. Ignore p-values and statistical significance. Record your answers in the excel workbook in the tab "Budget - 2024". You must show all your work within excel. You MUST submit your excel file to Moodle by 10:15 am. 1) Estimate the fixed and variable components of historic electricity bills. Record your estimates in the excel file under the tab "Budget - 2024". a. Typically, electricity bills have two components: i. Fixed delivery charge that does not vary with consumption. ii. Variable rate per kilowatt hour (kWh). 2) Use the above estimates to forecast monthly electricity costs for 2024 . You've been provided with estimated usage in the excel file under the tab "Budget - 2024". Record your estimates in the table "2024 Forecast - 1". 3) The months May, June, July, and August are considered peak months. This means that electricity generally costs more during these months. You are required to estimate whether the higher cost is usage-based only, or if the delivery charge is higher during peak months also. Record your estimates in the excel file under the tab "Budget - 2024 ". 4) Produce a second set of monthly forecasts for 2024 using the updated costs you calculated in requirement 3. Record your estimates in the table "2024 Forecast - 2 ". Note: Do not delete any observation in the dataset. You must use all the data in your analyses. Ignore p-values and statistical significance. Record your answers in the excel workbook in the tab "Budget - 2024". You must show all your work within excel. You MUST submit your excel file to Moodle by 10:15 am

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Process Audits And 6 Sigma Excellence To Mitigate Risk And Improve Business Performance

Authors: Mr Indulis Laimonis Svikis

1st Edition

B09M5FPYR4, 979-8769768996

More Books

Students also viewed these Accounting questions