Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells in gallon-size bottles with a spray attachment. The majority of Garfield's business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of their yards. Garfield's operating information for the first six months of the year follows: Number of Bottles Sold Operating Cost Month January February March April May June Required: 1,000 $ 10,420 1,300 15,600 1,810 16,050 2,490 19,380 3,550 27,440 3,630 34,870 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. 4. Perform a least-squares regression analysis on Garfield's data. 5. Determine how well this regression analysis explains the data. 6. Using the regression output, create a linear cost equation (y = a + bx) for estimating Garfield's operating costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. Note: Do not round your intermediate calculations. Round your variable cost per unit answer to 2 decimal places and fixed cost answer to the nearest whole number. Variable Cost per Unit Fixed Cost $ 9.30 Required 3 Required 4 Required 5 Required 6 Perform a least-squares regression analysis on Garfield's data. Note: Use Microsoft Excel or a statistical package to find the coefficients using least-squares to 3 decimal places. Intercept X Variable 1 Coefficients Required 3 Required 4 Required $ Required 6 Determine how well this regression analysis explains the data. Note: Round your regression statistics to three decimal places and, observation and percentage answer to the nearest whole number. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations From the regression output. number of bottles explains about % of the variability in Garfield's total cost. Required 3 Required 4 Required 5 Required 6 Using the regression output, create a linear cost equation (y = a + bx) for estimating Garfield's operating costs. Note: Round your answers to 3 decimal places. Total Cost = (Number of Bottles) Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells in gallon-size bottles with a spray attachment. The majority of Garfield's business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of their yards. Garfield's operating information for the first six months of the year follows: Number of Bottles Sold Operating Cost Month January February March April May June Required: 1,000 $ 10,420 1,300 15,600 1,810 16,050 2,490 19,380 3,550 27,440 3,630 34,870 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. 4. Perform a least-squares regression analysis on Garfield's data. 5. Determine how well this regression analysis explains the data. 6. Using the regression output, create a linear cost equation (y = a + bx) for estimating Garfield's operating costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. Note: Do not round your intermediate calculations. Round your variable cost per unit answer to 2 decimal places and fixed cost answer to the nearest whole number. Variable Cost per Unit Fixed Cost $ 9.30 Required 3 Required 4 Required 5 Required 6 Perform a least-squares regression analysis on Garfield's data. Note: Use Microsoft Excel or a statistical package to find the coefficients using least-squares to 3 decimal places. Intercept X Variable 1 Coefficients Required 3 Required 4 Required $ Required 6 Determine how well this regression analysis explains the data. Note: Round your regression statistics to three decimal places and, observation and percentage answer to the nearest whole number. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations From the regression output. number of bottles explains about % of the variability in Garfield's total cost. Required 3 Required 4 Required 5 Required 6 Using the regression output, create a linear cost equation (y = a + bx) for estimating Garfield's operating costs. Note: Round your answers to 3 decimal places. Total Cost = (Number of Bottles)
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-0078025518
2nd edition
Authors: Stacey Whitecotton, Robert Libby, Fred Phillips
Posted Date:
Students also viewed these accounting questions
-
REQUIRED Use the information given below to prepare the Income statement of Kendall Manufacturers for October 2 0 2 3 using the following methods: 2 . 1 Marginal costing 2 . 2 Absorption costing....
-
Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells in gallon-size bottles with a spray attachment. The majority of Garfields business comes from orders...
-
When stock prices initially began to fall, what was the reaction by many investors?
-
Why are lipids and proteins free to move laterally in membranes? O a. Lipids and proteins repulse each other in the membrane O b. The interior of the membrane is filled with liquid water Oc. There...
-
Write the balanced chemical equation for the neutralization reaction between HCl and Fe(OH)3. What is the salt?
-
For the previous month, the Ellram Lounge served 1,500 customers with very few complaints. Their labor cost was $3,000; material cost was $800; energy cost was $200; and building lease cost was...
-
What is the significance of strong growth economies among the Fortune 500?
-
Phillips Industries manufactures a certain product that can be sold directly to retail outlets or to the Superior Company for further processing and eventual sale as a completely different product....
-
Transcribed image text: 11
-
How do cultural dimensions, such as Hofstede's individualism-collectivism or Trompenaars' universalism-particularism, influence the development and evolution of organizational culture across...
-
Discuss the key dimensions of ethical leadership Define the term corporate governance Discuss the central issues in ethics and demonstrate how they relate to corporate governance Present the...
-
Name a company that you believe has either a good marketing strategy or marketing plan. What do you feel makes it effective? Also, why is having a formal marketing plan an important concept/idea for...
-
Identify a theory of leadership reviewed in the course that most closely aligns with your personal philosophy of leadership.
-
Is effective leadership behavior universal, or does it vary from culture to culture? Explain with examples. 1. What is Leadership? What are the different styles of leadership? 2. What is authentic...
-
JK Company produces two products, Plush and Supreme. JK Companycan sell all of the units it can produce for both products, but ithas limited production capacity. Machine hours per unit are .25hours 2...
-
Why are stocks usually more risky than bonds?
-
Qualitative Characteristics} Listed below are the fundamental and enhancing qualitative characteristics that make accounting information useful. a. Relevance b. Faithful representation c....
-
Events and Transactions OBJECTIVE 2 Several events are listed below. a. Common shares are issued to investors. b. An agreement is signed with a janitorial service to provide cleaning services over...
-
Events and Transactions} The following economic events that were related to A\&P Grocery Store occurred during 2018. a. On February 7, A\&P received a bill from Chatham Power and Light indicating...
Study smarter with the SolutionInn App