Questions
Use Excel to calculate the values to fill in the empty boxes. Feel free to add...

Use Excel to calculate the values to fill in the empty boxes. Feel free to add additional tables and calculations as

needed.

Historical Demand Data 2012 to 2016:

The table reproduced below is the demand data for a company (aggregated) for the previous five years.

2012

2013

2014

2015

2016

Q1

11632

15034

16117

15565

16470

Q2

22509

26824

24169

20151

42858

Q3

21646

13314

14505

13392

19278

Q4

11355

10698

11176

10613

13934

Annual Demand

67,142

65,870

65,967

59,721

92,540

Average Quarterly Demand

16,785.50

16,467.50

16,491.75

14,930.25

23,135.00

Forecasting Using Moving Average Methods

Using the historical demand data above, you are to determine the total annual demand forecast for 2016 and 2017 using:

Ø the three-period moving average forecasting method

Ø the three-period weighted moving average method with weights of .6, .3, and .1

Enter your forecast results in the following tables.

2016 Annual Forecast Using a Moving Average

2016 Annual Forecast Using a Weighted Moving Average

63,852.67

62209.7

2017 Annual Forecast Using a Moving Average

2017 Annual Forecast Using a Weighted Moving Average

72742.67

80037

Calculate a Time Series Linear equation using the all of the above demand data:

Using the historical demand data for 2012 through 2016, create a linear equation with the year as the independent variable and the annual volume as the dependent variable.

Enter your linear equation in text from here:   

Calculated 2017 Annual Forecast from Linear Equation:

Forecasting Using an Exponential Smoothing Method and Seasonal Factors:

Using the historical demand data for 2012 through 2016 given on the first page you are to:

Ø Using the exponential smoothing forecasting method with an alpha value of 0.7, forecast the total annual demand for 2017. Start your forecast calculations with the total annual demand for 2012 and a starting forecast for 2012 that is the

Ø Determine the average seasonal factors for each quarter. Remember that you will first need to calculate the total annual demand and then average quarterly demand for each year of data as shown in lecture.

Ø Determine the MAD, CFE, and MAPE errors between the annual forecast values using exponential smoothing for 2013 to 2016 and the actual annual demand data for 2013 to 2016. Enter the values in response to the three questions below.

2012

2013

2014

2015

2016

2017

Actual Annual Demand

67,142

65,870

65,967

59,721

92,540

Forecasted Annual Demand

67,142

67142

66251.6

66052.38

61620.414

Forecast Error

-1,272

-285

-6,331

30,920

Values

Seasonal Factor for each Quarter

2017 Quarterly Forecast

Quarter 1

0.89

Quarter 2

1.63

Quarter 3

0.98

Quarter 4

0.69

Totals

4.19

What is the MAD value for the exponential smoothing forecast? Answer =

What is the CFE value for the exponential smoothing forecast? Answer =

What is the MAPE value for the exponential smoothing forecast? Answer =

Forecasting using trend with regression:

Calculate forecasts for 2017, 2016 and 2015 using a linear regression of the previous three actual demand values.

(Hint: You will need to calculate three different linear equations.)

2012

2013

2014

2015

2016

2017

Actual Annual Demand

67,142

65,870

65,967

59,721

92,540

slope

-587.5

Forecasted Annual Demand

67,142

67,142

66,252

66,052

61,620

intercept

Forecast Error

-6,331

30,920

What is the MAD value for the trend with regression forecast? Answer =

What is the CFE value for the trend with regression forecast? Answer =

What is the MAPE value for the trend with regression forecast? Answer =

In: Operations Management

In a Human Capital Solow Model. What happens to total capital stock (human and physical) per...

In a Human Capital Solow Model. What happens to total capital stock (human and physical) per work, output per worker, output, and consumption per worker over time when:

A) G spending on military ↑
B) G spending on education, infrastructure, healthcare ↑
C) T ↑
D) Foreign Direct Investment (trade) allows domestic investment (I) to ↑

In: Economics

The Dynamic Credit Company issues credit cards and uses software to detect fraud. After tracking the...

The Dynamic Credit Company issues credit cards and uses software to detect fraud. After tracking the spending habits of one customer, it is found that charges over $100 constitute 35.8% of the credit transaction. Among 30 charges made this month, 18 involve totals that exceed $100. Does this constitute an unusual spending pattern that should be verified? Explain.

In: Statistics and Probability

Many government programs have both an efficiency-enhancing function and an equity / redistributive function. Choose any...

Many government programs have both an efficiency-enhancing function and an equity / redistributive function. Choose any government spending program.

a. Which government spending program did you choose?

b. Describe two ways in which the program you chose enhances efficiency.

c. Describe two ways in which the program you chose redistributes income.

In: Economics

1) An economy is currently producing at an equilibrium level of real GDP of $14 trillion....

1) An economy is currently producing at an equilibrium level of real GDP of $14 trillion. What will happen if government spending (alone, with no other changes) decreases by $100 billion? Will real GDP increase or decrease? Explain why it will change by $100 billion, by less, or by more.

2)Explain why rising prices reduce the spending multiplier effect of an increase in aggregate demand.

In: Economics

An economy has no government sector and no international trade. One year, desired investment spending equals...

An economy has no government sector and no international trade. One year, desired investment spending equals $481 billion, consumption spending in this economy equals $623 billion, and total output equals $1,401 billion.

4.1 Is this economy in equilibrium? Explain why or why not.

4.2 What is the unplanned increase in inventories in this economy?

4.3 What is total investment in this economy?

In: Economics

Custom Prints Inc. (CPI) specializes in logo-imprinted coffee mugs. CPI tracks the number of units purchased...

Custom Prints Inc. (CPI) specializes in logo-imprinted coffee mugs. CPI tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the accounting period, December 31. The inventory’s selling price is $11 per unit.

Transactions

Unit Cost

Units

Total Cost

Inventory December 1

$4.50

250

$1,125

Sale, December 10

(200)

Purchase, December 12

$5.00

300

$1,500

Sale, December 17

(150)

Purchase, December 26

$6.00

80

$480

  1. Compute the amount of goods available for sale at December 3 [1 mark]

  1. Compute the ending inventory, and cost of goods sold at December 31, under each of the following inventory costing methods: Specific identification, first in first out, weighted average method
  1. Assuming that the December 10 sale was from the beginning inventory and the December 17 sales was the December 12 purchase. [2 marks]

Cost of goods sold =

Ending Inventory =

In: Accounting

1. Assume that the actual amount of one of a company’s variable expenses was $45,198. The...

1. Assume that the actual amount of one of a company’s variable expenses was $45,198. The company’s planned level of activity was 19,000 machine-hours, and its actual level of activity was 18,475 machine-hours. The spending variance for this particular expense was $9,114 favorable. The cost formula per machine-hour for this expense is:

  • $1.92.

  • $1.96.

  • $2.88.

  • $2.94.

2. Assume a company is considering using available space to make 10,000 units of a component part that it has been buying from a supplier for a price of $40.50 per unit. The company’s accounting system estimates the following costs of making the part:

Per Unit 10,000 Units
per Year
Direct materials $ 17 $ 170,000
Direct labor 12 120,000
Variable manufacturing overhead 2 20,000
Fixed manufacturing overhead, traceable 8 80,000
Fixed manufacturing overhead, allocated 4 40,000
Total cost $ 45 $ 430,000


One-half of the traceable fixed manufacturing overhead relates to a supervisor that would have to be hired to oversee production of the part. The remainder of the traceable fixed manufacturing overhead relates to depreciation of equipment that the company already owns. This equipment has 20,000 units of unused capacity, no resale value, and it does wear out through use. The allocated fixed manufacturing overhead relates to general overhead costs, such as the plant manager’s salary, lighting, heating and cooling costs, and plant insurance costs. What is the financial advantage (disadvantage) of making 10,000 units instead of buying them from the supplier?

  • $(20,000)

  • $20,000

  • $(55,000)

  • $55,000

3. Assume the following:

  • The standard price per pound is $2.10.
  • The standard quantity of pounds allowed per unit of finished goods is 4 pounds.
  • The actual quantity of materials purchased was 53,000 pounds, whereas the quantity of materials used in production was 50,400 pounds.
  • The actual purchase price per pound of materials was $2.25.
  • The company produced 13,000 units of finished goods during the period.

What is the materials quantity variance?

  • $5,460 F

  • $5,850 F

  • $3,600 F

  • $3,360 F

4.Assume the following information appears in the standard cost card for a company that makes only one product:

Standard Quantity
or hours
Standard Price
or Rate
Standard Cost
Direct materials 5 pounds $ 11.00 per pound $ 55.00
Direct labor 2 hours $ 17.00 per hour $ 34.00
Variable manufacturing overhead 2 hours $ 3.00 per hour $ 6.00


During the most recent period, the following additional information was available:

  • 21,200 pounds of material was purchased at a cost of $10.50 per pound.
  • All of the material that was purchased was used to produce 3,900 units.
  • 8,000 direct labor-hours were recorded at a total cost of $132,000.


What is the direct materials price variance?

  • $9,750 F

  • $10,600 U

  • $10,600 F

  • $9,750 U

5. Assume a company’s estimated sales is 32,000 units. Its desired ending finished goods inventory is 8,500 units, and its beginning finished goods inventory is 3,500 units. What is the required production in units?

  • 44,000 units

  • 28,500 units

  • 20,000 units

  • 37,000 units

6. Assume that a company provided the following cost formulas for three of its expenses (where q refers to the number of hours worked):

Rent (fixed) $3,000
Supplies (variable) $4.00 q
Utilities (mixed) $150 + $0.75 q


The company’s planned level of activity was 2,000 hours and its actual level of activity was 1,900 hours. The actual amount of supplies expense for the period was $7,830. What is the spending variance for supplies expense?

  • $230 U

  • $230 F

  • $460 U

  • $460 F

7. Assume the following (1) variable expenses = $308,000, (2) unit sales = 10,000, (3) the contribution margin ratio = 20%, and (4) net operating income = $10,000. Given these four assumptions, which of the following is true?

  • The total fixed expenses = $61,600

  • The total sales = $369,600

  • The break-even point in sales dollars is $335,000

  • The total contribution margin = $246,400

In: Accounting

Which of the following statement is incorrect? Select one: a. Calvin Klein, Liz Claiborne, The Gap,...

Which of the following statement is incorrect? Select one:

a. Calvin Klein, Liz Claiborne, The Gap, and other garment industry companies that manufacture clothing outside of the United States to control labor costs must balance the moral issues of human rights against their obligations to stockholders.

b. Psychological and political factors also affect exchange rates.

c. Most of the answers are correct.

d. When the U.S. dollar strengthens against the Mexican peso, U.S. importers of Mexican goods will require more dollars to purchase Mexican goods that are sold in pesos.

e. The risk that a multinational corporation faces due to fluctuating exchange rates can be managed by using forward contracts, futures contracts, and currency swaps.

In: Finance

1. What are the most important instruments of international economic policy? Check all that apply. A....

1. What are the most important instruments of international economic policy? Check all that apply.

A. External balance

B. Income-changing instruments

C. Expenditure-changing instruments

D. Expenditure-switching instruments

2. Evaluate the following statement about expenditure-changing and expenditure-switching policies.

An expenditure-changing policy induces changes in aggregate demand, via fiscal policy or monetary policy, whereas an expenditure-switching policy diverts expenditures away from foreign goods to domestic goods.

A. True

B. False

Which of the following are examples of an expenditure-changing policy? Check all that apply.

A. Currency devaluation

B. Fiscal policy

C. Monetary policy

D. Import barriers

In: Economics