Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

What are the four steps in the planning and control cycle?

Answered: 1 week ago

Question

U11 Informing Industry: Publicizing Contract Actions 317

Answered: 1 week ago

Question

An advertisement for peanut butter

Answered: 1 week ago