{"id":7077,"date":"2025-10-13T06:15:17","date_gmt":"2025-10-13T06:15:17","guid":{"rendered":"https:\/\/assignmenttask.com\/answers\/?p=7077"},"modified":"2025-10-13T06:26:04","modified_gmt":"2025-10-13T06:26:04","slug":"accy5104-budgets-for-planning-and-control-assignment-2","status":"publish","type":"post","link":"https:\/\/assignmenttask.com\/answers\/accy5104-budgets-for-planning-and-control-assignment-2\/","title":{"rendered":"ACCY5104 Budgets for planning and control Assignment 2"},"content":{"rendered":"<blockquote><p><em>Do you want ACCY5104 Budgets for planning and control Assignment 2 Solutions? No, worry. Our expert assignment writers cover all types of assignments, such as <a href=\"https:\/\/assignmenttask.com\/accounting\/cost-accounting-assignment-help.html\"><strong>Cost accounting<\/strong><\/a>, <a href=\"https:\/\/assignmenttask.com\/accounting\/advanced-accounting-assignment-help.html\"><strong>Advanced accounting<\/strong><\/a>, <a href=\"hhttps:\/\/assignmenttask.com\/finance\/financial-accounting-assignment-help.html\"><strong>Finance accounting<\/strong><\/a>, and more, under one roof. We provide 100% plagiarism-free and AI-free content and on-time delivery with 24\/7 live chat support.<\/em><\/p><\/blockquote>\n<p><a href=\"https:\/\/assignmenttask.com\/order-now.php\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1261 lazyload\" data-src=\"https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment.jpg\" alt=\"Order-Your-Assignment\" width=\"600\" height=\"150\" data-srcset=\"https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment.jpg 600w, https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment-300x75.jpg 300w, https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment-360x90.jpg 360w\" data-sizes=\"(max-width: 600px) 100vw, 600px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 600px; --smush-placeholder-aspect-ratio: 600\/150;\" \/><noscript><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1261\" src=\"https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment.jpg\" alt=\"Order-Your-Assignment\" width=\"600\" height=\"150\" srcset=\"https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment.jpg 600w, https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment-300x75.jpg 300w, https:\/\/assignmenttask.com\/answers\/wp-content\/uploads\/2019\/04\/Order-Your-Assignment-360x90.jpg 360w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"148\"><strong>Task 1<\/strong><\/td>\n<td width=\"378\"><strong>Budget Amendments<\/strong><\/td>\n<td width=\"92\"><strong>(32.5 marks)<\/strong><\/td>\n<\/tr>\n<tr>\n<td colspan=\"3\" width=\"618\">Your starting point for this part of the assessment is the supplied Excel budget file provided on Moodle <em>(filename: ACCY5104 &#8211; Assessment 2 2025 S2 Starting File).<\/em><\/p>\n<p>Use Excel to amend the budget for the six months ending 31 December 2025 for Riley Jones who owns and operates \u201cTechTrio Gadgets\u201d considering the information that follows:<\/p>\n<ul>\n<li>Interest on Overdrawn Bank Account<\/li>\n<\/ul>\n<p>If the opening balance of the bank account in any month is less than zero, overdraft interest will be paid based on that amount.<\/p>\n<p>The current overdraft interest rate is 16% per annum. Calculate overdraft payments in the Cash Payments Budget Add overdraft payments to the Income Statement.<\/p>\n<p>Overdrawn bank accounts must be included as a current liability, not a negative current asset.<\/p>\n<ul>\n<li>Interest on Bank Loan<\/li>\n<\/ul>\n<p>Each month, interest will be paid based on the opening balance of the loan for that month. The current interest rate for the loan is 12.75% per annum.<\/p>\n<p>Create a loan repayment and interest payment schedule on the Input Page and add the loan interest payments to the Income Statement.<\/p>\n<ul>\n<li>Depreciation on Property, Plant and Equipment<\/li>\n<\/ul>\n<p>The equipment in the balance sheet was purchased on the last day of June, so has not yet had any depreciation deducted.<\/p>\n<p>It is expected that $52,000 will be spent on new equipment in August. All equipment is depreciated at 15% per annum on a straight-line basis.<\/p>\n<ul>\n<li>GST<\/li>\n<\/ul>\n<p>Turnover has reached the point where TechTrio Gadgets needs to register for GST. For the purposes of the assignment assume that:<\/p>\n<p>The GST rate is 15%.<\/p>\n<p>All items in the original file are exclusive of GST, and that if GST is applicable to them, that GST will be added to them.<\/p>\n<p>TechTrio Gadgets registered for GST effective 1 July 2025.<\/p>\n<p>No GST payments or receipts were recorded, no GST is owed, and no GST refund is due at the end of June 2025.<\/p>\n<p>TechTrio Gadgets will submit GST returns for the two-month periods ending August, October, and December, and that any GST to be paid or GST to be refunded will be paid in the following month.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"526\"><strong>Tasks<\/strong><\/td>\n<td colspan=\"2\" width=\"92\"><\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"618\">Modify the budget to include GST calculated using the payments (cash) method:<\/p>\n<p>Add GST rate to the Input Page.<\/p>\n<p>Add GST calculations to the Cash Receipts Budget.<\/p>\n<p>Add GST calculations to the Cash Payments Budget.<\/p>\n<p>Add GST to the Balance Sheet.<\/p>\n<p>(17.5 marks)<\/td>\n<\/tr>\n<tr>\n<td width=\"148\"><strong>Task 2<\/strong><\/td>\n<td colspan=\"2\" width=\"384\"><strong>Create a Dashboard<\/strong><\/td>\n<td width=\"86\"><strong>(4.5 marks)<\/strong><\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"618\">TechTrio Gadgets would like to know the effects of changing the various amounts in Cash Payments and Cash Receipts on monthly cash balances and income. Create a dashboard in the Excel file.<\/p>\n<p>On the dashboard the following should be entered, with the input page linking back to these values:<\/p>\n<ul>\n<li>items listed as \u2018Other Cash Payments\u2019 on the Input Page.<\/li>\n<li>All items listed as \u2018Other Cash Receipts\u2019 on the Input Page.<\/li>\n<\/ul>\n<p>The dashboard should also include the following:<\/p>\n<ul>\n<li>The closing bank account balance for each of the six (6) months.<\/li>\n<li>A formula calculating the minimum bank account balance over the (6) month budget period.<\/li>\n<li>The net profit across each of the six (6) months.<\/li>\n<li>Input page links to figures on dashboard page<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"148\"><strong>Task 3<\/strong><\/td>\n<td width=\"378\"><strong>Written Report: Analyse the Reworked Budget<\/strong><\/td>\n<td colspan=\"2\" width=\"92\"><strong>(10 marks)<\/strong><\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"618\"><strong><em>Please submit your Task 3 written report and Task 4 internal controls as one document only.<\/em><\/strong><\/p>\n<p>Write a report for Ryan Jones of TechTrio Gadgets including the following:<\/p>\n<p>A discussion of how the changes made to the original budget have changed the cash summary, income statement, and balance sheet.<\/p>\n<p>An analysis, using what-if analysis and the goal-seek function, covering the following questions TechTrio Gadgets would like answered:<\/p>\n<ul>\n<li>What is the most that TechTrio Gadgets can spend on equipment in August if he wants to avoid a negative cash balance during the (6) six-month budget period?<\/li>\n<li>What is the effect of changing the August equipment purchases on Net Profit? Your answer should explain why changing the equipment purchase will affect net profit.<\/li>\n<\/ul>\n<p>Use screenshots of the Goal Seek results and Dashboard to support your answer.<\/p>\n<p>This part of the report should have:<\/p>\n<ol>\n<li>An introduction.<\/li>\n<li>Discussion of how changes to the budget have affected:<\/li>\n<\/ol>\n<ul>\n<li>The Cash Summary,<\/li>\n<li>The Income Statement,<\/li>\n<li>The Balance Sheet<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"148\"><\/td>\n<td width=\"378\"><\/td>\n<td width=\"6\"><\/td>\n<td width=\"86\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<td colspan=\"3\" width=\"526\"><strong>Tasks<\/strong><\/td>\n<td width=\"92\"><\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"618\">(iii)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A clear statement of the most TechTrio Gadgets can spend on equipment purchases in August while avoiding a negative cash balance over full the budget period, with screenshots provided for supporting evidence.<\/p>\n<p>(iv)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 An overall conclusion.<\/td>\n<\/tr>\n<tr>\n<td width=\"56\"><strong>Task 4<\/strong><\/td>\n<td width=\"361\"><strong>Internal Controls<\/strong><\/td>\n<td colspan=\"2\" width=\"201\"><strong>(18 marks)<\/strong><\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"618\">Riley Jones of \u201cTech Trio Gadgets\u201d has been advised by his auditor that they have concerns about four (4) internal control issues in the business:<\/p>\n<ol>\n<li>Cash from customers is kept in an unlocked drawer until the end of the week.<\/li>\n<li>Only one staff member is responsible for ordering parts, receiving deliveries, and updating inventory.<\/li>\n<li>Customer repair jobs are recorded on paper slips, which are sometimes misplaced.<\/li>\n<li>Staff use a shared login to access the accounting software. Required:<\/li>\n<\/ol>\n<p>Write a short report to Mr Jones includes an introduction, a section for each of the four (4) issues raised above.<\/p>\n<p>The report\u2019s introduction should explain the importance of good accounting controls and the<\/p>\n<p>purpose of the report.<\/p>\n<p>For each issue, the section should:<\/p>\n<ul>\n<li>Describe the problem.<\/li>\n<li>Explain the risk that the business is exposed to.<\/li>\n<li>Recommend how Mr Jones should respond to the issue.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"56\"><\/td>\n<td width=\"361\"><\/td>\n<td width=\"109\"><\/td>\n<td width=\"92\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><em style=\"text-align: center;\"><strong>Also Checkout- <\/strong><a href=\"https:\/\/assignmenttask.com\/blog\/top-10-accounting-problems-to-solve-with-ease\/\"><strong>Solve 10 Biggest Accounting Problems for Students<\/strong><\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you want ACCY5104 Budgets for planning and control Assignment 2 Solutions? No, worry. Our expert assignment writers cover all types of assignments, such as Cost accounting, Advanced accounting, Finance accounting, and more, under one roof. We provide 100% plagiarism-free and AI-free content and on-time delivery with 24\/7 live chat support. Task 1 Budget Amendments (32.5 marks) Your starting point for this part of the assessment is the supplied Excel budget file provided on Moodle (filename: ACCY5104 &#8211; Assessment 2 2025 S2 Starting File). Use Excel to amend the budget for the six months ending 31 December 2025 for Riley <a href=\"https:\/\/assignmenttask.com\/answers\/accy5104-budgets-for-planning-and-control-assignment-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[655],"tags":[],"_links":{"self":[{"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/posts\/7077"}],"collection":[{"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/comments?post=7077"}],"version-history":[{"count":10,"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/posts\/7077\/revisions"}],"predecessor-version":[{"id":7087,"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/posts\/7077\/revisions\/7087"}],"wp:attachment":[{"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/media?parent=7077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/categories?post=7077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttask.com\/answers\/wp-json\/wp\/v2\/tags?post=7077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}