Instructions Read the scenarios and answer the questions that follow. Show your work and provide a brief explanation for each answer Scenario 1: The Garden Center department at a Walmart store in Michigan had a BOM (Beginning of Month) stock of $230,000 at retail at the beginning of February. Ne sales for the month were $85,000 and the EOM (End of Month) stock was $430,000. The department manager was expecting stock turnover in February of 25 percent (259). What was the department's stock turnover for the month of February? What factors may have impacted this turnover rate? Scenario 2: In April, the Party & Occasions department had an opening inventory of $57,000 at retail. The sell-thru percentage rate for April was 28 and closing inventory was $49,000. • What were the net sales in the department during the month of April? • Would this be considered a successful performance or not? Explain Scenario 3: Last year, a Walmart store in Nebraska had annual sales of $11,390,000 with an average dollar stock amount for the year of $2,149,000. What was the stock turnover for the year? How would the store manager determine if this was a good rate of turnover? Scenarlo 4: The buyer for the Electronics department has 15 big screen TVs in stock in a store in Colorado. The store maintains a reserve of big-screen TVs as safety stock. Delivery takes one week, and stock is reordered every two weeks. Sales of these TVs average 9 per week • How many big-screen TVs should the buyer reorder in order to meet sales and reserve requirements without running out of stock? • The store does not appear to have enough big-screen TVs on hand to meet average weekly demand before the new TVs arrive in three (weeks. What could have led to this situation and what can the buyer do in the future to avoid this from happening again? Scenario : It takes six weeks for a tire order to be delivered to the Auto & Tire Center in the Walmart Supercenter in Wisconsin. Tires are ordered every five weeks Currently, there are 90 tires on hand and another 340 on order. Sales are expected to use 120 tires per week and the department maintains a reserve of 4o tires. time to reorder tires • How many tires is the department open to receive? • It the tires that are ordered cost the company 543 per tire, and the retail price of the tires is determined by marking up the cost by 57, what is the total retail value of the tires being ordered?