An entrepreneur runs a website that sells car tires online. Based on the Regression output below, how much in Advertising Budget do you predict is needed to sell 40 tires per day. (round to the nearest dollar) SUMMARY OUTPUT Regression Statistics Multiple R 0.93303 R Square 0.87055 Adjusted R Square 0.85616 Standard Error 4.91656 Observations 11 Standard Error P-Value Coefficients Intercept 12.5671 3.16973 0.0032807 Advertising Budget 0.07224 009286 0.0000277

An entrepreneur runs a website that sells car tires online. Based on the Regression output below, how much in Advertising Budget do you predict is needed to sell 40 tires per day. (round to the nearest dollar) SUMMARY OUTPUT Regression Statistics Multiple R 0.93303 R Square 0.87055 Adjusted R Square 0.85616 Standard Error 4.91656 Observations 11 Standard Error P-Value Coefficients Intercept 12.5671 3.16973 0.0032807 Advertising Budget 0.07224 009286 0.0000277

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter3: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 10EB: Keleher Industries manufactures pet doors and sells them directly to the consumer via their web...

See similar textbooks

Similar questions

Hammond Company runs a driving range and golf shop. The budgeted income statement for the coming year is as follows. Required: 1. What is Hammonds variable cost ratio? Its contribution margin ratio? 2. Suppose Hammonds actual revenues are 200,000 greater than budgeted. By how much will before-tax profits increase? Give the answer without preparing a new income statement. 3. How much sales revenue must Hammond earn in order to break even? What is the expected margin of safety? (Round your answers to the nearest dollar.) 4. How much sales revenue must Hammond generate to earn a before-tax profit of 130,000? An after-tax profit of 90,000? (Round your answers to the nearest dollar.) Prepare a contribution margin income statement to verify the accuracy of your last answer.
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
Keleher Industries manufactures pet doors and sells them directly to the consumer via their web site. The marketing manager believes that if the company invests in new software, they will increase their sales by 10%. The new software will increase fixed costs by $400 per month. Prepare a forecasted contribution margin income statement for Keleher Industries reflecting the new software cost and associated increase in sales. The previous annual statement is as follows:
The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Multiple regression was run on the above data; the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 total purchase orders and 45 nonstandard orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders and 580 nonstandard orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 2? (Round your answers to the nearest dollar.)
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Speedy Petes on the previous page. Coefficients shown by a regression program for Speedy Petes data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of deliveries and the variable rate per delivery. 2. Construct the cost formula for total delivery cost. 3. Calculate the budgeted cost for next month, assuming that 3,000 deliveries are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-26 through 3-29: Speedy Petes is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows:
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web site construction is estimated to be $171,000. Variable processing costs are estimated to be $8 per book. The publisher plans to sell single-user access to the book for $41. Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 − 6p, where p is the price of the e-book. (a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit estimated
Refer to the original data. The Marketing Department thinks that a fancy new package for the laptop computer battery would grow sales. The new package would increase packaging costs by $0.70 per unit. Assuming no other changes, how many units would have to be sold each month to attain a target profit of $4,800?
A furniture's store is considering tow marketing strategies: a loyalty program that would cost $3,000 and increase revenue by $15,000, or a seasonal sale that would cost $5,000 and increase revenue by $25,000. The store's contribution margin is 30%. Which strategy should they pursue if the goal is to maximize ROMI? What about if the goal is to maximize revenue growth?
Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 22 per unit Variable costs 5 per unit Fixed costs 25,000 per month Assume that the projected number of units sold for the month is 7,000. Consider requirements (b), (c), and (d) independently of each other. Required: b. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent?
Tom uses his computer to calculate the following regression formula:Weekly total costs = $18,791 + ($19.97 * Number of orders per week) Draw the regression line on your graph. Use your graph to evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Is the cost function estimated using the high-low method a close approximation of the cost function estimated using the regression method? Explain briefly.
What's the breakeven point in sales units? What's the breakeven point in sales dollars? Cryptocoins is a manufacturer of 3D cameras and is preparing production and sales forecasts for the coming fiscal year. The company needs to determine the point at which the projected sales revenue will equal the total of all fixed and variable costs. Fixed costs are estimated to be $314,390, and variable costs are expected to be maintained at $150 per camera. Each camera will sell for $299.
Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 23 per unit Variable costs 6 per unit Fixed costs 24,000 per month Assume that the projected number of units sold for the month is 6,000. Consider requirements (b), (c), and (d) independently of each other. Required: What will the operating profit be? What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? Suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?