Home
Homework Answers
Marketing Help
Create A Spreadsheet For Each Of The Estimation Methods

Create A Spreadsheet For Each Of The Estimation Methods

Posted Under: Marketing

Ask A Question

Hire Experts For Answers

Order Now

Related Study Services

DESCRIPTION

Posted 2021-01-27T14:44:46.000000Z

Modified 2021-01-31T12:58:02.000000Z

Viewed 16

Using a blank MS Excel file, create a spreadsheet demonstrating application of the high-low method and regression method of estimating fixed and variable costs as follows: Using the data in Exhibit 2.23 in the textbook, create a spreadsheet for each of the estimation methods: high-low method and regression. Create the data in a chart, show your calculations in words and numbers (meaning don't just show me the numbers, show the formula as well) and be certain to tie in your results to those in the textbook. Compare the results of the two methods for variable cost component and fixed cost component. Now, that you have the hang of it, drop off the month of December from your calculations. Using only the 11 months of data (Jan - Nov), on new worksheet tabs, calculate again using the high-low method and the regression method. Finally, using the results from the 11 month data estimation methods, calculate the expected total cost for the month of December (using the 34,000 units sold), applying the fixed and variable components for each method. How do the calculated expectations compare with the actual data (cost of $540,000). Which method is closer? What are the benefits of each method? What limitations exist with each method?

This order does not have tags, yet.

Attachments

Explanations and Answers 1

Hi Submitting the answer, if you have any query feel free to contact otherwise kindly approve my answer. Will look forward for more work from you. Thanks

$0.00

From 0 reviews

mtayyab

answered2021-01-29T07:40:44.000000Z

Answer Reviews

(0)

This answer has not been reviewed yet. Like to add yours?