Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Both photos are a part of the same question. For this assessment, you will make two submissions: (1) your answers to all parts in one

image text in transcribed

image text in transcribed

Both photos are a part of the same question.

image text in transcribed

For this assessment, you will make two submissions: (1) your answers to all parts in one Word document through the "At Written..." submission link; and (2) your video for part 3 through the "A4 Video..."link. DO NOT include the questions in your submission document. Instead, use part numbers as headings. Marks for Parts 1(a) and 2(a) will be based on accuracy, correct approach and a concise, tidy and easy to follow presentation of the figures. Marks for Parts 1(b) and 2(b) will be based on practical and applied answers that demonstrate understanding of the relevant unit content (referring to relevant concepts) and are appropriate for the given scenario. References should be kept to an absolute minimum in this applied context. References to journal papers, in particular, are unnecessary and will detract from your answer. A separate marking rubric will be provided for Part 3 of the assignment The Overall Scenario You work for a management consulting firm and have 3 client jobs to complete: 1. Prepare a cash budget for XYZ Pty Ltd and provide associated advice on required financing: 2. Prepare and interpret a variance analysis for ABC Pty Ltd; and 3. Advise LMN Pty Ltd on sources of finance. Job Details 1. XYZ Pty Ltd operates in a seasonal industry with a sales peak in spring. Budgeted sales, along with budgeted raw materials and labour costs are shown in the table below. Month May June July Aug Sep Oct Nov Dec Extract from budgeted income statement Sales Labour and materials $150,000 $105,000 $160,000 $112,000 $210,000 $147,000 $300,000 $210,000 $400,000 $280,000 $500,000 $350,000 $340,000 $238,000 $200,000 $140,000 All sales are on credit and past records indicate that collections are as follows: 20% in the month of sale, 55% in the month after sale and 25% in the second month after sale. Labour and materials are paid as follows: 60% in the month the expenses are incurred and 40% in the month following that. Other budgeted expenses during the period July to December are as follows: selling, general and administration of $30,000 per month; rent of $10,000 per month; and depreciation of $20,000 per month. Where relevant, payments are made in the month the expenses are incurred. Taxation payments of $33,000 each will be made at the end of September and end of December. In October, company motor vehicles will be traded-in for new models with an expected net cash payment of $80,000. The motor vehicles are expected to have an 8 year life. Required: (a) prepare a cash budget for the company for July through to December (inclusive) (9 marks) (b) advise the company on the debt financing that would best be used to deal with cash shortfalls and major payments in the cash budget. Your advice in this part should explain and provide reasons for your recommendations and be a maximum of 200 words. (6 marks) For this assessment, you will make two submissions: (1) your answers to all parts in one Word document through the "At Written..." submission link; and (2) your video for part 3 through the "A4 Video..."link. DO NOT include the questions in your submission document. Instead, use part numbers as headings. Marks for Parts 1(a) and 2(a) will be based on accuracy, correct approach and a concise, tidy and easy to follow presentation of the figures. Marks for Parts 1(b) and 2(b) will be based on practical and applied answers that demonstrate understanding of the relevant unit content (referring to relevant concepts) and are appropriate for the given scenario. References should be kept to an absolute minimum in this applied context. References to journal papers, in particular, are unnecessary and will detract from your answer. A separate marking rubric will be provided for Part 3 of the assignment The Overall Scenario You work for a management consulting firm and have 3 client jobs to complete: 1. Prepare a cash budget for XYZ Pty Ltd and provide associated advice on required financing: 2. Prepare and interpret a variance analysis for ABC Pty Ltd; and 3. Advise LMN Pty Ltd on sources of finance. Job Details 1. XYZ Pty Ltd operates in a seasonal industry with a sales peak in spring. Budgeted sales, along with budgeted raw materials and labour costs are shown in the table below. Month May June July Aug Sep Oct Nov Dec Extract from budgeted income statement Sales Labour and materials $150,000 $105,000 $160,000 $112,000 $210,000 $147,000 $300,000 $210,000 $400,000 $280,000 $500,000 $350,000 $340,000 $238,000 $200,000 $140,000 All sales are on credit and past records indicate that collections are as follows: 20% in the month of sale, 55% in the month after sale and 25% in the second month after sale. Labour and materials are paid as follows: 60% in the month the expenses are incurred and 40% in the month following that. Other budgeted expenses during the period July to December are as follows: selling, general and administration of $30,000 per month; rent of $10,000 per month; and depreciation of $20,000 per month. Where relevant, payments are made in the month the expenses are incurred. Taxation payments of $33,000 each will be made at the end of September and end of December. In October, company motor vehicles will be traded-in for new models with an expected net cash payment of $80,000. The motor vehicles are expected to have an 8 year life. Required: (a) prepare a cash budget for the company for July through to December (inclusive) (9 marks) (b) advise the company on the debt financing that would best be used to deal with cash shortfalls and major payments in the cash budget. Your advice in this part should explain and provide reasons for your recommendations and be a maximum of 200 words. (6 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Accounting

Authors: Frederick D. Choi, Gary K. Meek

7th Edition

978-0136111474, 0136111475

More Books

Students also viewed these Accounting questions

Question

Understand the different approaches to job design. page 184

Answered: 1 week ago