LeighHutsell_DAT530_RetailAnalysisWorksheet_Unit2

Demand of Hairdryer from January to July   Month Demand January 2800 February 2870 March 2968 April 3000 May 3100 Jun 3150 July 3400   a). Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.         b) Determine TWO (2) consequences if the company produce supply more than the customer demand.         c) In your opinion, provide ONE (1) perspective you will look into supplier before made a decision to select a supplier.

Is it necessary that a sale forecast reflect fluctuations in demand pattern for a goods and service?

1.Solve the problem and create line graph. Please refer to the picture for the problem and formula: • Find 3-month moving average for the next (each) month (above table)   • Find 5-month moving average for the next (each) month (above table)

I'm trying to determine optimal order quantity but only have a Mean forecast and a standard deviation of it to use for sales data. How would I determine the sales data to use in the optimal order quantity formula?

Discuss this one way retailers uses Business Analytics in operations: “Analyzing sales transaction and traffic data to understand demand, build forecast to meet demand and improve in-stock position while reducing overstock or out-of-stock situations.”

Discussion #1 & #2 please

Year 1 Demand Year 2 Demand Year 3 Demand 1 12 1 16 1 14 45 25 32 3 76 52 3 71 84 4 4 62 4 47 a. Determine the seasonal factors for each quarter. b. Based on the result of part (a), determine the deseasonalized demand series. c. Predict the demand for each quarter of Year 4 for the deseasonalized series from a six-quarter moving average. d. Using the results from parts (a) and (c), predict the demand for the shoes for each quarter of Year 4.

Business Plan for 39 Storage https://www.39storage.com/ (This Company) Cover these points below Executive Summary Cite Sources

Imagine that you own a bakery! Your bakery sells cookies and brownies only. To run your bakery successfully, you must determine the production cost for each item, as well as, your maximum production cost for each day. Create a business plan for your bakery! Your business plan must include the following: • The cost to produce a cookie • The cost to produce a brownie • Your maximum production costs per day • The system of inequalities that describes these restrictions • A graph of your system including the shaded solution region

B 8,000 A 4,000 10,000 20,000 Disposable income Figure 1.2 2) Refer to Figure 1.2. The slope of the line between Points A and B is A) 0.4. C) 2.5. B) 1.2. D) indeterminate from this information. Consumption

Please get to me soon.

Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 000י7 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000

Michael’s Offi ce Supply (MOS) sells offi ce furniture,equipment, and supplies. Th is week the company has received 50customer orders. Each order has an average of fi ve line items. Th eaverage dollar amount of each order is $1200. MOS was able toship 47 of the 50 orders on schedule.(a) Using the percentage of orders shipped on time, calculatethe customer service level.(b) If Michael’s calculates customer service level by using thepercentage of line items shipped on schedule, how manyline items must be shipped to achieve the same customerservice level calculated in part (a)?(c) If Michael’s calculates customer service level by thepercentage of dollar volume shipped, how many dollarsof product must be shipped to achieve the same customerservice level calculated in part (a)?(d) What factors determine the customer service levelmeasure that MOS should use?

Not use ai please

Please do not give solution in image format thanku

4.  In the​ past, Peter​ Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2​ years, 220 and 250​, respectively were sold in​ fall, 360 and 300 in​ winter, 150 and 160 in​ spring, and 320 and 440 in summer. With a major expansion​ planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next​ year's projected​ sales, the demand for each season is going to be ​(enter your responses as whole​ numbers):   Season Demand Fall __________

Why would demand forecasting make sense in a “make to stock” situation?

The Ashton Furniture Company manufactures coffee tablesand chest of drawers. Last year the company’s cost ofgoods sold was $3,700,000, and it carried inventory of oak,pine, stains, joiners, and brass fixtures, work-in-process offurniture frames, drawers and wood panels, and finishedchests and coffee tables. Its average inventory levels for a52-week business year were as follows. Determine the number of inventory turns and the days ofsupply for the furniture company. Raw Materials Average Inventory Unit CostOak 8000 $6.00Pine 4500 4.00Brass fixtures 1200 8.00Stains 3000 2.00Joiners 900 1.00Work-in-ProcessFrames 200 $30Drawers 400 10Panels 600 50Chests 120 110Tables 90 90Finished GoodsChests 300 $500Coffee tables 200 350

Please assist to provide answers in an excel sheet and provide step by step solutions/explanation

explain briefly what does it mean "Not an issue of affordability but lack of support and priority"?

please answer in 30 mins.

Suppose that AlwaysRain Irrigation’s marketing department will undertake an intense ad campaign for the bronze sprinklers, which are more expensive but also more durable than the plastic ones. Forecast demand for the next four years is:   YEARLY DEMAND 1 (IN 000s) 2 (IN 000s) 3 (IN 000s) 4 (IN 000s) Plastic 90 32 44 55 56 Plastic 180 15 16 17 18 Plastic 360 50 55 64 67 Bronze 90 11 15 18 23 Bronze 180 6 5 6 9 Bronze 360 15 16 17 20 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require two operators and can produce up to 12,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 200,000 sprinklers. Three bronze machines and only one injection molding machine are available. Required: What are the capacity implications of the marketing campaign? (Assume that there is no learning.) In anticipation of the ad…

What determines the length of the future time period for which a sales forecast must be prepared for operations planning purposes?

Matt ress Wholesalers, Inc., is constantly trying to reduce inventory in its supply chain. Last year, cost of goods sold was $7.5 million and inventory was $ 1.5 million. This year, cost ofgoods sold is $8.6 million and inventory investment is $1.6 million. Ja) What were the weeks of supply last year?b) What are the weeks of supply this year?c) Is Mattress Wholesalers making progress in its inventoryreduction effort?

Need the correct answer to this practice question I found online please selecting one of the choices below What is a cost per mille? It is the total cost for a print advertisement. > It is the cost an advertiser pays to ship a print advertisement to its destination. > It is a percentage, which is based per thousand target viewers who have seen or heard an advertisement. > It is the formula for determining how much a billboard advertisement will cost based on how many miles away a person will see it.