Answer - The sales of X have followed a declining trend from Jan to June and then the sales recovered after the half year but ended up to less than the sales from where it started.
For Y , the sales started in almost mid year and have followed a uniform trend which is cyclical in nature. For Z , after the steady start in Jan, the sales increased drastically in the mid year.
Product Sales by Month Product X Product Y Product Z $100,000 $80,000 Value $60,000 $40,000 $20,000...
What is the cash collection for October? Sales are: In the month of sales: 25% In the next month: 22% After 2 months: 7% After 3 months: remainder is collected Month Sales $ Month Sales $ Jan 34,599 July 20,706 Feb 33,253 Aug 67,777 Mar 67,777 Sep 34,599 Apr 20,706 Oct 67,777 May 34,599 Nov 33,253 June 33,253 Dec 20,706
III. Cost of Goods Sold & Inventory (LLH 7) Cost of Goods Sold FIFO LIFO Hodor Company is a wholesale distributor of doors. He replenishes his supply of doors on the 15th of each month and has sales only on the last day of cach month. The following information is available for 2019: Periodic Perpetual 2 pts 2 pts 3 pts 3 pts Beginning Inventory Purchase, Jan. 15 Purchase, Feb. 15 Purchase, Mar. 15 Purchase, April 15 Purchase, May 15...
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $ Jan 19,034 July 99,711 Feb 5,265 Aug 80,177 Mar 80,177 Sep 19,034 Apr 99,711 Oct 80,177 May 19,034 Nov 5,265 June 5,265 Dec 99,711 Sales are collected as follows: In the month of Sales: 43% In the next month: 33% After 2 months: 9% After 3 months: remainder is collected What...
use python Write a program that asks the user for day and month of a birthday. The program then tells the Zodiac signs that will be compatible with that birthday. #Example for Aries The Ram Mar. 21–Apr. 19 day = 24 # user enters this month = 3 # user enters this if ( month == 3 and day >=21) or (month == 4 and day <= 19): print("You are Aries, Fire group, compatible with Aries, Leo, Sagittarius") Zodiac Signs:...
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $ Jan 46,442 July 37,618 Feb 36,143 Aug 39,034 Mar 39,034 Sep 46,442 Apr 37,618 Oct 39,034 May 46,442 Nov 36,143 June 36,143 Dec 37,618 The Purchases are 78% of Sales. Purchases are paid in the following month. The administrative expenses of $7,990 are paid each month Tax expenses of $12,127 are...
Month Sales $ Month Sales $ Jan 88,498 July 28,618 Feb 34,044 Aug 58,273 Mar 58,273 Sep 88,498 Apr 28,618 Oct 58,273 May 88,498 Nov 34,044 June 34,044 Dec 28,618 The table contains the Sales estimates for the next year. Sales are collected as follows: In the month of Sales: 33% In the next month: 21% After 2 months: 7% After 3 months: remainder is collected What is the cash collection for September? Enter your answer rounded off to two...
Month Sales $ Month Sales $ Jan 39,597 July 39,428 Feb 51,408 Aug 84,330 Mar 84,330 Sep 39,597 Apr 39,428 Oct 84,330 May 39,597 Nov 51,408 June 51,408 Dec 39,428 The table contains the Sales estimates for the next year. The Purchases are 76% of Sales. Purchases are paid in the following month. The administrative expenses of $11,695 are paid each month Tax expenses of $25,555 are...
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
The following information is about a Company Month Sales Purchases Jan. 60,000 30,000 Feb. 80,000 40,000 Mar. 100,000 60,000 Cash is collected from customers in the following manner: Month of sale 45% Month following the sale 60% 40% of purchases are paid for in cash in the month of purchase, and the balance is paid in the following month. Labor costs are 30% of sales. Other operating costs are 38,000 per month including deprecation of 10,000. Both of these are...
QUESTION FIVE Sales of products for the past 12 months are shown below. Month Jan Sales 89 Feb 74 March April May June July 92 123 102 139 152 Aug Sept Oct 128 183 148 Nov Dec 166 179 a) Find the equation of regression line b) Use linear regression to forecast sales for the next three months. c) Conduct an ANOVA analysis to test the hypothesis B = 0 at significance level 5%. d) Compute the coefficient of determination....