80.2K

Verified Solution

Link Copied!

Could someone answer No.4 and no.5? Thank you!!

This now provides a forecast, based on 2017 and 2018 data, for sales in Q4 2018. a) What are forecasted sales for October 2018? List dollar value here: $ 138004 b) What are forecasted sales for November 2018? List dollar value here: $ 157154 c) What are forecasted sales for December 2018? List dollar value here: $ 176304 To obtain actual values, create a new worksheet (tab), add Invoice Total to the Rows line, and add Invoice Date to the Columns line, expanding until months are shown. d) What are actual sales for October 2018? List dollar value here: $ 222137 e) What are actual sales for November 2018? List dollar value here: $ 259826 f) What are actual sales for December 2018? List dollar value here: $ 77687 QUESTION 2 Based on the sale amounts obtained in Question 1 above: What month(s) significantly underperformed expectations? You may select more than one answer. October November December QUESTION 3 Based on the sale amounts obtained in Question 1 above: What month(s) significantly outperformed expectations? You may select more than one answer. October November December QUESTION 4 What inherent weaknesses does the forecast (in Question 1) have? (In other words, the difference between actual and forecasted amounts is most likely due to bad forecasting in this case, rather than the actual amounts being especially unusual. Why are those forecasted amounts so inaccurate?) For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). T T T F Paragraph Arial 3 (12pt) T % DOO T* T fx Mashups T ABC HTML CSS Path: p Words:0 QUESTION 5 Based on this simple preliminary forecast: What audit evidence will the auditor need to obtain during the audit to become comfortable with revenue during Q4? T T T F Paragraph Arial T 3 (12pt) TY TO ABC fx Mashups HTML CSS Path:p Words:0 This now provides a forecast, based on 2017 and 2018 data, for sales in Q4 2018. a) What are forecasted sales for October 2018? List dollar value here: $ 138004 b) What are forecasted sales for November 2018? List dollar value here: $ 157154 c) What are forecasted sales for December 2018? List dollar value here: $ 176304 To obtain actual values, create a new worksheet (tab), add Invoice Total to the Rows line, and add Invoice Date to the Columns line, expanding until months are shown. d) What are actual sales for October 2018? List dollar value here: $ 222137 e) What are actual sales for November 2018? List dollar value here: $ 259826 f) What are actual sales for December 2018? List dollar value here: $ 77687 QUESTION 2 Based on the sale amounts obtained in Question 1 above: What month(s) significantly underperformed expectations? You may select more than one answer. October November December QUESTION 3 Based on the sale amounts obtained in Question 1 above: What month(s) significantly outperformed expectations? You may select more than one answer. October November December QUESTION 4 What inherent weaknesses does the forecast (in Question 1) have? (In other words, the difference between actual and forecasted amounts is most likely due to bad forecasting in this case, rather than the actual amounts being especially unusual. Why are those forecasted amounts so inaccurate?) For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). T T T F Paragraph Arial 3 (12pt) T % DOO T* T fx Mashups T ABC HTML CSS Path: p Words:0 QUESTION 5 Based on this simple preliminary forecast: What audit evidence will the auditor need to obtain during the audit to become comfortable with revenue during Q4? T T T F Paragraph Arial T 3 (12pt) TY TO ABC fx Mashups HTML CSS Path:p Words:0

Answer & Explanation Solved by verified expert

See Answer