zhi please solve all these 4 questions step-by- step and please write formula to. I provide you all formula, so don't forget to write formula.
Based on the following figures from the shoe department: The original planned purchases @ Retail for November. (1/2 Mark) Calculate the remaining open to buy balance given the following information: (1 Mark) On March 13, stock-on-hand is \$76,300@Retail, with planned sales for the balance of the month at $9,000 and remaining markdowns planned to be $2,800. Merchandise on order still to arrive is valued at $5,000@ Retail, and the planned April BOM stock is $70,000@ Retail. Find the balance of the OTB in Retail $ for The total planned purchases for the Mens Tops department for the season are \$526,000@Retail. The Mens Tops department is broken down into 4 sub-classes that the buyer will be purchasing: Calculate the desired purchases in retail dollars and units for each sub-class. (2 Marks) Key Terms \begin{tabular}{lll} assortment/classification planning & BOM (beginning of month) stock & merchandise plan \\ average retail stock/ inventory & EOM (end of month) stock & on order open-to-buy (OTB) \\ basic stock method & GMROI (gross margin return on investment) & planned purchases/ planned receipts \\ retail (4-5-4) fiscal calendar & stock keeping unit (SKU) & turnover/turn \\ six-month seasonal dollar merchandise plan & stock-to-sales method & weeks of supply method \\ \hline \end{tabular} Key Concept Formulas Average retail stock Average retail stock/inventory =TurnoverratePlannedsalesforperiod Average retail stock/inventory =Numberofinventories(Sumofbeginninginventories+Endinginventoryforgivenperiod) GMROI =100%Markup%Grossmargin%Turnover or GMROI =Averageinventoryatcost$Grossmargin$ Number of weeks of supply =Turnoverforthetimeperiod#Weeksintimeperiod Key Concept Formulas Open-to-Buy (OTB) OTB = Planned purchases for the month Outstandingorderstobedeliveredthatmonth OTBforbalanceofmonth=PlannedpurchasesformonthMerchandisereceivedtodateMerchandiseonorder Key Concept Formulas Planned purchases Plannedmonthlypurchasesatretail=PlannedEOMstock+Plannedsalesformonth+PlannedmarkdownsformonthPlannedBOMstock Plannedmonthlypurchaseatcost= Planned retail purchases (100% Planned markup %) Seasonal markdowns Planned total seasonal dollar markdowns =Plannedtotalseasonalsales$Totalseasonalmarkdown% Total seasonal markdown %=Totalseasonalsales$Totaldollarseasonalmarkdowns100 Key Concept Formulas Average retail stock Averageretailstock/inventory=TurnoverratePlannedsalesforperiodAverageretailstock/inventory=Numberofinventories(Sumofbeginninginventories+Endinginventoryforgivenperiod)GMROI=100%Markup%Grossmargin%Turnover or GMROI=Averageinventoryatcost$Grossmargin$Numberofweeksofsupply=TurnoverforthetimeperiodWeeksintimeperiod Key Concept Formulas Stock ratios Stock-to-sales ratio =SalesfortheperiodRetailstockatgiventimeintheperiod BOM stock = Planned monthly sales Stock-to-sales ratio BOM stock = Basic stock + Planned sales for the month Planned stock = Average weekly sales Number of weeks of supply Salesincrease%ordecrease%=LYactualsalesThisyear(TY)plannedsales-Lastyear(LY)actualsales100 Key Concept Formulas Seasonal planned sales = LY sales $+ Dollar increase Dollar increase = LY sales $ Planned increase % or Seasonal planned sales = LY sales $ Dollar decrease Dollar decrease = LY sales $ Planned decrease % Turnover =AverageretailstockforthesameperiodNetsalesforperiod
