|
|
|
|
New Member
|
|
May 16, 2007, 09:33 AM
|
|
Sales Budget
How would I create a sales budget by month and in total? Can I have an example please?
|
|
|
Junior Member
|
|
May 16, 2007, 01:08 PM
|
|
Is this homework or work related?
|
|
|
New Member
|
|
May 17, 2007, 10:20 AM
|
|
Originally Posted by Smith21000
Is this homework or work related?
Homework related... I have to complete a master budget and the sales budget has to be included in it.
|
|
|
New Member
|
|
May 17, 2007, 10:33 AM
|
|
This is the problem I'm completing:
You have been hired as a new management trainees by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experience a shortage of cash.
Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the benefits that can be gained from an integrated budgeting program. To this end, you have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of earrings, but all are sold for the same price-$10.00 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six month follow (in pairs of earrings):
January (actual) 20,000 February (actual) 26,000
March (actual) 40,000 April (budget) 65,000
May (budget) 100,000 June (budget) 50,000
July (budget) 30,000 August (budget) 28,000
September (budget) 25,000
The concentration of sales before and during May is due to Mother's Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month. Suppliers are paid $4.00 for a pair of earrings. One-half of a month's purchases in paid for in the month of the purchase; the other half is paid for in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 20 percent of a month's sales are collected in the month of sale. An additional 70 percent is collected in the following month, and the remaining 10 percent in the second month following sale. Bad debts have been negligible.
Monthly operation expenses for the company are given below:
Variable:
Sales Commission 4% of sales
Fixed:
Advertising 200,000
Rent 18,000
Salaries 106,000
Utilities 7,000
Insurance 3,000
Depreciation 14,000
Insurance is paid on an annual basis, in November of each year. The company plans to purchase 16,000 in new equipment during May and $40,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $15,000 each quarter payable in the first month of the following quarter.
A listing of the company's ledger accounts as of March 3 is given below:
Assets
Cash 74,000
Accounts receivalbe ($26,000 February sales;$320,00 March sale 346,000
Inventory 104,000
Prepaid Insurance 21,000
Property and equipment (net) 950,000
Total Assets 1,495,000
Liabilities and Stockholders Equity
Accounts payable 100,000
Dividends payable 15,000
capital stock 800,000
retained earnings 580,000
Total liabilities and Stockholders Equity 1,495,000
The company maintains a minimum cash balance of 50,000. All borrowing is done at the beginning of a month, and repayments are made at the end of a month. The annual interest rate is 12 percent. Interest is computed and paid at the end of each quarter on all loans outstanding during the quarter.
Required;
Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets;
1. a. A sales budget, by month and in total
b. A schedule of expected cash collections from sales, by month and in total
c. A merchandise purchaser budget in units and in dollars. Show the budget by month and in total.
d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.
2. A cash budget. Show the budget by the month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $50,000
3. A budgeted income statement for the three months period ending June 30. Use the contribution approach.
4. A budgeted balance sheet as of June 30.
|
|
|
New Member
|
|
Oct 27, 2007, 02:09 PM
|
|
Originally Posted by vtole
This is the problem I'm completing:
You have been hired as a new management trainees by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experience a shortage of cash.
Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the benefits that can be gained from an integrated budgeting program. To this end, you have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of earrings, but all are sold for the same price-$10.00 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six month follow (in pairs of earrings):
January (actual) 20,000 Febuary (actual) 26,000
March (actual) 40,000 April (budget) 65,000
May (budget) 100,000 June (budget) 50,000
July (budget) 30,000 August (budget) 28,000
September (budget) 25,000
The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month. Suppliers are paid $4.00 for a pair of earrings. One-half of a month’s purchases in paid for in the month of the purchase; the other half is paid for in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 20 percent of a month’s sales are collected in the month of sale. An additional 70 percent is collected in the following month, and the remaining 10 percent in the second month following sale. Bad debts have been negligible.
Monthly operation expenses for the company are given below:
Variable:
Sales Commission 4% of sales
Fixed:
Advertising 200,000
Rent 18,000
Salaries 106,000
Utilities 7,000
Insurance 3,000
Depreciation 14,000
Insurance is paid on an annual basis, in November of each year. The company plans to purchase 16,000 in new equipment during May and $40,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $15,000 each quarter payable in the first month of the following quarter.
A listing of the company’s ledger accounts as of March 3 is given below:
Assets
Cash 74,000
Accounts receivalbe ($26,000 febuary sales;$320,00 March sale 346,000
Inventory 104,000
Prepaid Insurance 21,000
Property and equipment (net) 950,000
Total Assets 1,495,000
Liabilities and Stockholders Equity
Accounts payable 100,000
Dividends payable 15,000
capital stock 800,000
retained earnings 580,000
Total liabilities and Stockholders Equity 1,495,000
The company maintains a minimum cash balance of 50,000. All borrowing is done at the beginning of a month, and repayments are made at the end of a month. The annual interest rate is 12 percent. Interest is computed and paid at the end of each quarter on all loans outstanding during the quarter.
Required;
Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets;
1. a. A sales budget, by month and in total
b. A schedule of expected cash collections from sales, by month and in total
c. A merchandise purchaser budget in units and in dollars. Show the budget by month and in total.
d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.
2. A cash budget. Show the budget by the month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $50,000
3. A budgeted income statement for the three months period ending June 30. Use the contribution approach.
4. A budgeted balance sheet as of June 30.
Do you know how to find the answer? I am not sure where I can get "all sales are on credit with no discout". I am trying to get the answer for master budget. Do you know how do get the answer?
|
|
|
New Member
|
|
Mar 11, 2010, 07:35 AM
|
|
If you go to this website there is an excel template for this very problem it saved me with this problem go to this site and go to ch. 9 and download the excel template for that chapter. The worksheet you want when you open the download is 9-30 here is the link http://highered.mcgraw-hill.com/sites/0073379611/student_view0/chapter9/excel_templates.html
I hope this helps it helped me. Good luck :o)
|
|
|
New Member
|
|
Aug 7, 2010, 05:53 PM
|
|
I am also working on this project! I cannot figure out the budgeted cash disbursements for merchandise purchases. Any help?
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Projected sales and budget
[ 1 Answers ]
1.Trapp Co. was organized on August 1 of the current year. Projected sales for trhe next three months are as follows:
August $100,000
September $185,000
October $225,000
The company expects to sell 40% of tis merchandise for cash. Of the...
How do I budget?
[ 1 Answers ]
One year ago, my husband and I divorced. We were renting a house with our 2 children. (one is not his). I stayed in the house and he moved in with his parents. For the past year, I have been a struggling mother trying to make ends meet. I have a great job and make good money. But every month, I can...
Forcasting budget
[ 1 Answers ]
I need to analyze 3 months forecast budget, what informations should I provide first to begin my analysis?
Problem: I need to prepare a master budget for 3 months on merchandise purchases budget.What information do I need to lay out to start my planning?
View more questions
Search
|