Management Accounting Problem - COMPANY INFORMATION: EXHIBITON FURNITURE
Exhibition Furniture is a desk manufacturer, has been operating in Sydney for 12 years. It makes executive desks i.e. the Chairman desks. In spring 2017, Exhibition furniture's management accountant prepares to arrange budgets for 2018. The following data are gathered to prepare the annual budget:
Materials and Labour requirements
Direct materials
Oak tops - 3 squaremetres per desk
Oak legs - 4 per desk
Direct manufacturing labour - 3 hours per desk
Exhibition furniture's CEO expect to sell 2,000 desks during 2018 at an estimated retail price of $ 800 per desk. Moreover, the CEO expects 2018 beginning inventory of 200 desks, and only 300 desks are in stock at the end of 2018.
Direct material inventories:
|
|
Beginning Inventory 1/1/2018
|
Ending Inventory 31/12/2018
|
|
Oak tops
|
40
|
24
|
|
Oak legs
|
100
|
80
|
Manufacturing overhead (fixed and variable) is allocated to each desk on the basis of budgeted direct manufacturing labour hours per desk. The budgeted variable manufacturing overhead rate for 2018 is $20 per direct manufacturing labor hour. The budgeted fixed manufacturing overhead is $50,000. Variable marketing costs are allocated at the rate $100 per sales visit. The marketing plan calls for 20 visits during 2018. There are $10,000 in fixed non-manufacturing cost budgeted for 2018.
Other data included:
|
|
2017 unit price
|
2018 unit price
|
|
Oak tops
|
$100 per squaremetres
|
$120 per squaremetres
|
|
Oak legs
|
$5 per leg
|
$7 per leg
|
|
Direct manufacturing labour
|
$50 per hour
|
$55 per hour
|
The inventoriable unit cost for ending finished goods inventory on 31 December 2017 is $4,000. Exhibition Furniture uses FIFO inventory method for both direct materials and finished goods. Ignore work in process in your calculations.
Budgeted balances at 31 December 2018 in the selected accounts are:
Cash - $20,000
Property Plant and Equipment (net) - 550,000
Current Liabilities - 30,000
Non-current liabilities - 59,340
Shareholders' equity - 650,000
Part 1 - Answer the following questions
a. Prepare the 2018 revenue budgets (in dollar)
b. Prepare the production budget (in units)
c. Prepare the direct materials usage and purchase budgets for 2018
d. Prepare the direct manufacturing labour budget for 2018
e. Prepare the manufacturing overhead budget for 2018
f. What is the budgeted manufacturing overhead rate for 2018
g. What is the budgeted manufacturing overhead cot per output unit in 2018
h. Calculate the unit cost of desk in closing inventory on 31 December 2018
i. Prepare the ending inventory budget for both direct materials and finished goods for 2018
j. Prepare cost of good sold budget for 2018
k. Prepare the budgeted income statement for the year ending 31 December 2018
l. Prepare the budgeted balance sheet as of 31 December 2018
Part 2 - Suppose Exhibition Furniture decides to incorporate continues improvement into its budgeting process. You are required to provide recommendation (memo) to the CEO two areas where Exhibition Furniture could incorporate continues improvement into the budget schedules in requirement I. To answer this question, you are required to provide minimum 400 words recommendation to the CEO. Apply your comprehensive knowledge in management accounting such as knowledge about company strategies in reducing cost in materials, labour and manufacturing overhead. You may also include analysis of non-manufacturing cost such as marketing cost and consider the company strategic planning to increase sales or profit targets. Please choose the best strategy among those strategies and provide your reasons. Please put some appropriate references.