Calculate both averaging and the weighted sales forecast

Assignment Help Financial Accounting

Reference no: EM13179390

This assignment is designed to not only to give students an opportunity to practice concepts learned in class, but also to give them experience using tools that are essential in business.

Respond to the following items. Also, be sure to follow guidelines in the syllabus for written work and be sure to check grammar, spelling, etc.

1. Using the information at the bottom of this page, calculate both the averaging and the weighted sales forecasts using Micro Soft Excel. Be sure to write the simple formulas in the spreadsheet, rather than calculating the answers by hand and entering the numbers directly into the spreadsheet.

2. Assuming you are a sales manager, send an email message to me explaining the forecast and including it as an attachment. When writing this email message, be sure to follow the guidelines discussed in class and in Chapter 5 of your textbook.

YEAR SALES WEIGHT

2006 $ 1,079,864 0.1

2007 $ 1,238,586 0.2

2008 $ 1,409,078 0.3

2009 $ 1,098,274 0.1

2010 $ 1,578,968 0.3

2011 ?1.0

Reference no: EM13179390

Questions Cloud

Is the mrs diminishing : asume that Bob consumes goods x and y according to the following utility function, U (x,y) = 2x + 4xy + y compute Bob's marginal rate of substitution for good x and for good y. Is the MRS diminishing?

Describe the maximum level of utility joe receives : If Joe's income is $5,040 a month, and the price of goods X1 and X2 are $45 and $5 respectively, derive the following: A) The quantity of X1 and X2 that maximize Joe's utility B) The maximum level of utility Joe receives.

Fastenals cost from lost sales of current customers : What is the minimum price Fastenalt should accept from Hank's for the special order and discuss the strategic implications of accepting Hank's offer.

Compute the quantity of energy produced per gram : Calculate the quantity of energy produced per gram of reactant for the fusion of H-3 (atomic mass = 3.016049 amu) with H-1 (atomic mass =1.007825 amu) to form He-4

Calculate both averaging and the weighted sales forecast : Calculate both the averaging and the weighted sales forecasts using Micro Soft Excel and assuming you are a sales manager, send an email message to me explaining the forecast and including it as an attachment.

Explain how triphenylmethanol is purified by extraction : DRAW a flow chart to show how triphenylmethanol is purified by extraction. Indicate which layer contains the product.

Define the subshell hybridization of elements such as copper : First Ionization Energies across a period, e.g., period 2. explain in detail why there are anomalies for Boron and Oxygen. Explain the subshell hybridization of elements such as copper or chromium

Explain benzoic acid can be extracted from an ether solution : Benzoic acid can be extracted from an ether solution using an aqueous solution of sodium bicarbonate.

Explain what is the percent yield of hcn : The equation for the reaction is 2 NH3 + 3 O2 + 2 CH4 ----> 2 HCN + 6 H2O, What is the percent yield of HCN?

User Account

All Pages