Question 3 Comprehensive Manufacturing Budget (20 marks) On your return from China you will undertake a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 3 Comprehensive Manufacturing Budget (20 marks) On your return from China you will undertake a 3 month secondment to wholly-owned subsidiary DairyCo based at their Australian Head Office in Albury Wodonga. Prior to your commencement in this role you have been asked to develop comprehensive production and income budget for the baby formula business unit for the next five years from 2018 to 2022 inclusive. The budget should include a sales budget, production budget, purchases budget and include a schedule of cost of goods manufactured, a schedule of cost of goods sold, and an income statement. The budget should be based on the following information: 2017 Financial Information sales Wholesale Price (per unit) Raw Material Cost (per unit) Direct labour (per unit) Manufacturing Overhead (per unit) Inventory 30/06/2017 Closing Inventory Raw Materials units 795,650 Administration Wages & Salaries General Expenses Sales commissions Utilities 886,800 Closing Finished Goods Inventory Units 663,000 WIP is not considered for the purpose of budgeting in this question Other Expenses: $ 37,793,375 5 1 1 1 665,100 1,969,275 1,200,000 375,000 1,300,000 361,250 ● Labour cost increases are expected to be held at the rate of inflation ● ● ● Utility expenses (Power & Water) are predicted to increase at 10% per annum whilst other non- manufacturing ● i. ii. Selling Price is expected to increase at 2% above the inflation rate Raw Material and Manufacturing Overhead costs are budgeted to increase at the inflation rate plus 1% iii. Required: 1. Five Year Budget (15 marks) For the 5 year budget period prepare: iv. The Australian Company tax rate is predicted to remain at 30% 2. expenditure will increase at the rate of inflation Target Raw Material Inventory is 10% of the expected production for the year Target Finished Goods Inventory is the equivalent of 1 month of the current year's sales The theoretical production capacity of the factory is 11,000,000 units and the practical production capacity for budgeting purposes is 10,000,000 units The long range inflation forecast for Australia is 2.5% over the 5-year budget period. Sales, Production and Purchases budget Budgeted schedule of cost of goods manufactured Budgeted schedule of cost of goods sold Budgeted income statement (including tax effect) Increased Production Constraint (5 marks) You are advised that the purchase of a new manufacturing machine can double the production capacity of the firm which is currently limited to 10,000,000 units. The extra cost of the new machine which can be installed for the commencement of the 2019 will be fixed at $200,000 per annum (before tax). In a new worksheet adjust the budget spreadsheet developed in part (a) to reflect this change and show the results. Question 3 Comprehensive Manufacturing Budget (20 marks) On your return from China you will undertake a 3 month secondment to wholly-owned subsidiary DairyCo based at their Australian Head Office in Albury Wodonga. Prior to your commencement in this role you have been asked to develop comprehensive production and income budget for the baby formula business unit for the next five years from 2018 to 2022 inclusive. The budget should include a sales budget, production budget, purchases budget and include a schedule of cost of goods manufactured, a schedule of cost of goods sold, and an income statement. The budget should be based on the following information: 2017 Financial Information sales Wholesale Price (per unit) Raw Material Cost (per unit) Direct labour (per unit) Manufacturing Overhead (per unit) Inventory 30/06/2017 Closing Inventory Raw Materials units 795,650 Administration Wages & Salaries General Expenses Sales commissions Utilities 886,800 Closing Finished Goods Inventory Units 663,000 WIP is not considered for the purpose of budgeting in this question Other Expenses: $ 37,793,375 5 1 1 1 665,100 1,969,275 1,200,000 375,000 1,300,000 361,250 ● Labour cost increases are expected to be held at the rate of inflation ● ● ● Utility expenses (Power & Water) are predicted to increase at 10% per annum whilst other non- manufacturing ● i. ii. Selling Price is expected to increase at 2% above the inflation rate Raw Material and Manufacturing Overhead costs are budgeted to increase at the inflation rate plus 1% iii. Required: 1. Five Year Budget (15 marks) For the 5 year budget period prepare: iv. The Australian Company tax rate is predicted to remain at 30% 2. expenditure will increase at the rate of inflation Target Raw Material Inventory is 10% of the expected production for the year Target Finished Goods Inventory is the equivalent of 1 month of the current year's sales The theoretical production capacity of the factory is 11,000,000 units and the practical production capacity for budgeting purposes is 10,000,000 units The long range inflation forecast for Australia is 2.5% over the 5-year budget period. Sales, Production and Purchases budget Budgeted schedule of cost of goods manufactured Budgeted schedule of cost of goods sold Budgeted income statement (including tax effect) Increased Production Constraint (5 marks) You are advised that the purchase of a new manufacturing machine can double the production capacity of the firm which is currently limited to 10,000,000 units. The extra cost of the new machine which can be installed for the commencement of the 2019 will be fixed at $200,000 per annum (before tax). In a new worksheet adjust the budget spreadsheet developed in part (a) to reflect this change and show the results.
Expert Answer:
Related Book For
Managerial Accounting Decision Making and Performance Management
ISBN: 978-0273764489
4th edition
Authors: Ray Proctor
Posted Date:
Students also viewed these finance questions
-
For what purpose is the schedule of cost of goods manufactured and sold prepared? Do all companies use the statement?
-
Following is the statement of cost of goods manufactured for Vermont Manufacturing Company. Required 1. Journalize, using page 116 of the general journal, the adjusting entries for Raw Materials...
-
Following is the statement of cost of goods manufactured for Carson Manufacturing Company. Required 1. Journalize, using page 116 of the general journal, the adjusting entries for Raw Materials...
-
What will be the sum of third proportional to 18 and 54 and fourth proportional to 12, 18 and LCM of 12 and 18? 1. 162 2. 216 3. 612 4. 256 526 5.
-
How does each of the following factors affect the IS curve? Start your argument from the diagram of Id-Sd and show how the associated change will affect IS curve. a. An increase in government...
-
What is recombination?
-
Write short notes on the application of coal, oil, natural gas, and nuclear energy.
-
The Friendlys in Problem 25 are considering hiring a petroleum analyst to determine the future availability of gasoline. The analyst will report that either a shortage or a surplus will occur. The...
-
The clinic s COO asks you to create a budgeted income statement ( also called a profit and loss statement ) for the clinic for the upcoming fiscal year. She has asked an intern to create a volume...
-
A number of cities are arranged on a graph that has been divided up like an ordinary Cartesian plane. Each city is located at an integral (x, y) coordinate intersection. City names and locations are...
-
The catapult is used to launch a ball such that it strikes the wall of the building at the maximum height of its trajectory. If it takes 1.5 s to travel from A to B, determine the velocity v at which...
-
Discuss the different methods of obtaining a trend projection from past observations to estimate the future demand.
-
What is the difference between economies of scale and economies of density?
-
Explain the differences between qualitative forecasting and quantitative forecasting, and provide an advantage and disadvantage of each.
-
Use the following regression analysis to answer the questions below. The dependent variable is the number of tickets sold per week, and the independent variables are the price of the flight (X1)...
-
Explain how passengers and employees are able to influence the safety practices of an airline.
-
Based on the activities table below; Activity Immediate Predecessors Copmletion time (days) A B C D E F G H I J K A D E B G and I C C J 3 8 5 4 9 2 5 10 6 6 6 Cost* 15,000 40,000 25,000 20,000 45,000...
-
In each of the following independent cases, document the system using whatever technique(s) your instructor specifies. a. Dreambox Creations (www.dreamboxcreations.com/) in Diamond Bar, California,...
-
SACCUS is a local charity which decides to hold an outdoors fund-raising event in mid-summer. The secretary has a connection with an entertainments company which puts on musical laser light shows for...
-
Stellar Showers Co. Ltd manufactures domestic electric showers. It moulds its own plastic casings but buys in the other components from a variety of sources. In addition to 54 production operatives,...
-
Medibed manufactures hospital beds. These are complicated mobile platforms with several moving parts. It is located on the outskirts of Bromsgrove and has good connections to the motorway system....
-
Do you believe that fraud in the United States is more or less prevalent than fraud in countries outside the United States? Why?
-
How would a fraudster conceal missing cash, especially amounts of this magnitude?
-
Why is it difficult to convict organized crime leaders?
Study smarter with the SolutionInn App