Question
1) a)Calculate the monthly seasonal index for alfalfa (for the last 5 complete years). b)Average the monthly seasonal indexes over the last 5 complete years
1)
a)Calculate the monthly seasonal index for alfalfa (for the last 5 complete years).
b)Average the monthly seasonal indexes over the last 5 complete years to determine the typical or average seasonal index.
c)Graph the average monthly seasonal index for alfalfa.
d)Using the price of alfalfa in August 2020, predict, September and October prices for 2020 using the 5 year MSIs calculated in question 2. You must upload an Excel file with the answers on Canvas. Label your answers clearly.
Problem-Set-2 Fall-2020 (1) (Protected View] Excel David Rei Ga Share File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing L16 D E F H 1 K M N 0 Q R S JUL OCT APR 213 207 MAY 219 227 AUG 199 207 SEP 194 206 217 193 193 197 MAR 219 193 169 139 134 165 186 175 154 150 183 187 146 156 189 201 179 JUN 218 224 178 140 154 182 192 179 172 138 153 179 183 174 161 137 148 177 179 172 160 136 149 179 179 155 135 152 176 177 NOV 188 182 147 130 150 173 169 DEC 186 180 149 127 149 179 172 198 180 172 A B 1 Alfalfa Hay Cash Price ($/ton) 2 3 JAN FEB 4 2013 217 218 5 2014 186 190 6 2015 170 167 7 2016 141 137 8 2017 126 127 9 2018 153 155 10 2019 179 180 11 2020 169 168 12 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Seasonal Index E + 100% 1 11:48 I Zur Suche Text hier eingeben 9 ?? DEU 15.10.2020 Problem-Set-2 Fall-2020 (1) (Protected View] Excel David Rei Ga Share File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing L16 D E F H 1 K M N 0 Q R S JUL OCT APR 213 207 MAY 219 227 AUG 199 207 SEP 194 206 217 193 193 197 MAR 219 193 169 139 134 165 186 175 154 150 183 187 146 156 189 201 179 JUN 218 224 178 140 154 182 192 179 172 138 153 179 183 174 161 137 148 177 179 172 160 136 149 179 179 155 135 152 176 177 NOV 188 182 147 130 150 173 169 DEC 186 180 149 127 149 179 172 198 180 172 A B 1 Alfalfa Hay Cash Price ($/ton) 2 3 JAN FEB 4 2013 217 218 5 2014 186 190 6 2015 170 167 7 2016 141 137 8 2017 126 127 9 2018 153 155 10 2019 179 180 11 2020 169 168 12 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Seasonal Index E + 100% 1 11:48 I Zur Suche Text hier eingeben 9 ?? DEU 15.10.2020Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Derivative Investments An Introduction To Structured Products
Authors: Richard D. Bateson
1st Edition
1848167113, 9781848167117
