ACCT2002 Cost Analysis for Decision Making Semester 1 and Trimester 1A, 2024 Portfolio Questions QUESTION ONE...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ACCT2002 Cost Analysis for Decision Making Semester 1 and Trimester 1A, 2024 Portfolio Questions QUESTION ONE (cont'd) Date Overhead Expense Sales (Units) Sales (Dollars) January-22 23,105 172 $19,990 QUESTION ONE Santana Company is a small manufacturer and retailer of guitars. The company produces wooden guitars that are made in-house and sold exclusively in-store. These guitars were originally hand-made, but over the years, production of guitars has slowly been automated as automation produced guitars with consistent quality. As of 2023, no more wooden guitars were hand-made by Santana Company. Brenda Wellington, the assistant manager, is in the process of working out a cost formula for overhead expenses. She assumes that in some way, overhead expense is related to sales, either in units or in dollars. She has collected data for sales and overhead expenses for January 2022 through December 2023. During her collection of the data for the last two years, she has established that the overhead expenses in February 2022 was exceptionally low as there was an electrical fire that year that caused wide-spread damage. REQUIRED: (Data for Question One is on the next page) This question must be completed using EXCEL. A. Assist Brenda in developing the regressions for supplies expenses under normal circumstances, for sales (both in units and in dollars). Hint: Do not attempt a multiple regression. February-22 14,460 52 $11,260 March-22 24,872 196 $18,940 April-22 24,684 202 $21,340 May-22 32,384 273 $32,100 June-22 28,945 245 $28,500 July-22 26,758 226 $22,650 August-22 32,394 290 $34,350 September-22 24,254 152 $20,365 October-22 25,763 239 $25,320 November-22 32,445 251 $30,040 December-22 45,476 342 $43,090 January-23 22,103 148 $18,950 February-23 30,105 237 $27,030 March-23 36,874 305 $40,010 April-23 27,784 221 $29,450 May-23 23,345 172 $24,150 June-23 29,312 234 $26,940 July-23 28,193 208 $21,880 August-23 28,473 214 $21,540 September-23 25,653 193 $24,675 October-23 23,849 178 $26,910 (4 marks) November-23 24,976 200 $21,890 B. Explain what you did in part A (ie why did you do it the way you did it). December-23 43,364 326 $34,330 (2 marks) C. Evaluate both regressions and determine which regression would be more appropriate. (4 marks) End of Question One. (Total: 10 marks) Question One continued on next page Question Two on next page. ACCT2002 Cost Analysis for Decision Making Semester 1 and Trimester 1A, 2024 Portfolio Questions QUESTION ONE (cont'd) Date Overhead Expense Sales (Units) Sales (Dollars) January-22 23,105 172 $19,990 QUESTION ONE Santana Company is a small manufacturer and retailer of guitars. The company produces wooden guitars that are made in-house and sold exclusively in-store. These guitars were originally hand-made, but over the years, production of guitars has slowly been automated as automation produced guitars with consistent quality. As of 2023, no more wooden guitars were hand-made by Santana Company. Brenda Wellington, the assistant manager, is in the process of working out a cost formula for overhead expenses. She assumes that in some way, overhead expense is related to sales, either in units or in dollars. She has collected data for sales and overhead expenses for January 2022 through December 2023. During her collection of the data for the last two years, she has established that the overhead expenses in February 2022 was exceptionally low as there was an electrical fire that year that caused wide-spread damage. REQUIRED: (Data for Question One is on the next page) This question must be completed using EXCEL. A. Assist Brenda in developing the regressions for supplies expenses under normal circumstances, for sales (both in units and in dollars). Hint: Do not attempt a multiple regression. February-22 14,460 52 $11,260 March-22 24,872 196 $18,940 April-22 24,684 202 $21,340 May-22 32,384 273 $32,100 June-22 28,945 245 $28,500 July-22 26,758 226 $22,650 August-22 32,394 290 $34,350 September-22 24,254 152 $20,365 October-22 25,763 239 $25,320 November-22 32,445 251 $30,040 December-22 45,476 342 $43,090 January-23 22,103 148 $18,950 February-23 30,105 237 $27,030 March-23 36,874 305 $40,010 April-23 27,784 221 $29,450 May-23 23,345 172 $24,150 June-23 29,312 234 $26,940 July-23 28,193 208 $21,880 August-23 28,473 214 $21,540 September-23 25,653 193 $24,675 October-23 23,849 178 $26,910 (4 marks) November-23 24,976 200 $21,890 B. Explain what you did in part A (ie why did you do it the way you did it). December-23 43,364 326 $34,330 (2 marks) C. Evaluate both regressions and determine which regression would be more appropriate. (4 marks) End of Question One. (Total: 10 marks) Question One continued on next page Question Two on next page.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Ten annual returns are listed in the following table: - 19.2% 16.5% 17.6% - 49.5% 43.6% 1.6% - 16.4% 46.4% 45.3% - 3.2% ) Click on the following icon to copy the data into a spreadsheet.( a. What is...
-
Santana Company is a small manufacturer and retailer of guitars. The company produces wooden guitars that are made in - house and sold exclusively in - store. These guitars were originally hand -...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
A travel softball team is trying to raise funds to go to the Colorado Sparkler, a major summer national tournament. The team is going to sell 3000 raffle tickets for $9 each. The prizes and their...
-
If x1 and x2 are the values of a random sample of size 2 from a population having a uniform density with α = 0 and β = θ, find k so that Is a (1...
-
Peter's Restaurant lists separate prices for all the items on its dinner menu. Chez Pierre offers only a fixed-price complete dinner (with patrons choosing from a list of appetizers, entrees, and...
-
Buckley Oil Company, a successful efforts company, began operations January 1, 20XA. Assuming the following facts about Buckleys first two years of operations, prepare the required disclosures under...
-
Think of a new team or group in which you participated during the past two years. Describe and explain the degree to which the development of this team or group matched the five-stage model of team...
-
7. (1 point) State the range of this function. 16- 12 2 {x R,x = _l, 5 b. x = R} xe c. ye Rys 18} d. ye R
-
Required: a. Calculate ROI for 2023. Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. b. Calculate ROE for 2023. Note: Round your answer to 1 decimal place....
-
2. AA, AAA, C and D cells all deliver the same voltage( 1.5V)when the batteries are fully charged. However,as the size of thebattery increases, the amount of current that can be deliveredbythe...
-
Martin & Sons (M&S) currently is an all equity firm with 40,000 shares of stock outstanding at a market price of $25 a share. The company's earnings before interest and taxes (EBIT) are $80,000. M&S...
-
An observation 'r' is characterised under binary hypotheses according to the following condi- tional probability density functions Ho: fr(r|Ho)= e #, r >= 0 TAO H: fr(r|H1)= r >= 0 r <0 (1) (2)...
-
Martinez Company, a machinery dealer, leased manufacturing equipment to Mays Corporation on January 1, 2017. The lease is for a 7-year period and requires equal annual payments of $20,786 at the...
-
Consider a sound wave moving through the air modeled with the equation s(x, t) = 7.00 nm cos(56.00 m-x - 12.00 10 s1t). What is the shortest time (in s) required for an air molecule to move between...
-
Read the following short summary about Spencer Johnson's book, Who Moved My Cheese? Then share your thoughts on the questions posed below. Arthur. (n.d.). Who moved my cheese summary - Dr. Spencer...
-
The purpose of this case is to come up with a contingency plan[s] in order to sustain the program Move With Me, a program that serves thousands of community members throughout Lower Manhattan. The...
-
Show how the share price of a very profitable company which invests at a rate of return that is higher than the required rate of return can still drop.
-
What is a conglomerate discount? How can it be avoided?
-
A company that is close to insolvency carries out a capital increase. Is this a signal? Why? What criteria can you identify as being necessary for a decision to be described as a signal?
Study smarter with the SolutionInn App