Hello and welcome to my official channel.
My name is Amaka Ifebunandu, a practising professional accountant based in Nigeria.
In this channel, you will learn basic to advanced Excel, Accounting Basics, Relevant Accounting Softwares and access to all Excel templates demo videos.
Basic to Advanced Excel skills will help you achieve more task in less time.
Practical knowledge of the basic accounting will help you manage your finance properly and make the right decisions.
Accounting software tutorials to gain easy mastery of it.
The Excel templates video will serve as a step by step guide on how to use each of the templates.
Send your Accounting & Excel questions, concerns, and problems to info@accountingonexcel.ng
New videos every week -- make sure to SUBSCRIBE, and turn on the notification bell so you don't miss a thing!
This channel is dedicated to educating and equipping you with all the skills and tools needed to Take Charge of Your Business & Personal Finance
Amaka Ifebunandu (dexcelcoach)
A company pays 5% commission on sales revenue.
Where should this be budgeted?
1 month ago | [YT] | 1
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Which overhead cost changes with production activity?
1 month ago | [YT] | 2
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Which cost is most often misclassified in a Manufacturing Overhead Budget?
1 month ago | [YT] | 0
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Which of the following will most likely distort the Direct Labour Budget, even if production volumes are correct?
1 month ago | [YT] | 0
View 0 replies
Amaka Ifebunandu (dexcelcoach)
A company increases its production volume, but the standard labour hours per unit remain unchanged.
What happens to the Direct Labour Budget?
1 month ago | [YT] | 0
View 0 replies
Amaka Ifebunandu (dexcelcoach)
A company plans to produce 1,000 units of a product. Each unit requires 2.5 yards of material.
What is the budgeted material usage?
1 month ago | [YT] | 1
View 0 replies
Amaka Ifebunandu (dexcelcoach)
In a well-structured Excel budget model, why should assumptions be kept separate from calculations?
1 month ago | [YT] | 2
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Which of the following best explains why production is not equal to sales in a manufacturing budget?
1 month ago | [YT] | 1
View 0 replies
Amaka Ifebunandu (dexcelcoach)
A company budgets sales of 300 units in January. Policy requires 10% of February sales to be held as closing inventory. February sales are forecast at 280 units.
What is the required closing inventory for January?
1 month ago | [YT] | 3
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Most budgeting errors do not start in Excel.
.
.
.
They often begin with a limited understanding of how sales and production budgets interact.
.
.
Consider the following simple example from my current Budgeting in Excel series.
.
.
A manufacturing company produces Big, Medium, and Small luggage bags.
.
.
For January:
Budgeted sales for Big bags = 300 units
Management requires 10% of next month’s sales as closing inventory
This means production is not equal to sales.
Production must cover:
✔ Budgeted sales
✔ Plus required closing inventory
✔ Minus opening inventory
If you miss this logic, every budget that follows will be wrong:
✔ Materials budget
✔ Labour budget
✔ Overhead budget
✔ Cash budget
That is why in my latest tutorials, I:
✔ Build the Sales Budget properly first
✔ Then show how the Production Budget is derived directly from it
✔ Use Excel formulas, not manual calculations
✔ Structure the model so that one change in assumptions updates everything automatically
This is not a theory.
This is how budgeting is done in real organisations.
If you work in:
✔ Finance or accounting
✔ Manufacturing or operations
✔ NGO or donor-funded projects
✔ Or you are a student preparing for management accounting
You need to understand this properly.
🎥 Sales Budget in Excel (Part 1) 👇
https://youtu.be/CcQmfBfIl3k?si=Wvc6X...
🎥 Production Budget in Excel (Part 2) 👇
https://youtu.be/N0Xwm6ERa8w?si=zKoCn...
Watch them now and re-watch before the next lesson drops.
#BudgetingInExcel
#SalesBudget
#ProductionBudget
#ExcelForAccountants
#ManagementAccounting
#FinanceProfessionals
#PracticalAccounting
#DexcelCoach
1 month ago | [YT] | 4
View 0 replies
Load more