Java Python BUSINESS 114 – Accounting for Decision Making
Assignment 1
FIRST SEMESTER, 2024
Due date: 4 pm (NZT) 22 March 2024
1. Budgeting and Professional Emails: 21 marks
(a) Prepare a Sales budget for the first quarter of 2024. (5 marks)
Sales Budget
| Jan | Feb | Mar | First Quarter |
Multigrain Bread – Budgeted sales units |
|
|
|
|
Budgeted selling price per unit |
|
|
|
|
Multigrain Bread – Budgeted sales revenue $ |
|
|
|
|
Blueberry Muffins – Budgeted sales units |
|
|
|
|
Budgeted selling price per unit |
|
|
|
|
Blueberry Muffins – Budgeted sales revenue $ |
|
|
|
|
Cinnamon Rolls – Budgeted sales units |
|
|
|
|
Budgeted selling price per unit |
|
|
|
|
Cinnamon Rolls – Budgeted sales revenue $ |
|
|
|
|
= Total Budgeted sales revenue $ |
|
|
|
|
Expected cash collections (cash sales) 70% |
|
|
|
|
Expected cash collections (credit sales) |
|
|
|
|
Expected cash collections (credit sales):
Total Sales | Credit Sales (30%) | Jan | Feb | Mar | |
January |
|
|
|
|
|
February |
|
|
|
|
|
March |
|
|
|
|
|
Total |
|
|
|
|
|
(b) Prepare an Inventory purchases budget for the first quarter of 2024. (3 marks)
Inventory Purchases Budget
| Jan | Feb | Mar | First Quarter |
Multigrain Bread – Budgeted purchases units |
|
|
|
|
Budgeted purchase cost per unit |
|
|
|
|
Multigrain Bread – Budgeted cost of purchases $ |
|
|
|
|
Blueberry Muffins – Budgeted purchases units |
|
|
|
|
Budgeted purchase cost per unit |
|
|
|
|
Blueberry Muffins - Budgeted cost of purchases $ |
|
|
|
|
Cinnamon Rolls – Budgeted purchases units |
|
|
|
|
Budgeted purchase cost per unit |
|
|
|
|
Cinnamon Rolls - Budgeted cost of purchases $ |
|
|
|
|
= Total Budgeted cost of purchases $ |
|
|
|
|
Expected cash payments |
|
|
|
|
(c) Prepare another expenses budget for general expenses for the first quarter of 2024