19C10.61 lectronique Instruments, a rapidly expanding electronic parts distributor, is formulating its plans for 2022. John...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
19C10.61 lectronique Instruments, a rapidly expanding electronic parts distributor, is formulating its plans for 2022. John Kedrowski, the firm's director of marketing, has completed his 2022 forecast and is confident that the compan meet or exceed sales estimates. The following sales figures show the growth that is expected and are the basis for pl. in the other corporate departments: Forecast Sales Forecast Month Month January $2,800,000 July Sales $4,000,000 February 3,000,000 August 4,000,000 March 2,800,000 September 4,200,000 April 3,200,000 October 4,200,000 3,500,000 November 4,000,000 May June 3,800,000 December 4,400,000 Tae Hwan, assistant controller, is responsible for the cash flow projection, a critical element during a period of rapid expansion. She will use the following information in preparing her cash analysis: 1. lectronique has experienced an excellent record in accounts receivable collection and expects this trend to continue. The company collects 50% of billings in the month after the sale and 50% in the second month after the sale. Uncollectible accounts are nominal and can be ignored in the analysis. 2. The purchase of electronic parts is lectronique's largest expenditure; the cost of these items is equal to 60% of sales. lectronique receives 40% of the parts one month before it sells them and 60% during the month of sale. 3. Historically, lectronique has cleared 60% of the accounts payable one month after it receives its purchases, and the remaining 40% two months after. A 4. Hourly wages, including fringe benefits, depend on the sales volume; they are equal to 20% of the current month's sales. The company pays these wages in the month incurred. 5. General and administrative expenses are projected to be $2,750,000 for 2022. The composition of these expenses is given below. The company incurs all of these expenses uniformly throughout the year, except for property taxes. It pays the property taxes in four equal instalments in the last month of each quarter: Salaries Promotion Property taxes Insurance Utilities Depreciation $ 490,000 670,000 250,000 370,000 350,000 620,000 $2,750,000 6. lectronique makes income tax payments in the first month of each quarter based on income for the prior quarter. The tax rate is 30%. The net income for the first quarter of 2022 is projected to be $750,000. 7. lectronique has a corporate policy of maintaining an end-of-month cash balance of $200,000. It invests or borrows cash monthly, as necessary, to maintain this balance. 8. lectronique uses a calendar-year reporting period. Instructions Prepare a schedule of Cash Receipts and Disbursements for lectronique Instruments, by month, for the second quarter of 2022. Be sure that all receipts, disbursements, borrowing, and investing amounts are presented on a monthly basis. Ignore the interest expense and income from borrowing and investing. 19C10.61 lectronique Instruments, a rapidly expanding electronic parts distributor, is formulating its plans for 2022. John Kedrowski, the firm's director of marketing, has completed his 2022 forecast and is confident that the compan meet or exceed sales estimates. The following sales figures show the growth that is expected and are the basis for pl. in the other corporate departments: Forecast Sales Forecast Month Month January $2,800,000 July Sales $4,000,000 February 3,000,000 August 4,000,000 March 2,800,000 September 4,200,000 April 3,200,000 October 4,200,000 3,500,000 November 4,000,000 May June 3,800,000 December 4,400,000 Tae Hwan, assistant controller, is responsible for the cash flow projection, a critical element during a period of rapid expansion. She will use the following information in preparing her cash analysis: 1. lectronique has experienced an excellent record in accounts receivable collection and expects this trend to continue. The company collects 50% of billings in the month after the sale and 50% in the second month after the sale. Uncollectible accounts are nominal and can be ignored in the analysis. 2. The purchase of electronic parts is lectronique's largest expenditure; the cost of these items is equal to 60% of sales. lectronique receives 40% of the parts one month before it sells them and 60% during the month of sale. 3. Historically, lectronique has cleared 60% of the accounts payable one month after it receives its purchases, and the remaining 40% two months after. A 4. Hourly wages, including fringe benefits, depend on the sales volume; they are equal to 20% of the current month's sales. The company pays these wages in the month incurred. 5. General and administrative expenses are projected to be $2,750,000 for 2022. The composition of these expenses is given below. The company incurs all of these expenses uniformly throughout the year, except for property taxes. It pays the property taxes in four equal instalments in the last month of each quarter: Salaries Promotion Property taxes Insurance Utilities Depreciation $ 490,000 670,000 250,000 370,000 350,000 620,000 $2,750,000 6. lectronique makes income tax payments in the first month of each quarter based on income for the prior quarter. The tax rate is 30%. The net income for the first quarter of 2022 is projected to be $750,000. 7. lectronique has a corporate policy of maintaining an end-of-month cash balance of $200,000. It invests or borrows cash monthly, as necessary, to maintain this balance. 8. lectronique uses a calendar-year reporting period. Instructions Prepare a schedule of Cash Receipts and Disbursements for lectronique Instruments, by month, for the second quarter of 2022. Be sure that all receipts, disbursements, borrowing, and investing amounts are presented on a monthly basis. Ignore the interest expense and income from borrowing and investing.
Expert Answer:
Related Book For
Managerial Accounting Tools for Business Decision Making
ISBN: 978-1118856994
4th Canadian edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso, Ibrahim M. Aly
Posted Date:
Students also viewed these finance questions
-
How all-you-can eat buffets really make money? What are the economics & probability of profit? What is there pricing strategy?
-
lectronique Instruments, a rapidly expanding electronic parts distributor, is formulating its plans for 2012. John Kedrowski, the firms director of marketing, has completed his 2012 forecast and is...
-
Electronique Instruments, a rapidly expanding electronic parts distributor, is formulating its plans for 2016. John Kedrowski, the firm's director of marketing, has completed his 2016 forecast and is...
-
how good are your with western civilization history?? choose one of the following topics topic 1: based on the texts by kafka and eliot, (writing on one or the other or both), discuss how the writers...
-
Indicate the hybridization of the central atom in (a) BCl3 (b) AlCl4- (c) CS2 (d) GeH4.
-
If \(a=10 \mathrm{ft}\), find \(b\). Refer to the \(45^{\circ}-45^{\circ}-90^{\circ}\) triangle shown in the following exercise. 45 b 45%
-
Let \(P_{t}\) be the observed market price of an asset, which is related to the fundamental value of the asset \(P_{t}^{*}\) via Eq. (5.9). Assume that \(\Delta P_{t}^{*}=P_{t}^{*}-P_{t-1}^{*}\)...
-
Hirams Lakeside is a popular restaurant located on Lake Washington in Seattle. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern...
-
Find newspaper article headline that could be rephrased using the language of partial derivatives. Write the original headline, and give the source. Explain how it relates to partial derivatives. In...
-
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service departments efforts (in percentages) to the other...
-
A process manager wants to use control charts to control their process. They have decided that each sample should have 4 observations. The number of standard deviations the manager wants to use is 3....
-
NoSQL databases can store relationship datathey just store it differently than relational databases do. How would you describe the differences between a relational database and a NoSQL database? What...
-
A Company produces three products A, B and C in a manufacturing process. Theoutput for the month of October was 12000 units of product A, 8000 units of B and 10000 units of C. The pre separation...
-
How much conversion cost was assigned to the units transferred out of the Fitting Department during March? . Sadanand Corporation uses the weighted-average method in its process costing system. The...
-
This question also connects with the FXstreet forecasts and the hedging decision depends on the number of analysts projecting an adverse movement. If ALL analysts think the foreign currency is going...
-
How does the concept of job crafting influence employee satisfaction and engagement, and in what ways can organizations encourage employees to proactively shape their roles ?
-
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $584,000 $514,000 Cost of goods sold...
-
Accounting policies and practices that are most important to the portrayal of the companys financial condition and results, and require managements most difficult, subjective, or complex judgments...
-
Focus on the monthly log returns in percentages of GE stock and the S\&P 500 index. Build a time-varying correlation GARCH model for the bivariate series using the Cholesky decomposition. Check the...
-
Consider the three-dimensional return series jointly. Build a multivariate timevarying correlation volatility model for the data, using the Cholesky decomposition. Discuss the implications of the...
-
Highland plc owns two subsidiaries acquired as follows: 1 July \(1991 \quad 80 \%\) of Aviemore Ltd for \( 5\) million when the book value of the net assets of Aviemore Ltd was \( 4\) million. 30...
Study smarter with the SolutionInn App