Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6. The Zebulon Machine Tool Company is creating a financial plan for the year 2016. The company uses a Weighted Moving Average approach to financial
6. The Zebulon Machine Tool Company is creating a financial plan for the year 2016. The company uses a Weighted Moving Average approach to financial planning. The most recent year for which actual costs have been formalized is 2014 (n-1). The company budgets R&D at 8.5% of forecasted revenue. The company uses the following formula to calculate wMA. Fn= 40%(An-1) + 3096(Au) + 20%(An-3) + 1096(An-4)-F-Forecast, A= Actual Revenue Calculate the forecasted revenue for 2015 a. b. Calculate the budget for R&D for 2015 2009 2010 2011 2012 2013 2014 2015 $135$146 $157 $168 $179 $188 $220 Sales Revenue Weighted 4-Year Moving Average R&D Expenditures (5% of Weighted 4 Year Moving Average) Simple 4 Year Moving $115 $124 $134 $146 $157 $168 $178 $5.7 $6.2 $6.7 $7.3$7.9 $8.4 $8.9 Average (Revenue) $113 $120 $128 $140 $152 $163 $173 R&D Expenditures (5% of Simple 4 Year Moving Average) $5.7 $6.0 $6.4 $7.0$7.6 $8.1 $8.7
Step 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