Using the provided Excel template, calculate if the shoe department has open-to-buy dollars for each month. You will build the formulas to determine monthly department open-to-buy dollars.

A B C D E F G H I J K L M N Special Notes 1 Open to Buy Report 2 Student Practice Template 3 Department Name 4 5 Department Number 6 7 Departmental MU% 8 55% OTB problem: Calculate open to buy for February, March, and April for the de Use the following information: Planned Feb BOM $150,000 Planned Feb Sales $135,000 Planned Feb Markdowns $12,000 On Order Feb $170,000 Planned Feb EOM $210,000 Planned March Sales $97,000 Planned March Markdowns $4,200 On Order March $4,000 Planned March EOM $162,000 Planned April Sales $ 75,000 Planned April Markdowns $ 15,000 On Order April $ 66,000 Planned April EOM $ 155,000 9 Month Month Month 10 11 Planned Sales 12 + Planned Markdowns 13 + Planned EOM Stock 14 - Planned BOM Stock 15 = Planned Purchases 16 - On Order 17 18 = Open to Buy at Retail 19 20 Open to Buy at Cost 21 Using Open to Buy results, calculate Open to Buy at cost A B C D E F G H I J K L M N Special Notes 1 Open to Buy Report 2 Student Practice Template 3 Department Name 4 5 Department Number 6 7 Departmental MU% 8 55% OTB problem: Calculate open to buy for February, March, and April for the de Use the following information: Planned Feb BOM $150,000 Planned Feb Sales $135,000 Planned Feb Markdowns $12,000 On Order Feb $170,000 Planned Feb EOM $210,000 Planned March Sales $97,000 Planned March Markdowns $4,200 On Order March $4,000 Planned March EOM $162,000 Planned April Sales $ 75,000 Planned April Markdowns $ 15,000 On Order April $ 66,000 Planned April EOM $ 155,000 9 Month Month Month 10 11 Planned Sales 12 + Planned Markdowns 13 + Planned EOM Stock 14 - Planned BOM Stock 15 = Planned Purchases 16 - On Order 17 18 = Open to Buy at Retail 19 20 Open to Buy at Cost 21 Using Open to Buy results, calculate Open to Buy at cost