BUDGETING & CONTROL

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.

LINK TO THE GOOGLE EXCEL SHEET TO COMPLETE THE TASK:

https://docs.google.com/spreadsheets/d/1yDNFoakc0v_E8pc61DtONy1Gyl5gEWD2y47e5DHzR3U/edit?usp=sharing

Use IF Functions for the formulas

The IF function The basic form or syntax of the function is: =[F(logic test, value if true, value if false) - Selling and Administrative Expense Budget, Sales Commission: =IF (SUM (C7:E7)>7500000;0.1*SUM(C10:E10),0) Direct Labor Budget, Direct Labor overtime costs: =IF(C13>29400, (C13-29400)*15/3,0) Supervision Overtime costs: =IF(C13>29400;(C13-29400) *21/3,0) Manufacturing Overhead Budget, Utilities: =+IF(C13>29400;50000+10000,50000) Please be aware that some computers prefer, instead of . and reverse. Or ; instead of , and reverse