Show all formulas

2. On the spreadsheet found on that file, input formulas that will calculate the following: a. Total cost for each item b. Total retail for each item c. Total cost of all items purchased d. Total retail of all items purchased e. Markup percentages for each item f. Cumulative markup percentage for all items purchased 3. Make the calculations listed above for problems that follow, and record your answers of tables provided at the end of the assignment. Stock # 1234 1235 1236 1237 1238 Units Ordered 300 100 25 150 Unit Cost $1.23 $26.98 $99.00 $21.45 $82.45 Unit Retail $2.50 $55.99 $199.99 $39.99 $175.99 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 PURCHASE ORDERS Stock Number Units Purchased Unit Cost Unit Retail Total Cost Total Retail Markup % TOTALS