Corp’s budgeted monthly sales are P5,000, and they are constant from month to month. 40% of its customers pay in the first month and take the 2% discount, while the remaining 60% pay in the month following the sale and do not receive a discount. The firm has no bad debts. Purchases for next month’s sales are constant at 40% of projected sales for the next month. “Other payments,” which include wages, rent, and taxes, are 25% of sales for the current month. Construct a cash budget for a typical month and calculate the average net cash flow during the month.

Corp’s budgeted monthly sales are P5,000, and they are constant from month to month. 40% of its customers pay in the first month and take the 2% discount, while the remaining 60% pay in the month following the sale and do not receive a discount. The firm has no bad debts. Purchases for next month’s sales are constant at 40% of projected sales for the next month. “Other payments,” which include wages, rent, and taxes, are 25% of sales for the current month. Construct a cash budget for a typical month and calculate the average net cash flow during the month.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 34E: A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and...

See similar textbooks

Similar questions

Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Nogueiras Corp's budgeted monthly sales are $6,000, and they are constant from month to month. 25% of its customers pay in the first month and take the 2% discount, while the remaining 75% pay in the month following the sale and do not receive a discount. The firm has no bad debts. Purchases for next month's sales are constant at 50% of projected sales for the next month. "Other payments," which include wages, rent, and taxes, are 25% of sales for the current month. Construct a cash budget for a typical month and calculate the average cash gain or loss during the month. Do not round intermediate calculations. a. $1,500 b. $1,380 c. $1,410 d. $1,493 e. $1,470
Nogueiras Corp's budgeted monthly sales are $8,500, and they are constant from month to month. 40% of its customers pay in the first month and take the 2% discount, while the remaining 60% pay in the month following the sale and do not receive a discount. The firm has no bad debts. Purchases for next month's sales are constant at 50% of projected sales for the next month. "Other payments", which include wages, rent, and taxes, are 25% of sales for the current month. Construct a cash budget for a typical month and calculate the average cash gain or loss during the month.
Niagara Corporation’s budgeted monthly sales are $5,000, and they are constant from month to month. Its customers pay as follows: 20% pay in the first month and take the 3% discount, 70% pay in the month following the sale with zero discount and 10% in the third month with 5% interest. The firm has no bad debts. Purchases for next month’s sales are constant at 45% of projected sales for the next month. “Other payments,” which include payments for wages, rent, and taxes, are 18% of sales for the month. Construct a cash budget for a typical month and calculate the average cash gain or loss during the month.(Please show work)
The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting. The company estimates its purchases at 60 percent of next month's sales, and payments for those purchases are budgeted to lag the purchases by one month. In addition, a tax payment of Sh.105,000 is due on January 15, and Sh.40,000 in dividends will be declared in January and paid in March. Also, the company has ordered a Sh.75,000 piece of equipment. Delivery is scheduled for early January, and payment will be due in February.The company’s projected cash balance at the beginning of January is Sh.100,000, and the company desires to maintain a balance of Sh.100,000 at the end of each month. Prepare a cash budget for Atlas Products, Company, for the first quarter of 2014, based on the following…
ZT Corporation's budgeted monthly sales are $3,00O. Forty percent of its customers pay in the first month and take the 2 percent discount. The remaining 60 percent pay in the month following the sale and don't receive a discount. Purchases for next month's sales are constant each month at $1,500o. Other payments for wages, rent, and taxes are constant at $700 per month. Construct a single month's cash budget with the information given and determine the average cash gain or (loss) during a typical month for ZT Corporation- $2,976 $740 $3,000 $2,200 O $776
ZT Corporation's budgeted monthly sales are $3,000. Forty percent of its customers pay in the first month and take the 2 percent discount. The remaining 60 percent pay in the month following the sale and don't receive a discount. Purchases for next month's sales are constant each month at $1,500. Other payments for wages, rent, and taxes are constant at $700 per month. Construct a single month's cash budget with the information given and determine the total disbursement during a typical month for ZT Corporatio." O $2,200 $3,000 $776 $2,600 O $740
9. Chadmark Cor. budgeted monthly sales are P3,000. Per experience, 40% of its customers pay in the first month and take the 2 % discount. The remaining 60% pay in the month following the sale and don't receive a discount. Bad debts are very small and are excluded from this analysis. Purchases for next month's sales are constant each month at P1,500. Other payments for wages, rent, and taxes are constant at P700 per month. Construct a single month's cash budget with the information given. What is the average cash gain or (loss) during a typical month? A. P728 B. P740 C. P776 D. P800 E. P2,600
ZT Corporation's budgeted monthly sales are $3,000. Forty percent of its customers pay in the first month and take the 2 percent discount. The remaining 60 percent pay in the month following the sale and don't receive a discount. Purchases for next month's sales are constant each month at $1,500. Other payments for wages, rent, and taxes are constant at $700 per month. Construct a single month's cash budget with the information given and determine the total collection during a typical month for ZT Corporation. $2,200 $3,000 O $776 O $740 $2,9760
ZT Corporation's budgeted monthly sales are $3,000. Forty percent of its customers pay in the first month and take the 2 percent discount. The remaining 60 percent pay in the month following the sale and don't receive a discount. Purchases for next month's sales are constant each month at $1,500. Other payments for wages, rent, and taxes are constant at $700 per month. Construct a single month's cash budget with the information given and determine the total disbursement during a typical month for ZT Corporation
Bear, Inc. estimates its sales at 200,000 units in the first quarter and that sales will increase by 20,000 units each quarter over the year. Bear calculates a 25% ending inventory of finished goods based on next month's sales. Each unit sells for $35. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Production in units for the third quarter should be budgeted at
The projected sales for the Leeds Company is given below. The company has determined that all sales are on credit and they do not have any cash sales. For the credit sales, experience tells Leeds they will collect 60% of sales in the quarter of the sale and the remaining 40% is collected the quarter after the sale. The sales in the last quarter of the previous year is $200,000. Qtr 1 Qtr 2 Qtr 3 Qtr 4 Budgeted Sales $600,000 $1,600,000 $800,000 $1,000,000 Leeds need cash to pay for purchases, wages, rent, interest, income taxes, cash dividends, and most other expenses. Leeds Company is a manufacturing company, the material purchases requirement for the next four quarters is given in the following table. Leed Company makes all material purchases on credit. Leed Company will pay for material purchases 80% in the quarter of purchase and 20% in the quarter after the purchase. The materials purchased in the last quarter of previous years is $400,000. Budgeted Material Purchases $250,000…