Master Budget for Hera Manufacturing Company.

Using HERA MANUFACTURING SALES excel sheet and the FORECAST excel sheet complete the excel pages called Sales Budget, S&A Exp. Budget, Direct Mat budget, Direct Labor Budget, Mfg OVH Budget, Production Budget, Cash Budget, Proforma Income Statement and the Proforma Balance Sheet.

In each page (except for Production Budget and the Proforma Income Statement page) to be completed there is a text box with information at bottom, so it is needed to zoom in and out the excel pages to see all so any information is not missed.

A B C D E F G H HERA Manufacturing Company Month Sales Jan 13.114 Feb 10.793 Background: Mar 12.765 Apr 13.573 These are the sales data of Hera, a winter sportwear May 20.930 manufacturer which manufacturers skis. You are Hera sales Jun 22.830 manager. Jul 25.206 Aug 18.360 Sep 10.199 You have to prepare a 12-month forecast for Year 5 in units Oct 12.672 and euros. Nov 12.851 Dec 16.246 You have the monthly unit sales data for the last 4 years; your Jan 15.716 average unit price to distributors has been 1056 last year and Feb 17.341 you do not think it is possible to increase it. Mar 20.032 Apr 14.853 Cash collection is as follows: May 24.324 Jun 27.890 80% of sales of month M are collected in M+1 Jul 29.185 19% of sales of month M are collected in M+2 Aug 20.494 1% of sales is never collected Sep 15.011 Oct 17.786 Nov 12.485 Dec 19.547 Jan 17.160 Feb 21.596 Mar 23.569 Apr 15.779 May 25.183 Jun 30.255 Jul 30.999 Aug 25.407 Se 15.542 Oct 20.495 Nov 19.115 Dec 20.520 Jan 21.242 Feb 19.968 Mar 24.674 Apr 21.972 May 23.949 Jun 35.586 Jul 40.042 Aug 32.246 Sep 17.480 Oct 21.599 Nov 16.875 Dec 21.242