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?

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?

Sample Spaces

1. Suppose S is a uniform sample space with N elements. If E is any possible come and ω is the probability function for S evaluate ω(e).

2. Define a probability function on the set A = {1, 2, 3} such that A is not a uniform sample space.

3. Given the sample space B = {a, b, c} and probability function ω on B. If ω(a) = 0.3, ω({a, b}) = 0.8 then find ω(b) and ω(c).

4. Suppose that only 30% of a birds hatchlings survive their first year. If a bird hatches 7 chicks, what is the probability exactly 3 will survive their first year? What is the probability at most 3 will survive?