Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedUsing 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

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

An Introduction To Derivatives And Risk Management

Authors: Don M. Chance, Roberts Brooks

7th Edition

0324321392, 9780324321395

More Books

Students also viewed these Finance questions