Question: 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
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 confident that the company will meet or exceed sales estimates. The following sales figures show the growth that is expected and are the basis for planning in the other corporate departments:
-1.png)
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. EÌ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 EÌlectronique's largest expenditure; the cost of these items is equal to 60% of sales. EÌlectronique receives 40% of the parts one month before it sells them and 60% during the month of sale.
3. Historically, EÌlectronique has cleared 60% of the accounts payable one month after it receives its purchases, and the remaining 40% two months after.
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 2016. 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 installments in the last month of each quarter:
-2.png)
6. EÌ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 2016 is projected to be $750,000.
7. EÌ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. EÌlectronique uses a calendar-year reporting period.
Instructions
Prepare a schedule of Cash Receipts and Disbursements for EÌlectronique Instruments, by month, for the second quarter of 2016. 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.
Month January February Forecast Sales 4,000,000 September 3,200,000 une 3,800,000 December 4,400,000 Salaries Promotion Property taxes Insurance Utilities Depreciation $ 490,000 670,000 250,000 370,000 350,000 620,000 $2,750,000 .rtu
Step by Step Solution
3.48 Rating (158 Votes )
There are 3 Steps involved in it
LECTRONIQUE INSTRUMENTS Cash Budget For the Second Quarter Ended June 30 2016 Quarter April May June Total Beg cash balance 200000 301933 539666 20000... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1190-B-M-A-J-O-C(3229).docx
120 KBs Word File
