|
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:
|
|||||||||||||||
|
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 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 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 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. 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 $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 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 |
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 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:
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:
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, 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. 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