Excel Sales homework
Pastel12
Name Assignment 11 Due
Actual (LY) Plan (TY)
Change(%)
over LY
$135,000.00 $148,500.00 10.00%
10.00% 8.00%
55.00%
$43,213.50
$22,500.00 $24,750.00
Aug Sep Oct Nov Dec Jan TOTAL
LY Actual ($) $6,750.00 $20,250.00 $40,500.00 $40,500.00 $20,250.00 $6,750.00 $135,000.00
LY Actual (%) 5.00% 15.00% 30% 30.00% 15.00% 5.00% 100.00%
TY Plan ($) $7,425.00 $22,275.00 $44,550.00 $44,550.00 $22,275.00 $7,425.00 $148,500.00
TY Plan (%) 5.00% 15.00% 30.00% 30.00% 15.00% 5.00% 100.00%
LY Actual (% of
seasonal reductions) 0.00% 10.00% 15.00% 15.00% 25.00% 35.00% 100.00%
TY Plan ($) $0.00 $1,188.00 $1,782.00 $1,782.00 $2,970.00 $4,158.00 $11,880.00
TY Plan (% of
seasonal reductions) 0.00% 10.00% 15.00% 15.00% 25.00% 35.00% 100.00%
TY Plan - (% of Sales) 0.00% 5.33% 4.00% 4.00% 13.33% 56.00% 8%
SSR LY & TY 3 2.5 1.8 1.6 2 2.7
BOM TY Plan ($) $22,275.00 $55,687.50 $80,190.00 $71,280.00 $44,550.00 $20,047.50
EOM TY Plan ($) $55,687.50 $80,190.00 $71,280.00 $44,550.00 $20,047.50 $8,464.50
Purchases
@Retail TY Plan ($) $40,837.50 $47,965.50 $37,422.00 $19,602.00 $742.50 0 $146,569.50
Purchases
@Cost TY Plan ($) $18,376.88 $21,584.48 $16,839.90 $8,820.90 $334.13 $0.00 $65,956.28
TY Plan (%) 55.00% 52.60% 53.20% 53.20% 49.00% 29.80% 51.40%
TY Plan ($) $4,083.75 $11,716.65 $23,700.60 $23,700.60 $10,914.75 $2,212.65 $76,329.00
Average Retail Stock
Total Retail ($)
Total Reduction (of Sales) %
Initial Markup %
Average Monthly Sales
Sales
Reduction
MMU