Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP I have to answer this using excel and it is due in a few hours This homework assignment is to be completed in

PLEASE HELP I have to answer this using excel and it is due in a few hours
image text in transcribed
This homework assignment is to be completed in Excel. You will also be interpreting your answers using textboxes near your Excel work.. Use Excel to find the numerical answers for each problem. Your Excel columns and work need to be clearly labeled. 1. Many businesses spend money each year on advertising in order to stimulate sales of their products. The data given in the table below show the approximate increase in sales (rate of change = derivative of revenue R'(x)) in thousands of dollars that an additional $100 spent on advertising, at various levels, can be expected to generate. Advertising Expenditures (hundreds of S) 25 50 75 100 125 150 175 R'(x) Rate of change of Revenue (thousands of $) 5 60 95 105 104 79 34 a) [10 pts. Use Excel and the data given to find a good approximation of the accumulated revenue for this company when spending between $2500 and $17,500 on advertising, Show all your work in Excel and state your answers in a text box region. b) [5 pts] Use Excel to graph the data for R'(x) and find a regression model for the data above using one of the six functions we use in Business Calculus. Round coefficients to 4 decimal places and place the equation on the graph. c) [10 pts] Remember, the point of diminishing return is the point of inflection on the revenue function (which is NOT shown), where the second derivative would be zero. Using the R'(x) equation that you found in part b. manually find the R"(x) equation and put this is a text region. Next produce an input/output table of R"(x) in Excel and use solver to find where R"(x) = 0 and changes sign, to find the x value of the point of diminishing return of the revenue function R(x). Interpret the meaning of this value using a complete sentence. This homework assignment is to be completed in Excel. You will also be interpreting your answers using textboxes near your Excel work.. Use Excel to find the numerical answers for each problem. Your Excel columns and work need to be clearly labeled. 1. Many businesses spend money each year on advertising in order to stimulate sales of their products. The data given in the table below show the approximate increase in sales (rate of change = derivative of revenue R'(x)) in thousands of dollars that an additional $100 spent on advertising, at various levels, can be expected to generate. Advertising Expenditures (hundreds of S) 25 50 75 100 125 150 175 R'(x) Rate of change of Revenue (thousands of $) 5 60 95 105 104 79 34 a) [10 pts. Use Excel and the data given to find a good approximation of the accumulated revenue for this company when spending between $2500 and $17,500 on advertising, Show all your work in Excel and state your answers in a text box region. b) [5 pts] Use Excel to graph the data for R'(x) and find a regression model for the data above using one of the six functions we use in Business Calculus. Round coefficients to 4 decimal places and place the equation on the graph. c) [10 pts] Remember, the point of diminishing return is the point of inflection on the revenue function (which is NOT shown), where the second derivative would be zero. Using the R'(x) equation that you found in part b. manually find the R"(x) equation and put this is a text region. Next produce an input/output table of R"(x) in Excel and use solver to find where R"(x) = 0 and changes sign, to find the x value of the point of diminishing return of the revenue function R(x). Interpret the meaning of this value using a complete sentence

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

Introduction To Management Accounting Chapters 1 To 17

Authors: Charles T. Horngren, Gary L. Sundem, William O. Stratton, Dave Burgstahler, Jeff Schatzberg

15th Edition

0136102654, 978-0136102656

More Books

Students also viewed these Accounting questions