Sheet Student name: Student ID:​ Student email: Phone: Course name: Diploma of Hospitality Management​ Course code: SIT50416 Unit of competency code:SITXFIN004 Unit of competency Name:Prepare and...

1 answer below »

Sheet

























Student name:Student ID:​
Student email:Phone:
Course name: Diploma of Hospitality Management​Course code: SIT50416
Unit of competency code:SITXFIN004Unit of competency Name:Prepare and monitor budgets
Task Number:Trainer name:





●I declare thatthe work contained in this Assessment Task is my own, except whereacknowledgement of sources is made. I keep copy of these assignment submitted for my record.



●I have read the BIT’s Plagiarism Policy and Procedures.



●I understand the consequences of engaging in plagiarism and collusion.













Student signature:





Date:





Please note: You are advised to keep a copy of all your work submitted to the institute.



For office use only:












Date received from student:





Name and signature of Trainer/Assessor:












✂--------------------------------------------------------------------------------------------------------Student Receipt (to be completed by BIT staff only)




















Unit(s) of competency (code and name):SITXFIN004-Prepare and monitor budgets






Student name:




Student ID:




Staff member signature:




Date:























This page intentionally blank
















ASSESSMENTSUMMARY /COVER SHEET







































































This form is to be completed by the assessor and used as afinal record of student competency.


All studentsubmissions including any associated checklists (outlined below) are to be attached to this cover sheet before placing on the students file.


Student results are not to be entered onto the StudentManagementDatabase unless all relevant paperwork is completed and attached to this form.



Student Name:





Student ID No:





Final Completion Date:





Unit Code:



SITXFIN004



Unit Title:



Prepare and monitor budgets



Please attach the following documentation to this form



Date



Result


S = Satisfactory


NS = Not Satisfactory


NA = Not Assessed





Date





Reassessment


S = Satisfactory


NS = Not Satisfactory


NA = Not Assessed



Assessment1



●Debtors control ledger attached


●Stock control ledger attached


●Creditors control ledger attached


●Budgeted cash flow statement attached


●Comments on cash flow attached


●Budgeted P&L Statement attached


●Report on expected performance attached


●Checklist attached





S | NS | NA





S | NS | NA



Assessment2



●​Initial budget attached


●​Written recommendations for new vehicle attached


●​Updated budget attached


●​Recommendation attached


●Checklist attached





S | NS | NA





S | NS | NA



Assessment3



●Budget variance report attached


●Predicted cash balance attached


●Actual cash balance attached


●Report outlining probably variance reasons attached


●Answer re: Quarterly vs Monthly budgets attached


●Cash Flow Budget (October) attached


●Checklist attached





S | NS | NA





S | NS | NA



Assessment4



●Written Assessment



S | NS | NA



S | NS | NA



Final Assessment Result for this unit



C / NYC



Assessor Notes:(inclusive of reassessment, reasonable adjustment, further opportunities for gap training etc.):______________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________



_______________________________________________________________________________________










Student Declaration:I declare that I have been assessed in this unit, and I have been advised of my result. Ihave been advised of and amaware of my appeal rights.


Name:​____________________________


Signature:​____________________________


Date:​____/_____/_____



Assessor Declaration:I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedbackincluding advising the student ontheir appeal rights.I further declare that this assessment has been checked and is free from plagiarism


Name:​____________________________


Signature:​____________________________


Date:​____/_____/_____




Administrative use only











Entered onto Student Management Database



●________________


Date




Initials


































TrainersAssessment Resource



Unitdetails



SITXFIN004​Prepare and monitor budgets



Assessment Type



This is asummative assessment, which requires each student to have adequate practice prior toundertaking this assessment


This assessment must be undertaken in a real or simulated work environment



Assessment Methods



Case study / role-plays



Assessment1


(Case Study - 2 budgets)



Assessment2


(Case Study / Role-play)



Assessment3


(Case Study / Role-play)





Written Assessment / Project



Assessment4


(Written Assessment / Project)















Unit Summary
This unit describes the performance outcomes, skills and knowledge required to analyse financial and other business information to prepare and monitor budgets. It requires the ability to draft and negotiate budgets, identify deviations, and manage the delivery of successful budgetary performance.The unit applies to all tourism, travel, hospitality and event sectors. The budget may be for an entire organisation, for a department or for a particular project or activity.It applies to senior personnel who operate independently or with limited guidance from others and who are responsible for making a range of financial management decisions.No occupational licensing, certification or specific legislative requirements apply to this unit at the time of publication.



























This page intentionally left blank



Summative Assessment - Assessor Instructions



It is important thatinconducting assessment, the assessor undertakes the following:



Prior to conducting the assessment

•Read the assessment tasksas detailedthroughout this document•Contextualise the task (and checklist) to ensure it reflects the students working environment. (Be sure to check with the mapping document to ensure any contextualisation still covers the unit requirements)•Read the assessor instructions and checklist prior to commencing the assessment•Ensure theassessment environmentis suitable for the parameters of the task,to ensure the students will have an appropriate opportunity to demonstrates their skills•Make suitable modifications to theassessment environment (if required),to allow all tasks to be observed•Ensure the student is allocated the appropriate time and resources for the task•Advise the student prior to conducting the assessment of:owhat will occur throughout the assessment processowhen the assessment will occurothe level of competency expected(review the checklist or the criteria for the task to ensure the student understands the assessment process and the expectations)othe RTOreasonable adjustment process and offer adjustment for any students needing assistanceothe RTOre-assessment and appeals process•You should not tell the student how to undertake thetask, as it would lead the student and render the assessment process invalid. The student should have been taught "How" to perform each task during the training stage, and is expected to know this prior to commencing the assessment.

Conducting the assessment

•Establish and oversee the evidence gathering process to ensureitremains valid, reliable, fair and flexible•Advise the student when to commence the assessment•Observe the student undertake the tasks as outlined•Record your observations in the assessor checklist•Where a checklist point is not observed due to an inappropriate environment, or for a reason outside the students control, modify the scenario to allow the student an opportunity to perform the associated task•Where a checklist point is not appropriate, write "N/A" in the space provided•Incorporate allowable adjustments to the assessment procedure without compromising the integrity of the assessment. Be sure to makeappropriatenotations on the assessment checklist to explain any variances tothe assessment process (such as probing questions, alterations to assessment environment, etc) to ensure the assessment process is transparent (and the assessment remains Valid)•Gather supporting documentation where available and appropriate (as evidence)•Do not interfere with the assessment unless thestudent’sactions impose a risk to themselves or anyone else. In the event that the actions of the student impact on the safety of any person - you are to immediately cease the assessment and take actions to reduce the identified risk.•If a student performs an action incorrectly, mark it as such. Record what you see, not what you want to see.•Once the assessment is complete, advise the student that the assessment has ceased, and record your comments in thesections provided.



Makingand recordingthe decision

•The student needs to be deemedsatisfactory in all assessmentsto gain competency.•You are to providefeedback*to the studenton their performance and/or the outcome from their assessment (whether satisfactory or not yet satisfactory)•If a studenthas been assessed as "NotYetSatisfactory"on their performance in an assessment they should be offered information about the appeal process and/or a reassessment opportunity.•Re-assessments:oRe-assessments are to be undertaken on a different date. This is to allow an opportunity for the student to undergo further training as required, and to ensure the student is assessed on their ability to demonstrate their actual skills and knowledge - not just their ability to answer questions / perform actions based on immediate advice of the assessor.oWhen undertaking observation based re-assessments, students must perform the full task that relates to the observation. This means if a student undertakes an observation and is marked not satisfactory on one or more points within the observation, they must perform the task again in full.oIf a student has been marked as satisfactory on any full observation task, they are not required to be re-assessed on that task again.oWritten assessments (if applicable). Students are only required to be re-assessed on the questions relating to the topic they answered incorrectly in the initial assessment. For example, if the student answered Q1, 2, 3 correctly, but answered Q4+5 incorrectly; then they must be re-assessed on Q4+5 on a later date•Using the evidence gathered and the rules of evidence (validity, reliability, sufficiency, currency and authenticity) determine the final outcome for the student.If you are in doubt, gatherfurther evidence to help guide your decision.•Assess the students on what youobserveduring the assessment period, not ontheiractions before or after the assessment.•If you are marking the student NYC, ensure you outline why you have made this decision, and provide advice on how the student can improve their skills / knowledge prior toreassessment;or if the re-assessment opportunities have lapsed,provideadvice on appeals and or re-enrolment.•Record the assessment results onto the Assessment Summary/ Cover Sheet, ensuring each section is complete•Attach all evidence (projects / checklists / tests, etc) to this form.•Submit the completed Assessment Summary/ Cover sheet and associated evidence for processing as per your RTO procedures



Providing feedback

•Provide constructive feedback to the student on their performance during the assessment period. Do not make any comments on actions undertaken prior or after the assessment period.•Provide the student with:oTheir assessment resultoClear and constructive feedback based on the assessment decisionoThe reasons underpinning your assessment decisionoInformation on ways of overcoming any identified gaps in competency revealed by the assessment the opportunity to discuss the assessment process and outcome information on reassessment and the appeals processes.oAn opportunity for reassessment if appropriate or requested by the candidateoInformation on appeal process as applicable to your organisation



ASSESSMENT 1 – STUDENT INFORMATION


This information is to be handed to each student to outline the assessment requirements



The owner of Cupcake Heaven, Sarah Winter, needs some assistance in preparing her budget and budget reports. She has gone through her past records thoroughly and has prepared a summary of what has happened and what is expected to happen. However she is unsure how to determine cash receipts from debtors and cash payments from creditors. She has provided the following for your information


































































































From balance sheet





Actual


31 July 2017



Predicted


31 August 2017





$



$



Balance of stock control



2600



36400



Balance of debtors control



2400



2800



Balance of creditors control



8600



9600



Balance of cash at bank



3210



?









From the profit and loss statement





Actual


31 July 2017



Predicted


31 August 2017



Cash sales



6500



6600



Credit sales



2750



2800



Cost of sales



4500



4600



Stock loss



800



800



Wages



1600



1600



Office expenses



200



200



Discount expense



110



120



Discount revenue



150



160



Bad debts



100



100



a)Reconstruct the following general ledger accountsto help Sarah with the preparation of her budgeted cash flow statement. Debtors Control, Stock Control and Creditors Control. Don’t forget to allow for 10% GST on all sales and purchases.b)Using the above information, plus your reconstructions from parta, prepare a budgeted cash flow statement for Cupcake Heaven for the month ending 31 August 2017.c)Taking into consideration your budgeted cash flow statement from part b, comment on the likely future cash position of this businessd)Prepare a budgeted profitand loss for the month ending 31 August 2017.e)Write a brief report on the future performance expectations of Cupcake Heaven in related to the expected profit or loss



Assessment Summary - You are to submit the following

•3 x reconstructed general ledger accounts•Budgeted cash flow statement and report•Budgeted Profit & Loss statement•Overview report on future performance expectations


This project is due for submission on: _____________________________________________




ASSESSMENT 1 – ASSESSOR INSTRUCTIONS


This information is to be handed to each student to outline the assessment requirements



Each student has been given the following case study:



“The owner of Cupcake Heaven, Sarah Winter, needs some assistance in preparing her budget and budget reports. She has gone through her past records thoroughly and has prepared a summary of what has happened and what is expected to happen. However she is unsure how to determine cash receipts from debtors and cash payments from creditors. She has provided the following for your information


































































































From balance sheet





Actual


31 July 2017



Predicted


31 August 2017





$



$



Balance of stock control



2600



36400



Balance of debtors control



2400



2800



Balance of creditors control



8600



9600



Balance of cash at bank



3210



?









From the profit and loss statement





Actual


31 July 2017



Predicted


31 August 2017



Cash sales



6500



6600



Credit sales



2750



2800



Cost of sales



4500



4600



Stock loss



800



800



Wages



1600



1600



Office expenses



200



200



Discount expense



110



120



Discount revenue



150



160



Bad debts



100



100



a)Reconstruct the following general ledger accounts to help Sarah with the preparation of her budgeted cash flow statement. Debtors Control, Stock Control and Creditors Control. Don’t forget to allow for 10% GST on all salesand purchases.b)Using the above information, plus your reconstructions from part a, prepare a budgeted cash flow statement for Cupcake Heaven for the month ending 31 August 2017.c)Taking into consideration your budgeted cash flow statement from part b, comment on the likely future cash position of this businessd)Prepare a budgeted profit and loss for the month ending 31 August 2017.e)Write a brief report on the future performance expectations of Cupcake Heaven in related to the expected profit or loss



Assessment Summary - You are to submit the following

•3 x reconstructed general ledger accounts•Budgeted cash flow statement and report•Budgeted Profit & Loss statement•Overview report on future performance expectations”



Assessors Notes:

•This assessment is a casestudy that focuses on the students ability to gatheroappropriate information to prepare budgetsoPrepare budgeted cash flow statementsoPrepare budgeted profit and loss statementsoExplain each prepared to their clientoProvide comment on business performance in relation to expected profit and loss.•No student self-assessment checklist has been provided with this assessment, as the students instructions provide clear guidance on what is expected to be completed and submitted.•Sample answers are provided below. Please refer to these whist assessing each students submission


ASSESSMENT1


A.Reconstruction of ledger accounts for August 2017









































































































































Debtors Control Account



Balance







Discount expense





Sales







Bad debts





GST







Cash at bank















Balance





















Stock Control Account



Balance







Cost of sales





Creditors







Stock loss











Balance















Balance













Creditors Control Account



Discount revenue







Balance





Cash at bank







Stock Control





Balance



























Balance
















Budgeted Cash Flow Statement for month ending 31 August 2017







































































Cash flow from operating activities







Cash sales







Collections from debtors







GST collected







Payments to creditors







Wages







Office Expenses







GST paid







Cash provided (used) by operating activities













Net increase (decrease) by operating activities







Cash held at beginning of month







Cash held at end of month







C.Thecompany’scash position is expected to decrease in a dramatic fashion during August. The big problem is the expected increase in stock, which is expected to lead to a big jump in payments to creditors. The cash coming into the business from sales and debtors is well short of that required to pay suppliers. The owner will need to make arrangements to cover the anticipated shortfall in cash. Additional capitalmay have to be injected or an overdraft may have to be arranged


D.BudgetedProfit and LossStatement for month ending 31 August 2017
























































































































Revenue











Cash sales











Credit sales









Less



Cost of sales













Gross Profit







Less



Stock loss













Adjusted Gross Profit







Plus



Other revenue











Discount revenue



















Less



Expenses











Wages











Office expenses











Discount expenses











Bad debts













Net profit








E.Although the future cash position of the business does not look bright, the profit performance or the business for August appears satisfaction. The difference between the two reports is that the budgeted cash flows include all the cash expected to be paid to the creditors. This is expected because the business is buildingup its stock levels for future trading. However, only the cost of goods actually sold is reported in the budgeted profit and loss statement. Therefore, this budget reports a positive result for August, despite the short fall of cash predicted in the budgeted statement of cash flows



This assessmentis contextualised for the classroom

oSimulation is a form of evidence gathering that involves the candidate in completing or dealing with a task, activity or problem in an off-the-job situation that replicatesthe workplace context. Documented definitions state "Simulations vary from recreating realistic workplace situations such as in the use of flight simulators, through the creation of role plays based on workplace scenariosto the reconstruction of a business situation on a spreadsheet. In developing simulations, the emphasis is not so much on reproducing the external circumstance but on creating situations in which candidates are able to demonstrate:▪technical skills(demonstrated through developing budgets)▪underpinning knowledge(demonstrated through reconstructing ledger accounts)▪generic skills such as decision making and problem solving(demonstrated through reconstructing ledger accounts)▪workplace practices such as effective communication(demonstrated when explaining accounts)"

oIn conducting training and assessment in a simulated workplace environment, trainers and assessors must make sure that the simulated environment gives the learner the opportunity to meet the following critical criteria:▪Quality – The work is of the standard requiredfor entryinto the industry.▪Productivity – The work is performed within a timeframe appropriatefor entryto the industry.▪Safety – The work is performed in a manner that meets industry safety standards.


oEach assessment has taken the following aspects into consideration, to ensure any simulations provide for integrated assessment of competence. This includes:▪performing the task (task skills)▪managing a number of tasks (task management skills)▪dealing with workplace irregularities such as unexpected problems, breakdowns and changes in routine (contingency management skills)▪fulfilling the responsibilities and expectations of the job and workplace, including working with others (job/role environment skills)▪transferring competencies to new contexts.


oIf a simulated workplace is used, it must allow for distractions such as background noises, ringing telephones, interruptions, etc. As this is aHospitality based businessunit, a simulated environment may also include an office environment with office equipment and computers. Each student must dress appropriately and professionally in line with workplace standards.


oFor each assessment, you are not to interfere. In the event that the assessment is activities willimpact on the safety of a student or bystander, the assessment must be stopped immediately



ASSESSMENT 1 – ASSESSOR CHECKLIST


This checklist is to be used when assessing the students in the associated task. This checklist is to be completed for each student. Please refer to separate mapping document for specific details relating to alignment of this task to the unit requirements.




Please complete below


















Student Name:





Student ID No:





Date:









































































































Did the student perform the following as per answers provided



Satisfactory



Part A- Accurately reconstruct the Debtors Control Ledger



●Yes●No



Part A- Accurately reconstruct the Stock Control Ledger



●Yes●No



Part A- Accurately reconstruct the Creditors Control Ledger



●Yes●No



Part A- Allow for GST



●Yes●No



Comment:








Part B- Provide an accurate budgeted cash flow statement



●Yes●No



Part B- identify negative cash held at end of month



●Yes●No



Comment:








PartC- Identify cash flow decrease in August



●Yes●No



PartC- Explain reason for cash flow decrease (increased stock and payments to creditors)



●Yes●No



PartC- Recommend arrangements to made for additional capital injection



●Yes●No



Comment:








PartD- Prepare accurate budgeted profit and loss statement for August



●Yes●No



PartD- Identify Gross Profit



●Yes●No



PartD- Identify Adjusted Gross Profit



●Yes●No



PartD- Identify Net Profit



●Yes●No



Comment:








PartE- Identify satisfactory profit performance for August



●Yes●No



PartE- Explain reason for difference in reports (creditor payments)



●Yes●No



Comment:








Ensure all calculations are accurate



●Yes●No



Provide clear explanations (easy to understand)



●Yes●No



Submit report on time



●Yes●No



Comment:











Result: Satisfactory | Not Satisfactory | Not Assessed












Student Declaration:I declare that I have been assessed in this unit, and I have been advised of my result. Ihave been advised of andam aware of my appeal rights.



Name:​________________________


Signature:​________________________


Date:​____/_____/_____












Assessor:I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedbackincluding the students appeal rights




Name:​________________________


Signature:​________________________


Date:​____/_____/_____





ASSESSMENT2– STUDENT INFORMATION


This information is to be handed to each student to outline the assessment requirements



Allan Smythe is the owner of Cakes-2-U, a specialist cake service that makes and delivers to wedding and celebratory cakes to customers. At the end of December 2016 there is only $260 in the company bank account. His other problem is that he would like to purchase a new vehicle (costing $25,000) for the business, but he doesn’t know when he will have the $10,000 deposit required. One of Smythes friends has advised him that he should prepare a forecast of his future transactions, but he is unsure how to do so. He has asked for your assistance and has provided the following information in relation to his business. (Youdo not have to account for the GST in this question).

•The quarter of January to March is Cakes-2-U’s busiest quarter each year. In January 2016 he earned the following revenue: January $12,000, February $14,000, and March $15,000. After this the business slowed down a little. In the next quarter he earned the following revenue. April, $14,000, May $12,000 and June $10,000. Allan is confident that revenue will be higher in the early part of 2017. He has already signed contracts to complete the following jobs in January 2017.•Piketon’s​$1,900•Fox’s​$1,750•Tan’s​$1,800•Singh’s​$1,950•Strong’s​​$1,850•Ablert’s​$1,950•O’Conner’s​$1,900•For the months of February and March, Allanexpects toearnfees from about 10% higher than the previous year, but in the quarter April-June he doesn’t expect the same level of business. In fact, he has stated that he expects his revenue to be about 5% lower than in the same quarter last year•Allanpurchases all ingredients and materials for jobs as they are required. When he is quoting for a job, he calculates the cost of materials and multiplies this by 4 to calculate the total cost of the job. Allan argues that this allows for labour costs, vehicle expenses and a profit margin for himself. The cost of materials is therefore 25% of the revenue expected to be earned.•The business employs 2 assistants who are each paid on Fridays. One is employed full time and is usually paid $500per week. Theother is employed on a casual basis. During the busiest months (January to March) the casual is probably paid around $500 per week. In the period April-June his wages will drop back to $400 per week. •The company has one vehicle which delivers all orders. Petrol expenses for the vehicle are usually around #200 per month, but in the January-March quarter this will go up to about $240 per month. The vehicle is due for a service in February, and this will cost about $320•Insurance on the vehicle is due on2 March each year, and is expected to cost $640 this year. Registration of the vehicle is due on 11 June and should be about $540•Allan advertises his business in the local papers at a cost of $150 per month•New equipment will have to be purchased duringFebruary at a cost of $3,800. Allan has arranged for a credit arrangement to help with this purchase. The supplier has agreed to take a $1,000 deposit on delivery of the equipment, and then $400 payments will have to be paid each month until it is fullypaid off•Allan does his office work from home. He usually incurs office expenses for the business at around $100 per month•Loan repayments of $1500 are due on 15 February, 15 May, 15 August and 15 November•Allan usually redraws $500 each Friday for personal use


a)Prepare a cash budget for Cakes-2-U for the period January - June 2017. You budget should allow for the anticipated cash balance at the end of each monthb)Provide a written report that states when Allan will be able to afford the $10,000 depositfor the new vehicle. Support your answer with reasonsc)Arrange a time and present your budget to Allan (role-played by your assessor) and explain your proposed cash budget along with your recommendations. It is important that you have access to a soft-copy of your budget for this meeting



Note: When you present your budget and response, it is important that you are professional. This means you must ensure all documentation is presented professionally, and that you explain everything in detail. If Allan asks any questions, you are to answer them clearly and accurately




You are to present your work on:_____________________________________________




ASSESSMENT 2 – ASSESSOR INSTRUCTIONS


This information is to be handed to each student to outline the assessment requirements



Each student has been given the following case study:


“Allan Smythe is the owner of Cakes-2-U, a specialist cake service that makes and delivers to wedding and celebratory cakes to customers. At the end of December 2016 there is only $260 in the company bank account. His other problem is that he would like to purchase a new vehicle (costing $25,000) for the business, but he doesn’t know when he will have the $10,000 deposit required. One of Smythes friends has advised him that he shouldprepare a forecast of his future transactions, but he is unsure how to do so. He has asked for your assistance and has provided the following information in relation to his business. (You do not have to account for the GST in this question).

•The quarterof January to March is Cakes-2-U’s busiest quarter each year. In January 2016 he earned the following revenue: January $12,000, February $14,000, and March $15,000. After this the business slowed down a little. In the next quarter he earned the following revenue. April, $14,000, May $12,000 and June $10,000. Allan is confident that revenue will be higher in the early part of 2017. He has already signed contracts to complete the following jobs in January 2017.•Piketon’s​$1,900•Fox’s​$1,750•Tan’s​$1,800•Singh’s​$1,950•Strong’s​​$1,850•Ablert’s​$1,950•O’Conner’s​$1,900•For the months of February and March, Allan expects toearnfees from about 10% higher than the previous year, but in the quarter April-June he doesn’t expect the same level of business. In fact, he has stated that he expects his revenue to be about 5% lower than in the same quarter last year•Allan purchases all ingredients and materials for jobs as they are required. When he is quoting for a job, he calculates the cost of materialsand multiplies this by 4 to calculate the total cost of the job. Allan argues that this allows for labour costs, vehicle expenses and a profit margin for himself. The cost of materials is therefore 25% of the revenue expected to be earned.•The businessemploys 2 assistants who are each paid on Fridays. One is employed full time and is usually paid $50 per week. The other is employed on a casual basis. During the busiest months (January to March) the casual is probably paid around $500 per week. In the period April-June his wages will drop back to $400 per week. •The company has one vehicle which delivers all orders. Petrol expenses for the vehicle are usually around #200 per month, but in the January-March quarter this will go up to about $240 per month. The vehicle is due for a service in February, and this will cost about $320•Insurance on the vehicle is due on 2 March each year, and is expected to cost $640 this year. Registration of the vehicle is due on 11 June and should be about $540•Allan advertises his business in the local papers at a cost of $150 per month•New equipment will have to be purchased during February at a cost of $3,800. Allan has arranged for a credit arrangement to help with this purchase. The supplier has agreed to take a$1,000 deposit on delivery of the equipment, and then $400 payments will have to be paid each month until it is fully paid off•Allan does his office work from home. He usually incurs office expenses for the business at around $100 per month•Loan repayments of $1500 are due on 15 February, 15 May, 15 August and 15 November•Allan usually redraws $500 each Friday for personal use

a)Prepare a cash budget for Cakes-2-U for the period January - June 2017. You budget should allow for the anticipated cash balanceat the end of each monthb)Provide a written report that states when Allan will be able to afford the $10,000 deposit for the new vehicle. Support your answer with reasonsc)Arrange a time and presentyour budget to Allan (role-played by your assessor) and explain your proposed cash budget along with your recommendations. It is important that you have access to a soft-copy of your budget for this meeting



Note: When you present your budget and response, it is important that you are professional. This means you must ensure all documentation is presented professionally, and that you explain everything in detail. If Allan asks any questions, you are to answer them clearly and accurately”





Assessors Notes:

•This assessment is a case study that focuses on the students ability to:oGather appropriate information to prepare budgetsoPrepare a cash budgetsoExplain cash budget and answer customers questionsoConsider changes that may affect cash budgetoModify budget and make recommendations on viability of modifications•No student self-assessment checklist has been provided with this assessment, as the students instructions provide clear guidance on what is expected to be completed and submitted.•The student is required to present their work to you (the client) as part of this assessment. When role-playing the client you are to allow the student to explain their cash budget and recommendations themselves. If the student presents irregularities in their budget, you are to question them. (A sample completed cash budget is provided below)•Note: in 2017 there are 4 pay days in each month, with the exception of March and June , where there are 5 Fridays, and therefore 5 pay days:

•After the student has presented their budget, you are to explain the following:oYou have hadsecond thoughts about the expected downturn in business in the April-June period. You are considering a new advertising strategy that will cost him $100 more each month (for April - June) butareexpected to increase his revenue during these months by 8%.However this will increase the wages by $150 per week and, of course, the extra jobs will cause an increase in the amount of materials that would be used. oAsk the student to redraft the budget and take note of the changes in the estimated bank balances. Ask the student if you shouldgo ahead with this advertising planand the reasons for their answer.•The student will need to go and re-work the budget before responding to your question. You are to allow a short period of time for this to occur (up to1 hour), but realistically it should only take a student a maximum of 30 minutes to respond appropriately. •By asking your student to work this out immediately, it allows the student to demonstrate their ability to meet appropriate deadlines and also reduces the risk of the student copying their answer from others. This modification extension helps demonstrate authenticity, as the student will need to re-work their figures


•Sample answers are providedoverleaf. Please refer to these whist assessing eachstudents submission



ASSESSMENT2














































































































































































































A.Cash budget for 6 months ending 30 June 2017



Jan


$



Feb


$



Mar


$



Apr


$



May


$



Jun


$



Estimated receipts















Fees















Total receipts





























Estimated payments















Materials















Wages















Petrol















Service of delivery vehicle















Insurance of delivery vehicle















Registration of delivery vehicle















Advertising















Purchase of equipment















Office expenses















Loan repayments















Drawings















Total payments





























Excess (deficit) for month















Bank balance at start of month















Bank balance at end of month















B.The earliest he should buy the new vehicle is in April. This leaves him with a safetymargin of about $1,800. IfSmythehas doubts about this he should delay the purchaseuntil May. As the business expects to have a negative cash flow in June,Smythemaywell hold off on his decision so that the next quarterly budget can be prepared. The factthat the cash position is expected to drop back to around $10,000 by the end of Juneis a warning that the business may not be able to go ahead with the purchase of thenew vehicle. It should be kept in mind that, once the deposit of $10,000 has been paid,another $15,000 still has to be paid in the future. This would put the cash resources of thisbusiness under intense pressure.















































































































































































































D.Revised cash budget for 6 months ending 30 June 2017



Jan


$



Feb


$



Mar


$



Apr


$



May


$



Jun


$



Estimated receipts















Fees















Total receipts





























Estimated payments















Materials















Wages















Petrol















Service of delivery vehicle















Insurance of delivery vehicle















Registration of delivery vehicle















Advertising















Purchase of equipment















Office expenses















Loan repayments















Drawings















Total payments





























Excess (deficit) for month















Bank balance at start of month















Bank balance at end of month














D. Comment:At first glance the new advertising strategy appears to be worthwhile. The predicted cash balance for April increases from $11,855 to $11,953 (increase of $98). In May the change is from $12,255 to $12,337 (increase of $82). However, in June the change is a negative result. Rather than the expected balance of $10,740, the reviewed budget predicts a balance of $10,542, a reduction of $198. This negative change is the result of the increase in wages and the fact that in June there are 5 pay days. The increase of $150 per week leads to an expected increase in wages for June of $750 ($150 x 5). This paymenteliminates any gains made in the area of revenue and therefore the advertising plan should not be adopted. An alternative point of view is that the plan should be adopted because it generates an increase in the market share for the business. The new advertising is expected to generate new work, meaning that new opportunities will be created for ‘word of mouth’ advertising. As long as customer satisfaction is high, it may well be that the new plan is just what the business needs in the slower months of the year. This may well lead to a very busy period in the following months! It is valid to argue that for around $200 (the net change in the budget) the business may, in the long run, receive benefits outweighing this cost.



This assessmentis contextualisedfor the classroom

a.Simulation is a form of evidence gathering that involves the candidate in completing or dealing with a task, activity or problem in an off-the-job situation that replicates the workplace context. Documented definitions state "Simulationsvary from recreating realistic workplace situations such as in the use of flight simulators, through the creation of role plays based on workplace scenariosto the reconstruction of a business situation on a spreadsheet. In developing simulations, the emphasis is not so much on reproducing the external circumstance but on creating situations in which candidates are able to demonstrate:i.technical skills(demonstrated through developing budgets)ii.underpinning knowledge(demonstrated through reconstructing ledger accounts)iii.generic skills such as decision making and problem solving(demonstrated through reconstructing ledger accounts)iv.workplace practices such as effective communication(demonstrated when explaining accounts)"

b.In conducting training and assessment in a simulated workplace environment, trainers and assessors must make sure that the simulated environment gives the learner the opportunity to meet the following critical criteria:i.Quality – The work is of the standard requiredfor entryinto the industry.ii.Productivity – The work is performed within a timeframe appropriatefor entryto the industry.iii.Safety – The work is performed in a manner that meets industry safety standards.


c.Each assessment has taken the following aspects into consideration, toensure any simulations provide for integrated assessment of competence. This includes:i.performing the task (task skills)ii.managing a number of tasks (task management skills)iii.dealing with workplace irregularities such as unexpected problems, breakdowns andchanges in routine (contingency management skills)iv.fulfilling the responsibilities and expectations of the job and workplace, including working with others (job/role environment skills)v.transferring competencies to new contexts


d.If a simulated workplace isused, it must allow for distractions such as background noises, ringing telephones, interruptions, etc. As this is aHospitality based businessunit, a simulated environment may also include an office environment with office equipment and computers. Each student must dress appropriately and professionally in line with workplace standards.


e.For each assessment, you are not to interfere. In the event that the assessment is activities will impact on the safety of a student or bystander, the assessment must be stopped immediately



ASSESSMENT 2 – ASSESSOR CHECKLIST


This checklist is to be used when assessing the students in the associated task. This checklist is to be completed for each student. Please refer to separate mapping document for specific details relating to alignment of this task to the unit requirements.




Please complete below


















Student Name:





Student ID No:





Date:







































































































































Did the student perform the following as per answers provided



Satisfactory



Part A- Develop a cash budget for Jan-Jun 2015 that is


•Accurate(refer sample answer provided)

●Yes●No


•Recognises that there are 5 paydays in March and June

●Yes●No


•Includes all estimated receipts and all estimated payments (refer sample answer provided)

●Yes●No



Comment:








PartB- Provide a recommendation that


•Identifies April as the appropriate month to purchase

●Yes●No


•Identifies the safety margin of about $1800

●Yes●No


•Identifies the cash flow drop in June which may place strain on the business

●Yes●No


•Identifies thatafter the $10,000 is paid, another $15,000 must also be paid in the future, which will place immense pressure on the business

●Yes●No



Comment:








PartC- Arrange a time to meet with the assessor and


•Present budget professionally (easy to read,accurate, etc.)

●Yes●No


•Clearly explain the budget

●Yes●No


•Highlight the proposed excess or deficits per month

●Yes●No


•Highlight the bank balance at the end of each month

●Yes●No


•Demonstrate that they understood their figures (by knowing what they are talking about)

●Yes●No


•Listen to Allan’s opinion (as outlined in Assessor Instructions)

●Yes●No


•Advise Allan that they will need to revisit the figures before providing an answer (not guess or make an immediate answer without running and checking the figures)

●Yes●No



Comment:








PartD- Review the budget:


•Consider the new details provided by the client

●Yes●No


•Adjust the budget reflecting the changes

●Yes●No


•Provide an accurate reviewed budget

●Yes●No


•Identify thenegative result in June

●Yes●No


•Identify the cause for the loss (additional pay days, which eliminates any gains)

●Yes●No


•Make a recommendation that is supported by fact (refer to sample recommendation provided in Assessors Instructions - AnswersSection)

●Yes●No


•Initial budget attached

●Yes●No


•Written recommendations for new vehicle attached

●Yes●No


•Updated budget attached

●Yes●No


•Recommendation attached

●Yes●No



Comment:












Result: Satisfactory | Not Satisfactory| Not Assessed












Student Declaration:I declare that I have been assessed in this unit, and I have been advised of my result. Ihave been advised of andam aware of my appeal rights.



Name:​________________________


Signature:​________________________


Date:​____/_____/_____












Assessor:I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedbackincluding the students appeal rights




Name:​________________________


Signature:​________________________


Date:​____/_____/_____





SITXFIN004 assessmentSeptember 2018 Review date:December2018


TOID 21438 CRICOS code 02552G Page1of36 Authorised by M. Phillips



ASSESSMENT3– STUDENT INFORMATION


This information is to be handed to each student to outline the assessment requirements



PART1:The following comparison of budgeted cash flow and actual cash flows has been prepared for Donna’s Diner for the quarter ending 30 September 2017

























































































Budget


$



Actual


$



Receipts







Cash fees



24000



32000



Collections from debtors



12000



14500



Loan from ABC Finance Company



5000





GST Collected



2400



3200









Payments







Wages



6000



6500



Insurance



800



840



Suppliers



14000



16400



Postage and telephone



400



380



Purchaseof new equipment



5000



4600



Cleaning of shop



1200



1200



Drawings



4500



3800



GST Paid



2140



2342




The business had $500 in the bank on 1 July 2017

A.Prepare a budgetvariance report for the quarter ended 30 September 2017 to reveal the significant differences between the budgeted and actual dataB.What was the predicted cash balance on 30 September?C.What was the actual cash balance on 30 September?D.State, and explain, the major causes of the difference between the budgeted and actual bank balanceE.Do you think that the quarterly period is appropriate for cash budgeting? Give reasons for your answer


You are to present your work on: _____________________________________________




PART2:Following from Part A, you are to arrange a time to talk with your assessor (who will role-play the manager for Donna’s Diner) and identify the possible cause for any unfavourable variances. You are to take into consideration the information you obtain, and then develop a projected cash flow budget for the next 1 month.



Prior to meeting with the supervisor it is important that you are prepared. This means you must know what you need to ask, as you will need this information to complete the next cash flow budget.



After meeting with your assessor, you are to developacash flow budget (for October 2017),and submit it along with a written report outlining the variations made and reasons.



This assessment is due on: ___________________________________________



ASSESSMENT3– ASSESSOR INSTRUCTIONS


This information is to be handed to each student to outline the assessment requirements



Each student has been given the following case study:


“Part1:The following comparison of budgeted cash flow and actual cash flows has been prepared for Donna’s Diner for the quarter ending 30 September 2017

























































































Budget


$



Actual


$



Receipts







Cash fees



24000



32000



Collections from debtors



12000



14500



Loan from ABC Finance Company



5000





GST Collected



2400



3200









Payments







Wages



6000



6500



Insurance



800



840



Suppliers



14000



16400



Postage and telephone



400



380



Purchaseof new equipment



5000



4600



Cleaning of shop



1200



1200



Drawings



4500



3800



GST Paid



2140



2342




The business had $500 in the bank on 1 July 2017

A.Prepare a budget variance report for the quarter ended 30 September 2017 to reveal the significant differences between the budgeted and actual dataB.What was the predicted cash balance on 30 September?C.What was the actual cash balance on 30 September?D.State, and explain, the major causes of the difference between the budgeted and actual bank balanceE.Do you think that the quarterly period is appropriate for cash budgeting? Give reasons for your answer


PART2:Following from Part A, you are to arrange a time to talk with your assessor (who will role-play the manager for Donna’s Diner) and identify the possible cause for any unfavourable variances. You are to take into consideration the information you obtain, and then develop a projected cash flow budget for the next 1 month.



Prior to meeting with the supervisor it is important that you are prepared. This means you must know what you need to ask, as you will need this information to complete the next cash flow budget.



After meeting with your assessor, you are to develop the cash flow budget (for October 2017),and submit it along with a written report outlining the variations made and reasons.”






Assessors Notes:

•This assessment is a case study that focuses on the students ability to:oMonitor the effectiveness of budgetsoIdentify variances in budgetsoExplain variances in budgets clearly and accurately•No student self-assessment checklist has been provided with this assessment, as the students instructions provide clear guidance on what is expected to be completed and submitted.•Part1requires no interaction with the student, as all required information is included in the Student Information Form•Part2: The student is required to present their work to you (the client) as part of this assessment. When role-playing the client you are to allow the student to present their cash flow budget and answer any questions relating to unfavourable variances. If the student presents irregularities in their budget, you are to question them. It is importantthat you only answer questions asked by the student during this conversation and not lead them in any way.•Part2: Reasons forvariationsare as followsoCash Fees(expected to continue - Ongoing catering job of $1,300 only commenced in September) ($32000- $1300 = $30700 / 3 = $10233 + $1300 = $11533oLoanfrom ABC company- did not apply due to increased sales and debtor collectionsoWages- Overtime was payable due to a catering job that was picked up in September. This catering job is ongoing, and is worth $1,300 per month (which results in an increase of COGS of $340 and increase of wages of $500). Note the catering job only accounts for 1 month in budget variance quarteroSuppliers- additional ingredients required due to increase in sales(ongoing). Note the catering job only accounts for 1 month in budget variance quarteroInsurance- premium increase due to change in fire levyoDrawings- this is not ongoing and will revert to $1500 per monthoGST- direct result of increased sales•Sample answers areprovidedoverleaf. Please refer to these whist assessing each students submission


ASSESSMENT3
























































































































































































A.budgetvariance report for quarter ended 30 September 2010



Budget


$



Actual


$



Variance













$



%



F or U



Receipts













Cash fees













Collections from debtors













Loan from ABC Finance Company













GST Collected













Total Receipts













Payments













Wages













Insurance













Suppliers













Postage and telephone













Purchaseof new equipment













Cleaning of shop













Drawings













GST Paid













Total payments

























Excess of receipts over payments













Bank balance as at 1 Jul 2017













Bank balance as at 30 Sep 2017













B.Predicted cash balance was $9,860C.Actual cash balance was $14,138D.Major reasons for difference:a.​Receipts: Cashsales were $8,000 above budget. Collections from debtors were $2,500 higher than expected. These unexpected results probably made the loan of $5,000 unnecessary. (Note: although the loan is listed as an unfavourable variance, it would probably be viewed as a positive result!)b.​Payments: Outflows to suppliers were $2,400 over budget. This may have been due to the higher levels of fees (more business leads to higher purchases of materials). Drawings were 16% below budget. The equipment was purchased at a much better price than was expected and helped the firm achieve the pleasing result.E.A monthly budget period is usually preferred to a quarterly budget. The problem with a quarterly period is that shortages may occur in some months before a recovery occurs within the quarter. A quarterly budget does not reveal the full month-by-month picture and may therefore not show that liquidity problems maybe forthcoming






Part B - Cash Flow Budget - October 2017

















































































Budget


$



Receipts





Cash fees





Collections from debtors





GST Collected





Total Receipts









Payments





Wages





Insurance





Suppliers





Postage and telephone





Purchase of new equipment





Cleaning of shop





Drawings





GST Paid





Total Payments





Excess of receipts over payments







This assessmentis contextualised for the classroom

a.Simulation is a form of evidence gathering that involves the candidate in completing or dealing with a task, activity or problem in an off-the-job situation that replicates the workplace context. Documented definitions state "Simulations vary from recreating realistic workplace situations such as in the use of flight simulators, through the creation of role plays based on workplace scenariosto the reconstruction of a business situation on a spreadsheet. In developing simulations, the emphasis is not so much on reproducing the external circumstance but on creating situations in which candidates are able to demonstrate:i.technical skills(demonstrated through developing budgets)ii.underpinning knowledge(demonstrated through reconstructing ledger accounts)iii.generic skills such as decision making and problem solving(demonstrated through reconstructing ledger accounts)iv.workplace practices such as effective communication(demonstrated when explaining accounts)"

b.In conducting trainingand assessment in a simulated workplace environment, trainers and assessors must make sure that the simulated environment gives the learner the opportunity to meet the following critical criteria:i.Quality – The work is of the standard requiredfor entryinto the industry.ii.Productivity – The work is performed within a timeframe appropriatefor entryto the industry.iii.Safety – The work is performed in a manner that meets industry safety standards.


c.Each assessment has taken the following aspects into consideration, to ensure any simulations provide for integrated assessment of competence. This includes:i.performing the task (task skills)ii.managing a number of tasks (task management skills)iii.dealing with workplace irregularities such as unexpected problems, breakdowns and changes in routine (contingency management skills)iv.fulfilling the responsibilities and expectations of the job and workplace, including working with others (job/role environment skills)v.transferring competencies to new contexts


d. If a simulated workplace is used, it must allow for distractions such as background noises, ringing telephones, interruptions, etc. As this is aHospitality based businessunit, a simulated environment may also include an office environment with office equipment and computers. Each student must dress appropriately and professionally in line with workplace standards.


e.For each assessment, you are not to interfere. In the event that the assessment is activities will impact on the safety of a student or bystander, the assessment must be stopped immediately



ASSESSMENT3– ASSESSOR CHECKLIST


This checklist is to be used when assessing the students in the associated task. This checklist is to be completed for each student. Please refer to separate mapping document for specific details relating to alignment of this task to the unit requirements.




Please complete below


















Student Name:





Student ID No:





Date:


















































































































































































































Did the student perform the following as per answers provided



Satisfactory



Part A- Develop a budget variance report that


•Is accurate(refer sample answer provided)

●Yes●No


•Shows variance in $ format

●Yes●No


•Shows variance in % format

●Yes●No


•Indicate if each variance is Favourable (F) or Unfavourable (U)

●Yes●No



Comment: (assessor must complete)








PartB -Identify predicted cash balance of $9,860



●Yes●No



Comment: (assessor must complete)








PartC -Calculate cash balance for $14,138



●Yes●No



Comment: (assessor must complete)








PartD -Identify reasons for variances including


•Cash sales $8000 above budget


•Debtor collections $2,500 than expected


•Above results probably made the loan unnecessary


•Payments to suppliers $2,400 over budget - possibly due to higher sales resulting in higher cost of goods sold


•Drawings 16% belowbudget


•Equipment purchased at a better price than anticipated



Comment: (assessor must complete)








PartE- Provide a recommendation that


•Recommend monthly budget over quarterly

●Yes●No


•Quarterly does not review full month by month figures

●Yes●No


•Quarterly may not identify liquidity problems forthcoming

●Yes●No



Comment: (assessor must complete)








PartF- Arrange a time to meet with the assessor and


•Present budget professionally (easy to read, accurate, etc.)

●Yes●No


•Clearly explain the budget

●Yes●No


•Highlight and explain the favourable variances

●Yes●No


•Highlight and explain the unfavourable variances

●Yes●No


•Demonstrate that they understood their figures (by knowing what they are talking about)

●Yes●No



Comment: (assessor must complete)








Ask questions to determine



●Yes●No


•Reasons for each unfavourable variance

●Yes●No


•Reasons for significant favourable variances

●Yes●No


•If variances are ongoing or once-off

●Yes●No


•Any significant changes

●Yes●No



Comment: (assessor must complete)








Review information received and develop cash flow budget for October that:



●Yes●No


•Is based on the actual figures provided (3 monthly divided by 3)

●Yes●No


•Takes into consideration increased receipts from ongoing monthly catering job

●Yes●No


•Takes into consideration increased wages as a result of ongoing monthly catering job

●Yes●No


•Takes into consideration increased COGS as a result of ongoing monthly catering job

●Yes●No


•Removes requirement for Loan

●Yes●No


•Keeps drawings at $1500

●Yes●No



Comment: (assessor must complete)








October Cash Flow Statement reflects sample cash flow statement provided



●Yes●No


•Budget variance report attached

●Yes●No


•Predicted cash balance attached

●Yes●No


•Actual cash balance attached

●Yes●No


•Report outlining probably variance reasons attached

●Yes●No


•Answer re: Quarterly vs Monthly budgets attached

●Yes●No


•Cash Flow Budget (October) attached

●Yes●No



Comment: (assessor must complete)












Result: Satisfactory | Not Satisfactory | Not Assessed












Student Declaration:I declare that I have been assessed in this unit, and I have been advised of my result. Ihave been advised of andam aware of my appealrights.



Name:​________________________


Signature:​________________________


Date:​____/_____/_____












Assessor:I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedbackincluding the students appeal rights




Name:​________________________


Signature:​________________________


Date:​____/_____/_____






SITXFIN004 assessmentSeptember 2018 Review date:December2018


TOID 21438 CRICOS code 02552G Page1of36 Authorised by M. Phillips


Answered 4 days AfterMay 13, 2021SITXFIN004Training.Gov.Au

Answer To: Sheet Student name: Student ID:​ Student email: Phone: Course name: Diploma of Hospitality...

Riddhi answered on May 17 2021
136 Votes
Assessment 1 –
Debtors Control Ledger –
Debtors control ledger is the ledger that reviews the balance between customers and the company after considering all the invoices raised and all the payment received from the customer for credit sales. The opening balance of Debtors control ledger in usual cases is on the debit side and closing balance on the credit side in the ledger and on the trial, balance shows on the debit side, the final amount of closing balance for the month or the year under preparation. Debtors control ledger is derived from the debtors of all the customers separately and later transferred it to debtors control ledger for consolidated review of all the customers. This ledger plays an especially important role as in real life most of the business is done on credit and that is when these ledgers play especially important role to confirm the amount outstanding from the customers and accordingly regular follow up with the customers is
performed. Another name for debtors control ledger is sales ledger control account.
    Predicted Debtors control ledger as on 31st August 2017
    Particulars
    Dr
    Particulars
    Cr
    Balance B/F
    2,400
    Discount expense
    120
    Credit sales
    2,800
    Cash at bank
    3,120
    GST
    940
    Bad debts
    100
     
     
     
     
     
     
    Balance C/D
    2,800
     
     
     
     
     
    6,140
     
    6,140
Stock Control ledger –
Stock control account reflects all the entries related to the value of stock held in the organization which includes data related to opening stock, purchases, closing stock, cost of goods sold and loss of stock in any form including stock distributed as free samples. The objective behind maintaining this ledger is to keep a track on the inward and outward of the stock of all the SKUs put together. The stock control ledger opening balance is shown on the debit side and credit balance shown on the credit side and the amount on the trial balance is shown on the debit side. Stock control account is also known as inventory control account. The amount credited to the stock control account includes the items of inventory of the cost of invoice, loss of stock, stock distributed as free samples, defective goods returned to the suppliers etc and on the debit side return of goods by customer, inward of stock on purchase, etc. This account holds the cost of stock held by the business at the end of every month or every year depending upon the date of closing of books of accounts and they are then compared with the budgeted stock and the variance if any available.
    Predicted Stock Control Ledger as on 31st August 2017
    Particulars
    Dr
    Particulars
    Cr
    Balance B/F
    2,600
    Cost of sales
    4,600
    Creditors
    39,200
    Stock loss
    800
     
     
     
     
     
     
     
     
     
     
     
     
     
     
    Balance C/D
    36,400
     
     
     
     
     
    41,800
     
    41,800
Creditors control ledger –
Creditors control ledger tracks the movement of purchases in the business and its payment to the vendor with whom the transaction is carried out. The ledger reflects the amount company is liable to pay to all the vendors and this shall be displayed in the form of closing balance. All the purchases, discount earned, payment made to vendor from bank etc are included in the creditors control ledger which is to ensure that creditors are not paid in excess. The opening balance is shown on the credit side of the ledger, closing balance shown on the debit side of the ledger and shall be shown in the trial balance on the credit side. Creditors control account is also known as purchase ledger control account and all the entries from the individual supplier ledger is posted to the creditors control ledger to take the consolidated view of the payment outstanding to the suppliers at the end of every month and accordingly plan further purchase considering the reorder level, availability of goods and go down space. Most of the purchases in real life are done on credit and hence this account plays a significant role in the business operations in the course of buying and selling of goods and payment to the suppliers and designing the credit period with the suppliers.
    Predicted Creditors Control ledger as on 31st august 2017
    Particulars
    Dr
    Particulars
    Cr
    Cash at bank
    38,040
    Balance B/F
    8,600
    Discount revenue
    160
    Stock Control
    39,200
     
     
     
     
     
     
     
     
     
     
     
     
    Balance C/D
    9,600
     
     
     
     
     
     
     
    47,800
     
    47,800
Budgeted Cash flow statement –
Budgeted cash flow statement is not same as the cash budget. Cash budget simply reflects the flow or movement of cash in the organization based on how much money spent and how much money received. Budgeted cash flow statement represents the future cash flow from operations, investing activities and financing activities. Budgeted cash flow statement estimates the future cash receipts, cash payments and the balance in the bank. Cash flow from operating activities include the activities related to the operations of the business which includes cash sales, collection from debtors, collection of Goods and Service Tax, payment to creditors, purchase of stock or raw material, payment of expenses and GST etc. The cash flow from investing activities includes the activities related to purchase or sale of fixed assets and other non-current assets. The cash flow from financing activities includes the activities related to procuring finance in the form of loan or repayment of loan, drawings in cash by the owner, introduction of capital, dividend paid, buyback of shares, etc. Finally, the net increase or decrease in the cash flow is reviewed and added to the opening cash balance. Cash flow statement is budgeted to create strategies for purchase of goods from suppliers and designing their credit period and align those strategies with the sale of goods to the customers and provide them with the credit period that the business can afford. Cash budget is prepared using the actual data of previous month or quarter or year and then allocating the expected increase in sales with the credit period and according reviewing the availability of cash in the business to initiate any expansion plan or buy new equipment of asset for the business.
Budgeted Cash flow statement for the month ended 31st August 2017.
    In the Books of Cupcake Heaven
    Budgeted Cash flow statement for the month ended 31st August 2017
    Particulars
    Amount
    Cash flow from operating activities
     
    Cash Sales
    6,600
    Collection from debtors
    2,180
    GST Collected
    940
    Payment to creditors
    -38,040
    Wages
    -1600
    Office expenses
    -200
    GST Paid
    -3920
    Cash provided (used) by operating activities
    -34,040
     
     
    Net increase (decrease) by operating activities
     
    Cash held at beginning of the month
    3210
    Cash held at end of the month
    -30,830
     
     
Report on the likely future cash position of the Cupcake heaven
Prediction for future cash position of the business is necessary to plan for business expansion with the additional available cash reserve over and above safety margin. It helps in making business strategies related to credit policy for the customers, inventory reorder level, credit policy of the suppliers, expenses related to advertising and other ancillary expenses of the business. It also helps the owner of the business in deciding the amount available for him as withdrawal from the business on the last day of the week or Friday of the week or create a fixed pay out or withdraw more during peak business tenure and later withdraw nothing.
The company does not have sufficient funds to undertake the operating activities of the business, this is because of excessive purchase in the month of August which has caused the Cash flow crunch for the business. It was a conscious effort to purchase high quantity as the closing inventory reflects such prediction. If the company would have purchased lower quantity of stock, there would not be a deficit in the cash balance and now to fund the company if it is sole trader the owner will have to introduce capital. GST collected and GST Paid is included in the cash flow, but the fact is credit for the same will remain on the portal and not be available in the form of cash to the company. The future cash position is not very favourable, and the cupcake heaven will either increase the sales or will have to purchase goods according to the size of sale. The owner, Sarah Winter is in the cupcake business, which is related to food and hence, into perishable product and every grain or Millet comes with an expiry so if she keeps buying in bulk month on month without any planning all the product purchased with eventually expire leaving with heavy losses. So, Sarah winter should purchase raw materials in smaller quantities or equivalent to the orders for next two months but not for the period of 6 months unless there is a serious situation of scarcity of raw material for baking cupcakes or exceptional demand in the industry in the long term. Without any projected or predicted order it will not be advisable to keep such heavy inventory as it is also cost Sarah in the form of storage space to the business and some goods might required to be kept in refrigerator which will add to the cost of electricity.
Budgeted Profit and loss for the month ending 31st August 2017.
Budgeted profit and loss are prepared to understand the profit of the business at the end of the month to see whether the business is viable or not. It also helps in taking major business decisions like payment of any additional on the income of the business, recruitment of more labour or...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here