Question: Dynasol is in a rapidly growing and highly competitive field of Solar Water Heating. It needs a forecast for based on their sales history and

Dynasol is in a rapidly growing and highly competitive field of Solar Water Heating.

It needs a forecast for based on their sales history and on the total solar heating market sales history

The forecast is needed as Dynasol is at manufacturing capacity and needs information to determine how much to expand.

The assignment is to develop a 6 month forecast for their sales and for the total market sales.

Total Market DynaSol Month Sales in Units Sales in units 2014 September 24 223 October 28 228 November 31 230 December 3


Total Market DynaSol Month Sales in Units Sales in units 2014 September 24 223 October 28 228 November 31 230 December 32 231 2015 January 30 229 February March 35 235 240 39 April 40 265 May 43 281 June 47 298 July 51 314 August 54 354 September 59 389 October 62 421 November 67 466 December 69 501 2016 January 74 529 February 79 573

Step by Step Solution

3.47 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

A A modified trend analysis 1 Determine the average monthly difference in Dynasols sales in units Year Average 2014 Year 2015 4966667 2016 2 Add that ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (3 attachments)

PDF file Icon

1258_60bca5df18be7_646390.pdf

180 KBs PDF File

Excel file Icon

1258-B-M-A-C-B(4005).xlsx

300 KBs Excel File

Word file Icon

1258_60bca5df18be7_646390.docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!