Question
In: Finance
Elias Company has prepared a budget for the first six months of 2020. Monthly budgets for...
Elias Company has prepared a budget for the first six months of
2020. Monthly budgets for revenues are provided at left. Experience
indicates that Elias will collect 75% of sales in the month of
sale, 15% in the month following the sale, and 7.5% in the second
month after the sale. The remaining 2.5% of sales are expected to
be uncollectible.
Prepare a cash collections budget
for Elias for the months of March, April, and May
2020. Show your work.
| Revenues budget: | |
| January | 8,537,500 |
| February | 9,748,615 |
| March | 10,250,324 |
| April | 8,904,561 |
| May | 12,358,975 |
| June | 14,548,289 |
| 64,348,264 | |
| Collections experience: | |
| Month of sale | 75.0% |
| Month after sale | 15.0% |
| 2 months after sale | 7.5% |
| Uncollectible | 2.5% |
| 100.0% | |
Please so some calculations, I'm having difficulty trying to follow just numbered answers.
Solutions
jeff jeffy answered 2 years agoRelated Solutions
ABC Company has the following sales budget for the last six months of 2020:
Note: Not all sales are always collected. Remember Bad Debt Expense. So don’t worry if the problems do not add up to 100%.
1. ABC Company has the following sales budget for the last six months of 2020:
July $9,000
August $8,000
September $11,000
October $9,000
Historically, the cash collection of sales has been as follows:
35% of sales collected in the month of sale,
45% of sales collected in the month...
Now that a business has prepared it budget for the next three months, and the budget...
Now that a business has prepared it budget for the next three
months, and the budget indicated that there will be cash shortage
(negative cash balance at the end of the month, mainly due to the
large total cash payments in the month than the total cash
receipts) in the second month.What actions should the managers take
when he is presented with this information?
What actions should the managers make if in the third month,
there will be a cash...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$439,200
$488,000
Direct materials purchases
146,400
152,500
Direct labor
109,800
122,000
Manufacturing overhead
85,400
91,500
Selling and administrative
expenses
96,380
103,700
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$435,600
$484,000
Direct materials purchases
145,200
151,250
Direct labor
108,900
121,000
Manufacturing overhead
84,700
90,750
Selling and administrative expenses
95,590
102,850
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$439,200
$488,000
Direct materials purchases
146,400
152,500
Direct labor
109,800
122,000
Manufacturing overhead
85,400
91,500
Selling and administrative
expenses
96,380
103,700
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$399,600
$444,000
Direct materials
purchases
133,200
138,750
Direct labor
99,900
111,000
Manufacturing
overhead
77,700
83,250
Selling and
administrative expenses
87,690
94,350
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Jackson company manufacture products and has prepared a monthly budget based on 10,000 units (produced and...
Jackson company manufacture products and has prepared a monthly
budget based on 10,000 units (produced and sold):
Per unit cost
Labour
(2 DLH x $11)
$22
Materials
0.5kg x $30/kg
$15
Fixed overhead
$10
Selling price
$65
In January, 9,000 units were produced and sold. The actual
budget for January is shown below:
Sales
$594,000
Labour
18,900 hours
$226,800
Material
4,700kg
$131,600
Fixed overhead
$92,000
Profit
$143,600
A) Calculate all the variances (DM price variance, DM material
variance, DL price...
Pro Sports Inc. manufactures basketballs for professional basketball associations. For the first six months of 2020,...
Pro Sports Inc. manufactures basketballs for professional
basketball associations. For the first six months of 2020, the
company reported the following operating results while operating at
90% of plant capacity:
Amount
Per Unit
Sales
$5,616,000
$52.00
Cost of goods sold
3,672,000
34.00
Selling and administrative expenses
486,000
4.50
Net income
$1,458,000
$13.50
Fixed costs for the period were cost of goods sold of $1,080,000,
and selling and administrative expenses of $194,400.
In July, normally a slack manufacturing month, Pro Sports...
Pro Sports Inc. manufactures basketballs for professional basketball associations. For the first six months of 2020,...
Pro Sports Inc. manufactures basketballs for professional
basketball associations. For the first six months of 2020, the
company reported the following operating results while operating at
90% of plant capacity:
Amount
Per Unit
Sales
$5,232,600
$51.00
Cost of goods sold
3,591,000
35.00
Selling and administrative expenses
451,440
4.40
Net income
$1,190,160
$11.60
Fixed costs for the period were cost of goods sold of $1,026,000,
and selling and administrative expenses of $184,680.
In July, normally a slack manufacturing month, Pro Sports...
Jupiter Company's budget for coming year estimates monthly sales in units for first five months of...
Jupiter Company's budget for coming year estimates monthly sales
in units for first five months of the year as follows: April
35,000; May, 38,000; June 40,000; July, 39,000; and August
38,000.
The ending inventory of finished units for each month is to be
maintained at 25% of next month's estimated sales. On April 1,
there were 12,000 units on hand.
a. prepare a production budget (in units) for the first four months
of the period. Rounds amounts to the nearest...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- (All figures in thousands) The Accessories Outlet has total equity of $286,000 sales of $508,000, and...
- Create a program that asks the user to input three numbers and computes their sum. This...
- 1. Evaluate how some of the tried-and-true strategies for merging companies will get the job done....
- Discuss and gather insight and feedback on the importance of data models and how to discover...
- . An investor can design a risky portfolio based on two stocks, A and B. Stock...
- 1.Instead of Build-Max-Heap, we could use Heap-Insert-Max to build a tree with heap property. Write a...
- explain why using email address as the primary key for Staff is a bad idea
ADVERTISEMENT