Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

Could someone answer No.4 and no.5? Thank you!!image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

The nature and importance of the global marketplace.

Answered: 1 week ago