Data Table Two below

Data Table Two

Please post the answer with the work performed in excel and not just the answer, need to show work as I don't understand how to do this and would like the steps so that I can also learn it and it shows all work. You can add screenshots of the steps to find the answer in excel.

The answer to this question is below: how is this answer made, need to show work on how this answer came to be. I have the answer but need to show the work!

1.Develop the typical seasonal pattern for Teton Village
Answer to question 1
Seasonal Indices
Period Index
1 19.0687
2 -19.1750
3 25.1563
4 -25.0500

Accuracy Measures
MAPE 2.7354
MAD 2.7779
MSD 11.4065

Time C3 Trend Seasonal Detrend Deseason Predict Error
1 117.0 100.085 19.0687 16.915 97.931 119.154 -2.15375
2 80.7 100.085 -19.1750 -19.385 99.875 80.910 -0.21000
3 129.6 100.085 25.1563 29.515 104.444 125.241 4.35875
4 76.1 100.085 -25.0500 -23.985 101.150 75.035 1.06500
5 118.6 100.085 19.0687 18.515 99.531 119.154 -0.55375
6 82.5 100.085 -19.1750 -17.585 101.675 80.910 1.59000
7 121.4 100.085 25.1563 21.315 96.244 125.241 -3.84125
8 77.0 100.085 -25.0500 -23.085 102.050 75.035 1.96500
9 114.0 100.085 19.0687 13.915 94.931 119.154 -5.15375
10 84.3 100.085 -19.1750 -15.785 103.475 80.910 3.39000
11 119.9 100.085 25.1563 19.815 94.744 125.241 -5.34125
12 75.0 100.085 -25.0500 -25.085 100.050 75.035 -0.03500
13 120.7 100.085 19.0687 20.615 101.631 119.154 1.54625
14 79.6 100.085 -19.1750 -20.485 98.775 80.910 -1.31000
15 130.7 100.085 25.1563 30.615 105.544 125.241 5.45875
16 69.6 100.085 -25.0500 -30.485 94.650 75.035 -5.43500
17 125.2 100.085 19.0687 25.115 106.131 119.154 6.04625
18 80.2 100.085 -19.1750 -19.885 99.375 80.910 -0.71000
19 127.6 100.085 25.1563 27.515 102.444 125.241 2.35875
20 72.0 100.085 -25.0500 -28.085 97.050 75.035 -3.03500

2. Determine the seasonally adjusted number of visitors for winter 2011.
Seasonally adjusted data
97.931
99.875
104.444
101.150
99.531
101.675
96.244
102.050
94.931
103.475
94.744
100.050
101.631
98.775
105.544
94.650
106.131
99.375
102.444
97.050

Cane Company manufactures two products called Alpha and Beta that sell for $205 and $164, respectively. Each product uses only one type of raw material that costs $8 per pound. The company has the capacity to annually produce 127,000 units of each product. Its average cost per unit for each product at this level of activity are given below:

The company considers its traceable fixed manufacturing overhead to be avoidable, whereas its common fixed expenses are unavoidable and have been allocated to products based on sales dollars.

5. Assume that Cane expects to produce and sell 112,000 Alphas during the current year. One of Cane's sales representatives has found a new customer who is willing to buy 27,000 additional Alphas for a price of $148 per unit; however pursuing this opportunity will decrease Alpha sales to regular customers by 12,000 units.

a. What is the financial advantage (disadvantage) of accepting the new customer’s order?

b. Based on your calculations above should the special order be accepted?

6. Assume that Cane normally produces and sells 107,000 Betas per year. What is the financial advantage (disadvantage) of discontinuing the Beta product line?

7. Assume that Cane normally produces and sells 57,000 Betas per year. What is the financial advantage (disadvantage) of discontinuing the Beta product line?

8. Assume that Cane normally produces and sells 77,000 Betas and 97,000 Alphas per year. If Cane discontinues the Beta product line, its sales representatives could increase sales of Alpha by 12,000 units. What is the financial advantage (disadvantage) of discontinuing the Beta product line?

Business Law II

1) Please distinguish between the legal effect of a personal defense and a universal defense. see Exhibit 27-2 on page 507 for a summary of these defenses.

2) Disinguish between fraud in the inducement and fraud in the execution of the instrument.

3) Distinguish between a material alteration and an unauthorized completion of an instrument.

The following information is taken from the records of XYZ Company: Cash $10,000 Accounts receivables 30,000 Inventory 80,000 Prepaid insurance 6,000 Fixed assets 200,000 Accounts payable 30,000 Notes payable (due in 10 months) 25,000 Wages payable 5,000 Long term liabilities 70,000 Owners’ equity 196,000 The company had sales of $150,000, cost of good sold of 60,000 and a net income of 25,000

MCQ

8-The company’s assets turnover is: A) 1 times B) 0.75 times C) 0.5 times

9. The company’s inventory turnover is: A) 1 times B) 0.75 times C) 0.5 times

10. The company’s Days inventory on hand is: A) 450 days B) 477 days C) 487 days

11. The company’s receivable turnover is: A) 5 times B) 10 times C) 15 times

12. The company’s average collection period is: A) 75 days B) 74 days C) 73 days

Curtiss Construction Company, Inc., entered into a fixed-price contract with Axelrod Associates on July 1, 2021, to construct a four-story office building. At that time, Curtiss estimated that it would take between two and three years to complete the project. The total contract price for construction of the building is $4,600,000. The building was completed on December 31, 2023. Estimated percentage of completion, accumulated contract costs incurred, estimated costs to complete the contract, and accumulated billings to Axelrod under the contract were as follows: At 12-31-2021 At 12-31-2022 At 12-31-2023 Percentage of completion 10 % 60 % 100 % Costs incurred to date $ 369,000 $ 2,940,000 $ 4,960,000 Estimated costs to complete 3,321,000 1,960,000 0 Billings to Axelrod, to date 730,000 2,370,000 4,600,000 Required: 1. Compute gross profit or loss to be recognized as a result of this contract for each of the three years. Curtiss concludes that the contract does not qualify for revenue recognition over time. 2. Assuming Curtiss recognizes revenue over time according to percentage of completion, compute gross profit or loss to be recognized in each of the three years. 3. Assuming Curtiss recognizes revenue over time according to percentage of completion, compute the amount to be shown in the balance sheet at the end of 2021 and 2022 as either cost in excess of billings or billings in excess of costs.

omplete this question by entering your answers in the tabs below.

• Req 1 and 2
• Req 3

Assuming Curtiss recognizes revenue over time according to percentage of completion, compute the amount to be shown in the balance sheet at the end of 2021 and 2022 as either cost in excess of billings or billings in excess of costs.

The table below shows data for Flo's Beach Ball Company, a monopolistically competitive firm.

a. Use the columns above to calculate Total Revenue, Marginal Revenue, and Marginal Cost at each output level. Use negative signs where appropriate.

b. In order to maximize profit, how many beach balls should Flo’s Company produce?  

What price should the firm charge? $  

c. At the profit-maximizing output level, what is the firm’s total profit? $  

d. Given your answer from (b), what will happen to the beach ball industry in the long-run? [Describe the steps that will occur.] What will happen to the profits for Flo’s Company?

Mazoon Electric Company is responsible for supplying and upkeep of the distribution of electric power in South Al Batinah region. The company is planning to upgrade the distribution system which will reduce line losses, failure occurrences and increased revenue. This up gradation will cost the company OMR 250,000. Information on the expected revenues and costs for coming years is tabulated below:

Assume that annual interest rate is 8% per annum and compounded annually.

a) Draw a cash flow diagram for the information given above.

b) Compute the Net Present Worth of the future cash flows.

c) Compute the Future Worth at the end of 2026 of cash flows.

Kalamazoo Paper Company has three divisions: Recycling, Cardboard, and Paper. In order to determine the profit provided by each division, the company allocates all costs to the three divisions. As a result, for the year ended December 31, 2015, Kalamazoo reported a profit of $50,000 for Recycling, a profit of $60,000 for Paper, and a loss of $30,000 for Cardboard. If Cardboard has avoidable costs of $40,000 and unavoidable costs of $50,000 which of the following actions should be taken by the company? Select one:

a. Eliminate the Cardboard Division because the division's unavoidable costs exceed the amount of the loss.

b. Continue the Cardboard Division because the revenue generated by the division exceeds the avoidable costs.

c. Continue the Cardboard Division because the revenue generated by the division exceeds the unavoidable costs.

d. Eliminate the Cardboard Division because the company's total net income would increase by $30,000.

Are America's top chief executive officers (CEOs) really worth all that money? One way to answer this question is to look at row B, the annual company percentage increase in revenue, versus row A, the CEO's annual percentage salary increase in that same company. Suppose that a random sample of companies yielded the following data:

​

Do these data indicate that the population mean percentage increase in corporate revenue (row B) is different from the population mean percentage increase in CEO salary? Assume that the distribution of differences is approximately normal, mound-shaped and symmetric. Use a 10% level of significance. Find (or estimate) the P-value.

​