Question
In: Accounting
Grover has forecast sales to be $128,000 in February, $137,000 in March, $151,000 in April, and...
Grover has forecast sales to be $128,000 in February, $137,000 in March, $151,000 in April, and $148,000 in May. The average cost of goods sold is 70% of sales. All sales are on made on credit and sales are collected 60% in the month of sale, and 40% the month following. What are budgeted cash receipts in March?
-
$133,400
-
$96,900
-
$137,400
-
$94,100
Solutions
Expert Solution
Answer: $133,400
.
.
| Calculation of budgeted cash receipts in March | ||
| Collections from sales made in February: | ||
| Sales made in February (a) | $128,000 | |
| Percentage of February sales to be collected in March [Month following the month of sale] (b) | 40% | |
| Collections in March from sales made in February: (c = a x b) | $51,200 | |
| Collections from sales made in March: | ||
| Sales made in March (d) | $137,000 | |
| Percentage of March sales to be collected in March [Month of sale] (e) | 60% | $82,200 |
| Collections in March from sales made in March: (f = d x e) | ||
| Budgeted Total cash receipts in January (c + f) | $133,400 |
ekkarill92 answered 2 years agoRelated Solutions
Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14...
Month
Actual Sales
Forecast Sales
January
8
10
February
11
10
March
12
10
April
14
10
-Compute the RSFE, MAD and tracking signals for months January
to April?
1. Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1. Sales forecast: January: 2,600 units; February:
4,500 units; March: 10,200 units; April: 12,000 units. The unit
sales price is $125. All sales are on credit and collections are
30% in the month of sale, 60% the following month, and 10% two
months following the sale. Accounts receivable as of the end of
December is $4,600 and this amount is expected to be collected in
January.
2. End of month inventory must equal 40% of next month’s sales.
The inventory...
1. Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1. Sales forecast:
January: 2,600 units; February: 4,500 units; March: 10,200 units;
April: 12,000 units. The unit sales price is $125. All sales are on
credit and collections are 30% in the month of sale, 60% the
following month, and 10% two months following the sale. Accounts
receivable as of the end of December is $4,600 and this amount is
expected to be collected in January.
2. End of month inventory must equal
40% of next month’s sales. The inventory...
Information for 2020: 1. Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April:...
Information for 2020:
1. Sales forecast:
January: 2,600 units; February: 4,500 units; March: 10,200 units;
April: 12,000 units. The unit sales price is $125. All sales are on
credit and collections are 30% in the month of sale, 60% the
following month, and 10% two months following the sale. Accounts
receivable as of the end of December is $4,600 and this amount is
expected to be collected in January.
2. End of month inventory must equal
40% of next month’s...
Information for 2019: 1. Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April:...
Information for 2019:
1. Sales forecast:
January: 2,100 units; February: 2,900 units; March: 3,300 units;
April: 3,500 units. The unit sales price is $50. All sales are on
credit and collections are 20% in the month of sale and 80% the
following month. Accounts receivable as of December 31, 2018 is
$15,000 and this amount is expected to be collected in January
2019.
2. End of month inventory must equal
60% of next month’s sales. The inventory at the end...
Grenoble Enterprises had sales of $50,200 in March and $60,200 in April. Forecast sales for May,...
Grenoble Enterprises had sales of $50,200 in March and $60,200
in April. Forecast sales for May, June, and July are $70,100,
$79,600, and $99,800, respectively. The firm has a cash balance of
$4,500 on May 1 and wishes to maintain a minimum cash balance of
$4,500. Given the following data, prepare and interpret a cash
budget for the months of May, June and July.
1) The firm makes 16% of sales for cash, 62% are collected in
the next month,...
Donna’s Fashions Corporation has the following sales forecast in units: January 1,000; February 800; March 900;...
Donna’s Fashions Corporation has the following sales forecast in
units:
January 1,000; February 800; March 900; April 1,400; May 1,550;
June 1,800; July 1,400
Donna always keeps ending inventory equal to 120 percent of the
next month’s expected sales. The ending inventory for December
(January’s beginning inventory) is 1,200 units, consistent with
company policy.
Materials cost $14 per unit and are paid for in the month after
production. Labour cost is $7 per unit and is paid in same month...
Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...
Cash budget—Basic
Grenoble Enterprises had sales of $50,100 in March and $60,100
in April. Forecast sales for May, June, and July are $69,500,
$80,000, and $99,800,
respectively. The firm has a cash balance of $4,800 on May 1 and
wishes to maintain a minimum cash balance of $4,800. Given the
following data, prepare and interpret a cash budget for the months
of May, June, and July.
(1) The firm makes 24% of sales for cash, 62% are collected in
the...
Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...
Cash budget—Basic
Grenoble Enterprises had sales of $50,100 in March and $60,100
in April. Forecast sales for May, June, and July are $69,500,
$80,000, and $99,800,
respectively. The firm has a cash balance of $4,800 on May 1 and
wishes to maintain a minimum cash balance of $4,800. Given the
following data, prepare and interpret a cash budget for the months
of May, June, and July.
(1) The firm makes 24% of sales for cash, 62% are collected in
the...
Cash budget—Basic Grenoble Enterprises had sales of $49,600 in March and $60,200in April. Forecast sales for...
Cash
budget—Basic
Grenoble Enterprises had sales of
$49,600 in March and
$60,200in April. Forecast sales for May, June, and July are
$69,800,$80,200,and
$ 99 comma 500$99,500,
respectively. The firm has a cash balance of
$ 4 comma 500$4,500
on May 1 and wishes to maintain a minimum cash balance of
$ 4 comma 500$4,500.
Given the following data, prepare and interpret a cash budget
for the months of May, June, and July.
(1) The firm makes
22 %22%
of sales...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In 2009, Nobel-prize winning economist Paul Krugman wrote, “The paradox of thrift is one of those...
- One electrode compartment consists of an aluminum strip placed in a solution of Al(NO3)3, and the...
- Problem #5: A loan of $44,000 is paid off in 36 payments at the end of...
- How many grams of Na2CO3 should be mixed with 5.00 g of NaHCO3 to produce 100...
- Given the following information for a monopolistic competitor: Demand: P = 78 – 5(Q) Marginal revenue:...
- Why does the auto industry prefer uniform (national) standards for automobile emissions as opposed to regionally...
- GOAL Apply the more general definition of torque. PROBLEM (a) A man applies a force of...
ADVERTISEMENT