Historical demand for iphones in a retail store is as follows: Sales January 12 February...

Historical demand for iphones in a retail store is as follows:

	Sales
	January	12
	February	14
	March	15
	April	12
	May	16


a) Using the simple mean method, find the June forecast.
b) Using a simple exponential smoothing with alpha = 0.1 and a January forecast = 13, find the June Forecast.
c) Use MAD to decide which method produced the better forecast.

Expert Solution

keosha answered 1 year ago

Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May...

Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May 17 June 16 a. Using a weighted moving average with weights of 0.60 (June), 0.20 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) c. Using single exponential smoothing with ? = 0.30 and a June forecast = 11, find...

Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May...

Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May 24 June 23 a. Using a weighted moving average with weights of 0.40 (June), 0.40 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) July forecast b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) July forecast c. Using single exponential smoothing with ? = 0.30 and a June...

the cash sales and credit sales projected for sarahs kitchen are as follows: January february march...

the cash sales and credit sales projected for sarahs kitchen are as follows: January february march april may cash 17,000 19640 16200 15380 17390 credit 40,000 42000 48000 50000 49500 if collections of credit sales are 70% the first month and 30% the second month, what would be the cash receipts for march, april, and may

Handy Hardware is a retail hardware store. Information about the store’s operations follows. November 20x1 sales...

Handy Hardware is a retail hardware store. Information about the store’s operations follows. November 20x1 sales amounted to $450,000. Sales are budgeted at $490,000 for December 20x1 and $450,000 for January 20x2. Collections are expected to be 70 percent in the month of sale and 28 percent in the month following the sale. Two percent of sales are expected to be uncollectible. Bad debts expense is recognized monthly. The store’s gross margin is 25 percent of its sales revenue. A...

Stine Co. is a retail store operating in a state with a 6% retail sales tax.

Stine Co. is a retail store operating in a state with a 6% retail sales tax. The retailer may keep 2% of the sales tax collected. Stine Co. records the sales tax in the Sales account. The amountrecorded in the Sales account during May was $148,400. 99. The amount of sales taxes (to the nearest dollar) for May isa. $8,726. b. $8,400. c. $8,904. d. $9,438.The amount of sales taxes payable (to the nearest dollar) to the state for the...

Vaughn Co. is a retail store operating in a state with a 7% retail sales tax....

Vaughn Co. is a retail store operating in a state with a 7% retail sales tax. The retailer may keep 2% of the sales tax collected. Vaughn Co. records the sales tax in the Sales Revenue account. The amount recorded in the Sales Revenue account during May was $747930. The amount of sales taxes payable (to the nearest dollar) to the state for the month of May is $37307. $47951. $51310. $61874.

Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14...

Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14 10 -Compute the RSFE, MAD and tracking signals for months January to April?

Historical demand for a product is as follows: April 60 May 60 Jun

Historical demand for a product is as follows: April 60 May 60 June 55 July 75 August 80 September 75 (a.) Using a simple four-month moving average, calculate a forecast for October. (b.) Using single exponential smoothing with alpha=0.3 and a September forecast =70, calculate a forecast for October. (c.) Using simple linear regression, calculate the trend line (Yt) for the historical data. The X-axis scale is: April = 1, May = 2, and so forth. Y-axis is Demand from...

Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July...

Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July 61 August 86 September 81 a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) b. Using single exponential smoothing with α = 0.30 and a September forecast = 64, calculate a forecast for October. (Round your answer to 2 decimal places.) c. Using simple linear regression, calculate the trend line for the historical data....

Blue Department Store converted from the conventional retail method to the LIFO retail method on January...

Blue Department Store converted from the conventional retail method to the LIFO retail method on January 1, 2020, and is now considering converting to the dollar-value LIFO inventory method. During your examination of the financial statements for the year ended December 31, 2021, management requested that you furnish a summary showing certain computations of inventory cost for the past 3 years. Here is the available information. 1. The inventory at January 1, 2019, had a retail value of $55,800 and...

Question