Home / Questions / Miller Corporation has the following sales budget for the first four months of the current year
Miller Corporation has the following sales budget for the first four months of the current year:
MonthSales
January$400,000
February320,000
March440,000
April360,000
Historically, the following trend has been established regarding cash collection of sales:
65% in month of sale
25% in month following sale
8% in second month following sale
2% uncollectible
The company allows a 2% cash discount for payments made by customers during the month of the sale. November and December sales were $400,000 and $240,000, respectively.
Required: Prepare a schedule of budgeted cash collections from sales for January, February, and March.
17.Quillin Company had the following budgeted information for October:
1.October 1 cash balance $3,500
2.Expected sales 2,500 units at $25 each (half in cash, remainder on credit due in November)
3.Inventory purchases 3,000 units at $14 each (all in cash)
4.Rent $1,450
5.Payroll $1,000
6.Utilities and other costs $4,500
7.Accounts receivable balance Oct. 1, $35,000 (includes $700 bad debts allowance)
A.What is the budgeted collection on accounts receivable for October?
B.What are the total cash disbursements for October?
C.What is the ending cash balance for October?
D.Assuming sales are collected 75% in the month of sale and 25% the following month, what is the ending cash balance for October?
18.Fredder Company usually sells about 20% of its merchandise during a month for cash with the remaining sales on account. The company’s accounts receivable payment history is as follows: 30% in the month of sale, 50% in the month following, and 15% in the second month following sale. Total budgeted sales for the second quarter are as follows:
April$100,000
May120,000
June80,000
Assume all questions relate to the month of June.
A.What are the expected cash sales?
B.What are the expected receipts from accounts receivable for sales made in April?
C.What are the expected receipts from accounts receivable for sales made in May?
D.What are the total expected cash receipts?
E.From the above accounts receivable history information, receipts from accounts receivable do not equal 100%. Why not? Does this amount appear on the cash budget?
19.Rivers Company purchases merchandise on account. In general, Rivers pays 50% in the month of purchase and 50% in the following month. All payments in the month of purchase qualify for a 2% cash discount. First quarter budgeted purchases are:
January$90,000
February80,000
March96,000
A.What are the total cash disbursements expected in February?
B.What are the total cash disbursements expected in March?
C.Suppose that there is NO cash discount for purchases made in the month of purchase. Now what are the total cash disbursements expected in February? In March?
Mar 13 2020 View more View Less
In calculating the GDP, why aren't stock market investments included? a. Stock prices fluctuate daily and a true value is hard to determine. b. Owning stocks does not co...
Jul 12 2021Billabong Tech uses the internal rate of return (IRR) to select projects. Calculate the IRR for each of the following projects and recommend the best project based on thi...
Jun 03 2021Question 16 Not yet answered Demand for a product is forecasted for the six periods is 263, 256, 301, 312, 304, and 294. If a LEVEL PRODUCTION strategy is adopted with a ...
Apr 29 2021Balance Sheet Ratios for 2004 and 2005Calculate the Current RatioCalculate the Book Debt to Equity RatioCalculate the Market Debt to Equity Ratio (Use Book Value of Debt ...
Aug 19 2020Use Figure 37.2 to identify the leukocytes in the micrograph on the left.________ neutrophil________ lymphocyte________ eosinophil________ basophilLook at the question in...
Jun 07 2021A binding price floor causes: A a shortage in the market. B a surplus in the market. C wasted resources. D a surplus in the market and wasted resources.
Jun 05 2020A payment made to the government that is the result of economic activity, generally collected from both individuals and businesses, is called ___.
Jul 02 2021The uniform 30-kg slender rod is being pulled bythe cord that passes over the small smooth peg at A. If therod has a counterclockwise angular velocity of 6 rad/sat the in...
May 08 2020QUESTION 6 Mohammed is a hardworking employee at Vita W.L.L. He senses that his organization's culture influences his decision-making processes, and he believes that his ...
Apr 22 2021What micron level should be achieved when evacuating a system?
Jun 11 2021