Sweden Ltd manufactures cabinets. You work in the accounting department and have been tasked… 1 answer below »
You need to prepare and submit an excel spreadsheet which answers the questions below.
Prepare an excel spreadsheet to help satisfy Learning Outcome 2: Formulate budgets and construct a
cost-volume-profit analysis using practical scenarios.
Sweden Ltd manufactures cabinets. You work in the accounting department and have been tasked
with preparing the Budget for the next month.
Sweden makes two products:
Premium cabinets – large cabinets with mirrors
De Luxe cabinets – medium sized cabinets with an innovative shelving solution and mirrors
Direct manufacturing labour is 3 hours for the Premium cabinet and 5 hours for the De Luxe.
The budgeted direct material usage for each product in 2020 is: