What would be the completed Excel sheets for Pages 136 and 137?

EOM for January $350,000

EOM for July $320,000

G 2 E + c chegg.com/reader/9780133028461/140/ : Search keywords a ... FIGURE 7.1 Florida Palm Beach Gardens. The Gardens Mall Nordstrom department store business retail fashion upscale shopping display juniors Source: Jeff Greenberg/Alamy In the following exercise, you will complete an entire fall and spring season merchandise plan for the junior department. As you will see from the format, the entire year is broken down into two merchandise plans. The connecting piece between the two plans is the EOM stock value for January, which becomes the BOM stock value for February. Use the information on page 131 to complete and calculate the merchandise plans. After you are finished, use the bullet points below to assess the strengths and weaknesses of this buyer's merchandise plan. Back to School sales are important to this department and the bulk of these sales should occur in the month of August Holiday includes Nov with the bulk of purchases received these two months. Holiday inventory levels build incrementally each month, starting with the month of September. January is reserved as a markdown month to clear through merchandise that did not sell during the holidays. Some receipts may be received in this month to transition into the spring season. February is the start of the spring season. Most of holiday and winter merchandise should be sold through prior to this month. June is an important swimwear month for this department. July should end at relatively low stock levels, to make room for Back to School received at the beginning of August 130 chapter 7 130 of 282 wrap.png Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG? | GO Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/141/ : 16 Search keywords a a ... Use these notes to analyze monthly sales percent, markdown rate, purchases, stock-to-sales ratio, average stock, and turnover for each season. You will be required to answer questions regarding these topics after completing the merchandise plan. Sales AUG SEPT OCT NOV DEC JAN Fall information BOM Stock Markdowns 150,000 8,000 130,000 6,000 175,000 7,500 190,000 8,800 220,000 23,000 175,000 35,000 58,000 55,000 60,000 70,000 120,000 90,000 > Spring information BOM Stock Markdowns FEB 140,000 10,000 MARCH 110,000 3,000 APRIL 115,000 2.800 MAY 118,000 4,100 JUNE 125,000 6,000 JULY 118,000 14,000 JULY EOM Stock = 125,000 Sales 33,000 28.000 30,000 36,000 46,000 43,000 Complete the merchandise plan and answer the questions on the following pages, using the history you've calculated. 131 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG G C Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/142/ : 16 Search keywords a a ... Merchandise Plan for Junior Department OCT NOV AUG SEPT DEC JAN FALL SEASON BOM Stock + Purchases = Total Stock Markdowns Sales Total Deductions EOM Stock % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover FEB MARCH APRIL MAY JUNE JULY SPRING SEASON > BOM Stock + Purchases = Total Stock Markdowns Sales Total Deductions EOM Stock % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover 132 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG? | GO Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/146/ : 16 Search keywords a a ... Six-Month Merchandise Plan for Fragrance (Spring) FEB MAR APR MAY JUN JULY SPRING SEASON BOM Stock 119,000 125,300 119.720 83,480 63,440 120,125 631,065 Basic Purchases Fashion Purchases Total Purchases 48,500 70,100 66,480 150,220 115,160 39,975 490,435 Total Stock RTV'S Markdowns Sales Total Deductions EOM Stock > % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover 136 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG? | GO Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/147/ : 16 Search keywords a a ... Six-Month Merchandise Plan for Fragrance (Fall) SEPT OCT NOV DEC AUG JAN FALL SEASON BOM Stock Basic Purchases 98,100 83,000 72,500 78,000 141,200 541,200 68,400 296,700 Fashion Purchases 98,800 145,000 235,000 236,300 215,400 1,227,200 Total Purchases Total Stock RTV's Markdowns Sales Total Deductions > EOM Stock % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover 137 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X G 2 E + c chegg.com/reader/9780133028461/140/ : Search keywords a ... FIGURE 7.1 Florida Palm Beach Gardens. The Gardens Mall Nordstrom department store business retail fashion upscale shopping display juniors Source: Jeff Greenberg/Alamy In the following exercise, you will complete an entire fall and spring season merchandise plan for the junior department. As you will see from the format, the entire year is broken down into two merchandise plans. The connecting piece between the two plans is the EOM stock value for January, which becomes the BOM stock value for February. Use the information on page 131 to complete and calculate the merchandise plans. After you are finished, use the bullet points below to assess the strengths and weaknesses of this buyer's merchandise plan. Back to School sales are important to this department and the bulk of these sales should occur in the month of August Holiday includes Nov with the bulk of purchases received these two months. Holiday inventory levels build incrementally each month, starting with the month of September. January is reserved as a markdown month to clear through merchandise that did not sell during the holidays. Some receipts may be received in this month to transition into the spring season. February is the start of the spring season. Most of holiday and winter merchandise should be sold through prior to this month. June is an important swimwear month for this department. July should end at relatively low stock levels, to make room for Back to School received at the beginning of August 130 chapter 7 130 of 282 wrap.png Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG? | GO Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/141/ : 16 Search keywords a a ... Use these notes to analyze monthly sales percent, markdown rate, purchases, stock-to-sales ratio, average stock, and turnover for each season. You will be required to answer questions regarding these topics after completing the merchandise plan. Sales AUG SEPT OCT NOV DEC JAN Fall information BOM Stock Markdowns 150,000 8,000 130,000 6,000 175,000 7,500 190,000 8,800 220,000 23,000 175,000 35,000 58,000 55,000 60,000 70,000 120,000 90,000 > Spring information BOM Stock Markdowns FEB 140,000 10,000 MARCH 110,000 3,000 APRIL 115,000 2.800 MAY 118,000 4,100 JUNE 125,000 6,000 JULY 118,000 14,000 JULY EOM Stock = 125,000 Sales 33,000 28.000 30,000 36,000 46,000 43,000 Complete the merchandise plan and answer the questions on the following pages, using the history you've calculated. 131 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG G C Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/142/ : 16 Search keywords a a ... Merchandise Plan for Junior Department OCT NOV AUG SEPT DEC JAN FALL SEASON BOM Stock + Purchases = Total Stock Markdowns Sales Total Deductions EOM Stock % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover FEB MARCH APRIL MAY JUNE JULY SPRING SEASON > BOM Stock + Purchases = Total Stock Markdowns Sales Total Deductions EOM Stock % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover 132 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG? | GO Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/146/ : 16 Search keywords a a ... Six-Month Merchandise Plan for Fragrance (Spring) FEB MAR APR MAY JUN JULY SPRING SEASON BOM Stock 119,000 125,300 119.720 83,480 63,440 120,125 631,065 Basic Purchases Fashion Purchases Total Purchases 48,500 70,100 66,480 150,220 115,160 39,975 490,435 Total Stock RTV'S Markdowns Sales Total Deductions EOM Stock > % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover 136 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X sf GGG? | GO Bb Bb Ne STUS y! Bb GOGNE Bb GE + C chegg.com/reader/9780133028461/147/ : 16 Search keywords a a ... Six-Month Merchandise Plan for Fragrance (Fall) SEPT OCT NOV DEC AUG JAN FALL SEASON BOM Stock Basic Purchases 98,100 83,000 72,500 78,000 141,200 541,200 68,400 296,700 Fashion Purchases 98,800 145,000 235,000 236,300 215,400 1,227,200 Total Purchases Total Stock RTV's Markdowns Sales Total Deductions > EOM Stock % Sales by Month Markdown Rate Stock-to-Sales Average Stock Turnover 137 of 282 wrap.png ST Chapter 9 Transl....ppt Chapter 11 A Pro....ppt VisualCV.htm P Chapter 1 PP Tr....pptx Show All X