spread sheet analysis

 

 

1 paged calculation on how Research & Development of ABC-2 Company on how it impacts sales
by R&D going down from 7.8% to 7% from Quarter 2 to Quarter 3 in 2016
1. what is the impacts on sales variances of McCoy lites & Real McCoy

2. How much extra buffer do we get in sales by going to 7% from 7.8% {i.e. of total sales was $59.6 million, in Quarter 2. How much buffer is there for Quarter 3 on sales.

NOTE: Indicate number lines or Row on spreadsheet {Row 93}where numbers utilized were pulled for the calculations
Spreadsheets and other relevant supporting documents are attached.
HINT: There is a required of ATLEAST 6% on sales BUT this required 6% of sales in R&D is strictly a function of the general spending in row 93 as compared to total sales for the quarter. It does not take any spending in Program Expense account #5 into account, so if you back that amount out of row 93, it is possible that you may not hit the required 6% target for the quarter. Row 93 is supporting the R&D function overall and investigating for future innovation (not implementing the product enhancements already identified – that spending is separate).

Thus, if you take the Program Expense #5 value out of Row 93, it does not get added back in anywhere to be part of the R&D as a % of Sales calculation (the required 6%).

Place your order now for a similar paper and have exceptional work written by our team of experts to guarantee you A Results

Why Choose US

6+ years experience on custom writing
80% Return Client
Urgent 2 Hrs Delivery
Your Privacy Guaranteed
Unlimited Free Revisions

 

find the cost of your paper

Is this question part of your Assignment?

We can help

Our aim is to help you get A+ grades on your Coursework.

We handle assignments in a multiplicity of subject areas including Admission Essays, General Essays, Case Studies, Coursework, Dissertations, Editing, Research Papers, and Research proposals

Header Button Label: Get Started NowGet Started Header Button Label: View writing samplesView writing samples