FNSACC412 Assignment

Assessment Coversheet Unit/s AssessedFNSACC412 Prepare Operational BudgetsAssessment NameFNSACC412 Assignment Type of Assessment This summative assessment will enable your assessor to make a judgement of competency based on the submission of your completed assessments against the requirements of the unit/s of competency in this module. Benchmark The Assessment Benchmark developed for each unit of competency is the evidence criteria used to judge the quality of performance (i.e. the assessment decision-making rules). Assessors use these benchmarks to make judgements on whether competency has been achieved and to determine if you have performed to the standard expected to meet the unit requirements. Reasonable Adjustment Where appropriate Monarch Institute will allow flexibility in the way in which each unit is assessed based on the needs of an individual. Assessment Coding Assessment of this course is based on competency-based principles. S = Satisfactory NS = Not Satisfactory If you fail to perform satisfactorily for the assessment in the prescribed way you may be assessed as ‘Not Satisfactory’. You are required to be assessed as ‘Satisfactory’ in all assessments for each unit of competency. Re-assessment Your assessment can be submitted after you have reviewed the learning materials and practiced enough to feel confident in your resubmission. You have two weeks from your last submission feedback to resubmit. You are re-assessed in only the areas where your assessor has indicated you were initially assessed as NS. It is at the assessor’s discretion to re-assess the entire assessment should an overall understanding not be demonstrated.  When you are re-assessed as ‘satisfactory’ after re-submission you will achieve competency for this assessment. Declaration of Understanding and Authenticity I acknowledge the assessment process has been explained and agree that I am ready to undertake assessment. I am aware of where to find the assessor’s feedback for the assessment. I am aware of the appeals process, should the need arise. I also understand I must be assessed as ‘satisfactory’ in all parts of the assessment/s to gain an overall competent result for the unit/s of competency. If I am found to be NS after a second attempt, it is at the assessor ‘s discretion whether I may be permitted one final attempt. I am aware that a ‘not competent’ final outcome means I may incur fees for re-enrolment in the unit/s. I certify that the attached material is my original work. No other person’s work has been used without due acknowledgement. I understand that the work submitted may be reproduced and/or communicated for the purpose of detecting plagiarism. I understand a person found responsible for academic misconduct will be subject to disciplinary action (refer to Student Information Guide). * I understand that by typing my name or inserting a digital signature into this box that I agree and am bound by the above student declaration. Student Name*:Date: Submission instructions: Complete the Declaration of Understanding and Authenticity (above).Once you have completed all parts of the assessment login to the Monarch Learning Management System (LMS) to submit your assessment.In the LMS, click on the link to ‘Submit [assessment name]’ in your course and upload your assessment files. Click save and then click submit assignmentPlease be sure to click ‘continue’ after clicking ‘submit assignment’. Assessment Activities Short Answer and Worked Answer Questions FNSACC412 – Prepare operational budgets The following questions are based on the material in the textbook “Prepare Operational Budgets” by Richard Hughes & Tony Kirby, 6th Edition (January, 2016). Activity instructions to candidates This is an open book assessment activity.You are required to read this assessment and answer all questions that follow.Please type your answers in the spaces provided.Please ensure you have read “Important assessment information” at the front of this assessmentEstimated time for completion of this assessment activity: 2-3 hours The following questions are based on the material in Chapter 1: Q1. James Ltd produces a single product which it sells for $100.00 per unit. The product requires $45.00 per unit in variable costs to produce and sell, and fixed costs per annum are $1,100,000. Determine: The dollar sales necessary to break even; and The income statement if 18,000 (Pessimistic) or 22,000 (Optimistic) are sold. Breakeven dollars. (Show your workings) Income Statement Projected IncomeStatement18,000Units22,000UnitsSales revenueLess: Variable costsContribution MarginLess Fixed costsProfit (Loss) beforetax Q2. (a) Sharp View Software wish to produce an expenses budget for the year ending 30 June 2016 based on the previous year’s actual figures. ExpensesforYearended30June2015Sales Commissions$ 350,000Consultancy Fees136,000Wages482,000Telephone16,000Stationery11,000Repairs9,600 The following assumptions are used to prepare the budget: Sales commissions and consultancy fees are expected to fall by 5% due to less demand within the industry.Wages will rise by 3%.Telephone costs will fall by 5% due to a new contract being negotiated.Stationery costs will rise by 5%.Repairs: no change. Sharp View Software – ExpensesBudgetforYearended30June2016Y/E30June2015%ChangeY/E30June2016Sales commissionsConsultancy feesWagesTelephoneStationeryRepairsTotal (b) When would it be appropriate for a firm to use qualitative forecasting techniques instead of quantitative forecasting techniques? The following questions are based on the material in Chapter 2: Q3. City Mowers Pty Ltd are wholesalers of two types of mowers. The sales for the quarter ending 31 December 2015 were as follows: UnitsSellingPriceMowerXOctober1,500$149.00November1,300December1,400MowerYOctober2,000$185.00November2,500December2,700 Predictions are that the sales volume for mower X will increase by 7% in January and increase by 5% for both February and March. (Based on the figures for October, November and December respectively). Sales for Mower Y are expected to decrease by 5% for January, February and March. (Based on the figures for October, November and December respectively.) Required: Using the format below, prepare separate Sales Budget for each of Mower X and Mower Y, for the three months ending 31 March 2016. Mower X – Actual and Budgeted salesACTUALBUDGETEDOctoberNovemberDecemberJanuaryFebruaryMarchTOTALExpected change   %%% Selling price $       Unit sales       Sales revenue $       Mower Y – Actual and Budgeted salesACTUALBUDGETEDOctoberNovemberDecemberJanuaryFebruaryMarchTOTALExpected change   %%% Selling price $       Unit sales       Sales revenue $       Total Budgeted Sales Revenue (both products)$ Q4. Hay and List is a firm of accountants. Between them, the two partners work 2,800 hours per annum. The current charge­out rate is $200 per hour. Next year the charge out rate will increase by 10%. The firm’s current market share of billable hours is 10% and this is expected to grow to 15% next year. Required: Prepare a fees income budget for the year. Use the layout below to show your workings. Fee Income Budget: Size of current total billable accounting market = _________________________ = ________ hours Predicted hours for next year = _________% of total hours = ________x ________ = _______hours New charge out rate =____________x ________ = $________ per hour Budgeted fees income = __________hours at $ ___________per hour = $____________ The following questions are based on the material in Chapter 3: Q5. The company, Out­of­It’s, expected revenues and expenses for the quarter ended 31 December are: OctoberNovemberDecemberProjectedSales$135,000$160,000$145,000 Monthly expenses: Wages&Salaries(split Marketing 55%, Administration 45%)$ 20,000DepreciationofMotorVehiclesformarketingactivities1,200Depreciation of fixtures andfittings (split Marketing 55% and Administration 45%)1,500Stationeryforadministrationactivities900Rent for administrationactivities600Interest onloan500Generalexpenses(split Marketing 60% and Administration 40%)1,000Bankcharges75Advertising $1,200 p.m. plus 3% ofsalesCommission 4% ofsalesCartage 2% ofsalesDiscount Allowed 1.5% ofsalesPayroll on costs being 5.0% ofWages and Salaries Required: Prepare a classified expenses budget for the quarter ending 31 December using the table below. Tip: Ensure that all expenses are for the quarter, i.e. 3 months. ClassifiedExpensesBudget – Quarter ending31December Budgeted sales revenue for Dec quarter = $_____________________ MarketingAdministrationFinancialTOTAL $Wages and salariesDepn of motor vehiclesDepn of fixtures & ftgsStationeryRentInterest on loanGeneralBank chargesAdvertisingCommissionsCartageDiscount allowedPayroll on-costsTotal Budgeted Expenses The following questions are based on the material in Chapter 4: Q6. The following information relates to the business of Sweet Idea. Actual Credit Sales amount to: MarchAprilMay$7,000$5,000$4,000 Customers normally pay their debts at the following rate: 60% in first month after sale • 40% in second month after sales Estimated Credit Sales: JuneJulyAugust$3,000$6,000$8,000 Required: Prepare an Accounts Receivable collections budget, for the months of June, July and August (no GST). SweetIdeaAccountsReceivableCollectionsBudgetAprilMayJuneJulyAugustCredit SalesCollections:One Month after saleTwo Months after saleTotal Receipts Q7. From the information provided by Better Land below, prepare a cash payments budget for the quarter ended December 31 (no GST). Expected purchases for the budget period are: OctoberNovemberDecember$6,50012,00015,000 Cash expenses to be incurred during the period: Rent, $6,600 per monthWages, $8,500 in October and November and $14,000 in December Marketing expenses $2,200 in October, increasing to $3,600 in November and December.Administration and general expenses $5,200 per month.Financial expenses $420 per month. Otherinformation: Inventory purchases are paid for in the month following purchase.The balance of Accounts Payable on September 30 is $4,840. Required: Prepare a cash payments budget for the quarter ended December 31 (no GST). Cash Payments Budget OctoberNovemberDecemberPurchasesRentWagesMarketing ExpensesAdmin & General ExpensesFinancial ExpensesTotalpayments Q8. Prepare a cash budget for Messara for January, February and March. All amounts below include GST where applicable. Expected receipts are: Cash SalesCollections from A/cs ReceivableJanuary5,8009,500February6,6008,200March7,9006,800 Budgeted purchases and wages are: PurchasesWagesDecember11,000—January13,2002,900February15,4002,700March17,6002,500 50% of purchases are paid in the month they are incurred. The rest are paid the following month. Wages are paid in the month they are incurred. The bank account balance at 31 December is $9,200. Required: Prepare the cash receipts, cash payments and cash budgets for Messara for January, February and March. ReceiptsBudgetJanuaryFebruaryMarchCash salesCollections from DebtorsTotal receipts PaymentsBudgetDecemberJanuaryFebruaryMarchPurchasesPayments:Same monthOne monthWagesTotalpayments CashBudgetJanuaryFebruaryMarchOpening Cash BalanceAdd: Receipts= Cash AvailableLess: Payments= Ending Cash Balance Q9. Video role play task You are the bookkeeper for Brad’s Vegan Ice Creamery. The business has had a bumper year in terms of sales volumes, but there are concerns about the fall in profits. Bradley Stanton, the owner of Brad’s Vegan Ice Creamery, has called a meeting with you (the bookkeeper) and the Melinda (sales manager) to discuss the results of operations for the year. In your meeting, you’ll discuss: The information belowMilestones and performance indicatorsThe variances in the budget, and what they meanBrad and Melinda’s views and opinions on the budget informationPlans to manage the budget for the coming year Sales volumes: Budget 750,000 litres; Actual 795,000 litres Profit & LossBudget ($000)Actual ($000)Variance ($000)Sales$12,000$14,310$ 2,310 FavourableLess Cost of goods sold$ 6,750$ 8,586$ 1,836 UnfavourableGross profit$ 5,250$ 5,724$ 474 FavourableLess operating expenses:Wages & commission$ 1,800$ 1,940$ 140 UnfavourableRent$ 800$ 800$ 0Advertising$ 650$ 890$ 240 UnfavourableInsurance$ 240$ 240$ 0Other$ 100$ 230$ 130 UnfavourableTotal expenses$ 3,590$ 4,100$ 510 UnfavourableNet Profit$ 1,660$ 1,624$ 36 Unfavourable General instructions: • Students must perform with at least 1 other person. Using just 1 other person to play multiple roles is completely OK. Alternatively, you can use as many other persons as there are roles. • The other person(s) can play multiple roles except for the role required to be played by the student. • There is no requirement for the other person(s) to be visible in the video, so if your partner(s) would prefer not to be visible, that’s OK. • The student must be visible throughout the video. • All persons must be audible throughout the recording. • Using a camera phone is often a quick and easy way to record the video. Instructions You will need at least one partner for this exercise, to read/play the parts of the other stakeholders. Give them the role play script titled ‘Budget meeting’. You only need one partner; they can read all the parts other than yours. Note: You will need a calculator to perform some basic calculations before performing this role play. Read the script to determine what you’ll need to calculate and prepare yourself and the figures before you begin the role play. Video record your meeting with Brad and Melinda at Brad’s Vegan Ice Creamery. Follow the video recording process you’ve used before (also on the LMS). Upload the meeting video recording when you upload this written assignment document. Please name your roleplay file with your surname followed by mod 4.2. For example, Smith Mod 4.2 Criteria For this task, you’re being assessed on your ability to: Student makes an effort to build rapport with colleaguesStudent discusses budget variance with the ownerStudent clarifies budget resultsStudent engages with the owner regarding costsStudent elicits owner and sales managers’ opinions on budget targets/ideasStudent answers question about reduced COGS impact on profit projection Q9 Video role play task Brad’s Vegan Ice Creamery Budget meeting Role Play Script Notes: This role play has three different roles, including the student/bookkeeper. You: bookkeeperBrad: ownerMelinda: sales manager Instructions: Remember what you’re being assessed on: your operational budget skills and your communication skills, as outlined in the instructions for Q9. If you only have one partner, they read/play all the roles except yours. You’ll need to have the answers to previous questions ready to guide you in this discussion.The parts are indicated with names in brackets, like this: [YOU] [BRAD]When something is written in bold, it’s just a guide – not a line you have to read word-for-word. There’s often no script for what you say; just guidelines. That’s part of the challenge! Don’t read these lines out. Instead, answer in a way that fulfils the guidelines. For example, if the guideline for you were: [YOU]: Name and describe a fruit. Say something good and something bad about the fruit. …you might say “Apples. They’re red, juicy, and crunchy. They’re high in fibre, but you can’t eat the core.” Normal speech is written as follows. Read these parts out.[MARY]: Let’s get this meeting started. Instructions for actions or body language are written in italics as follows. Don’t read these parts out.[FRED]: Look angry and raise your hand. – – – – – – – [BRAD]: Thanks for coming to this meeting. First things first: good work, everyone! It looks as if our sales this past year exceeded the budget. We were expecting to sell 750,000 litres of ice cream, like last year, but it turns out we sold 795,000 litres. Credit goes to our sales staff for their hard work! [YOU]: Say something nice to Melinda about her sales result. [MELINDA]: Smiling [MELINDA]: Thanks! Our full range is now in more stores than ever before. [BRAD]: I’m pretty happy about the sales volume. There’s just one thing I am concerned about: our costs. Despite increased sales, actual net profit is down compared to the budgeted net profit figure. [MELINDA]: Oh, that’s disappointing. Can you tell us the profit figures? [YOU]: Confirm the Actual and Budgeted Net Profit and variance figures to Melinda and Brad. [BRAD]: Given sales have increased, what could explain the fall in net profit? [YOU]: Tell Brad and Melinda why you think profits are down.Refer to the numbers in the budget information and highlight the unfavourable cost/expense variances, especially mention the largest unfavourable cost variance. [BRAD]: OK, thanks for that. I know the volume of sales has increased, but has the per litre selling price changed? [MELINDA]: Yes, good news! The selling price per litre actually increased slightly compared to budget. [BRAD]: Turns to bookkeeper [BRAD]: Can you tell us exactly how much was the actual and budget price per litre? [YOU]: Tell Brad and Melinda the dollars per litre actual price per litre and budgeted price per litre (TIP: you’ll need to calculate this using Sales dollar amount divided by Sales volume for Actual and then for Budget. You can do this before commencing the role play). [BRAD]: That’s awesome! So it seems costs are where we should focus our attention. [BRAD]: Turns to bookkeeper [BRAD]: So what can we do to control these costs? [YOU]: Talk Brad and Melinda about one of your ideas for controlling costs. For example, you’ll try to reduce Cost of Goods Sold by 10% while maintaining the same sales volume. [BRAD]: Sounds good! Just based on that idea alone, how much of an increase in profit do you think we can make over the next year, assuming all other sales and expense amounts remain constant? [YOU]: Explain how your idea would have an impact on profits.Suggest some budget process and review milestones to implement your idea. For example, you’ll target reducing COGS by a small percentage each quarter to achieve a total 10% reduction for the year. You’ll plan to do the calculations and review each month to make sure you are on track to hit your quarterly milestone targets.Ask Brad and Melinda what they think of the idea. [BRAD]: Great, sounds like a good idea! [MELINDA] Yeah, that’s definitely worth trying. [BRAD]: OK, thanks everyone, that’ll do for now. Let’s get to work! – – – – – – –

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

Leave a Reply

Your email address will not be published. Required fields are marked *