How does "Moms Burgers" compare to the other food industries shown in the excel file below? what conclusions can be made and what would you suggest Amy do going forward?

Amy likes to tell stories about her summers when she was a kid at the lake. Her stories would be about playing all day with friends and the dog, diving into the water, going fishing or swimming... but her stories always came back to those late afternoon burgers! Big fat burgers, made on the grill... with all the fixings! Amy's mom knew how to cook... And those summer days were her inspiration for "Mom's Burgers" It seemed that Amy started "Mom's Burgers" at the right time, just as the gourmet Burger craze was getting started. Amy now has 10 stores and is considering really pushing rapid growth. Amy knows her numbers but needs your help to understand how Mom's Burgers is doing against the competition. She has asked you to pull all public financial information for the fast food industry and tell her how Mom's Burgers compares. She has given you the following ratios for "Mom's Burgers" for 2017 Assignment 3 Dropbox Instructions 1. Review all the materials associated with completing this assignment (Before you complete this assignment, you will need to review all of the Financial Statement Review materials). HINT: net margin is the same as the net profit ratio. 1. SINCE MOM'S BURGERS RATIOS ARE FROM 2017, COMPARE ONLY TO THE FAST FOOD COMPANIES THAT HAVE PROVIDED 2017 DATA WITHIN THE PROVIDED EXCEL SPREADSHEET WITHIN THIS ASSIGNMENT AND THAT IS THE DATA YOU WILL USE FOR YOUR RATIO COMPARISON 2. Make sure you have read the Mom's Burgers case 3. Review the case and the question posed (Amy knows her numbers but needs your help to understand how Mom's Burgers is doing against the competition). 4. Conduct a case analysis (comparing her ratios to the industry, draw conclusions, and present your findings)MAKE SURE I CAN SEE/ACCESS ALL OF THE FORMULAS YOU HAVE USED WITHIN YOUR SPREADSHEET SUBMISSION. 1. Pull the public financial information for the fast food industry from the Fast Food-Student Excel spreadsheet within this assignment folder to complete ratios for comparisons 5. Create a mini presentation (can be a Power Point) that provides insight to Amy how she is doing against the competition 1. This is your creation and can be presented in any format as long as you have shown your analysis with findings (ratios from the fast food industry that were used to compare to Mom's Burgers). You can compare the ratios within an Excel spreadsheet by creating your own table (using shades of color to differentiate data), use simple line or column graphs for each company comparison or create a custom combo chart to compare two series of data. 2. Use the Excel skills you have learned thus far to ensure a quality mini presentation 3. The response for this assignment can vary and will depend on your evaluation of the case and data; it is your own data exploration, analysis, and conclusion findings to respond to Amy's inquiry 4. Make sure your case is backed up with your data findings within your mini presentation 6. Upload your completed presentation file with all resources cited in APA format Submissions No submissions yet. Drag and drop to upload your assignment below. Amy likes to tell stories about her summers when she was a kid at the lake. Her stories would be about playing all day with friends and the dog, diving into the water, going fishing or swimming... but her stories always came back to those late afternoon burgers! Big fat burgers, made on the grill... with all the fixings! Amy's mom knew how to cook... And those summer days were her inspiration for "Mom's Burgers" It seemed that Amy started "Mom's Burgers" at the right time, just as the gourmet Burger craze was getting started. Amy now has 10 stores and is considering really pushing rapid growth. Amy knows her numbers but needs your help to understand how Mom's Burgers is doing against the competition. She has asked you to pull all public financial information for the fast food industry and tell her how Mom's Burgers compares. She has given you the following ratios for "Mom's Burgers" for 2017 Assignment 3 Dropbox Instructions 1. Review all the materials associated with completing this assignment (Before you complete this assignment, you will need to review all of the Financial Statement Review materials). HINT: net margin is the same as the net profit ratio. 1. SINCE MOM'S BURGERS RATIOS ARE FROM 2017, COMPARE ONLY TO THE FAST FOOD COMPANIES THAT HAVE PROVIDED 2017 DATA WITHIN THE PROVIDED EXCEL SPREADSHEET WITHIN THIS ASSIGNMENT AND THAT IS THE DATA YOU WILL USE FOR YOUR RATIO COMPARISON 2. Make sure you have read the Mom's Burgers case 3. Review the case and the question posed (Amy knows her numbers but needs your help to understand how Mom's Burgers is doing against the competition). 4. Conduct a case analysis (comparing her ratios to the industry, draw conclusions, and present your findings)MAKE SURE I CAN SEE/ACCESS ALL OF THE FORMULAS YOU HAVE USED WITHIN YOUR SPREADSHEET SUBMISSION. 1. Pull the public financial information for the fast food industry from the Fast Food-Student Excel spreadsheet within this assignment folder to complete ratios for comparisons 5. Create a mini presentation (can be a Power Point) that provides insight to Amy how she is doing against the competition 1. This is your creation and can be presented in any format as long as you have shown your analysis with findings (ratios from the fast food industry that were used to compare to Mom's Burgers). You can compare the ratios within an Excel spreadsheet by creating your own table (using shades of color to differentiate data), use simple line or column graphs for each company comparison or create a custom combo chart to compare two series of data. 2. Use the Excel skills you have learned thus far to ensure a quality mini presentation 3. The response for this assignment can vary and will depend on your evaluation of the case and data; it is your own data exploration, analysis, and conclusion findings to respond to Amy's inquiry 4. Make sure your case is backed up with your data findings within your mini presentation 6. Upload your completed presentation file with all resources cited in APA format Submissions No submissions yet. Drag and drop to upload your assignment below