ACC00714: Monthly Sales Revenue and Cash Collection Budget - Accounting Assessment Answer

Required: ACC00714
1. Using the Excel template provided, prepare the following budgets for the twelve-month period from January 2020 to December 2020. The first worksheet should contain your raw data and assumptions and all future worksheets should be linked to this data. Use a different worksheet for each budget. Show all calculations and use Excel functions where possible. While you should use examples in your text as a guide, the key to using spreadsheets is that they are structured so that others can use them and follow the flow of information without 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 (break into variable and fixed components)
f. Monthly Operating Cost Budget
g. Ending Inventory budget for Finished Goods
h. Cost of Sales Budget
i. Budgeted Income Statement for the year ended 31 December 2020
j. Monthly Cash Budget
Your budget spreadsheet must be submitted in Excel Format (not as an appendix in your WORD document).
2. Write a report (Maximum 1,500 words) for your manager to present to the upcoming Board meeting. The report should include:

• an overview of the expected results for the 2020 year;
• an analysis of the Contribution Margin for each product and recommendations regarding the products Surf N Sea manufacture and sell;
• recommendations regarding the cash position of the business; and
• an analysis of current market conditions and future predictions that you believe should be considered when following year’s 2020 budget is prepared. You should use broader industry data and trends from sources such as IBISWorld and the Australian Bureau of Statistics to support your recommendations.
•  IBIS World Link via Library:
• Harvard Referencing Guide:
• Use visual aids such as tables and graphs to enhance your report presentation.

This ACC00714 Accounting Assessment has been solved by our Accounting experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.