FNSACC513 Manage budgets and forecasts - Assessment 5

Part A

Using the Excel Template for Assignment 5 from the OLS, complete the following tasks noting:

• Your spreadsheets must include a data sheet into which all data is entered.
• Worksheets need to contain formulae and/or links to the data sheet or a subsequent worksheet.
• Use the number format and use the 1000 separator (,) for amounts over 1,000.
• Do not round unit costs in your calculations. Show unit costs in dollars and cents.
• Ensure each budget or report has the name of the business, the type of report or budget and specifies the period to which it applies.

Prepare the following budgets for July, August and September.

1. Sales budget (showing units and $)
2. Production budget (in units)
3. Direct material purchases budget
4. Direct labour budget (showing hours and $)
5. Factory overhead budget
6. Schedule of collection from accounts receivable
7. Cash Payments budget
8. A schedule showing the cost of each golf bag
9. A budgeted Income Statement for the quarter ended 30 Sept 2018 (month by month details are not required). Round all figures to the nearest dollar.