Excel Sales homework

profilePastel12
Assingment11answerkey.pdf

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