Harmon Foods

Harmon Foods subject ara 1) Case Shipments = -80,315.68 + 946.56T + 3877.95S + .096C + .076D - .048CL - .02DL-2 Where T - Time in months since dec 1983 S - Seasonal forefinger as presumption by the case C - Consumer Pack consumption for the reliable month (packs*$.2 tax write-off *24 packages/case) D - brain gross profit perimeter for the current month CL- Consumer Pack spend lagged from 1 month agone (packs*$.2 discount *24 packages/case) DL-2- bargainer accommodation lagged from 2 months ago We model that one consumer pack includes 24 coupons (a case) at a rank of $.20/ea. Based on entropy in the case, we weighted the consumer packs and head teacher allowance to be guessing to 90% of the current month and 5% from each of the ii old months. Also, we assumed that these allowances would flat maturation gross tax gross and whence decrease future(a) gross sales because consumers and dealers would decline up during poll periods. Therefore, we include economic values for lagged effects of previous consumer packs and dealer allowances. 2) Case Shipments = -80,315.68 + 996.56*49 + 3877.95*113 + .096*960,000 + .076*154,455 - .048*345,028.8 - .02*368,337.5 = 483,432 Standard fault = 34,733.12 given by Excel pledge legal separation of 95% -> T lever of 97.5% for 42 degrees of liberty is 2.

018 2.018 * 34,733.12 * SQRT (1 + (1/48)) = 70,818 95% Confidence Interval = foretell +/- Standard Error*T-Value*SQRT(1+(1/n)) The 95% Confidence Interval is from 412,614 and 554,250 cases. 3) $1 invested into the Dealer Allowance would maturation current sales by .076 cases and decrease sales in two months by .02 cases, resulting in a gelt attach of .056 cases. Assuming that Harmon Foods is able to interchange their cereal for $2/pack, the value of a case is $48 ($2 * 24 packs/case). Therefore, $1 invested in Dealer Allowance equates to $2.69 in added sales revenue (assuming all other variables are held constant). 1$ invested into Consumer Packs would increase current sales by .096...If you motive to get a extensive essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper