subject
Business, 13.07.2021 15:50 bsrlee1115

Create the following budgets for each quarter in the year with the data provided below. Each budget will show results for each quarter and a total for the year. 1. Sales budget 2. Cash collections budget 3. Cash budget Data a. The budgeted unit sales are 500 units, 700 units, 800 units, and 1,000 units for quarters 1-4, respectively. The budgeted selling price for the year is $50 per unit. b. All sales are on credit. 50% percent of all credit sales are collected in the quarter of the sale, 35% are collected in the next quarter, and the remainder is collected in the quarter after. The following data is provided to complete the cash collections budget: 1. Q1 cash collection from prior year Q4 sales: $9,000 2. Q1 cash collection from prior year Q3 sales: $2,000 3. Q2 cash collection from prior year Q4 sales: $1,000 c. The company plans to maintain a minimum cash balance at the end of each quarter of $60,000. If the cash balance is below $60,000, the company will borrow money from the bank to arrive at a $60,000 balance. All borrowings take place on the first day of the quarter and have a 12-month maturity, an interest rate of 2.5% per quarter, and interest paid quarterly. The following data is provided to complete the cash budget: 1. Beginning cash balance: $70,000 2. Q1 cash disbursement: $26,000 3. Q2 cash disbursement: $41,250 4. Q3 cash disbursement: $34.000 5. Q4 cash disbursement: $38.000

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 19:50
Suppose your rich uncle gave you $50,000, which you plan to use for graduate school. you will make the investment now, you expect to earn an annual return of 6%, and you will make 4 equal annual withdrawals, beginning 1 year from today. under these conditions, how large would each withdrawal be so there would be no funds remaining in the account after the 4th?
Answers: 1
question
Business, 22.06.2019 02:10
The federal reserve's organization while all members of the federal reserve board of governors vote at federal open market committee (fomc) meetings, only of the regional bank presidents are members of the fomc. the federal reserve's role as a lender of last resort involves lending to which of the following financially troubled institutions? u.s. banks that cannot borrow elsewhere governments in developing countries during currency crises u.s. state governments when they run short on tax revenues the federal reserve's primary tool for changing the money supply is . in order to decrease the number of dollars in the u.s. economy (the money supply), the federal reserve will government bonds.
Answers: 1
question
Business, 22.06.2019 13:50
Selected t-account balances for bloomfield company are shown below as of january 31, which reflect its accounting adjustments. the firm uses a calendar-year accounting period, but prepares monthly accounting adjustments.suppliesjan. 31 bal. 1,800 1,800 jan. 31 bal.supplies expensejan. 31 bal. 1,920 1,148 jan. 31 bal.prepaid insurancejan. 31 bal. 1,148 1,148 jan. 31 bal.insurance expensejan. 31 bal. 164 164 jan. 31 bal.wages payablejan. 31 bal. 1,400 1,400 jan. 31 bal.wages expensejan. 31 bal. 6,400 6,400 jan. 31 bal.truckjan. 31 bal. 17,376 17,376 jan. 31 bal.accumulated depreciation -truckjan. 31 bal. 5,068 5,068 jan. 31 bal.a. if the amount in supplies expense represents the january 31 adjustment for the supplies used in january, and $1,240 worth of supplies were purchased during january, what was the january 1 beginning balance of supplies? $answerb. the amount in the insurance expense account represents the adjustment made at january 31 for january insurance expense. if the original insurance premium was for one year, what was the amount of the premium, and on what date did the insurance policy start? amount of the premium $answerthe policy began on answerjune 1july 1august 1september 1october 1november 1 of the previous year.c. if we assume that no beginning balance existed in either in either wage payable or wage expense on january 1, how much cash was paid as wages during january? $answerd. if the truck has a useful life of four years (or 48 months), what is the monthly amount of depreciation expense, and how many months has bloomfield owned the truck? answermonths
Answers: 1
question
Business, 23.06.2019 00:10
Many years ago, sprint telecommunications aired an advertisement intended to demonstrate the clarity of reception sprint customers could expect. the ad showed a rancher, who had used a different company, complaining that he had ordered 100 oxen from his supplier and instead received 100 dachshunds. the mix-up was probably due to the presence of in the communication process.
Answers: 3
You know the right answer?
Create the following budgets for each quarter in the year with the data provided below. Each budget...
Questions
question
Mathematics, 12.02.2021 01:40
question
Mathematics, 12.02.2021 01:40
question
Mathematics, 12.02.2021 01:40
question
Mathematics, 12.02.2021 01:40
question
Mathematics, 12.02.2021 01:40
Questions on the website: 13722359