How the price of a set of clubs affects the demand for clubs

Assignment Help Managerial Accounting
Reference no: EM131357034

Complete Problem 50 in Chapter 10 on page 477.

A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales.

Assume the only factor influencing monthly sales is price. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best?

Interpret your best-fitting equation.

Using the best-fitting equation, predict sales during a month in which the price is $470.

In the discussion area, attach the Excel document showing work.

Also Please show the work in EXCEL

PLEASE USE THE REQUESTED REFERENCE.

REFERENCE

Albright, S. C, & Winston, W. L. (2017). Business Analytics: Data Analysis and Decision Making (6th ed.). Boston, MA: Cengage Learning

Chapter 10: Regression Analysis: Estimating Relationships

Chapter 11: Regression Analysis: Statistical Inference

Chapter 12: Time Series Analysis and Forecasting

Attachment:- p10-50.xlsx

Verified Expert

Here all the three specified models are fitted to the data- linear,exponential and multiplicative model. The estimates of a and b are calculated using regression function in Excel. Once the estimates of the parameters are calculated, the predicted values are also calculated for these three models. Then the residuals are measured. In regression,our aim is to fit a model which has minimum error sum of squares. Here it can be seen that for the exponential model,the residual sum of squares is significantly lower than the other two, So,it can be concluded that exponential model fits the data well.

Reference no: EM131357034

Questions Cloud

Evaluate each of the approaches to applying the framework : Evaluate each of the approaches to applying the framework as discussed the Lane textbook. Determine how each approach would align to the organization for future growth and success. Give your opinion as to the validity of each approach.Identify thr..
Who enters the sale in a cash register : Describe the who, what, where, and how of the following scenario: A customer gives his purchase to a sales clerk, who enters the sale in a cash register and puts the money in the register drawer.
Find in the marketing function''s organization chart : What key players would you expect to find in the marketing function's organization chart?
Analyze specific steps ge took in developing its strategy : Analyze the specific steps GE took in developing its strategy to grow its BOP market. Determine the manner in which those actions apply to the principles of strategic thinking and strategic planning.
How the price of a set of clubs affects the demand for clubs : A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales.
What are the subsidiary processes of each major process : What data stores are owned by other information processes that provide data to the M/S process? What data does the M/S process obtain from these stores?
Who determines which transportation services are available : MGT325- Who determines which transportation services are available? What law allowed collective rate making by the transportation carriers?
Why a flow from a higher to a lower numbered bubble : Explain why a flow from a higher- to a lower-numbered bubble on a logical DFD is a physical manifestation of the system. Give an example.
Identifies potential stakeholders directly or indirectly : You have been hired by a large company with branch offices around the country to assist with rollout of a new companywide compliance system. While initially the focus was on implementation of the technology, it was found that success will require ..

Reviews

Write a Review

 

Managerial Accounting Questions & Answers

  Difference between a planning budget and a flexible budget

What is the difference between a planning budget and a flexible budget?

  Best estimate of the total variable cost per unit

Green Company's variable expenses are 75% of sales. At a sales level of $400,000, the company's degree of operating leverage is 8. At this sales level, fixed expenses are

  Evaluate the equivalent units for materials

Evaluate the equivalent units for materials using FIFO and compute the equivalent units for conversion costs using FIFO.

  What is the incremental cost associated

What is the incremental cost associated with producing an extra 50,000 jars of salsa?

  Discuss the key items related to a successful balanced

Help the company by identifying three customer-focused measures that can be used on the balanced scorecard. Discuss the key items related to a successful balanced scorecard.

  Assignation individual ai 3 master and flexible budget1

assignation individual ai 3 master and flexible budget1. orange company is planning to sell 200 buckets and produce 190

  Madrigal theater company is interested in estimating fixed

Assume that the selling price per ticket is $25.Based on your answer to part a, what is your estimate of the contribution margin ratio at Madrigal Theater?

  What rate is the mass of quasar

Quasars are thought to be the nuclei of active galaxies in the early stages of their formation. A typical quasar radiates energy at the rate of 1041 W.

  Record the journal entry to close over or under applied

Record the journal entry to close over or under applied factory overhead to Cost of Goods Sold for each of the independent cases below.

  Compute cash flows from financing activities

1.Compute cash flows from financing activities using the following company information.

  Which of the activity variances should be of concern

Which of the activity variances should be of concern to management? Explain.

  Recognize types of responsibility centers

Recognize types of responsibility centers as a cost center, a profit center, a revenue center or an investment center.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd