Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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) in thousands of dollars that an additional $100 spent on advertising , at various levels, can be expected to generate. 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 using the ACTUAL DATA, and the methods we use in this course. 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 ONLY 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 equation that you found in part b, manually find the equation and put this is a text region. Next produce an input/output table of in Excel and use solver to find where and changes sign, to find the x value of the point of diminishing return of the revenue function Interoret the meaning of this value using a complete sentence. 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) in thousands of dollars that an additional $100 spent on advertising , at various levels, can be expected to generate. 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 using the ACTUAL DATA, and the methods we use in this course. 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 ONLY 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 equation that you found in part b, manually find the equation and put this is a text region. Next produce an input/output table of in Excel and use solver to find where and changes sign, to find the x value of the point of diminishing return of the revenue function Interoret 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

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538750196, 538745487, 538750197, 978-0538745482

More Books

Students also viewed these Accounting questions