Question
pls show me the steps Kennison, Inc. has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $ 49
pls show me the steps
Kennison, Inc. has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $ 49 comma 000 $ 40 comma 000 $ 47 comma 100 Cash payments: Purchases of direct materials 30 comma 000 21 comma 100 17 comma 500 Operating expenses 12 comma 300 8 comma 300 11 comma 100 Capital expenditures 13 comma 300 24 comma 500 0 The cash balance on June 30 is projected to be $ 4 comma 400. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 4%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. How much will the company have to borrow at the end of August?
A. $5,000 B. $ 20 000.00 C. $ 15 000 D. $ 10 000.
2...
A manufacturing company's budgeted income statement includes the following data:
Data extracted from budgeted income statement | Mar | Apr | May | Jun |
Sales revenue | $ 130 comma 000$130,000 | $ 80 comma 000$80,000 | $ 140 comma 000$140,000 | $ 110 comma 000$110,000 |
Commission expense (2020% ofsale) | 26 comma 00026,000 | 16 comma 00016,000 | 28 comma 00028,000 | 22 comma 00022,000 |
Salaries expense | 32 comma 00032,000 | 32 comma 00032,000 | 32 comma 00032,000 | 32 comma 00032,000 |
Miscellaneous expenselong dash44% of sales | 5 comma 2005,200 | 3 comma 2003,200 | 5 comma 6005,600 | 4 comma 4004,400 |
Rent expense | 3 comma 8003,800 | 3 comma 8003,800 | 3 comma 8003,800 | 3 comma 8003,800 |
Utilities expense | 2 comma 0002,000 | 2 comma 0002,000 | 2 comma 0002,000 | 2 comma 0002,000 |
Insurance expense | 2 comma 7002,700 | 2 comma 7002,700 | 2 comma 7002,700 | 2 comma 7002,700 |
Depreciation expense | 4 comma 3004,300 | 4 comma 3004,300 | 4 comma 3004,300 | 4 comma 3004,300 |
The budget assumes that
6060%
of commission expenses are paid in the month they were incurred, and the remaining
4040%
are paid one month later. In addition,
5050%
of salaries expenses are paid in the month incurred and the remaining
5050%
are paid one month later. Miscellaneous expenses, rent expense, and utilities expenses are assumed to be paid in the same month in which they are incurred. Insurance was prepaid for the year on January 1. How much is the total of the budgeted cash payments for selling and administrative expenses for the month of May?
A.
$ 60 comma 800$60,800
B.
$ 64 comma 200$64,200
C.
$ 66 comma 600$66,600
D.
$ 43 comma 400$43,400
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started