The East Division of Kensic Company manufactures a vital component that is used in one of Kensic’s major product lines. The East Division has been experiencing some difficulty in coordinating activities between its various departments, which has resulted in some shortages of the component at critical times. To overcome the shortages, the manager of East Division has decided to initiate a monthly budgeting system that is integrated between departments.

The first budget is to be for the second quarter of the current year (April, May and June). To assist in developing the budget figures, the divisional controller has accumulated the following information.

Sales: Sales through the first three months of the current year were 30,000 units. Actual sales in units for January, February, and March, and planned sales in units over the next five months, are given below:

January (actual) 6,000

February (actual) 10,000

March (actual) 14,000

April (planned) 20,000

May (planned) 34,000

June (planned) 51,000

July (planned) 45,000

August (planned) 30,000

In total, the East Division expects to produce and sell 250,000 units during the current year.

Direct Material: Two different materials are used in production of the component. Data regarding these materials are given below:

Material 208:

Materials per Finished Component: 4 pounds

Cost per pound: $5.00

Inventory at March 13: 46,000 pounds

Material 311:

Materials per Finished Component: 9 feet

Cost per foot: $2.00

Inventory at March 31: 69,000 feet

Material No. 208 is sometimes in short supply. Therefore, the East Division requires that enough of the material be on hand at the end of each month to provide for 50% of the following month’s production needs. Material No. 311 is easier to get, so only one-third of the following month’s production needs must be on hand at the end of each month.

Direct Labor:   The East Division has three department through which the components must past before they are completed. Information relating to direct labor in these departments is given below:

Department: Shaping

Direct Labor Hours per Finished Component: .25

Cost per Direct Labor Hour: $18.00

Department: Assembly

Direct Labor Hours per Finished Component: .70

Cost per Direct Labor Hour: $16.00

Department: Finishing

Direct Labor Hours per Finished Component: .10

Cost per Direct Labor Hour: $20.00

Direct labor is adjusted to the workload each month.

Manufacturing Overhead: East Division manufactured 32,000 components during the first three months of the current year. The actual variable overhead costs incurred during this three-month period are shown below. Each Division’s controller believes that the variable overhead costs incurred during the last nine months of the year will be at the same rate per component as experienced during the first three months.

Utilities $57,000

Indirect Labor $31,000

Supplies $16,000

Other $8,000

Total variable overhead $112,000

The East Division has planned fixed manufacturing overhead costs for the entire year as follows:

Supervision $872,000

Property Taxes $143,000

Depreciation $2,910,000

Insurance $631,000

Other $72,000

Total fixed manufacturing

  Overhead $4,628,000

Finished Goods Inventory: The desired monthly ending inventory of completed components is 20% of the next month’s estimated sales. The East Division has 4,000 units in the finished goods inventory on March 31.

Selling and Administrative Expenses: Selling and Administrative Expenses are budgeted at $400,000 per month plus 1% of total credit sales for the month.

I NEED MANUFACTURING OVERHEAD BUDGET

  CASH BUDGET

  SALES BUDGET

Could this be answered within excel + handwritten notes and thoroughly explained. Please and thank you

INTRODUCTION TO LINEAR CORRELATION AND REGRESSION ANALYSIS.

An economist with a major bank wants to learn, quantitatively, how much spending on luxury goods and services can be explained based on consumers’ perception about the current state of the economy and what do they expect in the near future (6 months ahead). Consumers, of all income and wealth classes, were surveyed. Every year, 1500 consumers were interviewed. The bank having all of the data from the 1500 consumers interviewed every year, computed the average level of consumer confidence (an index ranging from 0 to 100, 100 being absolutely optimistic) and computed the average dollar amount spent on luxuries annually. Below is the data shown for the last 24 years.

Date                X                     Y (in thousands of dollars)

1994                79.1                 55.6

1995                79                    54.8

1996                80.2                 55.4

1997                80.5                 55.9

1998                81.2                 56.4

1999                80.8                 57.3

2000                81.2                 57

2001                80.7                 57.5

2002                80.3                 56.9

2003                79.4                 55.8

2004                78.6                 56.1

2005                78.3                 55.7

2006                78.3                 55.7

2007                77.8                 55

2008                77.7                 54.4

2009                77.6                 54

2010                77.6                 56

2011                78.5                 56.7

2012                78.3                 56.3

2013                78.5                 57.2

2014                78.9                 57.8

2015                79.8                 58.7

2016                80.4                 59.3

2017                80.7                 59.9

Questions:

1. Do you think that measuring the level of optimism is a good predictor for trying to forecast future spending on luxury items? Explain why or why not.
2. How would you be able to improve on the model? You must provide a minimum of two specific ways to go about improving the model.
3. If the economist expects that, by year’s end, the average level of consumer confidence will hit 81.5 points, how much will be expected by consumers to spend on luxury items?

On January 2, 2018, the Jackson Company purchased equipment to be used in its manufacturing process. The equipment has an estimated life of eight years and an estimated residual value of $43,625. The expenditures made to acquire the asset were as follows: Purchase price $ 198,000 Freight charges 5,200 Installation charges 8,000 Jackson’s policy is to use the double-declining-balance (DDB) method of depreciation in the early years of the equipment’s life and then switch to straight line halfway through the equipment’s life. Required: 1. Calculate depreciation for each year of the asset’s eight-year life.

Exercise 10-11 Straight-Line: Bond computations, amortization, and bond retirement LO P2, P4

On January 1, 2019, Shay Company issues $290,000 of 11%, 20-year bonds. The bonds sell for $282,750. Six years later, on January 1, 2025, Shay retires these bonds by buying them on the open market for $303,050. All interest is accounted for and paid through December 31, 2024, the day before the purchase. The straight-line method is used to amortize any bond discount.

1. What is the amount of the discount on the bonds at issuance?
2. How much amortization of the discount is recorded on the bonds for the entire period from January 1, 2019, through December 31, 2024?
3. What is the carrying (book) value of the bonds as of the close of business on December 31, 2024?
4. Prepare the journal entry to record the bond retirement.

For the data listed below, conduct following in Excel

i) Create a forecast with 4-day moving average,

ii) Create a forecast using exponential smoothing method with smoothing constant equal to 0.6,

iii) Compute Root Mean Squared Error (RMSE) and identify which of the two methods produces a forecast with better accuracy.

Culver Company sells 8% bonds having a maturity value of $1,500,000 for $1,386,275. The bonds are dated January 1, 2020, and mature January 1, 2025. Interest is payable annually on January 1.

1.Determine the effective-interest rate. (Round answer to 0 decimal places, e.g. 18%.)

The effective-interest rate _______%

2.Set up a schedule of interest expense and discount amortization under the effective-interest method. (Round intermediate calculations to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 38,548.)

part a

calculate the sample autocorrelation function and provide an interpretation

part b

construct an individual control chart with the standard deviation estimated using the moving range method. how would ypu interpret the chart? are ypu comfortable with this interpretation?

data

2048, 2025, 2017, 1995, 1983, 1943, 1940, 1947, 1972, 1983, 1935, 1948, 1966, 1954, 1970, 2039, 2015, 2021, 2010, 2012, 2003, 1979, 2006, 2042, 2000, 2002, 2010, 1975, 1983, 2021, 2051, 2056, 2018, 2030, 2023, 2036, 2019, 2000, 1986, 1952, 1988, 2016, 2002, 2004, 2018, 2002, 1967, 1994, 2001, 2013, 2016, 2019, 2036, 2015, 2032, 2016, 2000, 1988, 2010, 2015, 2029, 2016, 2010, 2000, 2009, 1990, 1986, 1947, 1958, 1983, 2010, 2000, 2015, 2032

Blue Company sells 8% bonds having a maturity value of $2,510,000 for $2,319,700. The bonds are dated January 1, 2020, and mature January 1, 2025. Interest is payable annually on January 1.

Determine the effective-interest rate. (Round answer to 0 decimal places, e.g. 18%.)

eTextbook and Media

Set up a schedule of interest expense and discount amortization under the effective-interest method. (Round intermediate calculations to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 38,548.)

Cheyenne Company sells 8% bonds having a maturity value of $2,400,000 for $2,218,040. The bonds are dated January 1, 2020, and mature January 1, 2025. Interest is payable annually on January 1.

Determine the effective-interest rate. (Round answer to 0 decimal places, e.g. 18%.)

eTextbook and Media

Set up a schedule of interest expense and discount amortization under the effective-interest method. (Round intermediate calculations to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 38,548.)

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.