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
-
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?
-
An oil with Pr = 1960, = 860 kg/m3, = 1.6 104 m2/s, and k = 0.14W/m oC enters a 2.5-mm-diameter tube 60 cm long. The oil entrance temperature is 20oC, the mean flow velocity is 30 cm/s, and the...
-
The standard deviation of the sale price of a bike is no more than $225. Write the claim as a mathematical statement. State the null and alternative hypotheses, and identify which represents the...
-
The following transactions were completed by Daws Company during the current fiscal year ended December 31: Jan. 29. Received 35% of the $9,000 balance owed by Kovar Co., a bankrupt business, and...
-
Sell as-is or process further (17 points): Douglas' Funiture Co. is considering whether they want to sell their furniture wood finish spray as-is or process it further. Douglas' has spent $20,000 to...
-
Based on your earnings and living expenses, you think you will be able to pay back $3,000 in one year, and then $6,000 each year for the next three years. If a bank charges you 6% per year, how much...
-
Which are the three fastest-growing companies in the country? What opportunities have they pursued to achieve this level of growth? What growth mechanism have they used (internal, joint venture,...
-
An attribute definition includes (a) name, data type, and default value if applicable (b) name, arguments, and constraints (c) constraints, data type, and a default value, if applicable (d) name,...
-
What elements are discovered using the sequence diagram and added to the class diagram? (a) Interfaces of the objects (b) Classes of the objects in the sequence diagram, attributes, and operations...
-
The definition of an operation includes (a) name, arguments, and return data type where the return data type is optional (b) constraints, name, and arguments where the return data type and...
-
In the oil and gas extraction industry, what are the pay ratios for the chief executives job to (a) human resources managers, (b) accountants and auditors, and (c) file clerks? In the retail trade...
-
Go to sec.gov and click on filings and you get a drop-down box. Click on company filings search. In the fast search box (right side), type in USB to get the sec filings for U.S. Bancorp Find the most...
-
One hundred pounds of water at atmospheric pressure are heated from 60F to 200F. What is the enthalpy change? The internal energy change? Why is the difference between the internal energy change and...
-
After successful stretches at Target and Apple, it seemed as though Ron Johnson was a master marketer. But things went sour quickly after JC Penney hired him as its CEO. Johnsons attempt to reinvent...
-
In the summer of 2015, Stephen Kuhl and Kabeer Chopra made their way to Philadelphia to prepare for business school. It was their first semester in the Wharton MBA program. They were both in an...
-
One of the main fears that retail startups have is if they will be able to compete against Walmart, Home Depot, and the other big-box stores. This is a legitimate fear. Big-box stores continue to...
Study smarter with the SolutionInn App