Question

In: Finance

Use the information in the 1st table (Weights & Periods) to fill in the missing values...

Use the information in the 1st table (Weights & Periods) to fill in the missing values in the second table

Weights Applied Period
5 Last month
3 Two months ago
1 Three months ago
Month Actual Sales 3-Month Weighted Moving Average
January 100
February 150
March 130
April 160 (  (  * 100 ) + (  *  ) + (  *  ) /  = 133
May 120 (  (  * 150 ) + (  *  ) + (  *  ) /  = 133
June 110 (  (  * 130 ) + (  *  ) + (  *  ) /  = 133
July 130 (  (  * 160 ) + (  *  ) + (  *  ) /  = 133

Solutions

Expert Solution

In any month, projected sales = Weighted Average of previous three months sales

Hence, your answers will be :

Month Actual Sales 3-Month Weighted Moving Average
January 100
February 150
March 130
April 160 ((1* 100) + (3*150) + (5*130) / 9) = 133
May 120 ((1*150) + (3*130) + (5*160) / 9)  = 149
June 110 ((1*130) + (3*160) + (5*120) / 9)  = 134
July 130 ((1*160) + (3*120) + (5*110) / 9)  = 119

Related Solutions

Fill in the following table, supplying all the missing information. Use this information to calculate the...
Fill in the following table, supplying all the missing information. Use this information to calculate the security’s beta. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your Return Deviations answers as a whole number percentage. Round Squared Deviations, Product of Deviations answers to 5 decimal places and Security's beta answer to 2 decimal places. Omit the "%" sign in your response.)...
Fill in the missing values in the table below given that , dy/dt = 0.8y -...
Fill in the missing values in the table below given that , dy/dt = 0.8y - 2 . t 0 1 2 3 4 y 8 ?? ?? ?? ??
fill in the missing future values in the following table for an ordinary annuity. Number of...
fill in the missing future values in the following table for an ordinary annuity. Number of Payments or Years Annual Interest Rate Present Value Annuity Future Value 7 8​% 0     ​$210.59 ​? 17 17​% 0 ​$1368.71 ​? 25 3.5%     0 ​$658.68 ​? 340 0.9​% 0 ​$496.92 ​? Number of Payments or Years Annual Interest Rate Present Value Annuity Future Value 7 88% 0     ​$210.59 ​$nothing ​(Round to the nearest​ cent.)
Fill in the missing information.
Question Fill in the missing information.a. The vendor ships the inventory and sends a(n) __________ back to the purchaser.b. After approving all documents, the purchaser sends a(n) __________ to the vendor.c. When ordering merchandise inventory, the purchaser sends a(n) __________ to the vendor.d. The purchaser receives the inventory and prepares a(n) __________. 
1) In the first table, there are missing values for direct and cross rates. Please fill...
1) In the first table, there are missing values for direct and cross rates. Please fill them out (using the available rates, you need to derive the missing rates). KEY CURRENCY CROSS RATES (09/16/2011) Country US $ Euro Pound Sfranc Peso Yen Can $ Canada 0.9782 1.3496 C 1.1173 0.0749 0.0127 1 Japan 76.79 105.9465 121.2346 87.7099 5.8829 1 78.5013 Mexico 13.0531 B 20.6080 14.9093 1 0.1700 13.3440 Switzerland A 1.2079 1.3822 D 0.0671 0.0114 0.8950 U.K. 0.6334 0.8739 1...
Fill in the missing information in the following table: At Expiration Long               Call            Strike    &nbsp
Fill in the missing information in the following table: At Expiration Long               Call            Strike       Value of             Value of       Profit                          Profit or Short          or Put        Price        Option Today   Underlying   (Intrinsic Value)      (Loss)                                                                                             Asset Long              Call             100             2.50                      110 Short             Call             100             2.50                       110 Long              Put              100            2.50                          95 Short              Put              100           2.50                       95 Long               Call             120          2.50                     105 Short              Call            120            2.50                    105 Long               Put             120           2.50                     130 Short               Put             120           2.50                     130
Calculate and fill in the missing values in the table below Moon Distance from Jupiter Period...
Calculate and fill in the missing values in the table below Moon Distance from Jupiter Period Io 42 hours Europa 6.71105km Callisto 17 days Ganymede 1.07106km 172 hours
Fill in the missing values for this ANOVA summary table round to two decimal places: S.S....
Fill in the missing values for this ANOVA summary table round to two decimal places: S.S. d.f. M.S. F Between 2371.488 6 Within TOTAL 5843.488 37 S.S. d.f. M.S. F Between 576.45 3 Within TOTAL 2276.45 37 S.S. d.f. M.S. F Between 107.07 Within 5160 TOTAL 5695.35 65 S.S. d.f. M.S. F Between 7.664 Within 430 10 TOTAL 50
Using the table below calculate the missing values.
Using the table below calculate the missing values.YearNominal GDPReal GDPGDP Deflator1 (2007)3,753____________812 (2008)4,5515,009____________3 (2009)5,150____________100.004 (2010)5,6665,255____________5 (2011)____________6,175          158Enter the missing values : the inflation/growth rates as indicated below.Inflation rate year 1-2 ____________Inflation rate year 3-4 ____________Real growth rate yr. 2-3 ____________Real growth rate yr. 4-5 ____________
Solve for the missing information designated by “?” in the following table. (Use 365 days in...
Solve for the missing information designated by “?” in the following table. (Use 365 days in a year. Round the inventory turnover ratio to one decimal place before computing days to sell. Round days to sell to one decimal place.) Case BI Purchases CGS EI Inventory Turnover Ratio Days to Sell a. $100 $700 $600 $200 4.0 91.3 b. $200 $1,200 6.0 60.8 c. $1,000 $150 36.5
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT