Budgeting Case Analysis

Need help with budgeting case analysis. Attached is the case info, the excel spreadsheet with the instructions on a word document in order to complete the case. Please use word and/or excel to complete the needs of the case. 

See attachments.