Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help answering 6 questions with multiple places. Please explain how to complete questions in attached doc. Alpha-Tech, a rapidly growing distributor of electronic components,

image text in transcribed

Need help answering 6 questions with multiple places. Please explain how to complete questions in attached doc.

image text in transcribed Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm's marketing director, has completed the following sales forecast. ALPHA-TECH 20x5 Forecasted Sales (in thousands) Month Sales 11,0 January $ 00 12,0 February 00 11,0 March 00 13,5 April 00 14,5 May 00 16,0 June 00 17,0 July 00 17,0 August 00 18,0 September 00 18,0 October 00 17,0 November 00 19,0 December 00 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. The following information will be used in preparing the cash flow projection. Alpha-Tech's excellent record in accounts receivable collection is expected to continue. Sixty percent of billings are collected the month after the sale, and the remaining 40 percent two months after. The purchase of electronic components is Alpha-Tech's largest expenditure, and each month's cost of goods sold is estimated to be 40 percent of sales. Seventy percent of the parts are received by Alpha-Tech one month prior to sale, and 30 percent are received during the month of sale. Historically, 70 percent of accounts payable has been paid one month after receipt of the purchased components, and the remaining 30 percent has been paid two months after receipt. Hourly wages and fringe benefits, estimated to be 30 percent of the current month's sales, are paid in the month incurred. General and administrative expenses are projected to be $16,420,000 for the year. The breakdown of these expenses is presented in the following schedule. All cash expenditures are paid uniformly throughout the year, except the property taxes, which are paid in four equal installments at the end of each quarter. 20x5 Forecasted General and Administrative Costs (in thousands) Salaries and fringe benefits $ 3,400 Promotion 4,100 Property taxes 1,420 Insurance 1,240 Utilities 2,000 Depreciation 4,260 Total $ 16,420 Income-tax payments are made at the beginning of each calendar quarter based on the income of the prior quarter. Alpha-Tech is subject to an income-tax rate of 40 percent. Alpha-Tech's operating income for the first quarter of 20x5 is projected to be $4,500,000. The company pays 100 percent of the estimated tax payment. Alpha-Tech maintains a minimum cash balance of $565,000. If the cash balance is less than $565,000 at the end of each month, the company borrows amounts necessary to maintain this balance. All amounts borrowed are repaid out of the subsequent positive cash flow. The projected April 1, 20x5, opening balance is $565,000. Alpha-Tech has no short-term debt as of April 1, 20x5. Alpha-Tech uses a calendar year for both financial reporting and tax purposes. Required: 1. Prepare a cash budget for Alpha-Tech by month for the second quarter of 20x5. For simplicity, ignore any interest expense associated with borrowing. (Negative amounts should be indicated by a minus sign.) 16points eBookAsk Print References Item2 Item 2 16 points Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1. Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition. The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $60,000; accounts receivable, $180,000; and accounts payable, $69,000. Mary and Kay, Inc. maintains a $60,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time. Additional data: January February March Sales revenue Merchandise purchases Cash operating costs Proceeds from sale of equipment $ 480,0 00 300,0 00 96,00 0 $ 570,0 00 330,0 00 75,00 0 $ 585,0 00 450,0 00 138,0 00 18,00 0 Required: 1. Prepare a schedule that discloses the firm's total cash collections for January through March. 2. Prepare a schedule that discloses the firm's total cash disbursements for January through March. 3. Prepare a schedule that summarizes the firm's financing cash flows for January through March. Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 30 percent of sales collected in the month of sale and 70 percent collected in the following month. The data that follow were extracted from the company's accounting records. Badlands maintains a minimum cash balance of $21,000. Total payments in January 20x1 are budgeted at $205,000. A schedule of cash collections for January and February of 20x1 revealed the following receipts for the period: Cash Receipts January February 105,0 From December 31 accounts receivable $ 00 91,00 144,0 From January sales $ 0 00 70,50 From February sales 0 March 20x1 sales are expected to total 7,000 units. Finished-goods inventories are maintained at 30 percent of the following month's sales. The December 31, 20x0, balance sheet revealed the following selected figures: cash, $24,000; accounts receivable, $105,000; and finished goods, $24,600. Required: 1. Determine the number of units that Badlands sold in December 20x0. 2. Compute the sales revenue for March 20x1. 3. Compute the total sales revenue to be reported on Badlands' budgeted income statement for the first quarter of 20x1. 4. Determine the accounts receivable balance to be reported on the March 31, 20x1, budgeted balance sheet. 5. Calculate the number of units in the December 31, 20x0, finished-goods inventory. 6. Calculate the number of units of finished goods to be manufactured in January 20x1. 7. Calculate the financing required in January, if any, to maintain the firm's minimum cash balance. Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1. Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition. The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $55,000; accounts receivable, $220,000; and accounts payable, $77,000. Mary and Kay, Inc. maintains a $55,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time. Additional data: Sales revenue Merchandise purchases Cash operating costs Proceeds from sale of equipment January 560,0 $ 00 380,0 00 104,0 00 February March 650,0 665,0 $ $ 00 00 410,0 530,0 00 00 83,00 146,0 0 00 26,00 0 Required: 1. Prepare a schedule that discloses the firm's total cash collections for January through March. 2. Prepare a schedule that discloses the firm's total cash disbursements for January through March. 3. Prepare a schedule that summarizes the firm's financing cash flows for January through March. Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1. Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition. The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $50,000; accounts receivable, $170,000; and accounts payable, $67,000. Mary and Kay, Inc. maintains a $50,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time. Additional data: Sales revenue Merchandise purchases Cash operating costs Proceeds from sale of equipment January 460,0 $ 00 280,0 00 94,00 0 February March 550,0 565,0 $ $ 00 00 310,0 430,0 00 00 73,00 136,0 0 00 16,00 0 Required: 1. Prepare a schedule that discloses the firm's total cash collections for January through March. 2. Prepare a schedule that discloses the firm's total cash disbursements for January through March. 3. Prepare a schedule that summarizes the firm's financing cash flows for January through March. Western State University (WSU) is preparing its master budget for the upcoming academic year. Currently, 15,000 students are enrolled on campus; however, the admissions office is forecasting a 5 percent growth in the student body despite a tuition hike to $90 per credit hour. The following additional information has been gathered from an examination of university records and conversations with university officials: WSU is planning to award 170 tuition-free scholarships. The average class has 25 students, and the typical student takes 15 credit hours each semester. Each class is three credit hours. WSU's faculty members are evaluated on the basis of teaching, research, and university and community service. Each faculty member teaches five classes during the academic year. Required: 1. Prepare a tuition revenue budget for the upcoming academic year. 2. Determine the number of faculty members needed to cover classes. 3. Assume there is a shortage of full-time faculty members. Select at least five actions that WSU might take to accommodate the growing student body by selecting an "X" next to the action. 4. You have been requested by the university's administrative vice president (AVP) to construct budgets for other areas of operation (e.g., the library, grounds, dormitories, and maintenance). The AVP noted: \"The most important resource of the university is its faculty. Now that you know the number of faculty needed, you can prepare the other budgets. Faculty members are indeed the key driverwithout them we don't operate.\" Are faculty members a key driver in preparing budgets? Western State University (WSU) is preparing its master budget for the upcoming academic year. Currently, 15,000 students are enrolled on campus; however, the admissions office is forecasting a 5 percent growth in the student body despite a tuition hike to $90 per credit hour. The following additional information has been gathered from an examination of university records and conversations with university officials: WSU is planning to award 170 tuition-free scholarships. The average class has 25 students, and the typical student takes 15 credit hours each semester. Each class is three credit hours. WSU's faculty members are evaluated on the basis of teaching, research, and university and community service. Each faculty member teaches five classes during the academic year. Required: 1. Prepare a tuition revenue budget for the upcoming academic year. 2. Determine the number of faculty members needed to cover classes. 3. Assume there is a shortage of full-time faculty members. Select at least five actions that WSU might take to accommodate the growing student body by selecting an "X" next to the action. 4. You have been requested by the university's administrative vice president (AVP) to construct budgets for other areas of operation (e.g., the library, grounds, dormitories, and maintenance). The AVP noted: \"The most important resource of the university is its faculty. Now that you know the number of faculty needed, you can prepare the other budgets. Faculty members are indeed the key driverwithout them we don't operate.\" Are faculty members a key driver in preparing budgets

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Payroll Accounting 2017

Authors: Bernard J. Bieg, Judith Toland

27th edition

1305675126, 1305675124, 9781305888586, 1305888588, 978-1337734776

More Books

Students also viewed these Accounting questions

Question

Solve 41[z1] - i [2 + i] 1 3 S 3 + 2i

Answered: 1 week ago

Question

What is stored in an ML evaluation environment?

Answered: 1 week ago