On January 1, 2021, the general ledger of Big Blast Fireworks included the following account balances:
  

The $43,000 beginning balance of inventory consists of 430 units, each costing $100. During January 2021, Big Blast Fireworks had the following inventory transactions:

The following information is available on January 31, 2021.

1. At the end of January, the company estimates that the remaining units of inventory are expected to sell in February for only $100 each.
2. At the end of January, $5,300 of accounts receivable are past due, and the company estimates that 35% of these accounts will not be collected. Of the remaining accounts receivable, the company estimates that 3% will not be collected.
3. Accrued interest expense on notes payable for January. Interest is expected to be paid each December 31.
4. Accrued income taxes at the end of January are $13,600.

Requirement

1. Record each of the transactions listed above in the 'General Journal' tab (these are shown as items 1 - 10) assuming a perpetual FIFO inventory system. Review the 'General Ledger' and the 'Trial Balance' tabs to see the effect of the transactions on the account balances.

2. Record adjusting entries on January 31 in the 'General Journal' tab (these are shown as items 11-14).

3. Review the adjusted 'Trial Balance' as of January 31, 2021, in the 'Trial Balance' tab.

4. Prepare a multiple-step income statement for the period ended January 31, 2021, in the 'Income Statement' tab.

5. Prepare a classified balance sheet as of January 31, 2021, in the 'Balance Sheet' tab.

6. Record the closing entries in the 'General Journal' tab (these are shown as items 15-16).

7. Using the information from the requirements above, complete the 'Analysis' tab.

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.

What level of line maintenance expense would be expected for a phone company with 75,000 cutomers according to this new estimated regression function? Show how you arrive at the value.

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

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 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.

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.