You don't need to mirror the book. I just need total cost of sales and cost of sales for each item. I also need the Excel formula in the answer.

Section II: Cost of Sales (Spreadsheet Only) Create an Excel spreadsheet for the cost of sales. The spreadsheet should clearly show the total cost of sales for all items as well as the cost of sales for each item. This spreadsheet should also include all necessary elements explaining how the total cost of sales is calculated. The Sales Mix/Cost Mix spreadsheet created for this section should mirror Form B from the textbook (page 99). Build the spreadsheet based on the data. Items, percentage of sales, and product cost are summarized below. Product Line % of Sales Product Cost % Hot Dogs 19% 22% Pizza 5% 30% Soft Drinks 24% 12% Draft Beer 28% 17% Hot Drinks 2% 18% Nacho Chips 7% 28% Popcorn 4% 16% Peanuts 4% 20% Ice cream 2% 21% Others 5% 23%