The Royal Paint factory in Tasmania is responsible for manufacturing the Organic Foundation product. The factory employs a process costing system. The process for manufacturing the Organic Foundation involves mixing all the ingredients. The ingredients are then poured into round containers and vigorously shaken. It is assumed for process costing purposes that all raw material ingredients are added at the commencement of the process. Packaging into pyramid-shaped boxes occurs when the manufacturing process is 70% complete. For the purpose of accounting, the conversion costs of manufacturing are assumed to occur evenly across the whole of the production cycle.

The following information relates to the production of Organic foundation during the month of November.

Work in process 01/11/2019		100,000
	Stage of completion	Value
Raw materials	100%	$ 120,000
Packaging	100%	$ 25,000
Conversion	65%	$ 20,000
Work in process - 30/11/2019	360,000
WIP - 30/11/2019 complete	60%
Cars commenced in November	400,000
Costs incurred
Raw materials	$ 28,000
Packaging	$ 82,500
Conversion	$ 175,500

Required:

1. Using the Weighted Average Cost Method, determine the cost value of closing WIP and the cost value of goods transferred out during the period. (7 marks)
2. Using the First in First Out (FIFO) method, determine the cost value of closing WIP and the cost value of goods transferred out during the period. (8 marks)

Question 2 Comprehensive Manufacturing Budget (30 marks)

You have been asked to prepare a 3-year budget forecast for the manufacturing of an organic lipstick. Royal Paints utilises a traditional manufacturing cost flow inventory and accounting system and has provided you with the following information for 2019.

2019 Year data
Sales (units)	750,000
Price (average 2015 price received)	$15.95
Prime Costs (per unit)
Ingredients & Packing	$4.50
Direct Labour	$3.50
Manufacturing Costs (per unit)	$4.00
Factory Management Salaries (per annum)	$250,000
Factory Plant & Equipment Depreciation (per annum)	$350,000
Sales and Marketing Costs (per annum)	$700,000
Finance Costs (per annum)	$888,000
Non-Factory Administration Costs (per annum)	$685,000

Inventory on Hand (at valuation):
Ingredients & Packaging (250,000 units)	$1,125,000
Finished Goods (175,000 units)	$2,790,000

Royal Paints maintains a target safety stock of raw materials inventory and finished goods inventory amounting to the equivalent of three (3) weeks of the current years budgeted unit sales. At the end of the 2019 calendar year, there were 175,000 completed units of Organic Lipstick in the warehouse as Finished Goods. There are enough raw materials on hand to manufacture a further 250,000 units of organic lipstick.

The Marketing Department at Royal Paint predicts that unit sales of the organic lipstick will continue to grow for the next 3 years at a rate of 5%, however after those 3 years sales will drop off significantly. The company is budgeting to achieve a year on year price increase of 3.5%. All other costs including direct labour, material costs, and other overhead and administration costs are expected to increase annually at the same rate of 3.5%. The company pays tax at the Australian corporate tax rate which is expected to hold at 30%.

Royal Paint recently had to modify an old Dulux paint factory to be able to manufacture organic lipstick. However, due to the expected growth in sales, the factory is nearing its practical manufacturing capacity of 825,000 lipsticks.

Required:

1. Using Excel develop a Sales, Production and Purchase budget, as well as a budgeted Schedule of Cost of Goods Manufactured, Schedule of Cost of Goods Sold, and an Income Statement for each of the 3 years in the budget period, commencing January 1, 2020. (Advice on the form of these budgets is linked through the online topic modules and in the Interact Resources folder and is also available in the Appendix to Chapter 9 of the textbook). This budget must also take into account the manufacturing facility's practical capacity production constraint. Your spreadsheet must include a data section which enables inputs (such as the budgeted cost and sales increases, and the production limit) to be simply altered and what if analysis to be undertaken. (Excel resources are provided on your Interact site to guide you on the use of the IF formula which can be used for the budget production constraint).(15 marks)

Hint: All 3 years of each budget should be shown side by side (1 column per year) for ease of comparison by management. All of the budgets should be presented on one worksheet together, working down the page commencing with the Sales and then Production budgets. You should be able to drag the formula across for the whole of the budget if the first years are properly constructed with a data input section and using absolute referencing. This makes the process much quicker and easier. An Excel help file and video which deals with the formula required has been placed in the Resources folder on the Interact site to assist students (linked through topic module 3).

2. If sales continue to grow beyond the expected 3 years, the practical production capacity of 825,000 units will constrain Royal Paint in a couple of years. The CEO of Royal Paint has the option of investing in new plant equipment for $10 million dollars which will be ready to start manufacturing by 2021. The new equipment will increase production capacity to 1.1 million units per annum and be depreciated on a straight-line basis over its 15-year useful life.

Using the Excel model developed in part 1. calculate the impact on sales and profit if the option of upgrading the manufacturing facility is exercised and the practical production capacity of the factory is increased to 1.1 million (Include the additional factory depreciation expense as a manufacturing cost. Submit results as a separate worksheet). (5 marks)

3. Given your findings from part 1. and 2. write a memorandum report for the CEO of Royal Paint recommending whether to take up the option to upgrade the production facility. In your report consider all of the strategic and financial implications to the firm of reaching its production constraint and any implications or opportunities arising from upgrading the facility and having extra productive capacity. Your grade will depend on the accuracy and depth of your analysis, and your capacity to identify strategic issues that management should consider when making their decision (Maximum of 400 words). (10 marks)

Question 3 Support Service allocation (15 marks)

Royal Paints manager has queried you on the budget but in particular about the service costs and how they are allocated. The production department has been categorised into Manufacturing and Packaging. These are supported by Maintenance and IT departments. Royal Paint allocates maintenance costs based on the number of repair jobs and services whereas IT costs are allocated based on the number of jobs logged online or manually.

You are provided with the following information:

Manufacturing	$625,000
Packaging	$285,000
Maintenance	$30,000
IT	$75,000

Department	No. of Maintenance (repairs and services)	No. of IT (online and manual jobs logged)
Manufacturing	26	68
Packaging	54	45
Maintenance	17	15
IT	25	10

Required:

1. Using the Direct Method allocate the service centre costs. (2 marks)
2. Using the Step Method allocate the service centre costs. (4marks)
3. Using the Reciprocal Method allocate service centre costs. 6 marks)
4. Discuss the implications of your results and why such an analysis is important. (3 marks)