Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how would i solve for the scenarios? Business math is used to analyze a company's performance by converting sales, inventory, financial, and other data into
how would i solve for the scenarios?
Business math is used to analyze a company's performance by converting sales, inventory, financial, and other data into actionable information. The information is used to identify problems and opportunities and make purchasing and planning decisions. 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 Waimart store in Michigan had a BOM (Beginning of Month) stock of $230,000 at retail at the beginning of February. Net sales for the month were $85,000 and the EOM (End of Month) stock was $430,000. The department manager was expecting sell-thru in February of 25 percent (25\%). - What was the department's sell-thru for the month of February? - What should the department manager consider in light of this sell-thru rate? Scenario 2: In April, the Party \& Occasions department had an opening inventory of $57,000 at retait. 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? Scenario 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 9 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 (3) weeks. What could have led to this situation and what can the buyer do in the future to avoid this from happening again? Scenario 5: 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 40 tires. it's time to reorder tires. - How many tres is the department open to recelve? - If the tires that are ordered cost the company $43 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started