D6 1 Cumulative Markup Markup % Cost Retail 3 Beginning Inventory 4 Purchases 1 5 Purchases 2 0.00 $0.00! #DIV/O! TOTALS Use the spreadsheet to calculate the cumulative markup percent for the problems presented below Record your answers on the table provided. (Credit will not be given for any item without the correct formula entered in the spreadsheet. You must do this via Excel, not by hand.) (1 pt. for each cost total, retail total, and cumulative markup %) 10 Question 1: A buyer for dresses has an inventory at the beginning of the month of $40,000 at cost and $55,000 at retail. New purchases during the month amounted to $10,000 at cost and $22,500 at retail 11 What is the cumulative markup percentage? 12 13 |Question #1 14 Beginning Inventory 15 Purchases 16 Totals 17 Cost Retail Cumulative Markup %