Explain how the private label cereal manufacturers havebeen able to lower their cost structure relative to the brandedcereal manufacturers by CREATING A EXCEL SHEET OR DATATABLE.

Note: This is a Quantitative Assignment (QA) thatrequires numerical analysis of data fromthe case. You may attach a separate Excel file or include a tableshowing the cost differences in your submission.

Compare and contrast the cost structures between thebranded cereal manufacturers and the private label cerealmakers. You can compare the industry valuechains of both types of cereal makers by using the coststructure information provided in Exhibit 2 and in the case text.[Assume that marketing costs are zero for the private label cerealmakers. Some cost information for the private label cereal makersmay not be directly available. So you need to estimate certaincosts based on the information provided by the case.] Pay specialattention to determining how the industry value chains aredifferent for each type of breakfast cereal manufacturers. I amincluding a template below for your reference.

Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e Cost Structure Comparison Raw materials Packaging manufacuting Distribution Big Three Average Private Label $ $ sises $ $ Advertising and sales Depreciation, overhead $ EBIT Wholesale price Retailer margin Retail Price SSS $ is is i $ 0.42 $ 0.19 $ 0.52 $ 0.14 $ 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ private label calculations 2 N ..e