Month OTB Plan H D E Student Assignment Spreadsheet: Use your knowledge of the Open-to-Buy Formula to complete the yellow highlighted sections of the spreadsheet 1 2 6 Month OTB Plan June July August September October November 3 Beginning of the Mouth Inventory $135.000 $150,000 $157,000 $157.000 4 Sales $47.000 $48.000 $50,000 $50,000 $52,000 S48,000 5 Markdowns $1.000 5750 $1,000 $1,500 $1,000 6 Open-to-buy (at retail) $43.000 $50,750 $35,750 $61.500 $37,000 7 Open-to-buy (at cost) if the initial markup is 40% 8 End of Month Inventory $150,000 $132.000 $157,000 S157.000 $153,000 9 10 The Open To Buy Formula Planned Sales 12 + Planned Markdowns 13 + Planned End of Month Inventory 14 Planned Beginning of Month lnventory 15 Open-to-Buy (at retail) 16 Questions: Read each question below and write your answer in the cell provided 17 18 What is the meaning of Open-to-Buy at retail? Answer: 19 Creating an Open-to-Buy plan can help you carefully manage merchandise across the business for the year. By using an opes-to-buy plan, your able to find areas your retail organization where you can save money to invest in other areas of the business. Using the Opee-to-Buy Formula, cakulate the dollar amount a 15% - savings would allow you to invest in another area of the business if you currently have $155.000 devoted to inventory Sheet1 Month OTB Plan H D E Student Assignment Spreadsheet: Use your knowledge of the Open-to-Buy Formula to complete the yellow highlighted sections of the spreadsheet 1 2 6 Month OTB Plan June July August September October November 3 Beginning of the Mouth Inventory $135.000 $150,000 $157,000 $157.000 4 Sales $47.000 $48.000 $50,000 $50,000 $52,000 S48,000 5 Markdowns $1.000 5750 $1,000 $1,500 $1,000 6 Open-to-buy (at retail) $43.000 $50,750 $35,750 $61.500 $37,000 7 Open-to-buy (at cost) if the initial markup is 40% 8 End of Month Inventory $150,000 $132.000 $157,000 S157.000 $153,000 9 10 The Open To Buy Formula Planned Sales 12 + Planned Markdowns 13 + Planned End of Month Inventory 14 Planned Beginning of Month lnventory 15 Open-to-Buy (at retail) 16 Questions: Read each question below and write your answer in the cell provided 17 18 What is the meaning of Open-to-Buy at retail? Answer: 19 Creating an Open-to-Buy plan can help you carefully manage merchandise across the business for the year. By using an opes-to-buy plan, your able to find areas your retail organization where you can save money to invest in other areas of the business. Using the Opee-to-Buy Formula, cakulate the dollar amount a 15% - savings would allow you to invest in another area of the business if you currently have $155.000 devoted to inventory Sheet1