Nolan Banks is an auditor for the Public Service Commission for the state of Georgia. The PublicService Commission is a government agency responsible for ensuring that utility companies throughout the state manage their operations efficiently so that they can provide quality services to the public at fair prices. Georgia is the largest state east of the Mississippi River, and various communities and regions throughout the state have different companies that provide water, power, and phone service. These companies have a monopoly in the areas they serve and, therefore, could take unfair advantage of the public. One of nolan's jobs it to visit the companies and audit their financial records to detect whether or not any abuse is occuring. A major problem Nolan faces in his job is determining whether the expenses reported by the utility companies are reasonable. For example, when he reviews a financial report for a local phone company, he might see cable line maintenance costs of $1,345,948, and he needs to determine if this amount is responsible. This determination is complicated by the fact that the companies differ in size - so he cannot compare the costs of one company directly to another. Similarly, he cannot come up with a simple ratioo to determine costs (such as 2% for the ratio of line maintenance costs to total revenue) because a single ratio might not be appropriate for companies of different sizes.

To help solve this problem, Nolan wants you to build a regression model to estimate what level of line maintenance expense would be expected for companies of different sizes. One measure of size for a phone company is the number of customers it has. Nolan collected the data in the file PhoneService.xlsx representing the numeber of customers and line maintenance of 12 companies he audited in the past year and determined being run in a reasonably efficient manner.

In your spreadsheet, calculate the estimated line maintenance expense that would be predicted by the quadratic regression function for each company in the sample. Plot these values on your graph (connected with a line) along with the original data and the original regression line.

(Y= b₀+b₁x₁+b₂x^2/1)

Question 9 (1 point)
Twelve students who were not satisfied with their ACT scores particiapted in an online 10-hour training program. The ACT scores before and after the training for the 12 students are given below:

Student Before After
1 23 27
2 25 26
3 27 31
4 30 32
5 24 26
6 25 24
7 27 31
8 26 28
9 28 30
10 22 25
11 20 24
12 29 32
Test a claim that the program is effective in improving a student’ ACT score.

What is the p-value?

Question 9 options:

Essentially 0

0.0325

0.0478

1.000

For the dataset Production Count.xlsx.   Is there evidence at a 5% significance level that the mean production count for factory workers is greater after attending a seminar than before? Highlight the P-value and interpret your result.

forty new automobile were tested for fuel efficiency by the Environmental protection Agency (in mile per gallon). The individual values and frequency distribution are displaced below.

24, 19 22 29 17 31 27 33 27 18

32 24 34 23 31 23 24 8 34 34

23 32 17 22 23 18 31 23 23 30

19 26 31 19 37 23 16 26 30 31

CLSS FREQUECY

8-12 1

13-17    3

18-22    8

23-27 14

28-32    9

33-37    5

Find the median, mode, and midrange of the data set.

[The following information applies to the questions displayed below.]

O’Brien Company manufactures and sells one product. The following information pertains to each of the company’s first three years of operations:

During its first year of operations, O’Brien produced 93,000 units and sold 76,000 units. During its second year of operations, it produced 77,000 units and sold 89,000 units. In its third year, O’Brien produced 85,000 units and sold 80,000 units. The selling price of the company’s product is $80 per unit.

Case 6-29 Part-3

3. Assume the company uses absorption costing and a FIFO inventory flow assumption (FIFO means first-in first-out. In other words, it assumes that the oldest units in inventory are sold first):

a. Compute the unit product cost for Year 1, Year 2, and Year 3.

b. Prepare an income statement for Year 1, Year 2, and Year 3.

a professor is teaching three sections of the same course and wants to determmine if the proprtion of students who passed is statistically different across the classes. the report below shows how many students in each section passed and how many were enrolled

Section 1 - 82 passed 107 enrolled

Section 2 - 74 passed 108 enrolled

Section 3 - 89 passed 115 enrolled

conduct the chi-square test and report the final test statistic

A random sample of size n₁ = 14 is selected from a normal population with a mean of 74 and a standard deviation of 6. A second random sample of size n₂ = 9 is taken from another normal population with mean 70 and standard deviation 14. Let X¯1and X¯2 be the two sample means. Find:

(a) The probability that X¯1-X¯2 exceeds 3.

(b) The probability that 4.4 ≤X¯1-X¯2≤ 5.4.

A company manufactures printers and fax machines at plants located in Atlanta, Dallas, and Seattle. To measure how much employees at these plants know about quality management, a random sample of 6 employees was selected from each plant and the employees selected were given a quality awareness examination. The examination scores for these 18 employees are shown in the following table. The sample means, sample variances, and sample standard deviations for each group are also provided. Managers want to use these data to test the hypothesis that the mean examination score is the same for all three plants.

Set up the ANOVA table for these data. (Round your values for MSE and F to two decimal places, and your p-value to four decimal places.)

Test for any significant difference in the mean examination score for the three plants. Use

α = 0.05.

H₀: μ₁ = μ₂ = μ₃
H_a: Not all the population means are equal.

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to four decimal places.)

Please explain how to solve using Excel.

West Java topography condition is very potential for the development of hydro power plant technology especially mini-hydro power (PLTM) and micro-hydro power (PLTMH) which is a runoff river power plant. Unfortunately, until right now the business performance of PLTM and PLTMH is not optimal yet. It was allegedly related to the supply chain management and business partnership aspect.

The mountainous topograph in Southern part of West Java, with many small rivers flowing throughout the year and high rain fall volume have springs flowing to the rivers is very potential for the development of environment friendly hydroelectric technology, which is a runoff river power plant between 1-10 MWh called Mini Hydro Power Plant (Pembangkit Listrik Tenaga Mini Hidro). The equipment used is relatively simple and easy to find. The required land is not extensive, so there is no need to open the forest to build the large scale hydroelectric power supply with big water dam and huge power installation. Southern part of West Java has mountain topography spread all over the region. In general, mountain’s texture is steep with relatively few inhabitants. The mountainous area has a large electrical energy in the form of water. The flow of water from the plateau to the lower one has potential energy that can be utilized as a source of electrical energy, especially in Sukabumi, Cianjur, Garut and Tasikmalaya that still have forests and stable water supply. With the publication of ESDM Regulation no. 19 of 2015 on Micro Hydro Power Plants regarding the electricity tariff (Feed In Tariff) of Hydro Power Plants under 10 MW/h of 12 cent USD / KWh and the use of mini hidro Potential of 500 MW, newly installed 86.1 MW, should increase the number of Mini Hydro Power Plants (PLTM) in West Java.

Actually, the potential of Mini Hydro Power Plants for supporting to the main grid of electricity (Jawa Bali Network) and remote areas that have not reached the electricity network or areas that do not have other sources of fuel, so that the potential for the development of the Mini Hydro Power Plants is not optimal. However, the request for a Water Power Business Permit under 10 MW in Indonesia has only reached 33 Commercial Operation Date (COD) Permits from 266 Permits during 2015 to date. Until now, the company's performance is only 65%-75% of 86.1 MW installed yet, due to the frequent down time. This problem is caused by lack of optimal partnership and also supply chain management in mini hydro power plants companies, especially in the technology to be used, expertise people and financial investor. The Previous study has not address on Supply Chain Management and Strategic Partnership during the operation phase of Mini Hydro Power Plant. The form of partners relationship proposed by Cravens (2013) that includes a vertical relationship consisting of relationships with suppliers and customers and the relationship horizontally consisting of lateral and internal partnerships. In the era of decentralization of the energy sector in Indonesia, the key to sustainability success is extensive coordination with private parties, local government offices, state electricity company, and communities. On the other hand, Clement, Clement, Joseph (2013) suggests that the performance of a company with partnership is better than a single-ownership company. In addition, Agus and Hassan (2012) demonstrate that the product quality performance and business performance dependence on practices of strategic suppliers partnerships. Another factor that is alleged to have an impact on the optimum business performance of micro hydro power plant companies is regard to the aspects of the supply chain. Turban, Rainer & Porter (2004) mentions supply chain includes 3 components ie upstream supply chain, internal supply chain management, and downstream supply chain. Lia, Ragu-Nathan, Ragu-Nathan, Rao (2006) found that higher levels of SCM practice lead to increased competitive advantage and improved organizational performance.

Based on this background, the aim of this study is to examine;

1. Identify the components of the supply chain management and specify how this process can be implemented to improve the performance of the micro hydro power plant in West Java. (10marks)
2. In this case, this study are expected to be used by the Government in their policies and private sectors to boosting the e-business infrastructure and may also provide benefits to the next Mini Hydro Power Plant Business to extend this process by the use of business partnership and build their business performance. (10marks)

Mid-South Auto Leasing leases vehicles to consumers. The attraction to customers is that the company can offer competitive prices due to volume buying and requires an interest rate implicit in the lease that is one percent below alternate methods of financing. On September 30, 2018, the company leased a delivery truck to a local florist, Anything Grows. The lease agreement specified quarterly payments of $3,000 beginning September 30, 2018, the beginning of the lease, and each quarter (December 31, March 31, and June 30) through June 30, 2021 (three-year lease term). The florist had the option to purchase the truck on September 29, 2020, for $6,000 when it was expected to have a residual value of $10,000. The estimated useful life of the truck is four years. Mid-South Auto Leasing’s quarterly interest rate for determining payments was 3% (approximately 12% annually). Mid-South paid $25,000 for the truck. Both companies use straight-line depreciation or amortization. Anything Grows’ incremental interest rate is 12%.

1. Calculate the amount of selling profit that Mid-South would recognize in this sales-type lease. (Be careful to note that, although payments occur on the last calendar day of each quarter, since the first payment was at the beginning of the lease, payments represent an annuity due.)
2. Prepare the appropriate entries for Anything Grows and Mid-South on September 30, 2018.
3. Prepare an amortization schedule(s) describing the pattern of interest expense for Anything Grows and interest revenue for Mid-South Auto Leasing over the lease term.
4. Prepare the appropriate entries for Anything Grows and Mid-South Auto Leasing on December 31, 2018.
5. Prepare the appropriate entries for Anything Grows and Mid-South on September 29, 2020, assuming the purchase option was exercised on that date.