Can someone please work out the opening cash balance and collections from customers with working out. FactSheet
Fantastic news! We've Found the answer you've been seeking!
Question:
Can someone please work out the opening cash balance and collections from customers with working out.
Transcribed Image Text:
FactSheet - Data on 2022 Financial Year Sales Volume - Pedal Classic Sales Volume - Folding Urban Dream Service Volume - No. of Hours (Repairs) Selling Price - Pedal Classic Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Jul-2022 Aug-2022 Sep-2022 Oct-2022 Nov-2022 Dec-2022 227 238 213 222 212 260 250 227 137 167 182 195 297 312 318 307 318 414 407 326 293 287 396 403 270 284 289 279 289 376 370 296 266 261 360 366 $ 500.00 Cost Price - Pedal Classic $ 300.00 Selling Price - Folding Urban Dream $ 800.00 Cost Price - Folding Urban Dream $ 650.00 Service Revenue Per Hour (Repairs) $ 80.00 Number of Sale Assistants: 3 Wage Rate Per Employee Per Month $ 6,000 Number of Office Staff: 2 Wage Rate Per Employee Per Month $ 3,500 Number of Repair Technicians 4 Wage Rate Per Employee Per Month $ 5,500 Additional Information: Both Tracie and Conor are owners within the business and each of them draws an amount of $2186 per month. Each owner plans on increasing the drawings to $6558 per month starting from January of 2024. As the manager, Tracie keeps a close eye on inventory management and would like to always maintain a monthly ending inventory requirement of 20% of next month's sales. You can assume the beginning inventory for January 2024 to be 0 units for both Pedal Classic and Folding Urban Dream ebikes. All purchases of inventory with the current supplier are on a credit basis, with 60% of the amount settled in the same month of purchase and the remaining 40% settled one month after the month of purchase. You can assume that all credit amounts for purchase of inventory prior to January 2024 have been settled. The business typically will have 70% of their sales of Pedal Classic and Folding Urban Dream ebikes as cash, with the remaining 30% on credit. Of the credit sales, 50% is collected in the month of sales, 30% is collected one month after the sales, and 20% is collected two months after the sales. You can assume that all credit amounts for sale of inventory prior to January 2024 have been settled. All customers coming in for ebikes repairs pay for the service in cash 100% of the time. The business has the following non-current assets: In 2022, the business purchased one specialised equipment to provide repairs for the ebikes. The total cost of such one equipment is $26856 and it is expected to last 6 years. Other office equipment has a total cost of $15168 and depreciates at 25% per annum. Shop fittings were originally purchased at $87840 and depreciate at 10% per annum. All non-current assets have $0 residual value and are depreciated using the straight-line method of depreciation. Other Fixed Costs: Marketing expense of $2028 per annum is paid and incurred evenly across 12 months. $6216 of business insurance is paid in advance every year on 1st January. This insurance covers the period 1st Jan to 31st Dec every year (50% store; 50% office). Bank fees work out to be $130 per month and are paid at the end of each quarter. On average, the office supplies are purchased, paid and expensed every month to the amount of $155. Council rates are $1164 per year and are usually paid in December each year. The rates cover the period 1st Jan to 31st Dec every year. (60% store; 40% office) Rent is paid at the start of each quarter and works out to be $8120 per month. (80% store; 20% office) Water, gas and electricity are combined under utility expense which adds up to $630 per quarter and is usually paid at the end of each quarter. (70% store; 30% office) *Note: Quarter 1 runs from 1 Jan- 31 Mar; Quarter 2 runs from 1 Apr - 30 Jun; Quarter 3 runs from 1 Jul - 30 Sep; Quarter 4 runs from 1 Oct - 31 Dec. FactSheet - Data on 2022 Financial Year Sales Volume - Pedal Classic Sales Volume - Folding Urban Dream Service Volume - No. of Hours (Repairs) Selling Price - Pedal Classic Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Jul-2022 Aug-2022 Sep-2022 Oct-2022 Nov-2022 Dec-2022 227 238 213 222 212 260 250 227 137 167 182 195 297 312 318 307 318 414 407 326 293 287 396 403 270 284 289 279 289 376 370 296 266 261 360 366 $ 500.00 Cost Price - Pedal Classic $ 300.00 Selling Price - Folding Urban Dream $ 800.00 Cost Price - Folding Urban Dream $ 650.00 Service Revenue Per Hour (Repairs) $ 80.00 Number of Sale Assistants: 3 Wage Rate Per Employee Per Month $ 6,000 Number of Office Staff: 2 Wage Rate Per Employee Per Month $ 3,500 Number of Repair Technicians 4 Wage Rate Per Employee Per Month $ 5,500 Additional Information: Both Tracie and Conor are owners within the business and each of them draws an amount of $2186 per month. Each owner plans on increasing the drawings to $6558 per month starting from January of 2024. As the manager, Tracie keeps a close eye on inventory management and would like to always maintain a monthly ending inventory requirement of 20% of next month's sales. You can assume the beginning inventory for January 2024 to be 0 units for both Pedal Classic and Folding Urban Dream ebikes. All purchases of inventory with the current supplier are on a credit basis, with 60% of the amount settled in the same month of purchase and the remaining 40% settled one month after the month of purchase. You can assume that all credit amounts for purchase of inventory prior to January 2024 have been settled. The business typically will have 70% of their sales of Pedal Classic and Folding Urban Dream ebikes as cash, with the remaining 30% on credit. Of the credit sales, 50% is collected in the month of sales, 30% is collected one month after the sales, and 20% is collected two months after the sales. You can assume that all credit amounts for sale of inventory prior to January 2024 have been settled. All customers coming in for ebikes repairs pay for the service in cash 100% of the time. The business has the following non-current assets: In 2022, the business purchased one specialised equipment to provide repairs for the ebikes. The total cost of such one equipment is $26856 and it is expected to last 6 years. Other office equipment has a total cost of $15168 and depreciates at 25% per annum. Shop fittings were originally purchased at $87840 and depreciate at 10% per annum. All non-current assets have $0 residual value and are depreciated using the straight-line method of depreciation. Other Fixed Costs: Marketing expense of $2028 per annum is paid and incurred evenly across 12 months. $6216 of business insurance is paid in advance every year on 1st January. This insurance covers the period 1st Jan to 31st Dec every year (50% store; 50% office). Bank fees work out to be $130 per month and are paid at the end of each quarter. On average, the office supplies are purchased, paid and expensed every month to the amount of $155. Council rates are $1164 per year and are usually paid in December each year. The rates cover the period 1st Jan to 31st Dec every year. (60% store; 40% office) Rent is paid at the start of each quarter and works out to be $8120 per month. (80% store; 20% office) Water, gas and electricity are combined under utility expense which adds up to $630 per quarter and is usually paid at the end of each quarter. (70% store; 30% office) *Note: Quarter 1 runs from 1 Jan- 31 Mar; Quarter 2 runs from 1 Apr - 30 Jun; Quarter 3 runs from 1 Jul - 30 Sep; Quarter 4 runs from 1 Oct - 31 Dec.
Expert Answer:
Answer rating: 100% (QA)
To calculate the opening cash balance and collections from customers we need to analyze the provided financial data However without the actual data fr... View the full answer
Related Book For
Financial Accounting An Introduction to Concepts, Methods and Uses
ISBN: 978-1133591023
14th edition
Authors: Roman L. Weil, Katherine Schipper, Jennifer Francis
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Problem Set 3 b. zero. c. negative. d. smaller than the variance. 22. Growth factors for the population of Atlanta in the past five years have been 1, 2, 3, 4, and 5. The geometric mean is a. 15. b....
-
Plot the following lines: a. y = 4 + x b. y = 5 - 2x c. y = -4 + 3x d. y = -2x e. y = x f. y = .50 + 1.5x
-
Dinoco Petroleum faces three potential contingency situations, described below. Dinocos fiscal year ends December 31, 2021, and it issues its 2021 financial statements on March 15, 2022. Required:...
-
Founded in 1966 as a trader of oil and oil products, Vitol is a company with no external shareholders. All shareholders are also employees. It is a conglomerate company of energy companies that work...
-
Scentsation, Inc., budgeted for 12,000 bottles of perfume Oui during the month of May. The unit cost of Oui was $20, consisting of direct materials, $7; direct labor, $8; and factory overhead, $5...
-
I wrote a relational model for the ER form, but I failed to normalize it. I separated customer contact from customer but I think there should be more. According to the EER chart given, is this...
-
Cinder and PQ are associated [ITA 256(1)(a)] and connected [ITA 186(4)] for tax purposes. Cinder Inc. is a Canadian-controlled private corporation based in your province. The company operates a...
-
Search "scholar.google.com" for a company or school that has defined the role of endusers in the creation of a contingency plan. Discuss why it is (or is not) important to include end users in the...
-
(a) Periodic inventory If sales account is $10 000 and the calculated value of the cost of sales is $4600, what is the gross profit where periodic inventory applies? (b) Perpetual inventory If sales...
-
On 1 July 2022, M Biel commenced business with bank $1000 and earthmoving equipment $36 000. On 1 August 2022 M Biel contributed further funds $10 000, GST receivable $5000 and a grader $50 000. On 1...
-
On 1 February 2022, T Abella commenced business with $50 000 bank and a loan from Strate bank $20 000. On 3 February T Abella purchased the existing continuing business of T Longman for $48 000 and...
-
M Gonzalez commenced business on 1 November 2022 with the following assets and liabilities: bank $2000, inventory $1500, accounts receivable control of $ . . . . . . . . . . for P Chain $451 and G...
-
G Attard commenced business on 1 December 2022 with capital $14 000 and the following assets and liability: bank $5000, inventory $4000, motor vehicle $8000, office furniture and equipment $1000 and...
-
Hot working of steel is performed at about (A) 100 (B) 900 (C) 400 (D) 1500
-
7 A 29-year-old, previously healthy man suddenly collapses at a party where legal and illicit drugs are being used. Enroute to the hospital, he requires resuscitation with defibrillation to establish...
-
The notes to the financial statements of Bayer Group, a German pharmaceutical company, report a balance of 154 million for Restructuring Provisions on December 31; for the prior year, the ending...
-
Exhibit 12.24 presents information from the income tax note of Dime Store, a discount retailer, for its fiscal years ending January 31, 2013, 2012, and 2011. Dime Store applies U.S. GAAP. a. Present...
-
The following information is based on accounting data for Year 7 and Year 8 for China Oil Company (COC), a large petrochemicals company in China. COC applies IFRS, and reports its results in millions...
-
Think back to the gold standard period. If the United States suffered a recession, to what degree could it engage in expansionary monetary policy?
-
True or False. A higher price level increases aggregate expenditures.
-
If the government decreases expenditures, the AE curve will shift _______ and the AD curve will shift _______. a. down; left b. down; right c. up; left d. up; right
Study smarter with the SolutionInn App