Question

In: Operations Management

The accounting department needs to forecast electricity expense for one of the buildings. The data for...

The accounting department needs to forecast electricity expense for one of the buildings. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the linear regression. Please round your forecast to the nearest whole number.

Apr 2020: 1463 Mar 2020: 1372 Feb 2020: 1087 Jan 2020: 1316 Dec 2019: 1346 Nov 2019: 1224
Oct 2019: 1050 Sep 2019: 1201 Aug 2019: 1320 Jul 2019: 1232 Jun 2019: 1472 May 2019: 1323
Apr 2019: 1490 Mar 2019: 1464 Feb 2019: 1147 Jan 2019: 1208 Dec 2018: 1471 Nov 2018: 1085
Oct 2018: 1477 Sep 2018: 1045 Aug 2018: 1473 Jul 2018: 1171 Jun 2018: 1480 May 2018: 1433
Apr 2018: 1369 Mar 2018: 1157 Feb 2018: 1079 Jan 2018: 1095 Dec 2017: 1127 Nov 2017: 1445
Oct 2017: 1381

Solutions

Expert Solution


Related Solutions

The accounting department needs to forecast the profit for a subsidiary. The data for several months...
The accounting department needs to forecast the profit for a subsidiary. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing with trend accounting for seasonality given a smoothing constant (alpha) of 0.69, a trend smoothing constant (delta) of 0.3, a previous trend amount, seasonally adjusted, of 65, and a previous seasonal forecast of 582. Please round your forecast to...
The purchasing and supply department needs to forecast the number of tubes of adhesive being ordered....
The purchasing and supply department needs to forecast the number of tubes of adhesive being ordered. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing accounting for seasonality with a smoothing constant of 0.35 and a previous forecast (with seasonality) of 635. Please round your forecast to the nearest whole number. Jul 2020: 588 Jun 2020: 508 May 2020:...
The human resources department needs to forecast the number of sexual harassement investigations for the entire company.
  The human resources department needs to forecast the number of sexual harassement investigations for the entire company. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the 4 month weighted moving average adjusting for seasonality where the weights, starting with the most recent time period, are 0.4, 0.3, 0.2, 0.1. Again, you must find the seasonality factors for the data....
A manufacturing area needs to forecast workhours. This is a slightly different project. The data for...
A manufacturing area needs to forecast workhours. This is a slightly different project. The data for several months is supplied below. Beside each of the actual numbers in black, the forecast is provided in red. The goal is to calculate three stats on the data: MAD, MAPE, and the tracking signal. Be careful since the data is listed beginning with the most recent. Please round to two decimal places. For MAPE, please convert to a percentage before rounding. Do not...
The accounting department of a large corporation checks the addition of expense reports submitted by executives...
The accounting department of a large corporation checks the addition of expense reports submitted by executives before paying them. historically, they have found that 15% of the reports contain additional errors. an auditor randomly selects 80 expense reports and audits them for additional errors. find the probability that between 5 and 15 (inclusive) of the sampled expense reports will have addition errors.
The IT department at Universal AreoSpace uses three Windows servers: one for the Accounting Department, one...
The IT department at Universal AreoSpace uses three Windows servers: one for the Accounting Department, one for engineering, and one for the Marketing Department. These servers are running on separate systems that are aging and do not have the capability for future expansion. A suggestion is to save costs by virtualization to consolidate their servers and provide high availability in the event of hardware failure. Write a memo that discusses the advantages and disadvantages of virtualization and discusses which data...
The IT department at Universal AreoSpace uses three Windows servers: one for the Accounting Department, one...
The IT department at Universal AreoSpace uses three Windows servers: one for the Accounting Department, one for engineering, and one for the Marketing Department. These servers are running on separate systems that are aging and do not have the capability for future expansion. A suggestion is to save costs by virtualization to consolidate their servers and provide high availability in the event of hardware failure. Write a memo that discusses the advantages and disadvantages of virtualization and discusses which data...
The accounting records of Pearl Inc. show the following data for 2017 1. Life insurance expense...
The accounting records of Pearl Inc. show the following data for 2017 1. Life insurance expense on officers was $9,500. 2. Equipment was acquired in early January for $307,000. Straight-line depreciation over a 5-year life is used, with no salvage value. For tax purposes, Pearl used a 30% rate to calculate depreciation. 3. Interest revenue on State of New York bonds totaled $3,700. 4. Product warranties were estimated to be $50,900 in 2017. Actual repair and labor costs related to...
Muhanad is a new hire in the accounting department of Jawwal. One of your responsibilities is...
Muhanad is a new hire in the accounting department of Jawwal. One of your responsibilities is the reconciliation of the operating account. After the end of the month he is given a copy of the bank statement and listing of checks paid during the month, and is instructed to perform bank reconciliation. He notices that there are some faint markings on a portion of the bank statement that could be alterations. What steps would you advise him to take in...
In an electricity market, there is only one provider who calls itself '' Electricity-to-All. The company's...
In an electricity market, there is only one provider who calls itself '' Electricity-to-All. The company's total cost function can be written as TC(Q)=10.000.000+200Q where Q is the amount of electricity produced. The demand curve can be written as Q=200.000-250P where the price is for a unit of electricity 1- How much output should the company produce to maximize profit? What will the price be? 2- How much profit and how much '' consumer surplus '' does the company generate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT