hi there can you help me to find the revenue budget and so on with this problem?
Sweden Ltd manufactures cabinets. Your team works in the accounting department and has been tasked with preparing the Budget for the next month {Question 1}. Your team has also been asked to provide management with some information and advice on kaizen budgeting (Question 2}. Sweden makes two products: PTemium Ilbinets - large cabinets with minors De Luxe cabinets - medium sized cabinets with an innovative shelving solution 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 2515 is: Square metres Premium De Luxe Mirrors 2 5 Softwood 1 5 Hardwood 4 1 Balsa wood 1 4 ItIprening direct materials inventory for September 2515 is: Square metres F'remium De Luxe Mirrors 45 5 Softwood 15 35 Hardwood 155 5 Balsa wood 4 45 Target ending direct materials inventory {September 35] is: Square metres Premium De Luxe Mirrors 24 5 Softwood 5 45 Hardwood 55 4 Balsa wood 4 44 Unit cost data is expected to be the same for September as it was in August for labour and all materials except Balsa Wood where a change in supplier has resulted in a cost increase of 55%. Detailed cost data is as follows: Aug ust {actual} September {budgeted} if It Mirrors per square metre 155 155 Softwood per square metre 125 125 Hardwood per square metre 12 12 Balsa wood per square metre 15 24 Manufacturing labour cost per hour 35 35 Manufacturing overhead [both variable and fixed} is allocated to each cabinet on the basis of budgeted direct manufacturing labour hours. The budgeted variable manufacturing overhead rate for September 2515 is 535 per direct manufacbrring Iabwr-hour. The budgeted xed manufacturing overhead for the month is $42,555. Both variable and xed manufacturing overhead lists are allocated to each unit of nished goods on the basis of direct manufacturing labour-hours. Data relating to finished goods inventory for September 2MB are: Premium De Lune Opening Inventory {units} 2:] 5 Opening Inventory {dollars} $1D.B4D $4,353! Target Ending Inventory BI] 15 Budgeted sales for September 2013 are 'Mf] units of the premium and SEE! units of the De Luxe. The budgeted selling plices per unit in September 2013 are $1,DED for the Premium and $1,6D for the De Luxe. Assume the following in your answer: In Work-in-process inventories are negligible and ignored. on Direct materials inventory and nished goods inventory are costed using the FIFO method. a: Unit costs of direct materials purchased and nished goods are constant in September 2cm. REQUIRED: 1] Prepare the following budgets for September 21:13: 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 S] d} Direct manufacturing labour budget E3 Mg} e} Manufacturing overhead budget (4 Marks} f} Ending inventolies budget [direct materials and nished goods} {5 Marks} g} Cost ofgoods sold budget (4 Marks} For each budget, prepare by product {Premium and De Luxe} and in total