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
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- Please help me. Thankyou.arrow_forwardA 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_forwardSuppose that Demont has been given a summer job as an intern at Isaac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. Classify each cost listed below as either product costs or period costs for the purpose of preparing the financial statements for the bank. Costs Product Cost/Period Cost 1. Depreciated on salesperson's cars 2. Rent on equipment used in the factory 3. Lubricants used for machine maintenance 4. Salaries of personnel who work in the finished goods warehouse 5. Soap and paper towels used by factory workers at the end of a shiftarrow_forward
- Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufacturessophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which isprivately owned, has approached a bank for a loan to help it finance its growth. The bank requires financialstatements before approving such a loan. You have been asked to help prepare the financial statements andwere given the following list of costs:1. Depreciation on salespersons’ cars.2. Rent on equipment used in the factory.3. Lubricants used for machine maintenance.4. Salaries of personnel who work in the finished goods warehouse.5. Soap and paper towels used by factory workers at the end of a shift.6. Factory supervisors’ salaries.7. Heat, water, and power consumed in the factory.8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.)9. Advertising costs.10. Workers’ compensation insurance for factory employees.11. Depreciation on chairs…arrow_forwardAs a recent hire of B-Well, your job is to evaluate whether the company should open a traditional grocery store in Astoria or start online shopping option instead. Before deciding which project to undertake, the Board of Directors has already agreed that they will hire a consultant to verify their decision. The consultant is charging $16, 580 total. They have also agreed that they will hire an NYC marketing agency to promote B-Well's reputation. They are not sure what the charge will be for the marketing services. For now, they just have to decide which project they will undertake. Brick & Mortar Store. B-Well Health Mart has to rent and renovate a space in Astoria. The estimates for the up-front renovation costs range from $2,250,000 to $2,650,000 to be depreciated over the life of the project using straight-line with a zero salvage value. There is a foreclosed warehouse in the area that their lenders are offering at a large discount since the lenders are losing money on it. The…arrow_forwardHarriet Moore is an accountant for New World Pharmaceuticals. Her duties include tracking research and development spending in the new product development division. Over the course of the past six months, Harriet has noticed that a great deal of funds have been spent on a particular project for a new drug. She hears “through the grapevine” that the company is about to patent the drug and expects it to be a major advance in antibiotics. Harriet believes that this new drug will greatly improve company performance and will cause the company’s stock to increase in value. Harriet decides to purchase shares of New World in order to benefit from this expected increase. Required What are Harriet’s ethical responsibilities, if any, with respect to the information she has learned through her duties as an accountant for New World Pharmaceuticals? What are the implications of her planned purchase of New World shares?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_forwardTaylor Construction builds custom homes in Dallas, Texas. Brandon Taylor knows that his future depends on the quality of the homes he builds and the service he provides to customers. Most new-customer sales arise from word-of-mouth advertising by former customers.Identify the balanced scorecard perspective for each measure in the exercise. Perspective a. Number of customer complaints Internal business processesCustomerLearning & growthFinancial b. Employee turnover Learning & growthFinancialInternal business processesCustomer c. Net profit per house constructed Learning & growthFinancialInternal business processesCustomer d. Turnaround time on customer design changes Learning & growthInternal business processesCustomerFinancial e. Hours of training per employee Learning & growthFinancialInternal business processesCustomer f. Average labor cost per house CustomerLearning &…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_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_forwardABC Company is a small business that sells handmade crafts online. The company has been in operation for three years and has been profitable since its inception. The owner, Sarah, has decided to expand her business by renting a physical storefront in addition to her online sales. She plans to purchase inventory and hire an employee to help manage the physical storefront. Sarah wants to know how this expansion will affect her financial statements and overall profitability. 1. How will the purchase of inventory affect the financial statements 2. How will the hiring of an employee affect the financial statements 3. How will the rental expense for the storefront affect the financial statements ???ts?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