upon the following historical data‚ calculate the following forecasts for each given forecasting method and then choose the best one to do the forecasts for the future. Actual Month Demand 1 62 2 65 3 68 4 70 5 72 6 74 a. Calculate the simple 3-month moving average forecast for periods 4-6. (5 points) b. Calculate the weighted 3-month moving average
Premium Exponential smoothing Time series analysis Forecasting
worksheet that calculates sales and commissions for a used car company. You will create functions that determine monthly payments‚ lookup commission rates‚ and calculate a bonus for the salespeople. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Start Excel. Open the downloaded Excel workbook named Exploring_e02_Grader_IR.xlsx. | 0 | 2 | In cell G5‚ enter a formula that calculates the state sales
Premium Sales Mathematics Spreadsheet
charges +20µC and -20µC are placed 20cm apart at A and B respectively. Compute the electric field at C 20 cm away from both A and B.[Ans:4.5x106N/C] 4. Calculate the work done in turning a dipole of moment 36x10-6 C m aligned in an electric field of 5X 105 N C-1 through an angle of 180º.[Ans:36J] 5. Two charges +1µC and -1µC are 1 cm apart. Calculate the electric field at a point distant 10 cm from the midpoint (i) on the axial line (ii) on the equatorial line. 6. A uniformly charged conducting sphere
Premium Electric charge Fundamental physics concepts Electrostatics
we want to value output in every year using the same prices. In other words‚ we calculate real GDP. Consider the following example: Nominal GDP for each of three years is as follows: 2001: $10 trillion 1996: $7.813 trillion 1968: $1 trillion In order to calculate real GDP for each year‚ we need to first pick a base year. We will use 1996. For each year (except the base year)‚ we calculate a GDP deflator‚ which is a number‚ that‚ when divided into nominal GDP and multiplied
Premium Gross domestic product Economic growth
assayed at an initial substrate concentration of 10-5M. The Km’ for the substrate is 2x10-3M. At the end of 1 min‚ 2% of the substrate had been converted to product. a. What % of the substrate will be converted to product at the end of 3 min.? calculate the product and substrate concentration at that time. b. If the initial concentration of the substrate were 10-6M‚ what percent of the substrate will be converted to product after 3 min? c. What is the maximum attainable velocity of
Premium Enzyme Enzyme inhibitor Catalysis
standard deviation of her salary? (Hint: Use the ‘Summary of the Laws of Expected Value and Variance’ slide in the lecture notes.) Exercise 5.4. Now assume the company managing the network gets penalised $900 for each interruption. Calculate the expected daily penalty. Calculate the standard deviation of the daily penalty. (Hint: Use the ‘Summary of the Laws of Expected Value and Variance’ slide in the lecture notes.) Part C: Week 4 Exercise 5.7 (a‚b‚d). Exercise 5.11 (a‚b). Exercise 5.12 (Expected
Premium Variance Probability theory Random variable
30000+3000-8000= 25000 OCF=25000 OCF-INV-FIXED ASSETS 25000-3000-2000=20‚000 2) Meese Paper Distributors‚ Inc. has before-tax earnings of $1‚900‚000. Calculate the amount of the total tax liability. 646000 113 900 + (0.34 x [1‚900‚000-335000]) 113 900 + (0.34 x 1‚565‚000) 113900 + 532100 = 646000 3) Calculate the future value of $4‚600 received today if it is deposited at 9 percent for three years. Rate | 9% | Nper | 3 | Pmt | 0 | Pv | 4600 | Fv | ($5‚957.13) |
Premium Time value of money Cash flow Rate of return
carbon make up only a small percentage of the carbon in the universe‚ the average of the masses of all carbon atoms is slightly higher than 12‚ so the atomic mass for carbon is actually 12.011. Objective Analyze the isotopes of “Metallo” and to calculate its atomic mass Materials sample of metallo (bag of mixed nuts‚ bolts‚ and washers) balance Procedures 1. Obtain a sample of the new element “Metallo.” 2. Separate the three isotopes of Metallo (nuts‚ washers‚ bolts) and measure the mass
Free Chemical element Atom Carbon
A firm-wide WACC is a beneficial tool for determining whether a firm should repurchase shares or buy back equity. On the other hand‚ when taking on divisional projects a company will benefit from divisional WACCs. While these prove difficult to calculate due to the lack of information a division would have such as what a division’s stock price would be; it is an optimal tool in deciding whether to accept or reject a project. Marriott will use its firm-wide WACC and divisional WACC to decide which
Premium Weighted average cost of capital Finance
CHAPTER 8 MAKING CAPITAL INVESTMENT DECISIONS Answers to Concept Questions 1. In this context‚ an opportunity cost refers to the value of an asset or other input that will be used in a project. The relevant cost is what the asset or input is actually worth today‚ not‚ for example‚ what it cost to acquire. 2. a. Yes‚ the reduction in the sales of the company’s other products‚ referred to as erosion‚ should be treated as an incremental cash flow. These lost sales are included because
Premium Depreciation Cash flow Net present value