Module Problem Assignment 20: Six-Month Plan (34 points maximum) Student Name: Kelsie Carn Based on the information on Pages 2-4, complete the 6-month plan in the chart below (and show your work for the selected cells listed on Pages 2-4). You may either type your answer directly in this Word document and submit it as a Word file, or print this document and hand-write your work and then scan the assignment into a single PDF file. Show 2 decimal places for all $ and % figures. Fall (Aug - Jan) Aug Sep Oct Nov Dec Jan TOTAL Sales 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% 2) 30.00% 15.00% 5.00% 100.00% (%) TY Plan ($) 3) 4) 5) $44,550.00 4) 3 ) 1) TY Plan (%) 5.00% 15.00% 2) 30.00% 15.00% 5.00% 100.00% Reducti LY Actual ($) $0.00 $1,350.00 $2,025.00 $2,025.00 $3,375.00 $4,725.00 $13,500.00 on LY Actual (% of seasonal 0.00% 10.00% 15.00% 15.00% 25.00% 35.00% 100.00% reductions) TY Plan ($) $0.00 7) $1,782.00 $1,782.00 8) 9 ) 6) TY Plan (% of seasonal 0.00% 10.00% 15.00% 15.00% 25.00% 35.00% 100.00% reductions) TY Plan - (% 0.00% 5.33% 11) 11) 12) 56.00% 10) of Sales) SSR LY & TY 3.00 2.50 1.80 1.60 2.00 2.70 BOM TY Plan ($) 13) $55,687.50 $80,190.00 $71,280.00 14) $20,047.50 EOM TY Plan ($) 15) 16) 17) 18) 19) 20) Purcha ses TY Plan ($) 21) $47,965.50 $37,422.00 23) 25) $0.00 27) @Retail Purcha ses TY Plan ($) 22) $21,584.48 $16,839.90 24) (26) $0.00 28) @Cost MMU TY Plan (%) 55.00% 52.60% 29) 29) 31) 29.80% 33)