question: "using the open-to-buy formula, calculate the dollar amount a 15% cost-savings would allow you to invest in another area of the business if you currently have $155,000 devoted to inventory"

D G 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 Month laventory $155,000 $150,000 $152,000 $157,000 S157,000 $165,000 4 Sales S47,000 S48,000 $50,000 $50,000 SS2,000 $48.000 5 Markdowns $1,000 5750 $750 $1,000 $1,500 $1,000 6 Open-to-buy (at retail) S43,000 $50,750 S55.750 $$1,000 $61,500 $37.000 7 Open-to-buy at cost) $17,200 $20,300 $22,300 $20,400 $24,600 $14,800 if the initial markup is 40% 8 End of Month Inventory S150,000 S152,000 $157,000 $157,000 S165,000 $153,000 9 10 The Open-To-Buy Formula 11 Planned Sales 12 + Planned Markdowns 13 + Planned End of Month Inventory 14 - Planned Beginning of Month Inventory 15 Open-to-Buy (at retail) 16 Questions: Read each question below and write your answer in the cell provided. 17