Chapter 10: Problem 7
Describe the account analysis method for estimating a cost function.
Short Answer
Step by step solution
Key Concepts
These are the key concepts you need to understand to accurately answer the question.
/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}
Learning Materials
Features
Discover
Chapter 10: Problem 7
Describe the account analysis method for estimating a cost function.
These are the key concepts you need to understand to accurately answer the question.
All the tools & learning materials you need for study success - in one app.
Get started for free
Discuss four frequently encountered problems when collecting cost data on variables included in a cost function.
What is the difference between a linear and a nonlinear cost function? Give an example of each type of cost function.
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: Revenue \(=\$ 51,999.64-(0.98 \times \text { Online advertising expense })\) 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: Revenue \(=\$ 28,361.37+(5.38 \times \text { Online advertising expense })\) 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?
(CIMA, adapted) Catherine McCarthy, sales manager of Baxter Arenas, is checking to see if there is any relationship between promotional costs and ticket revenues at the sports stadium. She obtains the following data for the past 9 months: $$\begin{array}{lcc} \text { Month } & \text { Ticket Revenues } & \text { Promotional costs } \\ \hline \text { April } & \$ 200,000 & \$ 52,000 \\ \text { May } & 270,000 & 65,000 \\ \text { June } & 320,000 & 80,000 \\ \text { July } & 480,000 & 90,000 \\ \text { August } & 430,000 & 100,000 \\ \text { September } & 450,000 & 110,000 \\ \text { 0ctober } & 540,000 & 120,000 \\ \text { November } & 670,000 & 180,000 \\ \text { December } & 751,000 & 197,000 \end{array}$$ She estimates the following regression equation: Ticket revenues \(=\$ 65,583+(\$ 3.54 \times \text { Promotional costs })\) 1\. Plot the relationship between promotional costs and ticket revenues. Also draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line. 2\. Use the high-low method to compute the function relating promotional costs and revenues. 3\. Using (a) the regression equation and (b) the high-low equation, what is the increase in revenues for each \(\$ 10,000\) spent on promotional costs within the relevant range? Which method should Catherine use to predict the effect of promotional costs on ticket revenues? Explain briefly.
Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night's stay at their hotels. One of the activities, "Inspection," occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using "number of rooms inspected" as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection. Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows: $$\begin{array}{cccc}\text { Week } & \text { Rooms Inspected } & \text { Inspection Labor-Hours } & \text { Inspection costs } \\\\\hline 1 & 254 & 66 & \$ 1,740 \\\2 & 322 & 110 & 2,500 \\\3 & 335 & 82 & 2,250 \\\4 & 431 & 123 & 2,800 \\\5 & 198 & 48 & 1,400 \\\6 & 239 & 62 & 1,690 \\\7 & 252 & 108 & 1,720 \\\8 & 325 & 127 & 2,200\end{array}$$ Mary runs regressions on each of the possible cost drivers and estimates these cost functions: Inspection costs \(=\$ 193.19+(\$ 6.26 \times \text { Number of rooms inspected })\) Inspection costs \(=\$ 944.66+(\$ 12.04 \times\) Inspection labor-hours) 1\. Explain why rooms inspected and inspection labor-hours are plausible cost drivers of inspection costs. 2\. Plot the data and regression line for rooms inspected and inspection costs. Plot the data and regression line for inspection labor-hours and inspection costs. Which cost driver of inspection costs would you choose? Explain. 3\. Mary expects inspectors to inspect 300 rooms and work for 105 hours next week. Using the cost driver you chose in requirement 2, what amount of inspection costs should Mary budget? Explain any implications of Mary choosing the cost driver you did not choose in requirement 2 to budget inspection costs.
What do you think about this solution?
We value your feedback to improve our textbook solutions.