Master budget

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 sheet there are information on a text box. Please look at the whole sheet to find the information. Sometimes it will be zoomed when opened. You will probably need to zoom out sometimes and please look at the whole sheet. Also, sometimes it will take a few seconds to charge and see everything.

Nothing is missing all the information is there on the text box in every sheet. Zoom out to see please.

Here is the link to the excel sheet to complete the work:

https://docs.google.com/spreadsheets/d/1l-nBdG6FjiTVRYiljjfFLycBaMVZctFCH284kTOmZ_s/edit#gid=634262227

• . Use IF Functions for the formulas

The IF function The basic form or syntax of the function is: =IF(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)