10 May THEREFORE IF HALLIBURTON ARE NOT LOWERING THEIR PRICES WHY SHOULD I?
Page 1You have just been hired as an accountant by Capital Industries a manufacturer of tools for the oil gas and mining industries based in Geraldton. The tools produced by Capital Industries are specialised high quality tools suited to very specific tasks as required by the oil gas and mining industries and as such are priced accordingly. The owner of the company Brendan Pierce has always believed in pricing a quality product based on how much their larger competitors are pricing theirs. His argument has been that “our product is as good if not better than the mass producers of tools so we should be charging at least as much if not more than what they charge”.When you arrived at work for the first time you learnt that although the company has been in existence for the last twelve years they have never had an accountant. The accounts were typically prepared by the Jodie Watts secretary of Brendan Pierce and Tom Nicholson a part-time accountant who came in once or twice a month. Tom has informed Brendan that he could no longer spare the time to come in and has suggested the need for an accountant on a full time basis which is why you have been hired. Brendan though is still not convinced of the need for a full time accountant. “Look why do I need a full-time accountant? At the end of the day all I need to do is total up my revenues total up my expenses and the difference is my profit. Do I really need to understand my product costs? What is the purpose of that? It’s not like I can lower my prices if my product costs are lower. We have a great product that is better than what the big boys like Halliburton sells. Therefore if Halliburton are not lowering their prices why should I? Why do I need to know what my product costs are?” asked Brendan.Jodie who has been the secretary cum bookkeeper (of sorts) since the day the company started has prepared some information for you. “I do not know much about accounting ” said Jodie. “But Tom has said that we need a Schedule of Cost of Goods Manufactured a Schedule of Cost of Goods Sold whatever those two means and an Income Statement. I have last month’s accounts and some additional information that was prepared by Tom for you. I have also included extra information in there in case you need them though I do not know what is relevant and what is not. So could you please prepare those schedules and the Income Statement and get it to Brendan? He gets cranky when he does not have all the information he needs. ” The information provided by Jodie can be found in Appendix A.Four days into your work there was a fire over the weekend in the main office that stored the accounts. The manufacturing facility was not affected and work could go on however most of the information that was for the current month’s accounts was damaged and only partial fragmentsCASE ANALYSISACCT 2002 Management Accounting Page 2were readable. These are shown in Appendix B. Luckily your work on last month’s accounts were not affected as you had brought them home to complete and was still in process of completing them.“You need to get me back all the information that’s now lost! If you can’t do it I’ll get someone else who can!” cried Brendan when he saw you.Sifting through ashes and interviewing selected employees you have gathered some additional information (Appendix B). Jodie also informs you that an additional piece of information is also included in Appendix B regarding a job that may be of use to you.You are now ready to reconstruct the accounts and give Brendan the information he needs before you lose your job! When you went in to tell him that you can now start working on the information Brendan tells you that he has spoken to Tom (their previous part-time accountant) and that the following information are required: “Tom says we need the following information: the pre-determined overhead rate which is based on direct labour costs the Overhead applied and the balance of the work-in-process accounts. He also suggested that we should be looking at whether the overhead was over- or under-applied whatever that means.”As you were about to leave Brendan stopped you. “Listen Gabriel down in accounts believes that if we can identify the variable and fixed components of our costs it will help us make better planning and control decisions. He thinks that there is a correlation between machine hours and the amount of indirect materials used. He has derived a cost estimate using least-squares regression and provided me with a formula (Appendix C). He said that it was derived from 40 observations. I don’t really understand what it means and neither do most of my senior staff so can you please explain it to us? Someone also said that a high-low method can be used to do the same thing but no one seems to be sure how to do it so can you have a look at the data and analyse it for us?”“Make sure you put all that I have asked for in the report for the next meeting. We will be discussing all of that then!”CASE ANALYSISACCT 2002 Management Accounting Page 3REQUIRED:Prepare a report (no more than 10-pages) for Brendan Pierce that addresses the following:a) The purpose of a product costing system.b) Preparation of a Schedule of Cost of Goods Manufactured Cost of Goods Sold and Income Statement (Use only Appendix A for this section).c) Prepare a Schedule of Cost of goods manufactured and determine the following (based only on Appendix B):i. Predetermined overhead rate for June;ii. Overhead applied for the month of June;iii. Ending balance of the work-in-process inventory in June; and iv. Over- or under-applied overhead in the month of June.d) Discuss how overheads can be over- or under-applied and how the company should deal with the over- or under-application.e) Explain the figures found in the regression equation provided in Appendix C and use it to estimate the cost of indirect materials if 850 machine hours are to be used during a month (assume that 850 machine hours falls within the relevant range).f) Explain how you would determine the validity of the data used for the regression.g) Use the high-low method to estimate the behaviour of the company’s indirect materials cost based on the data in Appendix C. State the cost behaviour pattern in equation form.h) Determine which cost estimate (regression or high-low) you would recommend to Brendan and the senior managers and explain why.CASE ANALYSISACCT 2002 Management Accounting Page 4Appendix ACapital IndustriesStatement of Cost of Goods SoldFor the month ended April 30 2015Inventory of Finished Goods March 31 2015$ 50 000Cost of Goods Manufactured790 000Cost of Goods Available for Sale840 000Inventory of Finished Goods April 30 2015247 000Cost of Goods Sold593 000Capital IndustriesPre-closing Account Balances31 May 2015Cash and Marketable Securities$ 54 000Accounts and notes receivable210 000Direct materials inventory (30 April 2015)28 000Work-in-process Inventory (30 April 2015)150 000Finished Goods Inventory (30 April 2015)247 000Property Plant and Equipment (nett)1 140 000Accounts notes and taxes payable70 000Bonds payable600 000Paid-in capital100 000Retained earnings930 000Sales1 488Purchases of direct materials510 000Freight-inwards for materials purchases*15 000Direct labour260 000indirect factory labour90 000Office salaries122 000Sales salaries42 000Utilities*135 000Rent*9 000Property tax*60 000Insurance*20 000Depreciation*54 000* See additional information overleafCASE ANALYSISACCT 2002 Management Accounting Page 5Appendix A (continued)Additional Information:? Freight inwards is added to the cost of direct materials.? Of the utilities 80% relates to manufacturing of the tools and 20% relates to the sales and administrative functions.? Rent is for the office building? Property taxes are assessed on the manufacturing plant.? 60% of the insurance is related to manufacturing of the tools and the remaining 40% is related to the sales and administrative functions.? Depreciation includes the following:Manufacturing Plant$ 20 000Manufacturing Equipment30 000Office Equipment4 000$ 54 000? The inventory balances at 31 May 2015 follow:o Direct materials $23 000o Work-in-process 220 000o Finished goods 175 000? Income tax rate for the company is 25%.CASE ANALYSISACCT 2002 Management Accounting Page 6Appendix BInventories 1 June 2015Materials inventory (all direct)$ 42 500Work-in-process inventory (Job AG-12)$ 54 000Finished goods inventory$ 75 000Inventories 30 June 2015Materials inventory (all direct)?Work-in-process inventory (Job CZ-46 and Job MT-23)?Finished goods inventory$ 96 080Cost of goods sold June$ 102 000Direct materials purchased June$ 25 000Direct materials issued to production$ 63 340Job AG-12$ 21 340Job CZ-46$ 26 000Job MT-23$ 16 000Factory labour-hours used (rate is $5.50 per hour)Job AG-122 800Job CZ-463 800Job MT-231 700Indirect labour900Other factory overhead costs incurredRent$ 29 500.00Utilities$ 8 600.00Repairs and maintenance$ 4 600.00Depreciation$ 27 100.00Other$ 6 600.00Additional Information:? Application of overhead is based on a predetermined overhead rate. The rate is calculated based on direct labour cost.? Job AG-12 is the only job completed during the month. The total cost of Job AG-12 is $123 080.CASE ANALYSISACCT 2002 Management Accounting Page 7Appendix C? The cost formula as derived by Gabriel:TMC = $190 $5 MH Where TMC = Total monthly indirect materials costMH = machine hours.? Additionally Gabriel has provided the following:o R-squared = 0.8316o Sample size = 40? Gabriel has also prepared data concerning machine hours and indirect material usage for the highest and lowest month of activity (as measured by machine hours) for the past four years which happened to be April and August:AprilAugustMachine hours…………………………..…1 000700Indirect materials:Beginning inventory………………….$1 300$1 000Ending inventory………………………1 3503 000Purchases………………………..………5 9006 200
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.