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:
- 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
- 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?
- 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:
- 4. What does the revised formula indicate? Plot the revised data on a graph. Is this relationship economically plausible?
- 5. Can Nandita conclude that there is a cause-and-effect relationship between online advertising expense and sales revenue? Why or why not?
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
COST ACCOUNTING
- A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.arrow_forwardSanjana’s Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per Customer Scenario (Price – Cost of Goods) Number of Customers Good $6.7 47,000 Fair 5.7 37,000 Poor 1.9 32,000 Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $47,000 plus $2 for every customer in excess of…arrow_forwardSanjana’s Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per Customer Scenario (Price – Cost of Goods) Number of Customers Good $5 30,000 Fair 4 20,000 Poor 2 15,000 Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $25,000 plus $2 for every customer in excess of…arrow_forward
- Kowkeela has recently opened The Cooker Shop, a store that specializes in one type of cooker. Kowkeela has just received a degree in business and she is anxious to apply the principles she has learned to her business. In time, she hopes to open a chain of cooker shops. As a first step, she has prepared the following analysis for her new store:Sales price per cooker . . . . . . . . . . . $50Variable expenses per cooker. . . . . . $16Fixed expenses per year:- - - Building rental . . . . . . . . . . . . . . $12000- - - Equipment depreciation . . . . . . $5300- - - Selling . . . . . . . . . . . . . . . . . . . . . $15500- - - Administrative . . . . . . . . . . . . . . $17000 d. Refer to the original data, the number of cookers to be sold each year to break even is (f)Refer to the original data, Kowkeela now has two salespersons working in the store—one full time and one part time. It will cost her an additional $7700 per year to convert the part-time position to a full-time position.…arrow_forwardassume that you are planning to purchase a new laptop for school, work, and home use. go to the website of two computer manufacturers and make a selection. complete the following items and questions. compare the following items for your selections in their financial statements. revenues for products, revenues for services, cost of goods sold, accounts receivable, inventories, accounts payable, and research ad development. what are some factors that can impact the gross profit of a merchandise company? one item that can help investors understand the relationship between net sales and net profits is the gross profit rates. find the financial information needed to calculate the gross profit rate for your two selected companies.arrow_forwardSanjana's Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer seaso the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first ste planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise ar experience, she develops the following. Scenario Good Fair Poor Gross Margin per Customer (Price Cost of Poor Fair Good Poor Fair Good Poor Fair Good Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $31,000 plus $2 for every customer in excess of 26,000. The marketing and administrative costs are estimated to be…arrow_forward
- You are a social media marketer responsible for creating a social media campaign for a pair of Ray Ban sunglasses. The goal of your social campaign is to drive sales for the sunglasses. With every single social post, you include a trackable call-to-action link to your website where users could purchase the sunglasses. You outsourced all of the professional photographs of the sunglasses, creation of the social media graphics and videos to a company for $5,000. You also spent $3,000 on social media ads directed at the target market. Your campaign ran for one month, and during that time you only worked on the campaign, making a salary of $5,000. The social media management tool that your company pays for costs $1,000 a month. By the end of the campaign, you were able to pull a report from your company website of all the sunglasses sold from customers who clicked on the trackable link from social media. The total revenue for sunglasses purchases from the social media campaign was $50,000,…arrow_forwardValencia Manufacturing Company manufactures and sells musical gadgets. You have just begun yoursummer internship at Valencia Manufacturing. To expand sales, the business is considering paying acommission to its sales team. You have been asked to compute 1) the new break-even sales figure, and 2) theoperating profit if sales increase by 10% under the new sales commission plan. She is confident that you canhandle the task, because you learned CVP analysis in your accounting class.The following data was obtained:Selling price per unit $200Variable expenses per unit: Direct Material $40Direct Labour $32Variable Manufacturing Overhead $18Fixed expenses: Fixed Manufacturing Overhead $190,000Fixed Selling Costs $115,000Fixed Administrative Costs $135,000Production/Sales 6,000 UnitsAfter collecting your data, you performed your analysis and submitted a memo to your manager, who was verypleased with the work done. Your report indicated that the new sales commission plan would result in…arrow_forwardYou have just begun your summer internship at Omni Instruments. The company supplies sterilized surgical instruments for physicians. To expand sales, Omni is considering paying a commission to its sales force. The controller, Matthew Barnhill, asks you to compute: (1) the new breakeven sales figure, and (2) the operating profit if sales increase 15% under the new sales commission plan. He thinks you can handle this task because you learned CVP analysis in your accounting class. You spend the next day collecting information from the accounting records, performing the analysis, and writing a memo to explain the results. The company president is pleased with your memo. You report that the new sales commission plan will lead to a significant increase in operating income and only a small increase in breakeven sales. The following week, you realize that you made an error in the CVP analysis. You overlooked the sales personnel’s $2,800 monthly salaries, and you did not include this fixed…arrow_forward
- Rock Designs, Inc. is a jewelry store located in Miramar Beach, Florida. After Valentine’s Day, the store often has excess cash to get it through the three-month slow season. The primary stockholder, Hardy Rock, wants to make this seasonal cash work for the business. Requirements Identify which investment class options are available to Rock Designs, Inc. The company identifies that it wants to invest in the technology sector and has narrowed its choices to three companies: Apple Inc., Google Inc., and Microsoft Corporation. Prepare a brief analysis comparing the three companies, and recommend one of the three based on your analysis.arrow_forwardUsing the information in the below paragraph, what is the expected Customer Lifetime Value (CLV) of Eugenia Garcia to Autobarn City Mazda? Eugenia Garcia is a DePaul Driehaus College of Business student majoring in Marketing with a concentration in Sales Leadership. Eugenia graduates at the end of this quarter. Following a successful internship, the previous summer, Eugenia has accepted a full-time job offer with Microsoft in the role of Associate Sales Representative with a starting annual salary of $79,500. Additionally, Eugenia will receive $500 monthly ($6,000 total annually) as a car allowance plus 72 cents per mile traveled for work given the need for Eugenia to visit customers in person across her sales territory in the Chicago metro area. Eugenia's new job starts two weeks following graduation during the same week Eugenia celebrates her 23rd birthday with family and friends. Like most urban college students, Eugenia has not owned a car while attending DePaul. Instead, she has…arrow_forwardLizzy's is a retail clothing store, specializing in formal wear for weddings. They purchase their clothing for resale from specialty distributors and manufacturers. Recently the owners of Lizzy have noticed an increased interest in costume jewelry and fashion accessories among their clientele. If the owners decide to expand their business to include these products, what cost data would they need to collect and analyze prior to expanding their business?arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College