Jetson Valves Ltd. (JVL) is engaged in manufacturing small-sized valves used in a variety of industrial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Jetson Valves Ltd. (JVL) is engaged in manufacturing small-sized valves used in a variety of industrial applications. The company is located in Ahmedabad and is one of the leading suppliers of these products to a large number of companies engaged in manufacturing machinery and other light engineering products. In recent years, the competition in this type of business has intensified. JVL has been able to withstand this competition and has been growing rapidly. The main reasons for its growth have been its good image for quality products, technological improvements leading to increased production capacity, cost advantage, and strong marketing team. Q-4 CLO 4 Jetson Valves Ltd. BL-4 Jetson Valves Ltd. (JVL) is engaged in manufacturing small-sized valves used in a variety of industrial applications. The company is located in Ahmedabad and is one of the leading suppliers of these products to a large number of companies engaged in manufacturing machinery and other light engineering products. In recent years, the competition in this type of business has intensified. JVL has been able to withstand this competition and has been growing rapidly. The main reasons for its growth have been its good image for quality products, technological improvements leading to increased production capacity, cost advantage, and strong marketing team. During the last two years of operation, the company has been facing frequent cash deficit problems, as a result of which the company has not been able to meet its obligation to pay its suppliers on time. The company's reputation as a credit-worthy customer has gone down. Mr. Anand Roy, CFO of the company speculates that if this experience is repeated, the suppliers would force the company for cash payments for its purchases. To prevent the re-occurrence of postponement of payments, he wanted to plan his cash in a better way. CFO asked his finance manager Mr. Aditya Joshi to develop the monthly cash forecasts for the period starting from January 2023 to June 2023. Mr. Joshi obtained the following actual sales figures from the records of the last three months. Actual Sales (Lakh Rupees) 480 October 2022 November 2022 560 December 2022 640 Month Mr. Joshi first tried to develop sales forecasts for the next seven months. After consulting with CFO, he developed the following forecasts. Month January 2016 February 2016 March 2016 April 2016 May 2016 June 2016 July 2016 Month January 2023 February 2023 Page 3 of 4 Over the past three years, JVL had an average of 25 percent of the total sales as cash sales, the remaining 75 percent of the sales being accounts receivables. 40 percent of these accounts receivables were collected in the first month after sales, 30 percent of collections took. place in the second month after the sales and the remaining receivables were collected in the third month. March 2023 April 2023 May 2023 June 2023 Sales Forecast (Rs. In Lakh) 520 420 320 480 400 320 400 JVL's average consumption of raw materials is 80 percent of the total sales in each month. The accounts indicated that 40 percent of this is paid in the same month itself, 55 percent in the following month, and the remaining in the third month. Mr. Joshi anticipated payments for wages and salaries to be as follows; Payments (Rs. In Lakhs) 84 Total Receipts Total Payments Surplus (+) / Deficit (-) 6MP103 78 64 80 64 56 The general administrative expenses were assumed to be about Rs. 5. Lakh per month. Mr. Joshi was aware of the 16 percent annual interest. payment liability on Rs. 40 Lakh of borrowing to be paid in the month of March. A final tax payment on 2022 income of Rs. 5 Lakh is due in April. Mr. Joshi estimated that JVL's tax liability for the next accounting year is expected to be Rs. 48 Lakh, for which the company would be required to pay the tax in advance. Equal quarterly installment of such liability of Rs. 12 Lakh would be due in March, June, September, and December. He is also aware that a capital expenditure of Rs. 150 Lakh is planned in February, of which 50 percent will have to be paid in the same month and the remaining in May. The company has a cash and cash equivalent balance of Rs. 15,00,000 as on December 31. Question: Putting yourself in the place of Mr. Joshi, prepare the cash budget for JVL for the relevant period and suggest in which month, the company would be required to arrange line of credit from their bankers. Strictly report the summary of cash budget in the following format; Particulars Jan Feb Mar Apr May Jun Page 4 of 4 (25) Jetson Valves Ltd. (JVL) is engaged in manufacturing small-sized valves used in a variety of industrial applications. The company is located in Ahmedabad and is one of the leading suppliers of these products to a large number of companies engaged in manufacturing machinery and other light engineering products. In recent years, the competition in this type of business has intensified. JVL has been able to withstand this competition and has been growing rapidly. The main reasons for its growth have been its good image for quality products, technological improvements leading to increased production capacity, cost advantage, and strong marketing team. Q-4 CLO 4 Jetson Valves Ltd. BL-4 Jetson Valves Ltd. (JVL) is engaged in manufacturing small-sized valves used in a variety of industrial applications. The company is located in Ahmedabad and is one of the leading suppliers of these products to a large number of companies engaged in manufacturing machinery and other light engineering products. In recent years, the competition in this type of business has intensified. JVL has been able to withstand this competition and has been growing rapidly. The main reasons for its growth have been its good image for quality products, technological improvements leading to increased production capacity, cost advantage, and strong marketing team. During the last two years of operation, the company has been facing frequent cash deficit problems, as a result of which the company has not been able to meet its obligation to pay its suppliers on time. The company's reputation as a credit-worthy customer has gone down. Mr. Anand Roy, CFO of the company speculates that if this experience is repeated, the suppliers would force the company for cash payments for its purchases. To prevent the re-occurrence of postponement of payments, he wanted to plan his cash in a better way. CFO asked his finance manager Mr. Aditya Joshi to develop the monthly cash forecasts for the period starting from January 2023 to June 2023. Mr. Joshi obtained the following actual sales figures from the records of the last three months. Actual Sales (Lakh Rupees) 480 October 2022 November 2022 560 December 2022 640 Month Mr. Joshi first tried to develop sales forecasts for the next seven months. After consulting with CFO, he developed the following forecasts. Month January 2016 February 2016 March 2016 April 2016 May 2016 June 2016 July 2016 Month January 2023 February 2023 Page 3 of 4 Over the past three years, JVL had an average of 25 percent of the total sales as cash sales, the remaining 75 percent of the sales being accounts receivables. 40 percent of these accounts receivables were collected in the first month after sales, 30 percent of collections took. place in the second month after the sales and the remaining receivables were collected in the third month. March 2023 April 2023 May 2023 June 2023 Sales Forecast (Rs. In Lakh) 520 420 320 480 400 320 400 JVL's average consumption of raw materials is 80 percent of the total sales in each month. The accounts indicated that 40 percent of this is paid in the same month itself, 55 percent in the following month, and the remaining in the third month. Mr. Joshi anticipated payments for wages and salaries to be as follows; Payments (Rs. In Lakhs) 84 Total Receipts Total Payments Surplus (+) / Deficit (-) 6MP103 78 64 80 64 56 The general administrative expenses were assumed to be about Rs. 5. Lakh per month. Mr. Joshi was aware of the 16 percent annual interest. payment liability on Rs. 40 Lakh of borrowing to be paid in the month of March. A final tax payment on 2022 income of Rs. 5 Lakh is due in April. Mr. Joshi estimated that JVL's tax liability for the next accounting year is expected to be Rs. 48 Lakh, for which the company would be required to pay the tax in advance. Equal quarterly installment of such liability of Rs. 12 Lakh would be due in March, June, September, and December. He is also aware that a capital expenditure of Rs. 150 Lakh is planned in February, of which 50 percent will have to be paid in the same month and the remaining in May. The company has a cash and cash equivalent balance of Rs. 15,00,000 as on December 31. Question: Putting yourself in the place of Mr. Joshi, prepare the cash budget for JVL for the relevant period and suggest in which month, the company would be required to arrange line of credit from their bankers. Strictly report the summary of cash budget in the following format; Particulars Jan Feb Mar Apr May Jun Page 4 of 4 (25)
Expert Answer:
Answer rating: 100% (QA)
The images provided contain information for preparing a cash budget for Jetson Valves Ltd JVL for the period from January 2023 to June 2023 A cash budget is a financial plan that estimates cash inflow... View the full answer
Related Book For
Managerial Accounting Creating Value in a Dynamic Business Environment
ISBN: 978-0078025662
10th edition
Authors: Ronald Hilton, David Platt
Posted Date:
Students also viewed these finance questions
-
Introduction In 2010, New United Motor Manufacturing, Inc., a unique and highly successful joint venture between Americas General Motors and Japans Toyota, went out of business. NUMMI, as the...
-
In Exercises find the derivative of the algebraic function. f(x) = (2x + 5x)(x 3)(x + 2)
-
Research has shown that losing even one night's sleep can have a significant effect on performance of complex tasks such as problem solving (Linde & Bergstroem, 1992). To demonstrate this phenomenon,...
-
Let g: A Rp be as in Theorem 5-1. If f: Rn R is differentiable and the maximum (or minimum) of f on g-1 (0) occurs at , show that there are , such that
-
Craxton Engineering will either purchase or lease a new $756,000 fabricator. If purchased, the fabricator will be depreciated on a straight-line basis over seven years. Craxton can lease the...
-
Steve Morgan, controller for Newton Industries, was reviewing production cost reports for the year. One amount in these reports continued to bother himadvertising. During the year, the company had...
-
10. A plastic ball is rising in water with terminal speed v. If we use a different plastic whose density is double that of the original ball but still less that density of water, keeping the radius...
-
A 18 cm radius air duct is used to replenish the air of a room 7.7m x 7.0m x 4.5m every 19 min. Part A How fast does air flow in the duct? Express your answer to two significant figures and include...
-
Using equation (2.4), what is the demand equation as a function of Ps if the price of other pastas ( P o ) is $3, the individuals income ( Y ) in thousands is $25, and tastes ( Z ) are represented by...
-
Speculate on what types of services are more appropriate to large, regional hospitals, and what types of services are more appropriate to small, local hospitals.
-
Consider a project that costs $10,000 today. It will provide benefi ts of $4,000 at the end of Year 1, $3,500 at the end of Year 2, and $3,500 at the end of Year 3. If the discount rate is 6 percent,...
-
In considering the difference in smoking between men and women, what is the null hypothesis? What is the alternative hypothesis? Is the alternative hypothesis simple or composite?
-
Because health insurance tends inevitably to cause moral hazard, will the population necessarily be overinsured (in the sense that a reduction in insurance would improve welfare)? Are there benefi...
-
Earth Star Diamonds Inc. began a potentially lucrative mining operation on October 1, 2020. It is authorized to issue 100,000 shares of $0.60 cumulative preferred shares and 500,000 common shares....
-
The following T-accounts show postings of selected transactions. Indicate the journal used in recording each of these postings a through e. Cash Accounts Receivable Inventory (d) 500 (e) 300 (b)...
-
Hiawatha Hydrant Company manufactures fire hydrants in Oswego, New York. The following information pertains to operations during May. Processing time (average per batch)......................4.25...
-
Outback, Ltd., manufactures tactical LED flashlights in Melbourne, Australia. The firm uses an absorption-costing system for internal reporting purposes; however, the company is considering using...
-
Allegheny River Sawmill manufactures two lumber products from a joint milling process. The two products developed are mine support braces (MSB) and unseasoned commercial building lumber (CBL). A...
-
a. Write out and explain the equation for volume breakeven. b. What is the difference between accounting breakeven and economic breakeven?
-
What is marginal analysis?
-
a. What is cost shifting? b. What is cross-subsidization?
Study smarter with the SolutionInn App