Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. In the fall season, which month had the highest markdown rate, and what was it? 2. In the spring season, which month had the

1. In the fall season, which month had the highest markdown rate, and what was it? 2. In the spring season, which month had the highest markdown rate, and what was it? 3. In the fall season, which month had the lowest % Sales, and what was the percentage? 4. How could you increase turnover in the spring season? 5. Based on markdown rate, how could you improve the plan for next fall and spring seasons? 6. How did you determine the EOM stock for the month of January? 7. Based on purchases, how could you improve the flow of goods for both the fall and spring seasons? 8. What percentage of sales is the fall season worth, compared to the total year of sales? 9. What percentage of sales is the spring season worth, compared to the total year of sales? 10. Using the stock-to-sales ratio and peak selling periods, what months should have higher and lower stock-to-sales ratios?

EOM for January $350,000

EOM for July $320,000

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Completed Excel sheets needed for pages 136 and 137

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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Energy Audit And Management Concept Methodologies Procedures And Case Studies

Authors: L. Ashok Kumar, Gokul Ganesan

1st Edition

978-1032067797

More Books

Students also viewed these Accounting questions