Answered step by step
Verified Expert Solution
Question
1 Approved Answer
budget please solve the fill in the blanks Observed Trend/Growth (%) 2019 2020 2021 2022 2023 2024 50000 100 5000000 Sales (Units) 5.0% Sale Price
budget please solve the fill in the blanks
Observed Trend/Growth (%) 2019 2020 2021 2022 2023 2024 50000 100 5000000 Sales (Units) 5.0% Sale Price ($/Unit) 1% Sales Revenue ($) Closing Inventory 10% of next year's (Units) Demand Opening Inventory (Units) Production Budget (Units) Material Requirements 2 2 Material Usage (Kgs) Labour Requirement N Labour Usage (Hours) Material Cost ($ per Kgs) 2 Material Cost ($) Labour Rate ($/Hour) 1.5 Labour Cost ($) Fixed FOH ($ per year) Variable FOH (as percentage of 20000 50% Variable FOH ($) Total FOH ($) Total Manufacturing Opening WIP ($) Closing WIP ($) Cost of Goods Completed (s) Cost per unit Opening Finished Goods Inventory Closing Finished Goods Inventory le Cost of Goods Sold ($) Gross Profit ($) Less: Operating Expenses General Expenses 10% of Sales Admin Expenses 5% of Sales Marketing Expense 2% of Sales Total Operating Expenses EBIT Less: Interest Expenses EBT Less Tax Expense 40% of EBT EAT Observed Trend/Growth (%) 2019 2020 2021 2022 2023 2024 50000 100 5000000 Sales (Units) 5.0% Sale Price ($/Unit) 1% Sales Revenue ($) Closing Inventory 10% of next year's (Units) Demand Opening Inventory (Units) Production Budget (Units) Material Requirements 2 2 Material Usage (Kgs) Labour Requirement N Labour Usage (Hours) Material Cost ($ per Kgs) 2 Material Cost ($) Labour Rate ($/Hour) 1.5 Labour Cost ($) Fixed FOH ($ per year) Variable FOH (as percentage of 20000 50% Variable FOH ($) Total FOH ($) Total Manufacturing Opening WIP ($) Closing WIP ($) Cost of Goods Completed (s) Cost per unit Opening Finished Goods Inventory Closing Finished Goods Inventory le Cost of Goods Sold ($) Gross Profit ($) Less: Operating Expenses General Expenses 10% of Sales Admin Expenses 5% of Sales Marketing Expense 2% of Sales Total Operating Expenses EBIT Less: Interest Expenses EBT Less Tax Expense 40% of EBT EATStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started