1. Using the Excel template supposing, furnish the subjoined budgets restraint the twelve-month time from January 2019 to December 2019. The leading worksheet should include your chill axioms and assumptions and complete coming worksheets should be linked to this axioms. Verification a unanalogous worksheet restraint each budget. Show complete calculations and verification Excel functions where potential. While you should verification examples in your citation as a pilot, the solution to using spreadsheets is that they are structured so that others can verification them and prosper the stream of advice outside difficulty.
a. Monthly Sales Revenue and Cash Collection Budget
b. Production Budget in Units
c. Direct Materials and Cash Purchases Budget
d. Direct Labour Budget
e. Manufacturing Overhead Budget (split into fickle and unroving components)
f. Monthly Operating Cost Budget
g. Ending Inventory budget restraint Finished Goods
h. Cost of Sales Budget
i. Budgeted Income Statement restraint the year ended 31 December 2019
j. Monthly Cash Budget
Your budget spreadsheet must be submitted in Excel Restraintmat (referable as an sequel in your WORD instrument).
2. Write a communication (Maximum 1,500 words) restraint your superintendent to give to the upcoming Board contravention.