Davis Stores sells clothing in 15 stores located around the southwestern United States The managers at...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Davis Stores sells clothing in 15 stores located around the southwestern United States The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following information from last year's operations (revenues and costs in thousands of dollars) Store 101 102 103 104 105 Costs $5,727 2,252 2,628 1,815 3,413 3,695 5,591 3,376 4,856 5,273 2,653 2,976 5,446 4,772 1,715 Employees Revenues $4,866 6,436 2,448 4,878 6,087 5,331 3,218 3,544 3,675 3,464 3,098 2,562 3,507 4, 588 3,768 52 29 45 26 36 106 53 57 107 108 51 109 110 45 52 111 43 112 113 38 53 31 114 115 25 e-1. Enter the regression coefficients. e-2. Estimate the cost of a store with revenues of $3.40 million and 51 employees using the results of a multiple regression of store costs on store revenues and employees Complete this question by entering your answers in the tabs below. Reg E1 Reg E2 Estimate the cost of a store with revenues of $3.40 million and 51 employees using the results of a multiple regression of store costs on store revenues and employees. (Round "Intercept", "Employees" and "Revenues" to 2 decimal places in the intermediate calculations. Round your final answers to 2 decimal places.) Slore cost < Reg E1 Store Employees 52 Costs $5,727 2,252 2,628 1,815 3,413 3,695 5,591 3,376 4,856 5,273 2,653 2,976 5,446 4,772 1,715 Revenues $4,866 6,436 2,448 4,870 6,087 5,331 3,218 3,544 3,675 3,464 3,098 2,562 3,507 4,588 3,768 101 102 103 29 45 104 105 26 36 53 106 107 57 108 51 109 110 111 112 113 45 52 43 38 53 114 31 115 25 e-1. Enter the regression coefficients. e-2. Estimate the cost of a store with revenues of $3.40 million and 51 employees using the results of a multiple regression o. costs on store revenues and employees. Complete this question by entering your answers in the tabs below. Req E1 Req E2 Enter the regression coefficients. (Round "Intercept", "Employees" and "Revenues" to 2 decimal places. Negative amounts should be indicated by a minus sign.) Intercept (1,319 87) 0.10 Revenues Employees 101.33 Req E2 > Davis Stores sells clothing in 15 stores located around the southwestern United States The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following information from last year's operations (revenues and costs in thousands of dollars) Store 101 102 103 104 105 Costs $5,727 2,252 2,628 1,815 3,413 3,695 5,591 3,376 4,856 5,273 2,653 2,976 5,446 4,772 1,715 Employees Revenues $4,866 6,436 2,448 4,878 6,087 5,331 3,218 3,544 3,675 3,464 3,098 2,562 3,507 4, 588 3,768 52 29 45 26 36 106 53 57 107 108 51 109 110 45 52 111 43 112 113 38 53 31 114 115 25 e-1. Enter the regression coefficients. e-2. Estimate the cost of a store with revenues of $3.40 million and 51 employees using the results of a multiple regression of store costs on store revenues and employees Complete this question by entering your answers in the tabs below. Reg E1 Reg E2 Estimate the cost of a store with revenues of $3.40 million and 51 employees using the results of a multiple regression of store costs on store revenues and employees. (Round "Intercept", "Employees" and "Revenues" to 2 decimal places in the intermediate calculations. Round your final answers to 2 decimal places.) Slore cost < Reg E1 Store Employees 52 Costs $5,727 2,252 2,628 1,815 3,413 3,695 5,591 3,376 4,856 5,273 2,653 2,976 5,446 4,772 1,715 Revenues $4,866 6,436 2,448 4,870 6,087 5,331 3,218 3,544 3,675 3,464 3,098 2,562 3,507 4,588 3,768 101 102 103 29 45 104 105 26 36 53 106 107 57 108 51 109 110 111 112 113 45 52 43 38 53 114 31 115 25 e-1. Enter the regression coefficients. e-2. Estimate the cost of a store with revenues of $3.40 million and 51 employees using the results of a multiple regression o. costs on store revenues and employees. Complete this question by entering your answers in the tabs below. Req E1 Req E2 Enter the regression coefficients. (Round "Intercept", "Employees" and "Revenues" to 2 decimal places. Negative amounts should be indicated by a minus sign.) Intercept (1,319 87) 0.10 Revenues Employees 101.33 Req E2 >
Expert Answer:
Answer rating: 100% (QA)
We have used MS Excel for performing regression analysis Following are the steps followed 1 On the D... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-1259565403
5th edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these law questions
-
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in...
-
[The following information applies to the questions displayed below.] Hitzu Co. sold a copier costing $4,800 with a two-year parts warranty to a customer on August 16, 2013, for $6,000 cash. Hitzu...
-
During one month, 45 preflight inspections were performed on an airplane at Southstar Airlines. 15 nonconformances were noted. Each inspection checks 50 items. Assuming 2 sigma off-centering, what...
-
While you may not work for a large corporation, there is merit to the notion that the organization must speak with one voice and speak quickly in a crisis. What forces (tradition, practice, and...
-
Use the Internet to conduct research related to whistleblower processes. Prepare a report summarizing key characteristics for the operation of an effective corporate whistleblower hotline. Be sure to...
-
A trial balance was extracted from the books of D. Wilson, and it was found that the debit side exceeded the credit side by 100. This amount was entered in the suspense account. The following errors...
-
Define a simple machine.
-
Gibson Motors manufactures specialty tractors. It has two divisions: a Tractor Division and a Tire Division. The Tractor Division can use the tires produced by the Tire Division. The market price per...
-
Coca Cola's dividend is $1/share per quarter. On average, the dividends are expected to grow by 2% per quarter. Assuming the expected return of the stock is 5% per quarter. What is the share price...
-
On January 1, 2021, Acme Co. is considering purchasing a 40 percent ownership interest in PHC Co., a privately held enterprise, for $700,000. PHC predicts its profit will be $185,000 in 2021,...
-
One million (1,000,000) shares of stock were issued to the founders of a start-up company on January 1, 2019. On July 1, 2019, the firm raised $500,000 from outside investors and issued 500,000 of...
-
Compare and contrast these methods, would you recommend accepting the project? (Do this concisely, it should not take more than a reasonably short paragraph.)
-
(a) Show that C(lim sup Ek) = lim inf CEK. (b) Show that if EkE or Ek E, then lim sup Ek = lim inf Ek = E.
-
Instructions Instructions Assets Q1 Journal Entries 1) Answer the questions in each tab, Q1-Q3 2) For the questions in Q1, first conduct a transaction analysis and indicate the dollar effects of the...
-
Assume the following three bonds a.) Calculate price, modified duration, and convexity for these three bonds. b.) Now, suppose you have $1,000,000 worth of the 5-year bond. You want to carry out a...
-
What is the IRR for this project? Assume BLTD requires a 14% return on a project, would you accept the project?
-
3. Find the volume under the given surface z = f (x, y) and above the rectangle with The given boundaries, a) z = 3x + 10y + 20; 0x3, 2 y 1
-
Which should drive action planning more, strengths or weaknesses? That is, is it more important to build on your strengths or to reduce your weaknesses? Explain.
-
It is clear after reading this chapter that activity-based costing is the best system. Whenever someone asks, Ill recommend its adoption. Do you agree? Explain.
-
What are life-cycle product costing and pricing?
-
Surf Beach State College (SBSC) has a business school with three products, undergraduate degrees, graduate degrees, and executive education. SBSC has three service departments, Computer Support,...
-
Which of the following is not a characteristic of prototype? (a) It is quick (b) It is relatively less expensive (c) It is reusable (d) None of these
-
All prototypes must be ___________ in nature. (a) Evolutionary (b) Conceptual (c) Physical (d) None of these
-
_____________ is an iterative tool for project development which produces a live working model of the system. (a) Function (b) Prototype (c) Module (d) Class
Study smarter with the SolutionInn App