EIR MU Worksheet Practice (Monday) R

EIR MU Practice Assignment Fill in greyed out areas Using formula and cell reference calculate answer in greyed out areas Maintain proper formating Unit Cost Unit Retail MU % $8.75 41.3% $9.49 45.0% $14.50 46.5% $8.99 51.6% $6.00 $13.50 $24.99 43.7% $13.00 46.5% $0.99 42.0% $18.66 $37.99 $22.50 39.9% $39.73 $80.99 $95.00 49.5% $5.00 $11.50 $12.60 $26.99 $40.23 49.9% Calculating MARKUP % When Individual Cost and Retail Are Known 16. A dress cost $18 and retails for $34.00. What is the retail markup percent? Calculating COST When Retail and MU% Are Known 17. The MU % is 37.5% and the retail price is $29.99 What is the cost of the item? 18.Determine the cost of a pajama set that retails for $35.00 and carries a markup of 55.0% Calculating RETAIL When Cost and MU% Are Known 19. If the MU is 46.7% and the cost of the item is $12.00, what is the retail price? 20. If a buyer purchases a leather coat for $210 and the planned MU% is 52.7% What will the retail be? The store uses even cent pricing, round up End of Document 1.     Mark-up Calculations 2.     • (Retail-Cost)/Retail = Markup% 3.       • Cost/(100% -MU% ) = Retail 4.     • Retail X (100%-MU%) = Cost 5.     6.       7.     8.     9.     10.  11.  12.    13.  14.  15.  Currency: 2 decimal spaces MU %: 1 decimal spaces

EIR MU Practice Assignment ANSWERS Fill in greyed out areas Table 1 Unit Cost Unit Retail MU % $8.75 $ 14.91 41.3% $9.49 $ 17.25 45.0% $ 7.76 $14.50 46.5% $8.99 $ 18.57 51.6% $6.00 $13.50 55.6% $ 14.07 $24.99 43.7% $13.00 $ 24.30 46.5% $0.99 $ 1.71 42.0% $18.66 $37.99 50.9% $22.50 $ 37.44 39.9% $39.73 $80.99 50.9% $ 47.98 $95.00 49.5% $5.00 $11.50 56.5% $12.60 $26.99 53.3% $40.23 $ 80.30 49.9% Calculating MARKUP % When Individual Cost and Retail Are Known 47.1% (Retail-Cost)/Retail = MU% Calculating COST When Retail and MU% Are Known $18.74 What is the cost of the item? Retail*(100%-MU%)=Cost 18.Determine the cost of a pajama set that retails for $35.00 and carries a markup of 55.0% $15.75 Retail*(100%-MU%)=Cost Calculating RETAIL When Cost and MU% Are Known $22.51 Cost / (100%-MU%)=Retail 20. If a buyer purchases a leather coat for $210 and the planned MU% is 52.7% $443.97 What will the retail be? The store uses even cent pricing, round up $444.00 Cost / (100%-MU%)=RETAIL End of Document 1.       2.       3.       4.       5.       6.       7.       8.       9.       10.    11.    12.    13.    14.    15.    16. A dress cost $18 and retails for $34.00. What is the retail markup percent? 17. The MU % is 37.5% and the retail price is $29.99 19. If the MU is 46.7% and the cost of the item is $12.00, what is the retail price? Currency: 2 decimal spaces MU %: 1 decimal spaces

EIR MU Practice Assignment ANSWERS Fill in greyed out areas Unit Cost Unit Retail IMU% Units Cost Total Retail Total CMU% 1 $6.00 $14.00 57.1% 100 $600.0 $1,400.0 57.1% 2 $5.50 $14.00 60.7% 120 $660.0 $1,680.0 60.7% 3 $7.00 $14.00 50.0% 100 $700.0 $1,400.0 50.0% 4 $4.85 $14.00 65.4% 400 $1,940.0 $5,600.0 65.4% 5 $3,900.0 $10,080.0 61.3% Description Style # Unit CostUnit Retail IMU % Sale Price MMU% 6 Sweater 2400 $8.75 $29.99 70.8% $19.99 56.2% Unit Cost Unit Retail IMU % Sale price Sale price MMU% 7 $10.00 $20.00 50.0% $14.99 33.3% 8 $10.00 $24.00 58.3% 40% 0ff $14.40 30.6% 9 $10.00 $30.00 66.7% 50% Off $15.00 33.3% 10 Which pricing scenario made the most money? $14.99 and 50% make the same profit with only a penny difference 11 Which pricing scenario reflects a high/low pricing strategy? 50.0% Description Style # QTY cost retail IMU ttl cost ttl retail CMU MMU 12 Orange Print 600 144 $12.00 $29.99 60.0% $1,728.0 $4,318.6 60.0% $19.99 $2,878.6 40.0% 13 Blue Print 604 96 $14.00 $29.99 53.3% $1,344.0 $2,879.0 53.3% $19.99 $1,919.0 30.0% 14 $3,072.0 $7,197.6 57.3% $4,797.6 36.0% 15 Which Style had the highest IMU% 600 16 Which Style had the highest MMU% 600 17 What is the CMU % on the buy? 57.3% 18 What is the MMU on the buy? 36.0% End of Document Sale retail ttl sale retail Currency: 2 decimal spaces Cost or retail of more than one unit use 1 decimal MU %: 1 decimal spaces On Quizzes to receive credit you must enter the Fill in the Blank correctly. MU %: 1 decimal spaces