Cozzie Ltd (you can use the supplied excel spreadsheet on ELE for speed) Cozzie Ltd. manufactures...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cozzie Ltd (you can use the supplied excel spreadsheet on ELE for speed) Cozzie Ltd. manufactures and sells swimwear to retailers. The cash budget has been prepared for the period January 2021 - June 2021: Receipts Sales Interest received Total Receipts Payments Purchases Wages & Salaries Machinery Rent Taxation Other expenditure Transportation costs Final dividend payment Total Payments Overdraft interest Net cash inflow/outflow Opening cash balance Closing cash balance. May June January November 2020 December 2020 2021 2021 78,000 2,500 80,500 Februar y Additional information: 94,600 2,500 97,100 120,000 110,800 18,200 18,200 85,000 3,600 March 172,350 2,500 174,850 82,600 16,400 42,000 4,100 1,800 20,000 294,700 134,500 104,200 (716) (875) (214,200 ) 42,400 (171,800 (209,916 (140,140 Sales 78,000 94,600 246,000 235,000 April 3,600 3,200 3,100 4,800 2,300 2,100 3,500 210,000 198,000 2,500 2,500 200,500 212,500 74,800 66,200 16,400 16,400 103,100 (584) Budgeted monthly figures (from the Income Period May Purchases 130,000 120,000 58,200 62,400 3,200 2,200 (38,116) 69,775 96,816 124,319 141,700 (171,800 (209,916 (140,140 ) (43,324) 80,995 (43,324) 80,995 222,695 June 220,000 2,500 222,500 58,200 16,400 3,600 2,600 88,000 80,800 (181) All purchases are bought on credit, a 30 day settlement period has been negotiated with suppliers. All goods are sold on credit, a 60 day settlement period has been negotiated with customers. Cozzie Ltd (you can use the supplied excel spreadsheet on ELE for speed) Cozzie Ltd. manufactures and sells swimwear to retailers. The cash budget has been prepared for the period January 2021 - June 2021: Receipts Sales Interest received Total Receipts Payments Purchases Wages & Salaries Machinery Rent Taxation Other expenditure Transportation costs Final dividend payment Total Payments Overdraft interest Net cash inflow/outflow Opening cash balance Closing cash balance. May June January November 2020 December 2020 2021 2021 78,000 2,500 80,500 Februar y Additional information: 94,600 2,500 97,100 120,000 110,800 18,200 18,200 85,000 3,600 March 172,350 2,500 174,850 82,600 16,400 42,000 4,100 1,800 20,000 294,700 134,500 104,200 (716) (875) (214,200 ) 42,400 (171,800 (209,916 (140,140 Sales 78,000 94,600 246,000 235,000 April 3,600 3,200 3,100 4,800 2,300 2,100 3,500 210,000 198,000 2,500 2,500 200,500 212,500 74,800 66,200 16,400 16,400 103,100 (584) Budgeted monthly figures (from the Income Period May Purchases 130,000 120,000 58,200 62,400 3,200 2,200 (38,116) 69,775 96,816 124,319 141,700 (171,800 (209,916 (140,140 ) (43,324) 80,995 (43,324) 80,995 222,695 June 220,000 2,500 222,500 58,200 16,400 3,600 2,600 88,000 80,800 (181) All purchases are bought on credit, a 30 day settlement period has been negotiated with suppliers. All goods are sold on credit, a 60 day settlement period has been negotiated with customers.
Expert Answer:
Answer rating: 100% (QA)
A cash budget is a financial tool used by managers to determine the availability of cash and to plan for potential shortages or excesses It is prepare... View the full answer
Related Book For
Financial And Management Accounting An Introduction
ISBN: 9781292244419
8th Edition
Authors: Pauline Weetman
Posted Date:
Students also viewed these accounting 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...
-
The following table, reproduced from Exercise 13.26, gives information on the amount of sugar (in grams) and the calorie count in one serving of a sample of 13 varieties of Kelloggs cereal. a. Make a...
-
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...
-
The following data pertain to the securities of Linford Company during 2012, the companys first year of operations: a. Purchased 400 shares of Persimmon Corporation stock at $40 per share plus a...
-
The Evanec Companys next expected dividend, D1, is $3.18; its growth rate is 6%; and its common stock now sells for $36.00. New stock (external equity) can be sold to net $32.40 per share. a. What is...
-
Solve the following SDEs using the general integrating factor method with \(X_{0}=0\) : (a) \(d X_{t}=\frac{X_{t}}{t} d t+\sigma t X_{t} d B_{t}\), (b) \(d X_{t}=X_{t}^{\alpha}+\sigma X_{t} d...
-
Thirty-three percent of online consumers in Russia prefer to shop online using smartphones. You randomly select 12 consumers. Find the probability that the number of online consumers who purchase...
-
At the end of 2014, Endrun Co. has accounts receivable of $700,000 and an allowance for doubtful accounts of $54,000. On January 24, 2015, the company learns that its receivable from Marcello is not...
-
How many standards are included in the ELP accreditation standards? What stands out to you about the different areas? What are the topic areas under administration and leadership? What are the...
-
Suppose that there are p = 4 quality characteristics, and in correlation form all four variables have variance unity and that all pairwise correlation coefficients are 0.9. The in-control value of...
-
Following Bohr, we assume that a hydrogen-like atom may be modelled as a single electron (mass m and charge -e) in a circular orbit around a much more massive nucleus (charge +Ze). (a) By balancing...
-
Eddie gets his haircut from Lui at Hats Off Barbershop. Prices are listed on a sign Hats Off has posted on the wall. After his hair cut is finished, Eddie tells Lui he is not going to pay for his...
-
How has family law in relation to separation evolved in response to changing values in the community?
-
1. Define family law and list at least five ways in which it has evolved since the 1970s. 2. Identify a minimum of three ways in which technology is influencing the practice of family law. 3....
-
Explain the Family law in Canada and the area it governs. Mention the issues that might seem like it falls under the family law but instead falls under provincial law instead. Elaborate as to why it...
-
Identify the impact that Family Law has on business Relate aspects of personal and family law with the obligations and contracts of a business.?
-
The dollar cost of the Euro is $1.19. a. You are planning a trip to Europe and read that hotel charges 125 euros per night. What is the cost to you in dollars? b. Your dollar will buy how many...
-
Huntingdon Capital Corp. is a competitor of Plazacorp and First Capital Realty. Huntingdon reported the following selected information (in millions):...
-
A manufacturer of toothpaste has estimated the price at which the product will sell, making use of market surveys and consumer analysis. A profit margin has been set. Finally a target cost has been...
-
The following financial statements relate to Hope plc: Income statement (profit and loss account)for the year ended 30 June Year 4 ...
-
Form a study group of four to six persons who are to negotiate the development of a new production line to process canned peas. The canned peas will replace an existing product, canned carrots. Half...
-
Consider the multiple linear regression model fit to the baseball data in Problem 3.41. Problem 3.41 Consider the 2016 major league baseball data in Table B.22. While team ERA was useful in...
-
Consider the simple linear regression model fit to the rental price data from Problem 2.36. Data From Problem 2.36 Table B.24 contains data on median family home rental price and other data for 51 US...
-
Consider the multiple linear regression model fit to the rental price data in Problem 3.42. Problem 3.42 Table B.24 contains data on median family home rental price and other data for 51 US cities....
Study smarter with the SolutionInn App