Brightline Confections is preparing its cash budget and expects to have sales of $80,000 in April, $90,000 in May, and $100,000 in June. If 25% of sales are for cash, 35% are credit sales paid in the month after the sale, and another 40% are credit sales paid 2 months after the sale, what are the expected cash receipts for June?

Brightline Confections is preparing its cash budget and expects to have sales of $80,000 in April, $90,000 in May, and $100,000 in June. If 25% of sales are for cash, 35% are credit sales paid in the month after the sale, and another 40% are credit sales paid 2 months after the sale, what are the expected cash receipts for June?

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

One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Sales are expected to increase each month by 10%. Prepare a budgeted income statement.
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.
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
AURORA BAKING IS PREPARING ITS CASH BUDGET AND EXPECTS TO HAVE SALES OF $60,000 IN JANUARY, $70,000 IN FEBRUARY, AND $70,000 IN MARCH. IF 20% OF SALES ARE FOR CASH, 40% ARE CREDIT SALES PAID IN THE MONTH AFTER THE SALE, AND ANOTHER 40% ARE CREDIT SALES PAID 2 MONTHS AFTER THE SALE, WHAT ARE THE EXPECTED CASH RECEIPTS FOR MARCH?
The Dunce Company expects to have sales of 30,000 in January, 33,000 in February, and 38,000 in March. If 20 percent of sales are for cash, 40 percent are credit sales paid in the month following the sale, and 40 percent are credit sales paid two months following the sale, how much is the expected cash receipts in March?
Discus Productions needs to know its anticipated ensh inflows for the next quarter by month Cash sales are 10% of total sales each month. Historically, sales on sccount have been collected as follows 60% in the month of ale, 30% in the month after the sale, and the reurining 10% two months after the sale. Sales for the quarter are projected as follows: April, S120,000: May, S100,000; and June, 590,000. Accounte receivable on March 31 were S60,000, The expected caalh collections of Discn Productions for June are Oa $92,000. Oh S89.000. Oe $91.200. Od 595.400.
jagdish
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. Initial 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: Prepare cash budget proforma for months June and July. Provide in-text citations and references, and explain your work in detail.
Baltimore Baking is preparing its cash budget and expects to have sales of $30,000 in January, $35,000 in February, and $35,000 in March. If 20% of sales are for cash, 40% are credit sales paid in the month after the sale, and another 40% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? O a. $29,700 O b. $24,057 O c. $33,000 O d. $26,730 Oe. $36,300