4. You want to test whether the quarter of birth affects grades at university. Assuming that births are randomly distributed throughout the year (this might not be correct in real life) you collect data on a sample of 100 students and get the following: Quarter birth Q1 Q2 Q3 Q4 Average grade 65 62 63 58 N 25 27 28 20 Compute the appropriate test using a 5% significance level Hint: Don’t forget to reweight the test of each category by the number of observations, as each cell represents the mean Xi for m observations.

Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheet Enrollment:

1. Develop an additive model for trend and seasonality. Please clearly define your variables.

b. Use the additive model to forecast for the enrollments for Fall 2013, Winter 2014, and Spring 2014.

Please show step by step instructions using excel:

Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheetEnrollment:

1. Develop an additive model for trend and seasonality. Please clearly define your variables.

b. Use the additive model to forecast for the enrollments for Fall 2013, Winter 2014, and Spring 2014.

Please show step by step instructions using excel:

Ruben Trout worked the following schedule: Monday, 8 hours, 27 minutes; Tuesday, 7 hours, 38 minutes; Wednesday, 9 hours, 19 minutes; Thursday, 8 hours, 3 minutes; Friday, 8 hours, 36 minutes. The employer pays overtime in accordance with FLSA regulations.

Required:
Determine Ruben's total time worked according to the (a) quarter-hour method and (b) the hundredth-hour method. Which is the more favorable method for Ruben, quarter-hour or hundredth-hour? (Do not round intermediate calculations. Round your final answers to 2 decimal places.)

The following data shows the quarterly profit (in thousands of dollars) made by a particular company in the past 3 years.

a. Use α = 0.3 to compute the exponential smoothing values for the time series. Compute MSE and the forecast of profit (in $1000s) for the next quarter.

the retailer JC Penney, and how they are trying to implement a strategy to reduce their inventory at their stores. Inventory last quarter rose 2.6%, and sales numbers were reported low. JC Penney has attempted to combat this problem by hiring a Senior Vice President of Planning and Allocation and Pricing. At the end of the previous quarter, inventory levels were reported at 2.9 billion dollars. Some of the causes of this large inventory was an addition of floor samples for appliance and mattress departments, and additional sizes in clothing assortments. Store sales for the quarter only increased by 0.2%, when they were projected to have increased by 2.1%. Industry specialists say that retail stores face the difficulty of inventory management because the stores need to carry a wide variety of products and sizes to draw in all sorts of customers, and the online competition from companies like Amazon are threats. Especially with fashion trends moving fast, the inventory management in retail stores has proved challenging. Total revenue for JC Penney has decreased 4.1% for the quarter, and a loss of 78 million dollars was reported.

I need help with the following Questions:

1) What are the financial consequences of having too much inventory on hand? What conclusions can be drawn from a company with too much excess inventory?

2) What are some inventory strategies that a company can use to keep their inventory levels at a desirable level?

Link to article: https://blogs.wsj.com/cfo/2018/05/18/j-c-penney-aims-to-trim-growing-inventory-at-comparable-stores/

Party Town (PT) is holding a Halloween party and charging the guests an admission fee of $20 per

person. PT has rented a banquet hall for $500 and the hall will accommodate up to 100 people. PT has

contracted with Cathy’s Catering to cater the party for $10 per person that attends (up to 100). The

party will occur on October 30, 2016 and is the only event scheduled for the quarter from October 1,

2022 to December 31, 2022 (fourth quarter of 2022).

Additional Information:

On October 1, 2022, PT’s balance sheet is expected to be as follows:

Cash $1,000

Party equipment $100

Bank loan $50

Equity, $1,050

The depreciation on the party equipment for the three months ended December 31, 2022 was expected

to be $5.

At the party, it is estimated that 90% of the guests will pay at the door in cash and 10% will pay on

January 30, 2023. The estimated party guests are 75.

Cathy’s Catering should be paid half their fee (Cathy requires the estimate to be the max of 100 people)

on October 1, 2022 and the balance will be paid on January 15, 2023.

The banquet hall should be paid in full on October 21, 2022.

Cash principal payments on the bank loan on December 31, 2022 will be $5. Interest on the loan will be

15% and will be paid in cash.

1: Party Town

Budgeted Income Statement for the Quarter Ended December 31, 2022

2: Party Town

Cash Flow Budget for the Quarter Ended December 31, 2022

3: Party Town

Balance Sheet Budget as of December 31, 2022

The corona virus pandemic has been, and will be, very costly to federal, state, and local governments as well as to businesses and to consumers. According to the Congressional Budget Office (2020):

CBO expects that the economy will contract sharply during the second quarter of 2020 as a result of the continued disruption of commerce stemming from the spread of the novel coronavirus. The following are CBO’s very preliminary estimates, which are based on information about the economy that was available through this morning and which include the effects of an economic boost from recently enacted legislation.

• Gross domestic product is expected to decline by more than 7 percent during the second quarter. If that happened, the decline in the annualized growth rate reported by the Bureau of Economic Analysis would be about four times larger and would exceed 28 percent. Those declines could be much larger, however.
• The unemployment rate is expected to exceed 10 percent during the second quarter, in part reflecting the 3.3 million new unemployment insurance claims reported on March 26 and the 6.6 million new claims reported this morning. (The number of new claims was about 10 times larger this morning than it had been in any single week during the recession from 2007 to 2009.)
• Interest rates on 10-year Treasury notes are expected to be below 1 percent during the second quarter as a result of the Federal Reserve’s actions and market conditions. (Swagel, 2020, para. 1)

How will the decline in GDP and the rise in unemployment, and low interest rates affect federal, state, and local governments?

YOU MUST SHOW ALL CALCULATIONS TO EARN CREDIT.

                                                                        2016                            2017

BALANCE SHEETS:

Accounts Receivable520,000620,000

                        Fixed Assets, net                     410,000                       510,000

Total Assets1,355,0001,580,000

Liabilities and Equity:

Accounts Payable350,000$375,000

Long-term Debt500,000625,000

Common Stock50,00075,000

                        Retained Earnings                   455,000                       505,000

Total Liabilities and Equity1,355,0001,580,000

INCOME STATEMENT:

            Revenue                                                                                  3,500,000

            Cost of Goods Sold                                                                2,275,000

            General and Administrative                                                     515,000

            Depreciation Expense                                                              120,000

            Earnings Before Interest and Taxes                                         590,000

            Interest Expense                                                                      40,000

            Pretax Net Income                                                                   550,000

            Income Taxes                                                                          167,000

            Net Income                                                                              383,000

What was Gannon’s total current assets at the end of 2017?

What was Gannon’s net working capital at the end of 2017?

What was Gannon’s shareholders’ equity at book value at the end of 2017?

An appraiser recently valued Gannon’s fixed assets at $600,000 and determined that $40,000 of their accounts receivable was noncollectible. Based on only this information and the balance sheet above, what was the market value of Gannon’s shareholders’ equity at the end of 2017?

Assuming that Gannon did not buy back or redeem any of its shares, how much new common stock did it issue in 2017?

How much dividends did Gannon pay out to its shareholders in 2017?

What was Gannon’s effective annual average tax rate in 2017?

If Gannon had 18,000 shares of common stock outstanding throughout 2017, what was its Earnings per Share (EPS) in 2017?

Assuming that Gannon didn’t dispose of any of its fixed assets, how much new capital spending did it incur in 2017?

What was Gannon’s Operating Cash Flow (OCF) in 2017?

What was Gannon’s investment in net working capital for 2017?

What was Gannon’s Cash Flow to Creditors in 2017?

What was Gannon’s Cash Flow to Stockholders in 2017?

For questions #19-20, assume that a corporation’s pretax net income is taxable (Federal + State) based on 21% of the first $300,000, 30% of the next $400,000, and 34% of anything beyond that.

2. Steven Soldenberg

Steven has been one of the stable employees of Performance Horizons for nearly 20 years. In fact, few can remember the company without him around. In addition to being an excellent salesperson, he’s the first one to remember birthdays and to spearhead plans for holiday parties. Whenever anyone has a problem, Steven is often the first one they go to for help. Several years ago, Steven was offered a promotion at a different site. He turned it down, though, citing family reasons. Many suspected that he just felt too comfortable with the crew at his location.

Which two of the four motivates Steven the most?