Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part I. The Income Statement 1. The 'Crocs IS Details' tab provides Croc's annual revenue, COGS, SGA and volume of shoes sold for the last
Part I. The Income Statement 1. The 'Crocs IS Details' tab provides Croc's annual revenue, COGS, SGA and volume of shoes sold for the last eight years. Ms denotes that a value is in millions and Ks denotes that a value is in thousands. Crocs reports, "On February 17, 2022, (the "Acquisition Date"), we acquired 100\% of the equity of HEYDUDE, pursuant to the SPA. HEYDUDE is engaged in the business of distributing and selling casual footwear under the brand name "HEYDUDE." The Acquisition allows us to diversify and expand our business by adding a second brand to the Crocs, Inc. portfolio." a. Run a regression that predicts Croc's COGS as a function of the volume of both Crocs sold AND the volume of HeyDude products sold. The volume of HeyDude products sold is zero in all years prior to 2022 . If you do not remember how to include two variables in a regression see here. You are creating a linear equation with two x-values. Keep the excel created output in your Excel file; label the tab. Y=m1x1+m2x2+b b. Run a similar regression that predicts Croc's SG\&A as a function of the volume of both Crocs sold and HeyDude products sold. Keep the excel created output in your Excel file; label the tab. +1 COGS Regression in Excel File +2 COGS regression is correct +1 SGA Regression in Excel File +2 SGA regression is correct 2. Use the results of your regression to create a cost-volume-profit formula for Croc's as a function of both Crocs sold and HeyDude products sold. Link the required values back to your source reports in the labeled box on the 'Crocs. IS Details' tab, also type in your final answers in the box below. Profit =( Price - VC/Unit) Crocs Sold +( Price - VC/Unit ) HeyDude Sold - Fixed Costs i. If any p-value is greater than 0.10 , we are not confident in our point estimate and will assume that value is zero
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started