PROTECTED VIEW Be carelul-files from the Internet can contain viruses. Unless you need to edit as safe to stay in Protected View Enabledding B D E F G H K M N o 6.2.b the business math spreadsheet using the data provided. 1. Calculate the new retail prices for each item, based on the new markup provided. 2. Calculate the new total retail prices for each item and for the category. 3. Calculate the new average markup percentage. 1. Calculate the projected season dollar sales for each item and in total. SALES TARGET: MARKUP TARGET: >/-$5.600 >/-56% Last Dept Class Description Cost Retail New Retail Last Season Total Cost Last Season New Total Total Retail Retail Season Mark Up New Markup Last Season Units Orginal On Hand Last Season Unit Sales Last Season Dollar Sales Projected Season Unit Sales 40 40 52 Automotive Accessories Mid-grade wiper blades - 2 pk Automotive Accessories Mid-grade wiper blades Automotive Accessories Economy wiper blade Automotive Accessories Economy wiper blades - 2 pk Automotive Accessories Premium wiper blades $ 7.50 $ 15.00 $ 5.25 S 12.00 $ 5.15 $ 10.00 $ 6.50 $ 10.00 $ 1115 $ 19.50 $1.500.00 $3,000.00 $1,197.00 $2,736.00 $1.380.20 $2.680.00 $2.008.50 $3,090,00 $1,906.65 $3,334 50 50.00% 56.25% 48 SON 35 OON 42 82% 57.50 60.2ON 55.00% 55. SON 53.5ON 200 228 26R 309 171 68 114 83 $ 600.00 $ 636.00 680.00 $ 1,140.00 $ 1,660.00 97 79 $7,992.35 46. 15N 1176 358 $ 4,716.00 336 3 -9 12 36 37 18 Sheet1 She Sheet PROTECTED VIEW Be carelul-files from the Internet can contain viruses. Unless you need to edit as safe to stay in Protected View Enabledding B D E F G H K M N o 6.2.b the business math spreadsheet using the data provided. 1. Calculate the new retail prices for each item, based on the new markup provided. 2. Calculate the new total retail prices for each item and for the category. 3. Calculate the new average markup percentage. 1. Calculate the projected season dollar sales for each item and in total. SALES TARGET: MARKUP TARGET: >/-$5.600 >/-56% Last Dept Class Description Cost Retail New Retail Last Season Total Cost Last Season New Total Total Retail Retail Season Mark Up New Markup Last Season Units Orginal On Hand Last Season Unit Sales Last Season Dollar Sales Projected Season Unit Sales 40 40 52 Automotive Accessories Mid-grade wiper blades - 2 pk Automotive Accessories Mid-grade wiper blades Automotive Accessories Economy wiper blade Automotive Accessories Economy wiper blades - 2 pk Automotive Accessories Premium wiper blades $ 7.50 $ 15.00 $ 5.25 S 12.00 $ 5.15 $ 10.00 $ 6.50 $ 10.00 $ 1115 $ 19.50 $1.500.00 $3,000.00 $1,197.00 $2,736.00 $1.380.20 $2.680.00 $2.008.50 $3,090,00 $1,906.65 $3,334 50 50.00% 56.25% 48 SON 35 OON 42 82% 57.50 60.2ON 55.00% 55. SON 53.5ON 200 228 26R 309 171 68 114 83 $ 600.00 $ 636.00 680.00 $ 1,140.00 $ 1,660.00 97 79 $7,992.35 46. 15N 1176 358 $ 4,716.00 336 3 -9 12 36 37 18 Sheet1 She Sheet
