![FOUND.OF FINANCIAL MANAGEMENT-ACCESS](https://www.bartleby.com/isbn_cover_images/9781260519969/9781260519969_largeCoverImage.gif)
Concept explainers
The Denver Corporation has
Monthly material purchases are set equal to 40 percent of forecast sales for the next month. Of the total material costs, 50 percent are paid in the month of purchase and 50 percent in the following month. Labor costs will run
Prepare a monthly summary of cash payments for the six-month period from January through June. (Note: Compute prior December purchases to help get total material payments for January.)
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 4 Solutions
FOUND.OF FINANCIAL MANAGEMENT-ACCESS
- Assume that sales and expenses forecasts for months April, May, June, and July are as follows. 20% of all sales in a month are paid in the same month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan.Any excess over $20,000,000 will be used to reduce or pay off cumulative loan.I nitial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: 1. Prepare cash budget proforma for months June and July. Provide in-text citations and references, and explain your work in detail.arrow_forwardTo meet projected annual sales, Bluegill Manufacturers, Inc. needs to produce 75,000 machines for the year. The estimated January 1 inventory is 7,000 units, and the desired December 31 inventory is 12,000 units. What are projected sales units for the year?arrow_forwardManagement wants to know if there will be a need for short-term financing in February. Essential information is as follows: Estimated sales for January and February are $1.1 million and $750,000, respectively. Sixty percent of sales are for cash and 40 percent are credit sales that are collected the next month. Cash disbursements that vary with sales are 35 percent of sales. Fixed operating disbursements are $400,000 a month. Depreciation expense is $50,000 a month. A tax payment of $70,000 is due in January. A bond payment of $250,000 is owed and will be due in February. The cash balance at the beginning of January is $12,000. Management seeks a minimum cash balance of $9,000. December credit sales were $110,000. Round your answers to the nearest dollar. Use a minus sign to enter shortage of cash, if any. January February Excess (shortage) of cash $ $ The firm need short-term funds in February.arrow_forward
- Rishi Sunak Manufacturing Pte. Ltd. is preparing its budget for next year. The company estimates that it will be making the following raw materials purchases in the last five months of 2021: $200,000 in August, $220,000 in September, $250,000 in October, $280,000 in November and $240,000 in December. The company anticipates that it will pay 55% of what is owed one month after the month of purchase, 30% of what is owed two months after the month of purchase and the remaining 15% three months after the month of purchase. What figure will be presented in the company’s cash budget for payments for raw materials purchases in December 2021? $233,500 $253,500 $262,000 $403,500arrow_forwardCash DisbursementTimber Company is in the process of preparing its budget for next year. Cost of goods sold has been estimated at 70 percent of sales. Lumber purchases and payments are to be made during the month preceding the month of sale. Wages are estimated at 15 percent of sales and are paid during the month of sale. Other operating costs amounting to 10 percent of sales are to be paid in the month following the month of sale. Additionally, a monthly lease payment of $64,000 is paid for computer services. Sales revenue is forecast as follows Month Sales Revenue February $220,000 March 260,000 April 270,000 May 310,000 June 290,000 July 330,000 RequiredPrepare a schedule of cash disbursements for April, May, and June.Do not use a negative sign with your answers. Timber Company Schedule of Cash Disbursements April, May, and June April May June Lumbers purchases Answer Answer Answer Wages Answer Answer Answer Operating expenses Answer Answer…arrow_forwardTerrel Manufacturing expects stable sales through the summer months of June, July, and August of $500,000 per month. The firm will make purchases of $350,000 per month during these months. Wages and salaries are estimated at $60,000 per month plus 7 percent of sales. The firm must make a principal and interest payment on an outstanding loan in June of $100,000. The firm plans a purchase of a fixed asset costing $75,000 in July. The second quarter tax payment of $20,000 is also due in June. All sales are for cash.(a) Construct a cash budget for June, July, and August, assuming the firm has a beginning cash balance of $100,000 in June.(b) The sales projections may not be accurate due to the lack of experience by a newly-hired sales manager. If the sales manager believes the most optimistic and pessimistic estimates of sales are $600,000 and $400,000, respectively, what are the monthly net cash flows and required financing or excess cash balances? Make your recommendations.arrow_forward
- Terrel Manufacturing expects stable sales through the summer months of June, July, and August of $500,000 per month. The firm will make purchases of $350,000 per month during these months. Wages and salaries are estimated at $60,000 per month plus 7 percent of sales. The firm must make a principal and interest payment on an outstanding loan in June of $100,000. The firm plans a purchase of a fixed asset costing $75,000 in July. The second quarter tax payment of $20,000 is also due in June. All sales are for cash. Construct a cash budget for June, July, and August, assuming the firm has a beginning cash balance of $100,000 in June. The sales projections may not be accurate due to the lack of experience by a newly-hired sales manager. If the sales manager believes the most optimistic and pessimistic estimates of sales are $600,000 and $400,000, respectively, what are the monthly net cash flows and required financing or excess cash balances?arrow_forwardBrandeis, Inc has a 45-day accounts payable period. The firm has expected quarterly sales of $2,400, $2,800, $3,600, and $4,200, respectively, for the next calendar year. The cost of goods sold for a quarter is equal to 70% of the next quarter sales. The firm has a beginning payables balance of $1,200 as of quarter one. What is the amount of the projected cash disbursements for accounts payable for quarter 3 of the next year? Each quarter has 90 days. Multiple Choice $3,900 $2,730 $2,240 $2,870 $3,060arrow_forwardTo meet projected annual sales, Bluegill Manufacturers, Inc. needs to produce 75,000 machines for the year. The estimated January 1 inventory is 7,000 units, and the desired December 31 inventory is 12,000 units. What are projected sales units for the year? unitsarrow_forward
- NuParts, Inc., has estimated quarterly sales for next year, starting with Quarter 1, of $15,900, $16,800, $17,500, and $16,400. Purchases are equal to 67 percent of the following quarter's sales and the accounts payable period is 60 days. Assume 30 days in each month. How much will the firm owe its suppliers at the end of Quarter 3? $7,066.67 $7,506.67 $7,816.67 $6,933.33 $7,325.33arrow_forwardYour projected sales for the first 3 months of next year are as follows:January, $15,000; February, $20,000; and March, $25,000. Based on lastyear’s data, cash sales are 20 percent of total sales for each month. Of theaccounts receivable, 60 percent are collected in the month after the sale and40 percent are collected in the second month following the sale. Sales forNovember of the current year are $15,000 and for December are $17,000.You have the following estimated payments: January, $4,500; February,$5,500; and March, $5,200.a. Using the format from the pro forma cash budget in Table 6–8, what is yourmonthly cash budget for January, February, and March?b. What will your accounts receivable be for the beginning of April?c. Will your company have any borrowing requirements for any month duringthis 3-month period?arrow_forwardTilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April 45,000 55,000 June 55,000 45,000 May Sales 35,000 45,000 Production Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 25% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $70,000 per month. The accounts payable balance on March 31 totals $174,000, which will be paid in April. All units are sold on account for $19 each. Cash collections from sales are budgeted at 50% in the month of sale, 30% in the month following the month of sale, and the remaining 20% in the second month following the month of sale. Accounts receivable on April 1 totaled $433,000 ($93,000 from February's sales and $340,000 from March's sales). Required: a. Prepare a schedule for each month showing budgeted cash disbursements for Tilson Corporation. b. Prepare a…arrow_forward
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)