REQUIRED:
Prepare the following budgets for January 2021:
a) Revenues budget (2 Marks)
b) Production budget in units (2 Marks)
c) Direct materials usage budget and direct materials purchases budget (both budgets in units and $) (4 Marks)
d) Direct manufacturing labour budget (2 Marks)
e) Manufacturing overhead budget (2 Marks)
f) Ending inventories budget (direct materials and finished goods) (2 Marks)
g) Cost of goods sold budget (2 Marks)
For each budget, prepare by product (Premium and De Luxe) and in total.
Format of the spreadsheet makes it easy to read and distinguishes clearly between the input and output cells (2 Marks)
Excel spreadsheets designed in a way that enables different input data to be entered and automatically change the output data (2 Marks)
Important Study Information