Explore BrainMass
Share

Budgets and Income Statements

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1. Prepare a Cash Receipts Budget for the quarter ending June 30th, by month and quarter. You do not need a formal sales budget since the sales budget is above in the data.
2. Prepare a merchandise purchase budget by month and quarter. A merchandiser purchases in dollars. I have set up a formatted budget for you. You can see how I have made a few minor changes to Schedule 2 on page 356, which is a production budget which we are not preparing. Make sure you think about the numbers you use in the quarter column. I am specifically talking about how you handle beginning and ending inventory.
3. Prepare a Selling and Administrative Expense Budget, by month and quarter. My budget is a little bit different than the one in the text, because I used percentage of sales dollar.
4. Prepare a Cash Disbursements Budget, by month and quarter.
5. Prepare a cash budget showing the months and quarter. Use the format I have provided on the budget sheet.
Do not worry about a minimum cash balance or financing needs, since we are trying to develop a cash management plan.
6. Based on the quarterly cash budget you prepared, do you have any recommendations on cash management. Discuss the type of business and the cash flow problems a company in this industry might have. Type your answer on the budget worksheet , where I have set out the question.
7. Prepare a budgeted income statement for the quarter ending June 30, 20XX. You do not need to show monthly columns.
8. What do you think about the survivability of this business?
9. What if the company finds out the monthly rent will increase to $3,000, what budgets are effected? Why?
What is the New Net income(Loss)? If you have linked everything correctly, you should only have to change the monthly rent on this sheet to determine your answer to the questions asked.

© BrainMass Inc. brainmass.com October 25, 2018, 8:03 am ad1c9bdddf
https://brainmass.com/business/cash-budgeting/budgets-income-statements-523811

Attachments

Solution Summary

The budgets and income statements are examined. The expert prepares a cash disbursement budgets.

$2.19
See Also This Related BrainMass Solution

Develop a master budget in excel - Harrison Company

PROJECT ONE HARRISON COMPANY BUDGET INSTRUCTIONS

Below you will find the data for Project One. You will be completing budgets and schedules for the firm's first quarter of operations in the year 20XY. Do all schedules and budgets showing the three months of January-March and a Total column, except for the balance sheet. Your budgets and schedules should include the following:

1. Sales budget and Schedule of Sales Cash Collections (Note - for Sales, Production and Direct Materials budgets you may need projections for April and May.)
2. Production budget
3. Direct Materials budget and Schedule of Cash Disbursements for Materials
4. Ending Raw Materials Inventory budget
5. Direct Labor budget and Schedule of Cash Disbursements for Direct Labor
6. Total Fixed and Variable Manufacturing Overhead budget and Schedule of Cash Disbursements for Overhead, and Unit Costs for Overhead
7. Ending Finished Goods Inventory budget
8. Cost Goods Manufactured and Cost of Goods Sold budgets
9. Fixed and Variable Selling and Administrative Expense budget and Schedule of Cash Disbursements for S & A Expenses
10. Schedule of Other Collections and Disbursements not included in budgets or schedules above, or other data in additional data (see below)
11. Cash budget
I suggest you do one month at a time to figure financing needs, repayments of principal, interest and ending cash balance; if financing is needed see additional data on financing.
12. Budgeted Income Statement
You will need to go back and forth between the cash budget and income statement to figure interest expense.
13. Budgeted Balance Sheet for March 31, 20XY
Just show the balance sheet for the end of the quarter not for each month.

Additional Data:
PROJECT ONE HARRISON COMPANY BUDGET INSTRUCTIONS

Below you will find the data for Project One. You will be completing budgets and schedules for the firm's first quarter of operations in the year 20XY. Do all schedules and budgets showing the three months of January-March and a Total column, except for the balance sheet. Your budgets and schedules should include the following:

1. Sales budget and Schedule of Sales Cash Collections (Note - for Sales, Production and Direct Materials budgets you may need projections for April and May.)
2. Production budget
3. Direct Materials budget and Schedule of Cash Disbursements for Materials
4. Ending Raw Materials Inventory budget
5. Direct Labor budget and Schedule of Cash Disbursements for Direct Labor
6. Total Fixed and Variable Manufacturing Overhead budget and Schedule of Cash Disbursements for Overhead, and Unit Costs for Overhead
7. Ending Finished Goods Inventory budget
8. Cost Goods Manufactured and Cost of Goods Sold budgets
9. Fixed and Variable Selling and Administrative Expense budget and Schedule of Cash Disbursements for S & A Expenses
10. Schedule of Other Collections and Disbursements not included in budgets or schedules above, or other data in additional data (see below)
11. Cash budget
I suggest you do one month at a time to figure financing needs, repayments of principal, interest and ending cash balance; if financing is needed see additional data on financing.
12. Budgeted Income Statement
You will need to go back and forth between the cash budget and income statement to figure interest expense.
13. Budgeted Balance Sheet for March 31, 20XY
Just show the balance sheet for the end of the quarter not for each month.

Additional Data:

? The firm will sell fully depreciated equipment for a $5,000 (thus a gain of $5,000 as well as a cash flow); the equipment originally cost $50,000.
? The firm will acquire new equipment at the end of March for $100,000.00.
? The firm has a line of credit with the bank to finance deficits in cash flow. It can borrow in increments of $10,000. Borrowing is always made at the end of the month in which money is needed. It must pay any interest due at the end of each month. The bank accrues 12% annual interest (1% interest per month). Repayments of any loans are made at the end of the month and can be any amount for which the firm has excess cash; but the firm must maintain a minimum cash balance of $50,000.00.
? Note - interest and income tax expense will have to be computed each month, before moving to the next month. Interest will have to be computed in doing the cash budget, and taxes when doing the income statement.

? The firm will sell fully depreciated equipment for a $5,000 (thus a gain of $5,000 as well as a cash flow); the equipment originally cost $50,000.
? The firm will acquire new equipment at the end of March for $100,000.00.
? The firm has a line of credit with the bank to finance deficits in cash flow. It can borrow in increments of $10,000. Borrowing is always made at the end of the month in which money is needed. It must pay any interest due at the end of each month. The bank accrues 12% annual interest (1% interest per month). Repayments of any loans are made at the end of the month and can be any amount for which the firm has excess cash; but the firm must maintain a minimum cash balance of $50,000.00.
? Note - interest and income tax expense will have to be computed each month, before moving to the next month. Interest will have to be computed in doing the cash budget, and taxes when doing the income statement.

View Full Posting Details