Cost Accounting (15th Edition)
Cost Accounting (15th Edition)
15th Edition
ISBN: 9780133428704
Author: Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
bartleby

Videos

Textbook Question
Book Icon
Chapter 10, Problem 10.41P

Interpreting regression results, matching time periods. Nandita Summers works at Modus, a store that caters to fashion for young adults. Nandita is responsible for the store’s online advertising and promotion budget. For the past year, she has studied search engine optimization and has been purchasing keywords and display advertising on Google, Facebook, and Twitter. In order to analyze the effectiveness of her efforts and to decide whether to continue online advertising or move her advertising dollars back to traditional print media, Nandita collects the following data:

Chapter 10, Problem 10.41P, Interpreting regression results, matching time periods. Nandita Summers works at Modus, a store that , example  1

  1. 1. Nandita performs a regression analysis, comparing each month’s online advertising expense with that month’s revenue. Verify that she obtains the following result:

  Required

     Revenue = $ 51 , 999.64 ( 0.98 × Online advertising expense )

Chapter 10, Problem 10.41P, Interpreting regression results, matching time periods. Nandita Summers works at Modus, a store that , example  2

  1. 2. Plot the preceding data on a graph and draw the regression line. What does the cost formula indicate about the relationship between monthly online advertising expense and monthly revenues? Is the relationship economically plausible?
  2. 3. After further thought, Nandita realizes there may have been a flaw in her approach. In particular, there may be a lag between the time customers click through to the Modus website and peruse its social media content (which is when the online ad expense is incurred) and the time they actually shop in the physical store. Nandita modifies her analysis by comparing each month’s sales revenue to the advertising expense in the prior month. After discarding September revenue and August advertising expense, show that the modified regression yields the following:

   Revenue = $ 28 , 361.37 + ( 5.38 × Online advertising expense )

Chapter 10, Problem 10.41P, Interpreting regression results, matching time periods. Nandita Summers works at Modus, a store that , example  3

  1. 4. What does the revised formula indicate? Plot the revised data on a graph. Is this relationship economically plausible?
  2. 5. Can Nandita conclude that there is a cause-and-effect relationship between online advertising expense and sales revenue? Why or why not?
Blurred answer
Students have asked these similar questions
Brian just completed a Client Needs Assessement and his client confirmed that she will requre profitability tracking, and need to create budgets and purchase orders in her accounting solution. What is the mimimum Quick Books online version suitable for Brian's client?
Valencia Manufacturing Company manufactures and sells musical gadgets. You have just begun your summer internship at Valencia Manufacturing. To expand sales, the business is considering paying a commission to its sales team. You have been asked to compute 1) the new break-even sales figure, and 2) the operating profit if sales increase by 10% under the new sales commission plan. She is confident that you can handle the task, because you learned CVP analysis in your accounting class. The following data was obtained: Selling price per unit Variable expenses per unit: $200 $40 $32 $18 Direct Material Direct Labour Variable Manufacturing Overhead Fixed expenses: Fixed Manufacturing Overhead Fixed Selling Costs Fixed Administrative Costs $190,000 $115,000 $135,000 6,000 Units Production/Sales After collecting your data, you performed your analysis and submitted a memo to your manager, who was very pleased with the work done, Your report indicated that the new sales commission plan would…
Valencia Manufacturing Company manufactures and sells musical gadgets. You have just begun your summer internship at Valencia Manufacturing. To expand sales, the business is considering paying a commission to its sales team. You have been asked to compute 1) the new break-even sales figure, and 2) the operating profit if sales increase by 10% under the new sales commission plan. She is confident that you can handle the task, because you learned CVP analysis in your accounting class.The following data was obtained:Selling price per unit $200 Variable expenses per unit: Direct Material $40Fixed expenses:Production/SalesDirect Labour $32 Variable Manufacturing Overhead $18Fixed Manufacturing Overhead Fixed Selling CostsFixed Administrative Costs$190,000 $115,000 $135,0006,000 Units   Find the break-even in sales find the operating profit before and after the fixed cost adjustments

Chapter 10 Solutions

Cost Accounting (15th Edition)

Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Text book image
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License