PLEASE CREATE EXCEL SHEET OR DATA TABLE FOR ANSWER

PLEASE CREATE EXCEL SHEET OR DATA TABLE FOR ANSWER

private label calculations Cost Structure Comparison Big Three Average Private Label Raw materials 0.42 $ Packaging $ 0.19 $ manufacuting $ 0.52 $ Distribution $ 0.14 $ Advertising and sales $ Depreciation, overhead $ EBIT Wholesale price $ Retailer margin $ Retail Price 0.75 $ 0.40 $ 0.40 $ 2.82 $ 0.38 $ 3.20 $ 2. Explain how the private label cereal manufacturers have been able to lower their cost structure relative to the branded cereal manufacturers. Will the private label cereal makers be able to withstand a price war with the branded cereal manufacturers? Note: This is a Quantitative Assignment (QA) that requires numerical analysis of data from the case. You may attach a separate Excel file or include a table showing the cost differences in your submission. The written portion of QA assignments must be no longer than two double-spaced pages